CJ XML feed - how to- URGENT

[homeideaz]

Tweet

Hi,

We are using CJ xml feeds for our site products but having many problems.

No one is able to help me ...

Problem is the individual feeds are too big and all mixed.

Eg. say efaucets xml feeds we want only the bathroom faucets .
How do I do this since its xml copying the data into new xml is not possible since so many tags. (csv we can ) but need to use xml..

How do I do this that is fins all bathroom related entries and copy to new xml then can use all feeds and output whatever data I need into new xml's and use those.

To open in excel is very tough as eg. efaucet feed is 360mb..

PLEASE HELP

[Daniel Powel]

Hi,

I'm sorry to hear you've been having some troubles. Who have you asked for help at CJ?

Your question isn't entirely clear, but I think I understand. If you want manually break down products from a feed, then you can either use something like: Magic Parser | PHP XML, RSS & CSV Parser or you could use our webservices to create your own API across numerous advertisers for certain product sets.

Let me know if this helps.

Thanks,
Dan
dpowel@cj.com

[homeideaz]

Hi,

Little confused how do u use that trid the demo but out put is some php then what ??

[Daniel Powel]

Sorry, I do not understand your question. Could you please explain the issue again?

[homeideaz]

Hi,

How would you use magicparser , tried the demo i uploaded a cj feed file and it outputted a php..
What am i supposed to do ??

[Daniel Powel]

Have you tried this?

1. Import the full feed into your database
a. If you have problems doing this then magic parser could help you.
2. Query the table where you imported the feed data for the subset of products you wish to display on your site and insert those records into your product table.
3. You’re products should now appear on your site as they will be dynamically pulled from your product table. This obviously requires that your site is coded to work by dynamically pulling products from your product table.

[homeideaz]

Actaully that was an idea just was looking for a quicker way,
Our site is fully coded for this so should not be an issue...

Thanks
Rajiv