Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When designing configuring and loading information to Engrafo it was very important is highly recommended to have a way to automate the creation of data catalogs and data usage documentation.

...

But, the extract you make and store must match tha the structure of the API. We have explanied explained how this is done in this section.

...

Table of Contents
minLevel1
maxLevel7

If you have questions about alternative methods to automatically load metadata and information into Engrafo, please reach out to us at contact@engrafo.dk (smile)

The overall process for uploading metadata

Metadata load is the core of Engrafo making documentations and data catalogs automated

The process is Upload files → validate files → load files

For the Upload of metadata files, it can be done in 3 ways

  1. Manually. You will have to select the file from your computer and upload it manually

  2. Semi-automated. All metadata files placed in wwwroot\uploads_csv\,\ are automatically imported and are ready for validation. Note that the csv-delimiter that is used is the name of the folder. Here it is “,”

  3. Fully-automated. All metadata placed in wwwroot\uploads_CSVAuto\;\ are automatically imported validated and loaded to Engrafo. Note that the csv-delimiter that is used is the name of the folder. Here it is “;” There is a check every 5 sec. on new files to import, validate and load. (If validation fails, and error messages on that metadata-file is produced and metadata is not imported)

...

Important when placing metadata in a folder, is that the subfolder name identifies which delimiters that is used:

...

So, if metadata is delimited with a “¤”, then place metadata in uploads_csv\¤\

In the following there is a description on how to create a metadata fil for Engrafo. It’s very important to hold the right syntax.

Generating Data Catalog via .csv load

...

  • Outputdata_customfelt_name

  • Outputdata_kategori

  • Outputdata_database

  • Outputdata_skema

  • Outputdata_tabel

  • Outputdata_kolonne (* can be used if ALL columns are to be loaded)

VIGTIGTImportant

  • The category hierarchy must already exist before it is possible to load into it

  • The category elements must be specified with ¤ as a separator, for example: Level1¤Level2¤Level3

  • The templates specified in [Skabelonnavn] must exist before loading to them is possible

  • Units specified in [Unitnavn] must exist before loading to them is possible

  • The fields specified in [Customfelt_text_name] must exist as Custom fields before it is possible to load content into them

  • The fields specified in [Customfelt_link_name] must exist as Custom Fields before it is possible to load content into them

  • The fields specified in [Inputdata_customfelt_name] must exist as Custom fields before it is possible to load content into them

  • The fields specified in [Outputdata_customfelt_name] must exist as Custom fields before it is possible to load content into them

  • The column specified in [Inputdata_kolonne] must exist before it can be loaded as input data

  • The column specified in [Outputdata_kolonne] must exist before it can be loaded as output data

...