Where to store the VAT number?

[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?

[mazhar]

May be you should write your custom routine that creates CSV with desired data.

[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?

[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");

[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???

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

[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!