12 replies to this topic

[johnay]

In the MOM demo (version 5.2) help file the section on supported data formats reads (in part): "IEM supports three types of data format: comma delimited, dBase III+, and fixed length (also known as standard data format)."

In MOM 5.3 it reads: "IEM supports four types of data format: comma delimited, dBase III+, fixed length (also known as standard data format) and XML."

The printed reference guide only refers to three, as does the pdf version I downloaded (pdf file dated 7/03.)

I can't find any more information on the XML import file format. I'm hoping it doesn't have the five-item-per-record limit. That would make it a lot easier to format our shopping cart's order files for immediate import.

Does anyone have any info on it?

[johnay]

Does anyone know if exported orders are in the same format as import order files?

I was able to export XML and comma delimited examples. The XML version is significantly longer (35.9k for a one-order export, vs 635 bytes for the comma-delimited) but because of the tagging what everything is is self-evident.

I wonder if the import/export module would choke if I included a stylesheet link in the import files to improve their readability.

[Videoflicks2004]

Hi Johnay (or anyone else who's got some test files)....could i ask you to send me the text XML and CSV files you got to successfully import.  I'm having some trouble with some of the fields, and I think if I had a 'working' example, it would help a lot.  My email is kevinmg(at)gmail(dot)com

Thanks in advance!

I'm ready for XML import into MOM 4.3 is it possible? Has anyone done it?

Johnay .. talk to me...

[johnay]

Hi Guys!

I haven't done any importing yet. We haven't even had time to get to the point where we're using MOM yet. Having it replace Quickbooks for order & customer recording & receipt printing will be our first phase. Order import won't be until the second phase, though I'm hoping for that phase to follow quickly after the first.

The XML files I made were exported from orders hand entered into MOM. I was looking at them on the assumption that XML files to be imported would be in the same format. I doubt they would work any better or worse than comma-delimited, but like I said before there is a trade-off between human readability (mostly useful for debugging) and size.

Not having 4.3, I have absolutely no idea about XML in 4.3.

[Videoflicks2004]

Hey,

It is interesting that you are moving away from Qb to MOM for order processing. I was hoping to do the opposite since QB integrates better with Able Commerce than MOM does.

Able commerce exports orders in XML format. I'll be sure to post the how to here in this forum once we get the XML to MOM import working.

Best,

David

[johnay]

Our problem with QB is the limited number of customer & item records. IIRC, in Pro it's limited to 15000 total, in Enterprise it's 30000. For a business like ours with items that come & go weekly if not daily, and a constant influx of new customers we want to track, QB is just too limiting.

Peachtree, AFAIK, does not have that limitation, but I think it also lacks QB's rich SDK.

[AlanPoint45kg]

In the MOM demo (version 5.2) help file the section on supported data formats reads (in part): "IEM supports three types of data format: comma delimited, dBase III+, and fixed length (also known as standard data format)."

In MOM 5.3 it reads: "IEM supports four types of data format: comma delimited, dBase III+, fixed length (also known as standard data format) and XML."

The printed reference guide only refers to three, as does the pdf version I downloaded (pdf file dated 7/03.)

I can't find any more information on the XML import file format. I'm hoping it doesn't have the five-item-per-record limit. That would make it a lot easier to format our shopping cart's order files for immediate import.

Does anyone have any info on it?

I am looking at a variety of options for importing orders into MOM.
Does anyone have an example of an XML import file?

[MOM Sucks]

We had the same issue. We are doing al lot of EDI with major manufacturers now, and they all require EDI.

The only way I could get it to work with MOM (4.3) was to write a VB program that parsed the XML file and then put them into a MOM DBF Import file.

Works very well.

[planetdj]

We had the same issue. We are doing al lot of EDI with major manufacturers now, and they all require EDI.

The only way I could get it to work with MOM (4.3) was to write a VB program that parsed the XML file and then put them into a MOM DBF Import file.

Works very well.

Hey MOM Sucks ,

Since you mentioned EDI, we are trying to find out if we can obtain vendor price lists in excel or another electronic format and have them "auto-import" into MOM, mapping all of the correct fields. Do you have any knowledge of this?

[imzee]

what is MOM? what does it stand for?

[johnay]

what is MOM? what does it stand for?

Look at the name of the forums.

[notehead]

Look at the name of the forums.

I have fairly extensive knowledge of this. We recently migrated to Marketlive a tier 1 e-commerse provider and the integration is all done through XML both in and out.

MOM XML is a dumb flat file in xml format. Basically I mapped xml data using a great product called mapforce from altova. It has worked great for me. The learning curve was a little steep but it cost $1500 instead of 20-50K on paying someone to do the integration.

I am always happy to share what I know so please feel free to ask or msn or even call me.