Importing Or Exporting Lookup Tables

TIBCO Scribe® Online Lookup Table values can be exported to a file in a CSV format or appended to an existing Lookup Table from a CSV file. If you have more than one TIBCO Scribe® Online Organization, you can export Lookup Table values from one Organization and add them to an existing Lookup Table in another Organization. The process of creating Lookup Tables can be sped up significantly by entering the data in an Excel spreadsheet and then adding the data to an existing Lookup Table.

Requirements For Appending Lookup Table Values

CSV files used for add Lookup Table values to an existing Lookup Table have the following requirements and restrictions:

Note: If you have exported Lookup Table values to CSV and plan to edit the file, then append them to an existing Lookup Table, do not edit the CSV file in NotePad. The CSV file is exported with newline characters (/n) that do not display correctly in NotePad. Edit the CSV files in Excel.

Editing CSV Files

TIBCO recommends editing the CSV file in Excel. Excel handles the comma field delimiter and the required carriage return at the end of a record for you. If there are commas or double quotes within a field, when you save the CSV file, Excel surrounds those fields with the appropriate double quotes required by the import process.

Sample CSV Files

CSV File In Excel

CSV File In NotePad

In the sample CSV files shown above, note how the items that contain commas and double-quotes are treated. It is important to use double quotes correctly or the import may fail.

Append Lookup Table Values From A CSV File

  1. From the Menu bar, select More > Lookup Tables.
  2. From the Lookup Tables page, select Add to create a new Lookup Table. TIBCO Scribe® Online creates an empty Lookup Table and opens the Edit Lookup Table dialog.
  3. Modify the default name for this Lookup Table, and optionally, enter a description. Only alphanumeric characters, underscore, and dash are supported in these two fields.

    Note: Consider using the Description field to call out the entities and fields you are using for this Lookup Table.

  4. From the Menu , select Append.

  5. On the Append Lookup Table Values dialog, make sure the Column Headers In First Row option is enabled.
  6. Browse to the location of your CSV file, select the file and select Open.

    Note: CSV files are appended immediately. There is no confirmation dialog. If the table contains duplicate values, all values are included. All values are appended to the existing list of values.

  7. When the process is complete the Append Lookup Table Values dialog displays the following message: Lookup table values successfully appended. Select Close.
  8. Select Close on the Edit Lookup Tables dialog.

Note: Changes to Lookup Tables are saved immediately and cannot be canceled.

Export Lookup Table Values

Note: Each export contains the values for a single Lookup Table. Multiple tables cannot be exported at the same time or to the same export file.

  1. From the Menu bar, select More > Lookup Tables.
  2. Open the Lookup Table with the values you want to Export.
  3. From the Menu , select Export. TIBCO Scribe® Online generates the export file and saves it to the default Downloads folder for your browser. The default name of the export file is the name of the table followed by Lookup_<datetime>.csv, for example, Products Lookup_2-1-2017 8-11-51 PM.csv

Related Topics

Lookup Tables

Adding Or Editing A Lookup Table

LOOKUPTABLEVALUE1

LOOKUPTABLEVALUE1_DEFAULT

LOOKUPTABLEVALUE2

LOOKUPTABLEVALUE2_DEFAULT

LOOKUPTARGETVALUE

LOOKUPTARGETVALUE2

CSVLOOKUPVALUE