Architecture Repository Import
Dragon1 provides three applications for importing data:
- The Import Application
- The CSV Import Feature in the Architecture Repository, that is explained on this page.
- The Import Feature in the Visual Designer.
The Architecture Repository provides a quick and easy feature for CSV only import.
How to Import a CSV File
CSV means Comma-Separated File.
Here you can read the official RFC 4180 specification
If you have an Excel Sheet, you can save it as Comma-Separated File (CSV). Next, you can import that file in the Architecture Repository.
Here is an example CSV file
NOTE: If your original data has fields with commas in the text, the text on export to csv file, will be placed in double quotes like this: one, two, "three, four", five, six.
To import a CSV file in the Architecture Repository:
- Login via www.dragon1.com/login
- Go to the Architecture Repository via www.dragon1.com/architecturerepository
- Click on Choose File (depending on your Browser language settings, the button will have a different name)
- Select a CSV file
- Check in the preview pane if Dragon1 recognizes your data correctly.
- Select the Entityclass. (Check carefully that you do not select the wrong class to map the imported data on).
- Select a Cabinet, Dossier, and Folder
- Click on Import to import the data
- The import data is tagged as import with a unique code (like import001), this makes it easier for you to bulk delete the imported data as a set.
Screenshot of the Architecture Repository Import feature.
Reserved Column Names
When importing a file, make sure you have the following three columns available in your file:
The names for these columns may be in uppercase and/or lowercase.
If you follow this rule, then on importing the data, Dragon1 will put the name in the name field, description in the description field and uniqueid in the ref id field.
The import mechanism wil recognize by means of the ref id field whether or not you already imported a version of this data. If so, you need to approve if the data of existing rows may be updated and the data of new rows may be inserted.
User Defined Fields (Max 100 per Row)
When you import data, you will often have your own unique fields (attributes). Dragon1 will import up to 100 fields per row.
In the Architecture Repository you can edit the labels/names and values for these fields.
In the Visual Designer and the Content Viewer you can use these attributes and values to generate specific views for your data.
CSV File Structure
The import mechanism in the architecture repository for CSV is hardcoded for the comma as a field separator. The Import Application supports other field separators for CSV files.
Compliant to the CSV standard, fields that contain commas and linefeeds or carriage returns (LF or CR), need to have to enclose double-quotes. A double quote inside a field needs to be escaped (preceded by a double quote). Dragon1 can deal with this part of the specification. Normally exporting a CSV file from professional software creates a correct CSV file and any compliant CSV file can be imported.
In addition to the CSV file standard you can add a comment field with three double hashtags, like: ###. If such a line is present in the file, Dragon1 will ignore these lines on import.
Updating Imported Data
As discussed in the paragraphs before, Dragon1 recognizes if data is already imported.
If you want to update imported data you can import the data and answer yes on the question if the data should be updated.
NOTE: Updating imported data cannot be reversed.
Deleting Imported Data
You can delete imported data per entity or in batch in the Architecture Repository. NOTE: Deleting imported data is irreversible. Only the user who imported the data can delete this data.
Check Imported Data With a Report
If you import data you may want to check the imported data on correctness. For that, we provide basic reports on imported in the Architecture Repository and Business Analyzer.
The activities of importing, updating and deleting data are logged and available as reports in the Business Analyzer.