Jump to content


Photo

XML Import


  • Please log in to reply
12 replies to this topic

#1 johnay

johnay

    Advanced Member

  • Members
  • PipPipPip
  • 92 posts

Posted 10 September 2005 - 04:59 PM

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?

#2 johnay

johnay

    Advanced Member

  • Members
  • PipPipPip
  • 92 posts

Posted 14 September 2005 - 08:09 AM

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.

#3 Guest_Kevin_*

Guest_Kevin_*
  • Guests

Posted 28 September 2005 - 01:02 PM

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.

View Post


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! :)

#4 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 16 December 2005 - 09:26 PM

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! :)

View Post


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

Johnay .. talk to me...
David Narciso
Ecommerce Operations Manager CVS Inc

dnarciso@cvsinc.ca

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 johnay

johnay

    Advanced Member

  • Members
  • PipPipPip
  • 92 posts

Posted 17 December 2005 - 08:28 AM

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.

#6 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 18 December 2005 - 06:39 AM

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
David Narciso
Ecommerce Operations Manager CVS Inc

dnarciso@cvsinc.ca

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 johnay

johnay

    Advanced Member

  • Members
  • PipPipPip
  • 92 posts

Posted 19 December 2005 - 06:34 AM

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.

#8 AlanPoint45kg

AlanPoint45kg

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 29 February 2008 - 02:39 PM

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?

#9 MOM Sucks

MOM Sucks

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 24 April 2008 - 12:11 PM

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.

#10 planetdj

planetdj

    Advanced Member

  • Members
  • PipPipPip
  • 109 posts
  • Location:Reno, NV, USA

Posted 26 April 2008 - 09:51 AM

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 :lol: ,

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?
Chris Whybrew
PLANET DJ, INC
www.planetdj.com

#11 imzee

imzee

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 29 January 2009 - 02:53 AM

what is MOM? what does it stand for?

#12 johnay

johnay

    Advanced Member

  • Members
  • PipPipPip
  • 92 posts

Posted 29 January 2009 - 06:26 AM

what is MOM? what does it stand for?


Look at the name of the forums. ;)

#13 notehead

notehead

    Advanced Member

  • Members
  • PipPipPip
  • 52 posts

Posted 05 February 2009 - 02:07 PM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users