Here is my issue.
I'm doing a website for a customer of mine and she needs to be able to have customers input data onto a website and then be able to download a file and merge it or import into MOM so she can do whatever she needs to get done.
I just got this job today (3 hours ago acually) and I've been doing research on MOM but I'm still not sure how this can be done.
I'm sure this has been done before but perhaps it just wasn't worded how I'm thinking.
The languages I'd need to do it in is php, perl, cgi or java.
She was given sites of free scripts but none of them have anything on MOM.
Can anyone shed some light on how to get the data into MOM? Without buying another product?
MOM file format generator
Started by
Guest_stephen_*
, Nov 23 2004 04:45 PM
7 replies to this topic
#2
Videoflicks2004
-
- Moderators
-
- 241 posts
GLOBAL MODERATOR
- Gender:Male
- Location:Canada
- Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.
Posted 24 November 2004 - 01:40 PM
Hi Stephen,
First of all, make sure your client has the MOM IMPORT / EXPORT MODULE. Attempting to write data directly into MOM without this module is just not fun.
There are many key fields that need to be populated correctly to work. I have scanned a few sheets of my MOM DATABASE bible. This listing outlines the fields in the import.dbf table that you need to populate (including the formatting).
Best of luck with your project.
David
First of all, make sure your client has the MOM IMPORT / EXPORT MODULE. Attempting to write data directly into MOM without this module is just not fun.
There are many key fields that need to be populated correctly to work. I have scanned a few sheets of my MOM DATABASE bible. This listing outlines the fields in the import.dbf table that you need to populate (including the formatting).
Best of luck with your project.
David
David Narciso
Ecommerce Operations Manager CVS Inc
[email protected]
mobile: 4168238175
DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.
Ecommerce Operations Manager CVS Inc
[email protected]
mobile: 4168238175
DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.
#3
Guest_Stephen_*
Guest_Stephen_*
-
- Guests
Posted 24 November 2004 - 03:55 PM
Wow.. thank you very much! this answers a major question I've been wondering all night. customers looking for their oranges and gala apples had to deal with an absent minded produce worker. 
I still have 1 question tho. how is this file formated?
is it tab delimited? comma? xml?
do I need to have all of these entries in every import table file?
I have to go back over to my client's place and re get the demo cd she was going to give me. she put it into her computer to show it to me when I was there but forgot to put it back into the case. so I have a case.. but no cd
(can't go over there whenever being I don't have a car and it's on the other side of town)
I hope this isn't asking too much but if possible might it be possible to email me an example of a import table file? [email protected]
I still have 1 question tho. how is this file formated?
is it tab delimited? comma? xml?
do I need to have all of these entries in every import table file?
I have to go back over to my client's place and re get the demo cd she was going to give me. she put it into her computer to show it to me when I was there but forgot to put it back into the case. so I have a case.. but no cd
(can't go over there whenever being I don't have a car and it's on the other side of town)I hope this isn't asking too much but if possible might it be possible to email me an example of a import table file? [email protected]
#4
Videoflicks2004
-
- Moderators
-
- 241 posts
GLOBAL MODERATOR
- Gender:Male
- Location:Canada
- Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.
Posted 25 November 2004 - 07:47 AM
Hi Stephen,
It's my pleasure. I like to help out when possible.
The MOM import / export module has a setup option that will let your client either import from a comma delimited file or the option we use, a .dbf table (foxpro table).
It's upto to you to decide which method you are more comfortable creating. I will email you a sample database table that we use to import new orders. The process for creating the import file is essentially the same process as entering the order manually.
You need to populate the billing and shipping address (unless it is a repeat customer and you know the MOM assigned CUSTNUM. If you know the custnum you can populate it in the first field and MOM will match up your order to that customer during the import process.
You also have to enter the stock numbers and the qty's (just to state the obvious). The import table can only accept 5 items per line. You continue entering new items on the next line by entering a Y or X into the CONTINUED field in the import table.
Have a look at my import table that I will email you and I'm sure you will be able to whip up a posting utility to write into it. It's probably the easiest way to do it.
On the other hand, if you are not having much luck with the posting program I do sell a utility that will let your client import orders into mom from an excel spread sheet .. (only $99.00 one time fee). We use it for our customers that enter their orders directly from our excel style flyers. Saves on data entry time.
Their is a post in the forum that talks about it... Link in forum
Cheers,
David
It's my pleasure. I like to help out when possible.
The MOM import / export module has a setup option that will let your client either import from a comma delimited file or the option we use, a .dbf table (foxpro table).
It's upto to you to decide which method you are more comfortable creating. I will email you a sample database table that we use to import new orders. The process for creating the import file is essentially the same process as entering the order manually.
You need to populate the billing and shipping address (unless it is a repeat customer and you know the MOM assigned CUSTNUM. If you know the custnum you can populate it in the first field and MOM will match up your order to that customer during the import process.
You also have to enter the stock numbers and the qty's (just to state the obvious). The import table can only accept 5 items per line. You continue entering new items on the next line by entering a Y or X into the CONTINUED field in the import table.
Have a look at my import table that I will email you and I'm sure you will be able to whip up a posting utility to write into it. It's probably the easiest way to do it.
On the other hand, if you are not having much luck with the posting program I do sell a utility that will let your client import orders into mom from an excel spread sheet .. (only $99.00 one time fee). We use it for our customers that enter their orders directly from our excel style flyers. Saves on data entry time.
Their is a post in the forum that talks about it... Link in forum
Cheers,
David
David Narciso
Ecommerce Operations Manager CVS Inc
[email protected]
mobile: 4168238175
DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.
Ecommerce Operations Manager CVS Inc
[email protected]
mobile: 4168238175
DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.
#5
Guest_Stephen_*
Guest_Stephen_*
-
- Guests
Posted 25 November 2004 - 08:16 AM
excel wouldn't work being this is all comming from a sql db that is updated by forms online but thanks for the offer
that file you sent me is a foxpro db correct?
would the comma seperated list have the same extention? and may I have an example of that one too? .. from the looks of it this would be alot easier to generate
I really don't know very much about foxpro.
that file you sent me is a foxpro db correct?
would the comma seperated list have the same extention? and may I have an example of that one too? .. from the looks of it this would be alot easier to generate
I really don't know very much about foxpro.
#6
Videoflicks2004
-
- Moderators
-
- 241 posts
GLOBAL MODERATOR
- Gender:Male
- Location:Canada
- Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.
Posted 25 November 2004 - 09:11 AM
Stephen,
I've emailed you a comma del file of the same import table I emailed you earlier. Your comma del file will have the .txt extension.
-- You can import my ximp.txt file as a test if you like.
I hope this helps.
Cheers,
David
I've emailed you a comma del file of the same import table I emailed you earlier. Your comma del file will have the .txt extension.
-- You can import my ximp.txt file as a test if you like.
I hope this helps.
Cheers,
David
David Narciso
Ecommerce Operations Manager CVS Inc
[email protected]
mobile: 4168238175
DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.
Ecommerce Operations Manager CVS Inc
[email protected]
mobile: 4168238175
DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.
#7
KevinMG
-
- Members
-
- 1 posts
Newbie
Posted 10 February 2005 - 12:01 PM
Hi David,
Could I trouble you to send me those two sample files you sent Stephen? It would be greatly appreciated.
kevin (at) endsdesign (dot) com
Thanks in advance,
-Kevin
Could I trouble you to send me those two sample files you sent Stephen? It would be greatly appreciated.
kevin (at) endsdesign (dot) com
Thanks in advance,
-Kevin
#8
Videoflicks2004
-
- Moderators
-
- 241 posts
GLOBAL MODERATOR
- Gender:Male
- Location:Canada
- Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.
Posted 15 February 2005 - 10:40 AM
Hi David,
Could I trouble you to send me those two sample files you sent Stephen? It would be greatly appreciated.
kevin (at) endsdesign (dot) com
Thanks in advance,
-Kevin
Kevin,
The comma del file from the import was created easily using dbuwin.exe Open the IMPORT file and then choose the COPY TO option in dbuwin. You can save the file as a csv or dbf file.
Let me know if this helps.
Cheers,
David
David Narciso
Ecommerce Operations Manager CVS Inc
[email protected]
mobile: 4168238175
DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.
Ecommerce Operations Manager CVS Inc
[email protected]
mobile: 4168238175
DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
