cgchris99 Posted March 18, 2004 Share Posted March 18, 2004 I have the mySQL ODBC connection to the UPS Worldship software. But one item that doesn't come through properly is the state. I think this is because osc stores Wisconsin and UPS is looking for WI Anyone have any ideas? Thanks Link to comment Share on other sites More sharing options...
gmessner Posted March 18, 2004 Share Posted March 18, 2004 You simply need to add a translation to WorldShip. Do this as follows: 1) Select Create/Edit Map on the UPS OnLine Connect menu. 2) Highlight the map you wish to edit and select [Edit]. 3) In the bottom window select the mapping that has the state field/column in it. 4) Select the [Edit] button. 5) Select [Translations]. 6) Select "State" and click [OK]. 7) Click [OK] on the remaining dialogs. 8) You're done. I've also added the Canada province abbreviations to the translation, you'll need to figure this out on your own, it was pretty simple to do. Link to comment Share on other sites More sharing options...
cgchris99 Posted March 18, 2004 Author Share Posted March 18, 2004 That worked perfectly. Can you help with one more item? I want to put in the customers email address for notification but I can't figure out which field to put it in. Thanks for any help Link to comment Share on other sites More sharing options...
arbeit Posted March 26, 2004 Share Posted March 26, 2004 Not sure if anyone will still reply to this thread, but I have another similar question. I have the translation running for the state conversion, but have you run into any problems with phone number. Not everyone inputs the number the same way, so it can screw up the display in Worldship. Yeah, I would say the phone number wouldn't get used that often, but it's nice if all the data imports how it's mean to import. Link to comment Share on other sites More sharing options...
cgchris99 Posted February 12, 2005 Author Share Posted February 12, 2005 Anyone know how to pull over the shipping type? Ground, 2nd day air, next day air, etc. Not sure if anyone will still reply to this thread, but I have another similar question. I have the translation running for the state conversion, but have you run into any problems with phone number. Not everyone inputs the number the same way, so it can screw up the display in Worldship. Yeah, I would say the phone number wouldn't get used that often, but it's nice if all the data imports how it's mean to import. <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
cgchris99 Posted February 15, 2005 Author Share Posted February 15, 2005 Some of you must be pulling the info into worldship "Anyone know how to pull over the shipping type? Ground, 2nd day air, next day air, etc. Link to comment Share on other sites More sharing options...
cgchris99 Posted February 16, 2005 Author Share Posted February 16, 2005 Can anyone help with this? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.