Table Data Import
This tool is made for importing table data (i.e. data organized in columns) into tables in the program, e.g. load, coordinates, etc. The tool can read the following formats:
- text file separated by delimiters, e.g. commas, semicolumns, tabs, file extension CSV
- generic text file with fixed width of columns, data is organized into columns using spaces or tabs, usual file extension TXT
- Microsoft Office Excel tables (Office Open XML) - file extension XLSX
- OpenOffice system tables (OpenDocument) - file extension ODS
Import is organized gradually in three steps, which moreover varies according to the loaded format. At the top of the window brief help is displayed. The program attempts to analyze the file content and to suggest the best parameters of the transfer. If the user changes some parameters, the program tries to remember these changes and use them appropriately for other files.
1st step: select a file, determine the file type and view its contents
2nd step: splitting the input file into columns
In this step the visible parts are (2) Input file preview, (3) Parameters for input file splitting into columns and (4) Input file split into columns.
3rd step: Assigning columns to data
After pressing the "OK" button the data is transferred into program.