Hello:
We recently purchased the MOM options module (USI) for using Endicia with MOM.
We've used Endicia for many years to print out our USPS mail labels and are glad to see a way to integrate the two.
At the moment we are stuck on one part of the setup. Endicia and MOM have been contacted, but their fixes havent worked.
The workstation which is being setup is a Win XP Pro machine with all the needed Windows updates. This ws has had Endicias Dazzle on it for a number of years.
Steps 1-4 of the Galaxy setup have been completed. (Galaxy is a program provided by Endicia which helps Dazzle communicate with MOM.)
Unfortunately, when we come to step 5, which is "Creating a Visual Foxpro ODBC Data Source", we run into trouble. Specifically the instructions call for,
"Go into the ODBC, select the system DSN tab. Under system data sources, select add and choose Microsoft Visual FoxPro Driver from the list and click finished."
When finished is click, a message stating, "You must first install the current version of the Visual Foxpro ODBC Driver. Go to http://msdn.microsof...oxpro/downloads. Select product updates, then visual foxpro odbc drivers."
The above link, takes you to a page which does list a link to a ODBC driver. But the driver isnt meant for XP Pro.
I've contact Endicia, they provided with a link to,
http://msdn.microsof...bc/default.aspx
They stated they think the driver I need is there. Once again, there isnt one listed for Win XP Pro.
So my question is, what do I need to do to get past this point.
Thanks
- Mail Order Manager & Dydacomp Sitelink Tech Support Forums
- → Viewing Profile: Topics: [email protected]
Community Stats
- Group Members
- Active Posts 2
- Profile Views 3,139
- Member Title Newbie
- Age Age Unknown
- Birthday Birthday Unknown
-
Gender
Not Telling
0
Neutral
User Tools
Topics I've Started
Endicia - Galaxy Ship - MOM
03 August 2005 - 09:30 AM
Extract PO Information
01 July 2005 - 11:20 AM
Hello,
I've been trying to figure out a way to extract
Purchase orders, both non-drop ship and drop ship,
from MOM. The goal would be to create a file which
we could then go to our suppliers web site and up
load.
The reason for this is that many of our suppliers
are moving away from purchase orders which are sent
via fax, or email. They woulld rather have us either
hand type it into their web interface or upload a
file via their web site.
The file would need to be created on a supplier
basis. Meaning, we would extract the PO data for
each supplier for a particular date. Example,
extract the purchase orders for todays date for
supplier XYZ, extract the purchase orders for todays
orders for the next supplier. Each extracted file
would have a slightly different file format
depending upon what the supplier requires in the
file format. Obviously the PO's for the drop
shipments would contact the info as to who the items
are being sent to.
I spoke with the people at Dydacomp and they
identified the following tables as having the data
we would need:
Purchase.dbf
Puritem.dbf
Cms.dbf
Cust.dbf
They suggested that we could use Report Writer,
Crystal Report or Fox Pro to write a program which
would extract the data based on the criteria we
would define. This program would be run after our
drop ships have been done and after the normal
purchase orders have been done. By done, I mean that
they have been completed in MOM, but they have not
been sent to the supplier. I'm thinking that we
would set all PO's to just print.
My question is, has anyone tried this?
Thanks
I've been trying to figure out a way to extract
Purchase orders, both non-drop ship and drop ship,
from MOM. The goal would be to create a file which
we could then go to our suppliers web site and up
load.
The reason for this is that many of our suppliers
are moving away from purchase orders which are sent
via fax, or email. They woulld rather have us either
hand type it into their web interface or upload a
file via their web site.
The file would need to be created on a supplier
basis. Meaning, we would extract the PO data for
each supplier for a particular date. Example,
extract the purchase orders for todays date for
supplier XYZ, extract the purchase orders for todays
orders for the next supplier. Each extracted file
would have a slightly different file format
depending upon what the supplier requires in the
file format. Obviously the PO's for the drop
shipments would contact the info as to who the items
are being sent to.
I spoke with the people at Dydacomp and they
identified the following tables as having the data
we would need:
Purchase.dbf
Puritem.dbf
Cms.dbf
Cust.dbf
They suggested that we could use Report Writer,
Crystal Report or Fox Pro to write a program which
would extract the data based on the criteria we
would define. This program would be run after our
drop ships have been done and after the normal
purchase orders have been done. By done, I mean that
they have been completed in MOM, but they have not
been sent to the supplier. I'm thinking that we
would set all PO's to just print.
My question is, has anyone tried this?
Thanks
- Mail Order Manager & Dydacomp Sitelink Tech Support Forums
- → Viewing Profile: Topics: [email protected]
- Privacy Policy
- Forum Guidelines ·