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..