Import Data to dqMan

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.

Import CSV or Text Files

Function	Description
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.

Import from Clipboard

You can also import data directly from the clipboard, if the data is of type text. Calling this function opens the CSV import assistant.