Skip to main content

4-12-2 Format of CSV file used in test data import mode

Create the comma or tab-delimited CSV files used in the test data import mode in the following format. Tab-delimited format is supported from Service Pack 2.

  • Use a comma "," or a tab as a delimiter.

  • Use line feeds to separate rows.

  • If the data contains a comma "," or tab, enclose the cell contents with double quotations (").

    Example: Row number (2) in the "Example of CSV file"

  • If double quotations (") exist at the start or end of the data, use three consecutive double quotations (""").

    Example: Row number (3) in the "Example of CSV file"

  • To output IVS characters, set the CSV file character code to "UTF-8". For printer models compatible with IVS characters, see "SVF for Java Print User's Manual" or "Restrictions" in "SVF for PDF User's Manual".

  • The maximum number of rows is 100.

Example 1. Example of CSV file (comma-delimited)
　　　 Product Code,Product Name,Supplier Code,Classification Code,Packing Unit,Unit Price,Inventory,Ordered,Order At,Discontinued
(1)    1,100% orange juice,100% fruit juice orange,2,1,200g x 12 bottles,¥200,10,100,0,0
(2)    2,100% Kaju Grape,"100% Fruit Juice, Grape",2,1,200g x 12 bottles,¥200,12,100,0,0
(3)    3,Coffee Mild,"""Coffee Mild""",2,1,195gX10 Cans,190,12,200,0,0


Restriction

  • Fields cannot be repeated within records.

  • You can use commas (,), tabs, and double quotations (") for data in a CSV file, but not for the header line (first line).

In this section: