Dataport Fields list

NOx wrote:

Hi everybody,

first post, long time reader

I would like to create a report that lists the dataport fields of a chosen dataport in their correct order.

This way, people using the dataports can always check how their import-file should be constructed.

Is this possible by any means?

Kind regards,

Bart

You can do this by creating a function using an Excel AUtomation. You need two tables, a header that defines import profiles and determines the table, and a lines table that defines fields. Allow the user to setup the profiles and they can then import excel spread sheets directly. Always make sure you validate every imported field, so that they can't do things that will damage data, and of coure a "INSERT(TRUE)"

If you allow export ot excel as well, then the user can create a sample excel fromt he function to then know what th etemplate should look like.

There are a few limitations, but its going to be your best solution. You are also going to have to do a lot of playing with formats.

In the long run, you mayfind it a lot cheaper to simply train the sys admin at the customer site to use the Datport Designer.