Member Avatar for Typhoon

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.

  • 2 Contributors
  • 7 Replies
  • 210 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by gtd
Member Avatar for gtd

Hi,
what kind of format are/is the file(s) you want to transform to xml ?

Member Avatar for Typhoon

Excel sheets.

Thanks for helping me.

Member Avatar for gtd

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.

Member Avatar for Typhoon

Like what for example ?

Member Avatar for gtd

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.

Member Avatar for Typhoon

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.

Member Avatar for gtd

I'm glad I could help you.

And of course don't hesitate if you have any other question.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.