Top

Introduction

Note: All references to "spreadsheet" refer to either a CSV file, an Excel spreadsheet file, or an Open Document spreadsheet file.

The Column Mapping screen allows you to specify how the columns in the spreadsheet are mapped to attributes in the selected category. If the spreadsheet has a header row then an attempt is made to automatically map spreadsheet columns to attributes.

Top

Features

The mappings are divided into several sections.

Built-in Item Properties

Item Id

The item id property represents the unique id associated with each item in your database. If the imported data contains a column for the item id then MyStuff2 can update the existing item in the database with the imported data. Imported data that does not have an item id or the item id is not found in the database then the imported item is simply added as a new item.

Group

The Group property is used to assign the imported item to a specific group or subgroup within the category. If the imported item references a group that does not exist in the category then the group is automatically added to the category. To assign an item to a subgroup the value in the spreadsheet should be the list of groups leading to the subgroup. Separate the group names with the value selected for the Multi-value Delimiter on the Import Settings screen.

Location

The Location property us used to assign the imported item to a specific location or container. If the imported item references a location or container that does not exist then the location and/or container is automatically created. If the imported item does not specify a location or you choose not to import a location then the default location selected on the Import Settings screen is used for the item. To assign an item to a container or subcontainer the value in the spreadsheet should be the name of the location followed by the name of each container. Separate each name with the value selected for the Multi-value Delimiter on the Import Settings screen.

Pictures

If the imported file is a zip file containing a spreadsheet and pictures then you can use this property to select the column that contains the path names to the picture files. The value in the column must be one or more path names. Each path name should be a relative path name to a picture within the zip file. If more than one picture is associated with an item, separate each path name with the value selected for the Multi-value Delimiter on the Import Settings screen.

Attachments

If the imported file is a zip file containing a spreadsheet and item attachments then you can use this property to select the column that contains the path names to the files. The value in the column must be one or more path names. Each path name should be a relative path name to an attachment file within the zip file. If more than one file is associated with an item, separate each path name with the value selected for the Multi-value Delimiter on the Import Settings screen.

Item Barcode

The Item Barcode property allows you to specify a spreadsheet column that represents the item's barcode number.

Item Colors

The Item Colors property allows you to provide custom colors for the item. The format of the value must be three colors separated with the value selected for the Multi-value Delimiter on the Import Settings screen. The three colors represent the item's title color, the item's subtitle color, and the item's background color. For no specific color simply leave that part blank. Each color should be specified using a valid CSS color representation. Example: To specify a red title with no value for the subtitle or background, and a Multi-value Delimiter of colon, the value would be: red:: or you can use: #ff000::

Item Updated

This represents the timestamp of the item's last update. This must be in the format: YYYY-MM-DD HH:MM:SS. You must use the specified punctuation. This is the 4-digit year, 2-digit month, 2-digit day of the month, 2-digit 24-hour hours, 2-digit minutes, and the 2-digit seconds. For values less than 10 you must add a leading zero to create the 2-digit value. Example: 2013-09-20 17:30:00. This is September 20, 2013 at 17:00:00 (5pm). Also note that the timestamp must be in UTC time, not local time.

Item Created

This represents the timestamp of the item's creation. This must be in the format: YYYY-MM-DD HH:MM:SS. You must use the specified punctuation. This is the 4-digit year, 2-digit month, 2-digit day of the month, 2-digit 24-hour hours, 2-digit minutes, and the 2-digit seconds. For values less than 10 you must add a leading zero to create the 2-digit value. Example: 2013-09-20 17:30:00. This is September 20, 2013 at 17:00:00 (5pm). Also note that the timestamp must be in UTC time, not local time.

Category Attributes

Each of the category's attributes will be listed in this section. For each attribute you need to select its corresponding column in the spreadsheet. If there is no corresponding data in the spreadsheet or you do not wish to populate an attribute from the spreadsheet then select '[Do not Import]'.

Action Attributes

For each action there will be a section listing the action's attributes. If your spreadsheet contains a value for any of the action attributes you can select the column. Any imported item that has at least one value for an action attribute will have that action applied to it.

Import Actions

Skip Row

You may not want to import every row from the spreadsheet. If this is the case then you can add a column to the spreadsheet. Map this column to this Skip Row action. Then for each row in the spreadsheet you don't wish to import you need to enter a value that will be interpreted as a 'yes'. Valid values include yes, true, on, 1, y, t. All values are case insensitive. Any other value, including no value, will result in the row being imported. If set to '[Do not import]' then no rows will be skipped.

Import Row

You may only want to import some rows from the spreadsheet. If this is the case then you can add a column to the spreadsheet. Map this column to this Import Row action. Then for each row in the spreadsheet you wish to import you need to enter a value that will be interpreted as a 'yes'. Valid values include yes, true, on, 1, y, t. All values are case insensitive. Any other value, including no value, will result in the row being ignored. If set to '[Do not import]' then all rows will be imported.