DataPort and User-Defined values - HELP

[niall08]

I have a user-defined value set up ("VATNumber") - are these values export-able using DataPort??

[jmestep]

I don't know how they would be if they are in a non-Able field or table. The dataport wouldn't know where to find them.

[niall08]

If I do a simple export to XML of all users, its there..

Code: Select all

<Settings>
<UserSetting>
<UserId>1</UserId>
<FieldName>VATNumber</FieldName>
<FieldValue>12345</FieldValue>
<UserSettingId>12</UserSettingId>
</UserSetting>
</Settings>

But the fields aren't accessible in the default CSV export..

So how can I setup an XML template to generate a CSV showing these values??

Any help? It seems that the forum has become VERY quiet recently - a lot of questions have gone completely unanswered..

[jmestep]

There are some pieces of data that the Dataport doesn't export in the csv format because it is hierarchical data from more than one table.

[niall08]

So, given that this version is intended for non-US businesses, where should the VAT Number for a trade customer be stored? The inclusion of the VAT Number is essential for export and SAGE report building..