4 {{ upvoteCount | shortNum }}
4 {{ upvoteCount | shortNum }}

Questions about an XML datafeed

by Talltom1
3 replies
OK, I admit I'm tearing my hair out and I don't have much to begin with.

I'm taking on a new supplier, that has xml datafeeds for the products. I'm at a complete loss of how to work with this data.

I can't load it into excel, find a way to convert it into a csv, or import it into Magento.

Can somebody PULLEEZ get me pointed in the right direction?

Talltom
#datafeed #questions #xml
  • Profile picture of the author SunilTanna
    XML feeds are usually read by scripting languages like PHP, etc. If you look in PHP, there is a bunch of functions for parsing and processing XML files.

    It may or may not make sense to convert it to CSV.

    A CSV assumes assumes each row/record is the same structure. That isn't necessarily the case in XML.
    Signature
    ClickBank Vendor?
    - Protect Your Thank You Pages & Downloads
    - Give Your Affiliates Multiple Landing Pages (Video Demo)
    - Killer Graphics for Your Site
    SPECIAL WSO PRICES FOR WARRIORS + GET THE "CLICKBANK DISCOUNT" TOO!
    {{ DiscussionBoard.errors[8052701].message }}
  • Profile picture of the author Talltom1
    OK - I can follow that. However I thought Excel natively had the ability to read in an XML file. Am I wrong?
    Signature

    {{ DiscussionBoard.errors[8052725].message }}
  • Profile picture of the author AverageGuy
    in a simple way to explain, XML is just a text file. You can use notepad open it.

    XML has certain structure, you can use xml viewer to view it, i.e. Internet Explorer.

    As for a data feed, the XML must have certain node with certain properties. you just need to open it in notepad, fill in the properties.

    a good way is to get a sample xml file from supplier, then convert it to the feed that magento can load.
    {{ DiscussionBoard.errors[8053021].message }}

Trending Topics