Page 1 of 1
Where to store the VAT number?
Posted: Thu Mar 12, 2009 4:08 am
by niall08
There's a paucity of responses on the forum at the minute..
Anyway..
WHERE can I store a customers VAT Number??
At the minute i've kept it in user-defined data, but the values MUST be available for export/import via Dataport - and it sounds like this option is out.
So... What are the options? A new table in the database??? Is THAT accessible from Dataport?
Re: Where to store the VAT number?
Posted: Thu Mar 12, 2009 4:11 am
by mazhar
May be you should write your custom routine that creates CSV with desired data.
Re: Where to store the VAT number?
Posted: Thu Mar 12, 2009 4:18 am
by niall08
Yes - fair enough - but to export the data from where? A user-defined field?
On a different post I said that a simple XML export shows this data - but the CSV from the default template doesn't.. What would be the syntax to access the settings > usersettings > name/value pair?
Or is a new table the right way to go, with a CSV to make use of this data?
Re: Where to store the VAT number?
Posted: Thu Mar 12, 2009 4:40 am
by mazhar
Code: Select all
//In order to set a custom field for user
user.Settings.SetValueByKey("myfield"," This is a custom value");
// In order to geta a saved value
string value = user.Settings.GetValueByKey("myfield");
Re: Where to store the VAT number?
Posted: Thu Mar 12, 2009 4:42 am
by niall08
I can set/gather that data in the AC application - but it's the export/import that defeats me..
How can I access the VAT Numbers for export???
Re: Where to store the VAT number?
Posted: Thu Mar 12, 2009 5:59 am
by jmestep
There are several fields in the user table that are not used currently but that are exported in the .csv file. I think the Comments one would be the safest to use in case Able starts using the others later.
PasswordQuestion, PasswordAnswer, Comments, Nickname.
Re: Where to store the VAT number?
Posted: Thu Mar 12, 2009 6:04 am
by niall08
Thanks Judy - not ideal, but if thats the best we've got, it'll have to do.
Thanks
Just a tip for the future development of AC - A VAT Number field!