Log in

Import Data

From MDrivenWiki

This article describes a new feature of the EcoSpaceDebugger. The feature lets you easily import any tab separated data into any eco-based system and enable you to define transformation on how to interpret the data and also look up values in order to set links.

So suppose you find some data somewhere.

Data Example.png

And you have model that should hold it:

Model for data.png

And that you can create a view model that explains how to receive the data

View Model Data.png

Now click up the system prototyper:

Import data system prototyper.png

Start the system and click up the debugger:

Import data start system.png

Switch to the “Import tab separated” tab, enter the ViewModel that you want to control the import, press “Get headers from viewmodel” to the names in columns – in this case Code and Name:

Import data ecospace prototyper.png

Paste in your tab separated data and press GO:

Import data ecospace debugger-import data.png

Now you have created objects – switch to the “Dirty Objects” to save them…

The “UseKey” flag

The UseKey instructs the logic to pick the first column, and try to look up this value with <ClassFromViewModel>.allinstances->select(keyname=’valueinfirstcolumn’). If an object is returned it will be used for update – if none is returned a new will be created. This will give one such evaluation per imported row.

I have found this being a very versatile tool. But one thing that limited the usefulness of the tool is how keys(first column) are looked up in existing data. Before all you had was “UseKey” and then “Key” that should be an attribute in the model. Here we have extended the ability to enter your own criteria:

Import data mdriven debugger-lookups.png

This way I can, for example have an optionalfilter like this “->select(lp|(lp.ArticlePricePeriod.Name=’2014′) and (lp.SalesArticle.Article.ArticleNumber=vKeyValue))” and the imported values are steered to update just the objects I had in mind

Setting links

Often you will want to assign a link when importing your data. This is done by designing a ViewModel that has PickLists. This is powerful since the lookup will be made on the result of the expression of the Associated viewModel Class. The lookup will be done in memory in dictionaries and will be very fast.

Import data setting links.png

Creating link objects

Link objects can be created the same way. You will need to provide the two keys needed for the association in the first 2 columns.