Transform a product gamut catalog into a xml file.

Please support our XML, XSLT and XPATH advertiser: Intel Parallel Studio Home
Thread Solved

Join Date: Jul 2008
Posts: 9
Reputation: Typhoon is an unknown quantity at this point 
Solved Threads: 0
Typhoon Typhoon is offline Offline
Newbie Poster

Transform a product gamut catalog into a xml file.

 
0
  #1
Jul 28th, 2008
Due to some changes in my company's structure, I need to transform our catalog of products in a xml file.

I need to know how can I do this provided that nobody has a technical background in the team.
Reply With Quote Quick reply to this message  
Join Date: Jul 2008
Posts: 31
Reputation: gtd is an unknown quantity at this point 
Solved Threads: 4
gtd gtd is offline Offline
Light Poster

Re: Transform a product gamut catalog into a xml file.

 
0
  #2
Jul 29th, 2008
Hi,
what kind of format are/is the file(s) you want to transform to xml ?
Talend, provider of open source data integration software.
Reply With Quote Quick reply to this message  
Join Date: Jul 2008
Posts: 9
Reputation: Typhoon is an unknown quantity at this point 
Solved Threads: 0
Typhoon Typhoon is offline Offline
Newbie Poster

Re: Transform a product gamut catalog into a xml file.

 
0
  #3
Jul 30th, 2008
Excel sheets.

Thanks for helping me.
Reply With Quote Quick reply to this message  
Join Date: Jul 2008
Posts: 31
Reputation: gtd is an unknown quantity at this point 
Solved Threads: 4
gtd gtd is offline Offline
Light Poster

Re: Transform a product gamut catalog into a xml file.

 
0
  #4
Aug 1st, 2008
Excel 2003 has various ways to export XML. For example : Save As -> XML Spreadsheet. But you obtain a ridiculous file with much more info that you might want (formatting info, etc.).

The other way to do it is to write an xml schema and load that into the spreadsheet.

If you don't know how to do it, you might use a free soft that can do it automatically better than excel.
Talend, provider of open source data integration software.
Reply With Quote Quick reply to this message  
Join Date: Jul 2008
Posts: 9
Reputation: Typhoon is an unknown quantity at this point 
Solved Threads: 0
Typhoon Typhoon is offline Offline
Newbie Poster

Re: Transform a product gamut catalog into a xml file.

 
0
  #5
Aug 4th, 2008
Like what for example ?
Reply With Quote Quick reply to this message  
Join Date: Jul 2008
Posts: 31
Reputation: gtd is an unknown quantity at this point 
Solved Threads: 4
gtd gtd is offline Offline
Light Poster

Re: Transform a product gamut catalog into a xml file.

 
0
  #6
Aug 5th, 2008
Well, you can do it with this tool : Talend Open Studio.

It is capable of doing many more things than what you're trying to do since it is a comprehensive data integration software, but as a matter of fact it can perform the operation you're describing.

Besides it is open source therefore no strings attached.
Last edited by gtd; Aug 5th, 2008 at 5:48 am.
Talend, provider of open source data integration software.
Reply With Quote Quick reply to this message  
Join Date: Jul 2008
Posts: 9
Reputation: Typhoon is an unknown quantity at this point 
Solved Threads: 0
Typhoon Typhoon is offline Offline
Newbie Poster

Re: Transform a product gamut catalog into a xml file.

 
0
  #7
Aug 11th, 2008
I gave TOS a try, and it is a very user-friendly tool, which is indeed capable of doing many more things than what I tried to do.

I managed to transform my files, and I may soon create another post (if I need help) since I plan on using this soft for other purpose, thanks a lot.
Last edited by Typhoon; Aug 11th, 2008 at 1:18 pm.
Reply With Quote Quick reply to this message  
Join Date: Jul 2008
Posts: 31
Reputation: gtd is an unknown quantity at this point 
Solved Threads: 4
gtd gtd is offline Offline
Light Poster

Re: Transform a product gamut catalog into a xml file.

 
0
  #8
Aug 12th, 2008
I'm glad I could help you.

And of course don't hesitate if you have any other question.
Talend, provider of open source data integration software.
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:



Other Threads in the XML, XSLT and XPATH Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC