You can import data (not documents) from external sources into a repository using the import function. A data import takes place in two stages. First the data is loaded into a dqMan data grid, then the data is processed using the script generator.
The Import function is available in the Extras menu. In the File Open dialog box, you can select Excel files, CSV or text files.
Depending on the selected file type, you will be helped by the import assistants, as you can see later in this document.
| Function | Description |
|---|---|
You can also import data directly from the clipboard, if the data is of type text. Calling this function opens the CSV import assistant.
Header line
Line number with column headers, enter 0 for none.
Start row
Line to import from.
End row
Line to import to.
Separator
The character that separates the data columns. Valid are Tab, Semicolon, Comma or any free combination of characters, as well as the Fixed Width option.
Options
Remove leading and trailing blanks - Removes all surrounding blanks. Remove leading and trailing apostrophes – Removes apostrophes. Pool separators – Combines several sequential separators into one. Ignore empty lines – Does not import lines with no data.
Preview
The preview shows how the selected options affect the import result. The number of lines displayed as preview is limited to 25.