Importing\Exporting Default Location Data
Formatting the Data
This will allow you to mass import\export default part locations.
All fields will be one of type:
- Text - A textual value. May contain any character, but if it
contains a line break, comma or double quote, it must be wrapped with double
quotes on both ends. If a field is wrapped, all text must be inside the double
quotes. Double quotes in the text value must be doubled to
import properly
CSV Fields Used to Import\Export Default Locations
| Column Name |
Type |
Description |
| PartNum |
Text |
The number of the part to define the location for.
Required |
| Location |
Text |
The name of the Location.
Required |
| LocationGroup |
Text |
The name of the Location Group.
Required |
Creating a CSV file
In order to import your data, you must first export it to a comma separated
values (CSV) text file. All major spreadsheet programs can export data in this
format. If you do not know how to export your data to a CSV file, please refer
to the documentation of your spreadsheet program.
When exporting to CSV format, make sure to verify the following:
- The data is formatted properly (see the first section)
- The file must contain column names in the first row, using the column names in the table above.
- Each bill of material item to be added or updated is on its own line
- Commas are used to separate fields
- Text values are surrounded by double quotes