Jump to content


steveweissmusic's Content

There have been 19 items by steveweissmusic (Search limited from 05-May 23)


By content type

See this member's

Sort by                Order  

#1548 eBay Module?

Posted by steveweissmusic on 06 October 2006 - 07:20 AM in Order Import/Export

Is anyone using the eBay module? I'm wondering how it works for you.

Thanks.



#1444 Adept Suite

Posted by steveweissmusic on 18 July 2006 - 01:36 PM in Off Topic Discussion

Has anyone messed with Adept Suite? I have no need to convert to it, but it seems like it could be work for some businesses. They're giving away a 1 user version. I haven't had time to play with it yet, but I'll post what I think of it shortly.

http://www.adeptsuite.com/



#1372 How to Backup MOM

Posted by steveweissmusic on 12 April 2006 - 08:20 AM in MOM & FOX Database Issues

In Windows Server 2003, I believe I've successfully backed up an open version of MOM using the included backup utility and volume shadow copy. I've tested this by backing up MOMWIN while making changes in MOM. I then restored the backup to an alternate location, and opened MOM from that location. Everything seems to work....

Can someone else with Server 2003 try this out and let me know if they think it works correctly?

ntbackup backup D:\Momwin /J "MOM Backup" /F "D:\backup.bkf" /SNAP:on

I am a little confused, because articles that I've found say that the included backup utility does support Volume Shadow Copy, but most of them also include a line that says something like "To take advantage of open-file backups, purchase a backup application that works with the Volume Shadow Copy service."
http://www.ntbackup....file-backup.htm



#1363 How to Backup MOM

Posted by steveweissmusic on 10 April 2006 - 04:59 AM in MOM & FOX Database Issues

Further, I backup the MOMWIN folder nightly onto a seperate hard drive and burn a copy onto DVD-R each morning.


Do you run a script to make sure your users are logged out before attempting to copy the backup to an external drive? Do you reindex as part of a script, or do you do this manually?

Does anyone have experience with Volume Shadow Copy?



#1355 How to Backup MOM

Posted by steveweissmusic on 07 April 2006 - 11:40 AM in MOM & FOX Database Issues

I'd like to start a thread dedicated to backing up MOM.

How do most people deal with backing up open files? Is anyone using Volume Shadow Copy in Windows Server 2003 to backup open files throughout the day? I am currently doing a full backup each night (with no open files), and am using Volume Shadow Copy throughout the day incase of database corruption. Our server has a hardware RAID mirror. Does anyone see any problems with this method? I am not extremely familar with Volume Shadow Copy.



#1347 Worldship Automatic Importing

Posted by steveweissmusic on 07 April 2006 - 05:58 AM in Shipping Issues & Calculation

I just discovered that MOM does not support 3rd party billing with Worldship. It doesn't seem like it would be hard for them to do, since they do support it with UPS Link. However, according to support (and from my testing), it cannot be done with Worldship.

Has anyone else had this problem with Worldship? How do you deal with it?



#1341 Please help all MOM Users

Posted by steveweissmusic on 04 April 2006 - 11:29 AM in General Mail Order Manager Discussion

Fellow MOM users,

I've posted before about using MOM to interface with Quickbooks for accounting purposes. I've recently bought a copy of Quickbooks 2006 to interface with the MOM accounting interface. Now everything seemed peachy untill I started reading the article done by I believe VideoFlicks on downloading the Quickbooks MOM setup file qbfc2installer.exe and installation.

So where is the catch? Well my MOM subscription just ran out and I didn't know that this exe was available for download. I'm asking someone to kindly take a few minutes out of their time and upload the file qbfc2installer.exe to momfaqs.com or e-mail to me at [email protected].

Tomorrow I will try to get in touch with MOM tech support if not and find out what they will do for me.

Regards,
Josh


