Hi David,
Probably a stupid question but what programs can I use to open xml feeds and view them before importing into database. Have being using CSV files up until now and viewing them in Excel/Open Office. Would like to view in column format and be able to filter within the program to find the categories I want to use. Have tried to open an XML file in openoffice and it opens in the Word Processor.
Thanks
Adrian
Hi David,
Do you know of anyway in Firefox to filter all of the "masterCategory" from the following
<product>
<Advertiser>AJ Electronics Limited</Advertiser>
<language>EN</language>
<masterCategoryID>9</masterCategoryID>
<masterCategory>Televisions</masterCategory>
<offerID>AG682S</offerID>
<productID>28717264</productID>
<productname>Alphason AG682S Silver Universal bracket stand</productname>
<brand>Alphason</brand>
<promotionText></promotionText>
<description></description>
−
<deepLink>
http://www.awin1.com/pclick.php?p=28717264&a=63365&m=980
</deepLink>
−
<imageURL>
http://www.ajelectronics.co.uk/images/products/large/ag682s.jpg
</imageURL>
<delivery></delivery>
<validFrom>0000-00-00</validFrom>
<validUntil>0000-00-00</validUntil>
<Price>199.00</Price>
</product>Thanks
Adrian
Hi Adrian,
I'm afraid there's no easy way to do this via a browser, they're really only suitable for viewing entire documents.
Is it a list of all masterCategory values that you are after?
Cheers,
David.
Hi Adrian,
If you don't want to edit the file, a web browser is the best thing to use - both Internet Explorer and Firefox display XML nicely, and you can open / close nodes etc.
Just use the "Open File..." (or equivalent) menu option and browse to the XML file on your location computer - that should be all you need to do; however be aware that large product feeds may take a long time to come up whilst the browser builds the document tree...
Cheers,
David.