It is possible to insert rows from an Excel file into the structure of an analysis in TiCon using Ctrl+C / Ctrl+V.
Please note the following:
•The Excel row must be created in the following format: Description | Code | Quantity x Frequency. The code can be specified as short or long code. If the code is entered as short code, the corresponding element system must be selected in TiCon.
•If one of the added codes cannot be assigned to an element existing in the database, an appropriate error message is displayed in the status bar. All other rows are transferred to the analysis.
•The columns are filled from left to right. Only editable columns are inserted. Read-only columns are skipped in TiCon and inserted into the next editable column.
•Inserting performs all the checks that are also performed when you type the data.
Copy analysis structure to Excel file
Analysis inserted in TiCon
Please note: |
Insertion of content with illegal characters (% _ ' " * ?) into TiCon is supported. However, fields containing illegal characters are highlighted as incorrect in TiCon and need to be corrected manually before saving. |