Josh,
Did you ever figure this out? I am trying to interface MOM 5.4 with Quickbooks Pro 2006. The tutorial by videoflicks is no longer in the download section (I can't seem to find the download section). Can anyone help?

Thanks.



#1288 JOBS Offered for M.O.M. Experts

Posted by steveweissmusic on 23 February 2006 - 12:25 PM in 3rd Party eCommerce Solutions

dpeltz,
What 3rd party ecommerce platform will be integrated?



#1286 HTML Notice Templates

Posted by steveweissmusic on 23 February 2006 - 09:13 AM in Email Issues & List Management

Shipping Notification made from passion.

Attached Files




#1285 HTML Notice Templates

Posted by steveweissmusic on 23 February 2006 - 08:37 AM in Email Issues & List Management

Does anyone have HTML Notice Templates to share? I am going to start taking some designs from www.oswd.com and making them into HTML templates for use in MOM. If anyone has any templates to share, please post them in this thread.



#1280 Worldship Automatic Importing

Posted by steveweissmusic on 22 February 2006 - 07:56 AM in Shipping Issues & Calculation

In the Worldship 8.0 help files, look for "Hands-off shipping". It gives a good description of how the feature works, along with detailed instructions for setting it up.


Evan,
I guess my desired results are a bit different. Let me explain our process....

We do not have MOM stations in our shipping department, and we print our invoices on plain paper. We print 2 copies of the packing slip/invoice. When the order is packed, one copy goes into the box, the other gets attached to the outside. That copy is then scanned at the Worldship machine, the box is placed on the scale, and we press F10 to print the shipping label.

It would be great if Worldship Hands-Off shipping was able to import data as a background process, to then be pulled up by a keyed import. I cannot figure out how to design this type of process solely in Worldship using Hands-Off shipping.



#1278 Worldship Automatic Importing

Posted by steveweissmusic on 20 February 2006 - 01:17 PM in Shipping Issues & Calculation

This seems to be working well for me. I am still only testing things, but it is working as expected. I created a batch file with the following contents:

@ECHO OFF
path=c:\php
php convert.php >> convert.log

I then scheduled this batch file using the Windows Scheduler (Programs->Accessories->System Tools->Scheduled Tasks). Create a local account on the machine to run the process. This way, the batch process will run in the background, instead of in the active window (I am running this on the Worldship machine). I am running the process every minute.

You'll need the following programs installed to make this work:
http://www.php.net/downloads.php
http://dev.mysql.com.../mysql/5.0.html

These tools will help in the process (MySQL Administrator & MySQL Query Browser):
http://www.mysql.com/products/tools/



#1277 Worldship Automatic Importing

Posted by steveweissmusic on 17 February 2006 - 01:00 PM in Shipping Issues & Calculation

I realized that I needed to include an update query, incase a package was updated in MOM, and the shipping record was created again.

Attached is the new version.

Attached Files




#1276 Worldship Automatic Importing

Posted by steveweissmusic on 17 February 2006 - 09:51 AM in Shipping Issues & Calculation

The latest version of WorldShip--8.0 if I recall correctly--includes a new feature for doing an automatic import at specified intervals, which could be every few minutes if you want. I haven't had time to set this up yet, but it seems like the simplest way to get the results you described.

If you decide to go this route, I would be interested to hear how it works for you.

Good luck!

Evan Frink
Journeyworks Publishing

View Post


We have Worldship 8, but haven't seen this functionality. Because we want to do a keyed import, I believe we need a ODBC source that contains all of the information we need. If you know a way to do the automatic import, and then pull that info up by keyed import, let me know.



#1274 Worldship Automatic Importing

Posted by steveweissmusic on 17 February 2006 - 09:25 AM in Shipping Issues & Calculation

I think I am going to attempt to run MySQL on the machine with UPS Worldship, and run the attached script every minute. I will then setup Worldship to pull from the MySQL ODBC source instead of the DBF.

Please let me know if anyone sees potential problems.

Attached Files




#1273 Worldship Automatic Importing

Posted by steveweissmusic on 17 February 2006 - 07:18 AM in Shipping Issues & Calculation

I would like to improve the process of importing of shipment data into Worldship. The problem is that each time the shipment data is exported from MOM, the DBF file that is created gets overwritten. I do not want to have to export from MOM, and then immediately go to my UPS Worldship terminal and import the new information. I would like to use the keyed import function in Worldship to pull up shipment information.

I'm looking for suggestions on what route to take. Does a program exist that will append information from a DBF table onto another DBF? If this exists, I will write a script that polls the import / export directory every minute, and if a new DBF exists, it will append to the DBF that I am using to import from.

If this type of program does not exist, I will write a script that will import the DBF data into a Access database, and then rename the dbf file. I would then use the Access database as the source for the import.

Does anyone do anything similar to this? Can you offer any different suggestions?



#1222 Sales Order Table

Posted by steveweissmusic on 12 January 2006 - 07:02 AM in MOM & FOX Database Issues

Casey,
I am presently trying to accomplish the same task of integrating MOM 5.4 with Worldship 8.0. Please keep me updated on what you find, or contact me directly at "webmaster at steveweissmusic.com". Hopefully I can work with a local UPS technician using whatever you find out.

Thanks.



#1210 Importing Data Into MOM

Posted by steveweissmusic on 04 January 2006 - 12:52 PM in MOM & FOX Database Issues

Here is my updated method (includes bin.dbf):

I would like to find resources available that help with the process of manually importing data into MOM. I've written some PHP scripts to do the data conversion, but I am worried that problems will come up in the future, once we start using MOM full force.

Here is what I am doing so far:

Importing Customers
I am mapping my data to 1 text file and appending it to CUST.DBF. As far as I can tell, this is the only table modified when a new customer is created.

Importing Suppliers
I am mapping my data to 1 text file and appending it to SUPPLIER.DBF. As far as I can tell, this is the only table modified when a new vendor is created.

Importing Inventory
I am mapping my data to 5 text files, and appending them to STOCK.DBF, STOCKINF.DBF, and STOCKMEM.DBF, BUYPRICE.DBF, and BIN.DBF. As far as I can tell, these are the only tables modified when a new stock item is created.

Please let me know if you see any problems with this method. If anyone is interested in developing a useful guide to importing / exporting from MOM please let me know.



#1201 Importing Data Into MOM

Posted by steveweissmusic on 02 January 2006 - 06:34 PM in MOM & FOX Database Issues

I would like to find resources available that help with the process of manually importing data into MOM. I've written some PHP scripts to do the data conversion, but I am worried that problems will come up in the future, once we start using MOM full force.

Here is what I am doing so far:

Importing Customers
I am mapping my data to 1 text file and appending it to CUST.DBF. As far as I can tell, this is the only table modified when a new customer is created.

Importing Suppliers
I am mapping my data to 1 text file and appending it to SUPPLIER.DBF. As far as I can tell, this is the only table modified when a new vendor is created.

Importing Inventory
I am mapping my data to 4 text files, and appending them to STOCK.DBF, STOCKINF.DBF, and STOCKMEM.DBF, and BUYPRICE.DBF. As far as I can tell, these are the only tables modified when a new stock item is created.

Please let me know if you see any problems with this method. If anyone is interested in developing a useful guide to importing / exporting from MOM please let me know.