Page 1 of 1

DataPort and User-Defined values - HELP

Posted: Wed Mar 11, 2009 4:11 am
by niall08
I have a user-defined value set up ("VATNumber") - are these values export-able using DataPort??

Re: DataPort and User-Defined values - HELP

Posted: Wed Mar 11, 2009 5:57 am
by 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.

Re: DataPort and User-Defined values - HELP

Posted: Wed Mar 11, 2009 7:53 am
by 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.. :(

Re: DataPort and User-Defined values - HELP

Posted: Wed Mar 11, 2009 10:56 am
by 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.

Re: DataPort and User-Defined values - HELP

Posted: Thu Mar 12, 2009 2:46 am
by 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..