Top

Introduction

The Data Settings screen allows you to specify how the CSV file is to be imported. You use this screen to define the file and row range to import, the category to import into, and some details about the data format.

Note: You must select a CSV file, provide a range of rows, select a category, and verify the column mapping to be able to tap the Save button.

Top

Features

The settings are divided into five sections.

CSV Import Source

CSV File

Use this option to select the specific CSV file to use for import.

Import Rows

Use this option to brings up the Import Rows screen allowing you to indicate which rows in the CSV file should be imported. The row range should include the header row, if any.

Import Destination

Category

Select the category (and optionally a group) that the items in the specified data cells will be imported into.

Location

You can specify a default location to be used for items that don't specify their own explicit location.

CSV File Format

Header Row

If ON the first row of the chosen Import Rows will be the column titles. The column titles will match the attribute names of the category. If OFF the CSV will not include the column titles.

Field Delimiter

Despite being called a CSV (comma separated values) file, the values can be separated by punctuation other than a comma. You can choose from several different separators. You would choose a specific value if you plan to import the CSV file into another application that expects a specific separator. If unsure leave the default of a comma.

Text Delimiter

It's possible that a value in the CSV file contains the same punctuation used as the Field Delimiter. When this happens the value must be placed within the Text Delimiter. You can choose either the double-quote or the single-quote. Again, you would choose a specific delimiter if another application expects it.

Multi-value Delimiter

This option let's you specify a delimiter to be used to separate multiple values in the same column. This is used for attributes associated with multi-select lookup lists and for listing picture paths for items with more than one picture. Don't use a value that could appear in the data. This must be different from the chosen Field Delimiter.

CSV Data Preview

Select this option to view the first few rows of the CSV file. The data will be split into columns based on the select file format options. Use this to confirm you have selected the correct delimiters.

CSV Data Format

Date Format

The items being imported may include dates from different Date attributes. These Date attributes may have various date formats associated with them. This option brings up the Date Format screen and lets you specify how the dates should be formatted on import. Selecting Attribute Format results in each exported date being formatted based on its corresponding attribute. Selecting Default results in every date being formatted the same as specified by the selected Date Format on the Settings screen. You also have the option to select any other suitable date format or create and use a new format.

Time Format

The items being imported may include times from different Time attributes. These Time attributes may have various time formats associated with them. This option brings up the Time Format screen and lets you specify how the times should be formatted on import. Selecting Attribute Format results in each exported time being formatted based on its corresponding attribute. Selecting Default results in every time being formatted the same as specified by the selected Time Format on the Settings screen. You also have the option to select any other suitable time format or create and use a new format.

Duration Format

The items being imported may include durations from different Duration attributes. These Duration attributes may have various duration formats associated with them. This option brings up the Duration Format screen and lets you specify how the durations should be formatted on import. Selecting Attribute Format results in each exported duration being formatted based on its corresponding attribute. You also have the option to select any other suitable duration format.

Locale

The Locale option lets you indicate what locale the imported data has been formatted with. The locale will affect how numbers, dates, times, and currency values are formatted. Selecting Default uses the current locale of the iOS device.

Column Mappings

Column Mappings

Selecting this option brings up the Column Mappings screen. This is where you map the columns from the CSV file with attributes of the category. MyStuff2 does its best to match up columns to attributes but you must carefully verify the mapping is correct.