We are considering using CMS Import for the Umbraco project we're currently working on. Most of the data I think should be fairly easily imported but I have 1 field which is a taxonomy (associated content), in the database this is a comma separated list of the associated Umbraco Content Ids.
How we'd like this to work is for the Excel column to contain a column with a comma separated this of Item names (e.g. Item A, Item C, Item E) and then this to be translated to the corresponding Umbraco Ids for those items when adding that property for the content node to the database (e.g. 1285, 1339, 1341).
Any suggestions or examples on how we'd get this to work would be appreciated.
I think this already works out of the box, 100% sure on comma separated list of nodenames. Just use Multi node tree picker then CMSImport converts the items to data MNTP understands.
Thanks for that we actually use our own custom Taxonomy Picker control for the CMS content (rather than an Multi node tree picker) will that be an issue?
Thanks for that, pretty much sorted using a FieldProvider I'm intercepting the required field and can see it's equal to "Value A, Value C" which I can easily split then and work on each value. I was wondering what's the similest way to query the Umbraco Cache from a field provider to get the ID where title is 'Value A' and itemtype is 'Taxonomy' within children of a specific node. Know how to do it from the frontend but not so sure with the back end.
Importing taxonomy data
Hi,
We are considering using CMS Import for the Umbraco project we're currently working on. Most of the data I think should be fairly easily imported but I have 1 field which is a taxonomy (associated content), in the database this is a comma separated list of the associated Umbraco Content Ids.
How we'd like this to work is for the Excel column to contain a column with a comma separated this of Item names (e.g. Item A, Item C, Item E) and then this to be translated to the corresponding Umbraco Ids for those items when adding that property for the content node to the database (e.g. 1285, 1339, 1341).
Any suggestions or examples on how we'd get this to work would be appreciated.
Thanks Andy
Hi Andy,
I think this already works out of the box, 100% sure on comma separated list of nodenames. Just use Multi node tree picker then CMSImport converts the items to data MNTP understands.
Hope this answers your question.
Best,
Richard
Hi Richard,
Thanks for that we actually use our own custom Taxonomy Picker control for the CMS content (rather than an Multi node tree picker) will that be an issue?
Thanks Andy
Hi Andy,
Depends on the format. But you can always create a Fieldprovider that transforms the mapped value in the value you need in the picker.
Best to check the manual https://soetemansoftware.nl/cmsimport/downloads for a sample. It's really simple to implement.
Hope this helps you,
Richard
Hi Richard,
Thanks for that, pretty much sorted using a FieldProvider I'm intercepting the required field and can see it's equal to "Value A, Value C" which I can easily split then and work on each value. I was wondering what's the similest way to query the Umbraco Cache from a field provider to get the ID where title is 'Value A' and itemtype is 'Taxonomy' within children of a specific node. Know how to do it from the frontend but not so sure with the back end.
Thanks Andy
is working on a reply...