Sage 100

Upgrading client from 4.10 to 2013, Sage 100 Standard. They don't use Starship and won't buy it. Rather previous IT person ran a program (Python - some programming language program) to export orders from Sage, make them available to UPS. Client has now moved to cloud and Python software isn't going with to the cloud. Anybody know if I create a VI export, can I import to UPS or suggestions on how to resolve this. I attached the python job below. It opens in notepad. Thanks

Are they using UPS Worldship?

If all the client is doing is pulling order information out of Sage and populating the UPS Worldship fields, an Access PTQ should still work. Writing back to Sage is a bit trickier

I have used the ODBC getting the information to applications like UPS / Worldship and then usually use Visual Integrator to bring the tracking numbers into SO Invoice Data Entry. Have your client get in touch with UPS to see if they can use ODBC and map the fields.

Thanks everyone, I'll be working on this today (or contacting UPS). Afterthought: I'm betting I can't use the ODBC as client is now in a hosted environment and using RDP to get to Sage. The UPS computer won't be able to access the ODBC.

Guess this depends on how their ""cloud"" is configured. I have a client that accesses Sage via a VPN/RDP connection. We set up a mapped drive to their remote system. You should be able to do the same and it should work if you link to a PTQ access database.....

Thankfully outside IT was there to help me today. Successfully created an import mapping within UPS - after 4 calls with UPS, getting disconnected right when I was getting into the guts of the problem. Outside IT created a script to bring source file from cloud to local pc and synchronize it regularly. Had it up and running when I left today. Thanks everyone for your suggestions.