Jump to content


[email protected]

Member Since 17 Jan 2005
Offline Last Active Nov 26 2005 03:45 AM
-----

Topics I've Started

Endicia - Galaxy Ship - MOM

03 August 2005 - 09:30 AM

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

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