Welcome, %1$s. Please login or register.
October 25, 2014, 09:05:55 PM
: SMF - Just Installed

+  The SuperManager Forum
|-+  Importing and Exporting
| |-+  Other Software
| | |-+  Barcode for Worldship
« previous next »
: [1]
: Barcode for Worldship  ( 3103 )
arueder
Newbie
*
: 17


« : May 04, 2012, 10:18:12 AM »

Is there a way to have all orders export to a CSV file, then have a bar-code print out with the invoice? Then I can use Worldship to create a map to that CSV and use the bar-code to retrieve and populate the information in Worldship?
David Johns
Administrator
Hero Member
*****
: 1840


MSN Messenger - david@thesupermanager.com AOL Instant Messenger - SuperWare+LLC
« #1 : May 04, 2012, 03:43:59 PM »

arueder,

Yes, you can do that.  Please check out this post, which contains an invoice template that includes a barcode:
http://www.thesupermanager.com/forum/index.php/topic,726.0.html

For exporting orders to a CSV file, there is a pre-defined export format called "UPS WorldShip" that should work for you.  Instructions for setting up a link to WorldShip using ODBC/CSV are in section 11.4.b.  You can choose "Help", "User's Manaul" from SuperManager's main menu to get to the user's manual.  Post back if you need any help.

Thanks,
David

SuperManager Support
info@thesupermanager.com
arueder
Newbie
*
: 17


« #2 : May 07, 2012, 04:41:45 AM »

Step 3 in the help pdf says I have to select "Microsoft Text Driver (*.csv, *.txt)"
from the option list and then click "Finish". Theree is no Microsoft Text Driver to select. I only have 2 options:

SQL Native Client, and SQL Server

Aaron


arueder,

Yes, you can do that.  Please check out this post, which contains an invoice template that includes a barcode:
http://www.thesupermanager.com/forum/index.php/topic,726.0.html

For exporting orders to a CSV file, there is a pre-defined export format called "UPS WorldShip" that should work for you.  Instructions for setting up a link to WorldShip using ODBC/CSV are in section 11.4.b.  You can choose "Help", "User's Manaul" from SuperManager's main menu to get to the user's manual.  Post back if you need any help.

Thanks,
David
David Johns
Administrator
Hero Member
*****
: 1840


MSN Messenger - david@thesupermanager.com AOL Instant Messenger - SuperWare+LLC
« #3 : May 07, 2012, 05:07:04 AM »

Aaron,

You're right.  We need to update the instructions for Windows 7.  They moved this to the windows control panel.  Go to the windows control panel and select Administrative Tools, the. Select Data Sources (ODBC).

Let me know if that gets you back on track.

Thanks,
David

SuperManager Support
info@thesupermanager.com
arueder
Newbie
*
: 17


« #4 : May 07, 2012, 05:23:54 AM »

David,

I can find ODBC in control panel however the problem is when clicking on the System DSN tab, then "ADD", I do not have the option to select "Microsoft Text Driver". The only 2 options that show up after clicking "Add" are SQL Native Client, and SQL Server.

Aaron
David Johns
Administrator
Hero Member
*****
: 1840


MSN Messenger - david@thesupermanager.com AOL Instant Messenger - SuperWare+LLC
« #5 : May 07, 2012, 08:03:24 AM »

Aaron,

There is a further complication for 64-but machines.  You'll have to go to the start menu and where it says "Search programs and files" type:
Code: [Select]
%systemdrive%\Windows\SysWoW64\odbcad32.exe
Then press enter.  This will bring up a different ODBC administrator that will have the  text file options.

Thanks,
David
« : May 07, 2012, 08:09:29 AM David Johns »

SuperManager Support
info@thesupermanager.com
arueder
Newbie
*
: 17


« #6 : May 07, 2012, 08:08:05 AM »

That did it THANK YOU!!
arueder
Newbie
*
: 17


« #7 : May 07, 2012, 11:29:05 AM »

Whe creating the map in Worldship, the Instructions for SM page 100 get me to the "Select an ODBC source" dialog. The file im supposed to select is not showing up "smupsw".
arueder
Newbie
*
: 17


« #8 : May 07, 2012, 11:57:54 AM »

nevermind. Got it.
: [1]  
« previous next »
:  



Powered by MySQL Powered by PHP SMF 2.0.9 | SMF © 2014, Simple Machines Valid XHTML 1.0! Valid CSS!