I get a lot of information on spreadsheets that must be uploaded to Tridion (usually one line per component). Currently I am using Core Service to upload this data but it's a time consuming job defining the xml schema templates each time (I have a lot of schema definitions). I can't help thinking that this is a common requirement and someone has already come up with a good solution.
Can anyone suggest a solution?
Here's a scenario
I am a content editor, I am good at organising data but I don't know how to write software (I don't really know what XML is).
A third party company provides me with data about the 1000 richest people in the world. Fields may be
Estimated Wealth. I create a
RichPerson Schema reflecting these fields with the
Country being a component link. Now I need to put all this data into Tridion, I can't do it manually, it would take me about a week and I'll probably make a mistake.
So, I convert all the countries in the spreadsheet to tcms of existing components. I then use some program to upload all this data as a particular schema. As long as I name the field titles correctly the program works out where to put the data.