Dataport Fields list

NOx

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

kriki

The only way I can think of: export them as text and read and analyze them in the report.

David_Singleton

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.

NOx

Thanks for the replies guys.

I know it isn't an easy job, and I've been breaking my head on it for some time now.

I've also played with the idea of them exporting a file, so they can create their own template, and I guess that will be plan B

David, I will try your option as well. It sounds good, but it will be a lot of work I guess (like you said, playing with the formats)

If anybody has got an idea to tackle this issue, please feel free to chime in!

Kind regards,
Bart