Importing Data from a Text File
To import information from a text file, add a File Data field using the Insert > File Data command. Then link the field with a text file. Double-click on the field two times to open the properties panel. Then, click the Choose… button in the panel to bring up the import dialog. Select a text file, set up the import options, and click the Open button.
Barcodes can also use text files as a data source.
Text files must be saved in the plain text format that is discussed below. As a rule, spreadsheets can be exported to so-called tab-delimited text files.
By selecting the First row is header check box, you skip importing the first row. This basically says that the first row is not data. It is full of headers for the data below.
The Single Column Data and Multiple Column Data options let you define if each line should be treated as one piece of information (one column), or as several (multiple columns). In the second case you should select the delimiter type, and the column number from which data should be imported. A delimiter is a character or space that lets the program know where one column ends, and another begins.
Keep the default Encoding unless you know the encoding of your file. If the imported text is unreadable (usually characters are replaced with some symbols), reimport with another character encoding selected.
Text File Format
The input text file may have all data organized in one or several columns.
Bend the Guitar
[LINE 1, COLUMN 1][DELIMITER][LINE 1, COLUMN 2][DELIMITER]...[LINE 1, COLUMN n][DELIMITER][RETURN]
[LINE 2, COLUMN 1][DELIMITER][LINE 2, COLUMN 2][DELIMITER]...[LINE 2, COLUMN n][DELIMITER][RETURN]
[LINE m, COLUMN 1][DELIMITER][LINE m, COLUMN 2][DELIMITER]...[LINE m, COLUMN n][DELIMITER][RETURN]
An example with a semicolon used as the delimiter:
3;Bend the Guitar;368
If your data is stored in a database or spreadsheet, export it to a tab- or comma-delimited text file.
To create a text file manually:
- Open a new document in the Text Edit application.
- Switch to the plain text format (Format > Make Plain Text or Cmd-Shift-T).
- Add several lines of text. Use a semicolon or tabulation to split a line into several columns.
- Save the file.
Do not add any unnecessary symbols! Otherwise you will break the file structure.