We're working with FedEx to set up the ship manager and when we downloaded the orders the file contained numeric state and country codes instead of actual names. Tenn was 43 and USA was 228. FedEx can't use this, they need actual alphabetic state codes.
 
Is this a setting in Viart that we are overlooking?
 
thanks :)

in the export setup there are two fields (delivery state code & delivery country code), for some reason viart does not set these "on" as a default, but if you check off these boxes it will show up in the extract. there may be a global flag to turn these on the time on someplace but i have not found it yet.

Thanks for the reply :)
 
Unfortunately, both the State box and the Delivery State box as well as both the Country box and the Delivery Country box all export numeric code and not alphabetic code.
 
For example, instead of TN for Tennessee, it exports 43. Instead of USA it exports 228. The Fedex software does not recognize these numeric codes.
 
Is this a programming error by Viart?

your version is exporting differnt data than mine fore some reason, you might want to contact support.
 
when I check off those two fields just before the export it adds two new columns in the export, the old numerical coulumns are there but so are the new (correct) codes

They advised me to upgrade to 3.5. I did so, created new customer accounts and new test orders and it still exports the wrong info :(

After upgrading from 3.2 to 3.4.7, I experienced the same problem. It seems Viart added new columns to the va_orders table somewhere in that upgrade timeframe. It used to be
 
state_code
delivery_state_code
 
were the columns, but after the upgrade orders that come in have those columns empty, but two new columns
 
state_id
delivery_state_id
 
now have the numeric values instead of the alphabetic codes. These numeric values are just used to lookup in the va_states table. During the upgrade process, these columns were added to va_orders, and they're at the end of the table structure.
 
You'll have to create a view or your own extract with a table-lookup to convert the 'id' vields into 'code' fields like they used to be. I'm surprised ViArt told you to upgrade to fix the problem. That would have no effect at all.
 
The fields added to the tables can be seen in \admin\admin_upgrade.php