I am using a U7 Grid data type (called WeekAhead) to store and render information about days of the week in my Umbraco website. Rather than manually adding new content each week I was looking to utilise CMSimport to load a spreadsheet containing the data for the days of the week.
Upon installing the package and setting up my initial import the 'settings' area is displaying the U7 Grid data type of WeekAhead but I can only select a single column from my spreadsheet.
Is there away of assigning the days of the week within my WeekAhead U7 Grid data type to specific columns within my spreadsheet, or is CMSImport not able to do this?
Sorry for the delay. Didn';t receive a notification about this topic. Out of the box this is not possible with CMSImport. But you can create a Fieldprovider that structures the data in the exact format the Grid wants. Or use the event system for set the values via code. See documentation http://soetemansoftware.nl/cmsimport/downloads
Grid support is on the list, same as Archetype etc but those types are a structure of itself and that's the hard part.
Using inconjunction with a U7 Grid data type
I am using a U7 Grid data type (called WeekAhead) to store and render information about days of the week in my Umbraco website. Rather than manually adding new content each week I was looking to utilise CMSimport to load a spreadsheet containing the data for the days of the week.
Upon installing the package and setting up my initial import the 'settings' area is displaying the U7 Grid data type of WeekAhead but I can only select a single column from my spreadsheet.
Is there away of assigning the days of the week within my WeekAhead U7 Grid data type to specific columns within my spreadsheet, or is CMSImport not able to do this?
If not can this be done with custom code
Hi David,
Sorry for the delay. Didn';t receive a notification about this topic. Out of the box this is not possible with CMSImport. But you can create a Fieldprovider that structures the data in the exact format the Grid wants. Or use the event system for set the values via code. See documentation http://soetemansoftware.nl/cmsimport/downloads
Grid support is on the list, same as Archetype etc but those types are a structure of itself and that's the hard part.
Hope this helps you for now.
Best,
Richard
Thanks Richard, I will look into using Fieldprovider's injunction with CMS Import. KR David
+1
is working on a reply...