Import Data

Dragon1 provides three applications for importing data:

On the Dragon1 Platform you can import data from any type of file. Most common, users import MS Excel files by saving them first as .csv and next import them as .csv on Dragon1.

Support of Import Formats

Dragon1 supports the import of the following data and file format:

  • XML
  • CSV
  • TXT
  • Signavio XML exports (BPMN language and ArchiMate language)
  • MS Excel XSLX, XLS (via CSV)
  • MS Visio VSDX
  • MS Visio VDX (Lucid chart)
  • Archi XML exports (ArchiMate 3.1 language)
  • BizzDesign Enterprise Studio XML exports (ArchiMate 3.1 language)
  • Topdesk XML exports
  • BMC/Remedy XML exports

Required Configuration of the Import Data File

In order to have a smooth import of your data, you need to make sure that your import data has a certain data structure, as Excel or CSV File (NOTE: an Excel Sheet must be first saved as CSV before you can import it here.).

A CSV File for import, must always contain column headers,

The required data structure for your data file is:

  • There is a column called uniqueid
  • There is a column called name
  • There is a column called type
  • There is a column called class
  • There is a column called description
  • Make sure that you use , (comma) as field seperator
  • Try not to maken use of double quotes or single qoutes in your data. This ensures perfect import of your data
  • Do NOT use a column called ref or id
  • Optional column: BitmapImage
  • Optional column: Title
  • All other columns of data you provide are treated as User Defined Data (UDF) and stored in the data field of an entity

EXAMPLE CSV FILE
EXAMPLE Excel Sheet
Download it and edit it to your likeness and use it to upload your data.

If your data has user defined attributes you can use what ever name for the column, but do not use single or double quotes, spaces or hyphen in the name. Column names with only alphanumeric characters (a-z and 0-9), work best.

The uniqueid will be stored in the reference field on Dragon1. With this we can detect updates to your data in later imports.

You can use different classes in a file (processes, applications, ...), but we advise to create and import a data file per class.

Import Data Example
Import Data Example in Open Office

How to Import Data via the Import Application

Select File

  • Login first
  • Go to www.dragon1.com/import/csv
  • Click on the Choose File button. The File Open screen appears.
  • Select the correct file that is locally on your computer.
  • Sometimes you have to wait up to a minute for the browser to react after clicking on the File Choose button. And click OK.
  • Note: Verify if your import data file has data headers. If not select the correct option for that.
Import Example Data Preview
Import Example Data Preview in the Import Application

Check Preload Screen and Fields

  • Check in the preload screen that the file contains a unique ID, Name, Description, Class and Type information.
  • Select the correct Cabinet, Dossier and Folder, you want the data to land in.
  • And if you have not provided a Class field, select the correct Class for the import. (We advise to provide a class in the import data to prevent mistakes here.)
  • The user defined fields that your provide in the import data, will be stored in the data attribute of the entity.
  • In models, views and visualizations you can access the data in the data attributes.

Load Data

  • Click on the Import button
  • During the load of the data you see the progress. Which items could be imported or not.
  • If there is already data in the folder you selected, the import will not run. You can only import data in an empty folder, or update data in an existing folder.
  • If you want to delete all the imported data from a folder, you can do that here. Click on the Check Selected Folder button. And if the folder has imported data, you can delete that data by Clicking on the Remove Imported Items button. NOTE: this can only be done for imported data. Not manually added data.
  • After the import in the progress window below the button shows how many items successfully could be imported and how many items could not be imported.
  • Finally, go to the folder and check if the data has been imported correctly.
Example Imported Data
Example imported data in a folder in the Architecture Repository.

SaaS platform for Enterprise Architecture. The best option a CIO has for Technology Innovation and Digital Transformation.

© 2019 Dragon1