Raw XML datatype for importing existing structured data
Is there a built in (or available 3rd party) datatype that enables me to simply store raw XML data?
The UI would just need to be a simple textbox that saves any input to the database in a raw form so if you enter XML it will be parseable; the important thing is that I can automatically import a load of records from an XML file including structured data.
I don't necessarily want to create a usercontrol to manage it properly as it will never need to be done; all updates will be from the XML file.
You could try the Embedded Content package. Just add a simple textarea and you can store your raw xml in there.
Otherwise it might be best to create a custom usercontrol which does what you want. It's very easy to store xml these days: http://www.nibble.be/?p=100
You might be interested in cmsimport Pro indeed. You can schedule the import of xml files and maintain structure during the import. Only thing is that it maps against documenttypes. Dont know if that is what you want to achieve.
CMS Import is a bit overkill, it's a very simple use case and everything other than this works perfectly, so I'll probbaly look at the custom usercontrol, thanks!
Basically, you want a 'Textstring Multiple' data-type that doesn't wrap the contents/data in CDATA tags?
If you need this working 'today', then you could use the Textstring Multiple and use an XSLT extension from uComponents: Xml.Parse? It's an extra step, but it's avaliable to you straight away.
If you do anything with a custom data-type for this, do let us know - could be something to include in uComponents?
Hi, sorry for lack of response, in the end the client didn't want the functionality I was trying to support so I didn't do anything with it! I've marked Lee's response as the anwer because that would have done the trick for my usage simply and without extra development.
Raw XML datatype for importing existing structured data
Is there a built in (or available 3rd party) datatype that enables me to simply store raw XML data?
The UI would just need to be a simple textbox that saves any input to the database in a raw form so if you enter XML it will be parseable; the important thing is that I can automatically import a load of records from an XML file including structured data.
I don't necessarily want to create a usercontrol to manage it properly as it will never need to be done; all updates will be from the XML file.
If you want to import data you can use CMSImport.
You could try the Embedded Content package. Just add a simple textarea and you can store your raw xml in there.
Otherwise it might be best to create a custom usercontrol which does what you want. It's very easy to store xml these days: http://www.nibble.be/?p=100
Jeroen
Hi Rob,
You might be interested in cmsimport Pro indeed. You can schedule the import of xml files and maintain structure during the import. Only thing is that it maps against documenttypes. Dont know if that is what you want to achieve.
Check out the video on importing content '
Hope CMSImport can help you and please let me know if you have any questions.
Best,
Richard
CMS Import is a bit overkill, it's a very simple use case and everything other than this works perfectly, so I'll probbaly look at the custom usercontrol, thanks!
Hi Rob,
Basically, you want a 'Textstring Multiple' data-type that doesn't wrap the contents/data in CDATA tags?
If you need this working 'today', then you could use the Textstring Multiple and use an XSLT extension from uComponents: Xml.Parse? It's an extra step, but it's avaliable to you straight away.
If you do anything with a custom data-type for this, do let us know - could be something to include in uComponents?
Cheers, Lee.
Hi, sorry for lack of response, in the end the client didn't want the functionality I was trying to support so I didn't do anything with it! I've marked Lee's response as the anwer because that would have done the trick for my usage simply and without extra development.
is working on a reply...