I am looking for a tool (if possible free version) to export content and import it back . For instance we are looking at bulk exporting all SEO related data such as title meta tags and then it gets updated in excel and we import it back. I saw csv import stuff but not sure how to first export it and then use that tool. Any suggestion for alternative will be very helpful
You can create a simple macro that creates a CSV file (which you can open in Excel) and then edit and then write another one which reads a source file looping through "getting" the node, updating the properties and then Save (and optionally publishing).
It's not hard to do - a combination of the link above and a simple c# csv read write example will give you what you need.
Bulk Export /Import from Excel/CSV
Hi,
I am looking for a tool (if possible free version) to export content and import it back . For instance we are looking at bulk exporting all SEO related data such as title meta tags and then it gets updated in excel and we import it back. I saw csv import stuff but not sure how to first export it and then use that tool. Any suggestion for alternative will be very helpful
Regards Raghav
Hi Raghav,
Perhaps you can use the package called CMSImport to solve your case https://our.umbraco.org/projects/developer-tools/cmsimport/
You can see how it works here. http://soetemansoftware.nl/cmsimport/videos
Hope this helps,
/Dennis
Hi,
As Dennis says CMS Import is the easy way to go. It's also pretty trivial to bake something custom using the ContentService - https://our.umbraco.org/documentation/reference/management/services/contentservice
You can create a simple macro that creates a CSV file (which you can open in Excel) and then edit and then write another one which reads a source file looping through "getting" the node, updating the properties and then Save (and optionally publishing).
It's not hard to do - a combination of the link above and a simple c# csv read write example will give you what you need.
HTH Steve
is working on a reply...