Skip to content
SmartFACT HelpHandbooksWatch and practise
Handbooks: SmartFACT Data

Import a whole file into a large reference lookup

Choose the file's columns, review every row left out and every unused column, and save the exact file as the next version.

Review edition · 18 November 2026 · For Owner, Operator

On this page

Import a whole file, such as a stockroom's sheet of product codes and drawer locations, into a large reference lookup. The file is read whole and kept by its fingerprint with the version it becomes. You choose which of its columns fill the table, and you see every row that will be left out before anything is saved. Values are kept as exact text: leading zeroes, case and spaces inside a value stay as they are.

Read the file

Open Reference tables and select the large reference lookup. Under Import a file, choose the file, its delimiter, and whether its first row names the columns, then choose Read the file. Data lists every column of the file by its letter, with the name in its first row (or Unnamed) and how many rows hold data in it. A spreadsheet export often has unnamed columns with notes in them: they are listed too.

A file Data cannot read whole is refused with the row where reading stopped, for example a row with a different number of columns. Correct the file and read it again. A file may have up to 25,000 rows, 64 columns and 8 MiB.

Choose the columns

For each table column, choose the file column that fills it. The file's own names are chosen first where they match. The table's matching key, for example the product code, must have a value in every row that is kept. Tick Leave out a row with no ... for any other column every row must have, such as the location. Then choose Preview the import.

Every file column you did not choose is shown as Not used. Where it holds data, that data will not be imported: check it is not something the table needs.

Review every row left out

The review counts the rows kept and the rows left out, and lists every row left out by its row number in the file and why:

  • a blank line, or a row whose cells are all blank;
  • no value in the matching key;
  • no value in a column you marked as required;
  • a key repeated on identical rows, or repeated with different values.

A repeated key keeps none of its rows. Neither the first nor the last wins, because Data cannot know which is right. Correct the file so each key appears once, and import it again to include them. A location may be shared by several keys: that is not a repeat.

Codes that differ only in spaces or case, such as AB - 12 beside AB-12, are listed under Codes that differ only in spaces or case, column by column, with how many rows hold each spelling. They are kept exactly as written, so StoresFlow, and a zone set by code prefix there, treat them as different drawers. If they are meant to be one, correct the file and import it again.

The review also says how many rows the table gains, changes and loses. An import replaces the table's rows, so a row missing from the new file is removed.

Save the version

Tick that you reviewed every row left out, every unused column with data and every set of codes that differ only in spaces or case, write a change note, and choose Save the import as the next version. If the file, your choices or the table changed since the review, saving is refused; read and review it again. The saved version keeps the file's fingerprint, the columns you chose and the rows left out, so the version can be traced to the exact file.