Import #
MetaCroc supports import from CSV files. Import can be started from two points:
- Columns tab in table form (by Import button)
- Folder context menu in project tree
In Columns tab, it is possible to import columns to the active table only. In project tree, multiple columns metadata can be imported including new tables creation.
How to import #
Import from CSV step by step:
- Press Import button on Columns tab and select CSV file
- File preview with data is shown. Has headers checkbox should be switched ON if the first row contains column headers.
- If the import file contains headers, MetaCroc tries to link columns to attributes. Unlinked columns can be linked manually or keep ignored.
- The final settings
| Attribute | Description |
|---|---|
| Case sensitive | The same names but with different letter cases are recognize as different ones (e.g, DT Key and dt key are recognize as two different names) |
| Create new domains | If new domains are found they are automatically created in Settings |
| Do not import technical columns | Columns with the same name as technical one is not imported |
| Names normalization | Names aer normalized as selected from the dropdown |
New domain is also recognized in the case when existing domain has different definition. Therefore it is necessary to be careful - in such situation new domains with the same name but different definition are created.