Views:

Question:
How can i Import/Export a Pick List?
Note: This Feature was added in Fortis 2.6.0

Answer:
If you want to Export or Import a Pick List do the following,

To import a Pick List:

  1. With a database open, click the Pick Lists button on the toolbar or choose Pick Lists from the Window menu. The main Pick Lists window opens, displaying the Pick Lists available for the open database, if any. Note that a Pick List menu is added to the menu bar.
  2. Click the New button on the Pick Lists window button bar or open an existing Pick List by selecting it and clicking Open on the button bar.
  3. Click the import button
  4. In the resulting dialog box, define the file you will import
    1. In the "use this file" box type the path or browse to the location of the file
    2. In the "Field Delimiter" box, verify that the character is the same as the delimiter in the text file (The default is a comma for CSV files.)
    3. In the "String Delimiter" box, verify that the character is the same as the delimiter in the text file. This is optional, but is good practice to use.
    4. Choose to delimit Rows by line or by pipe.

    Note: For each row, fields will be entered in order. If inactive status will be set on import, all alias fields must be accounted for on the row. For example, to add an inactive row for Chevrolet it would look like this: "Chevrolet","Chevy",,,,,"i"

  5. Click OK and Save

To Export a Pick List:

  1. With a database open, click the Pick Lists button on the toolbar or choose Pick Lists from the Window menu. The main Pick Lists window opens, displaying the Pick Lists available for the open database, if any. Note that a Pick List menu is added to the menu bar.
  2. Select the Pick List to be exported
  3. Click the Pick List menu and choose Export... or click the Export button
  4. In the resulting dialog box, define the file you will export
    1. In the "use this file" box type the path or browse to the file to be used, enter a file name.
    2. In the "Field Delimiter" box, set the character to delimit each field.
    3. In the "String Delimiter" box, set the character to delimit each string, this is optional but reccomended.
    4. Choose to delimit Rows by line or by pipe.
  5. Click OK, the file will be exported.