You will need to choose the correct 32/64-bit module depending on your WorldShip architecture. ![]() Run (WinKey + R) the command ‘control admintools’ to launch Windows Administrative Tools, or go to the Control Panel and click on ‘ Administrative Tools’, and the click on ODBC Data Sources (32-bit). Windows has a built in driver for CSV or XLSX files.Įxamples: Shipping Database.xlsx / Shipping Database.csv Step 2: Adding an ODBC Data Source If you have neither MySQL nor Microsoft Access databases, or if you don’t have your ODBC driver installed yet, you can still follow along by downloading my example CSV/XLSX file. MariaDB / MySQL: These two database softwares are meant to be compatible, so either connection driver will work with either one. In my experience, this is 32-bit on most WorldShip installations. Download the version that matches your UPS WorldShip architecture. ![]() Windows will allow you to install either the 32-bit or 64-bit driver according to your client, which is WorldShip in this case. The Microsoft Access drivers Download pageģ2-bit / 64-bit Drivers: This is not the architecture for your version of Windows. For example, this website runs on WordPress, but the back-end database is MySQL. Note: You will need the drivers for the back-end database your software uses, not the front end software itself. Some vendors will charge you for the driver package. If you’re using a proprietary database, then you will need to contact your software vendor for driver access. Most major database vendors will provide an ODBC driver for free. ODBC, or Open Database Connectivity, is a software standard that allows applications like WorldShip to interact third party databases.įirst you will need to install the ODBC drivers for the type of database you are connecting to. This post will cover MySQL, but the basic concepts apply to all databases with ODBC support. WorldShip even supports foreign key relationships, which is pretty awesome. All relevant fields can be customized to automatically populate from a database. ![]() Simply put, you can ship packages by keying in order numbers or any unique reference number. If your business uses an e-commerce solution or ERP that records customer shipping information, then chances are you can integrate your shipping database with the UPS shipping platform, WorldShip®.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |