not strictly an Umbraco question but I thought I'd ask here anyway for any ideas
a user wants to import a range of data from Excel which includes a node_id as a column, and then a couple of properties will be updated on that content node with the data from the other columns
looping through the data and updating the nodes etc is simple and i am happy with that
but i can't choose between a few different ways to get the data
1) save the worksheet as an xml file upload it and extract the data
2) save the worksheet as some kind of CSV file upload it and extract the data
3) get the user to copy & paste to infopath first and then either save the xml from there or submit to a webservice
4) add a control to the web page where the range can be copied and pasted and submitted
5) add some sort of VSTO button into excel "copy to umbraco" that validates it as a suitable range and then communicates to some kind of web service
Only one user will ever be doing this, they are using Office 2007 so can be fairly rigid about the users set up. If they are ever replaced they will use the same PC and desk.
If you want to import data into Umbraco you can export to csv and then you can use CMSImport http://our.umbraco.org/projects/developer-tools/cmsimport to import the data into Umbraco. CMSImport is Free for importing 500 records.
Sorry for the delay. Yes you could move CMSImport tab to the content section. It's not the most userfriendly solution but it will work. In later versions of CMSImport I will make it possible that you can setup an Import definition for your client and that your client can execute that by a single click (and the upload of the file ofcourse) That will be better for usability.. Don't know when that will see the day of light. First I want to focus on Structured Imports.
As a work around you can create an UserControl which uploads a file to a specific folder in your Umbraco Install. Then Use CMSImport to point to that location instead of uploading a file.
When you save the wizard steps you have an right click option to run the import again. Basically that calls an url (Fiddler knows the full url and query parameters ;-))and when you are logged in you can run the import. You can use that url in your usercontrol that uploads the file and when the file is uploaded execute the import by calling that url.
Think it will be a little bit of programming but it will be much more user friendly IMHO.
import data from excel
not strictly an Umbraco question but I thought I'd ask here anyway for any ideas
a user wants to import a range of data from Excel which includes a node_id as a column, and then a couple of properties will be updated on that content node with the data from the other columns
looping through the data and updating the nodes etc is simple and i am happy with that
but i can't choose between a few different ways to get the data
1) save the worksheet as an xml file upload it and extract the data
2) save the worksheet as some kind of CSV file upload it and extract the data
3) get the user to copy & paste to infopath first and then either save the xml from there or submit to a webservice
4) add a control to the web page where the range can be copied and pasted and submitted
5) add some sort of VSTO button into excel "copy to umbraco" that validates it as a suitable range and then communicates to some kind of web service
Only one user will ever be doing this, they are using Office 2007 so can be fairly rigid about the users set up. If they are ever replaced they will use the same PC and desk.
Hi,
If you want to import data into Umbraco you can export to csv and then you can use CMSImport http://our.umbraco.org/projects/developer-tools/cmsimport to import the data into Umbraco. CMSImport is Free for importing 500 records.
Cheers,
Richard
maybe not such a crazy idea
presumably if i went pro i could set up the import as a saved import ? so the process was easy for the user once i'd set it up
can it take a number of columns import them to a new folder of a specified document type to a specified document type
ie
Imported Data Folder (has properties like Title; Date; Captions; Summary etc that are set by the user)
+ Imported Data Line ( has the properties from each column of the csv )
Written like this it looks like a CMS import problem
Been trying to push CMSImport to this customer for some other uses, but this really could be quite good.
I see your next post is your 1000th :)
If there is a saved import, is there any way to make that accessible to the user to run without the users needing to access the developer tab?
sorry... just seen the answer to this here:
http://our.umbraco.org/projects/developer-tools/cmsimport/using-umbimport/12442-Move-CMSImport-node-to-custom-section
Hi John,
Sorry for the delay. Yes you could move CMSImport tab to the content section. It's not the most userfriendly solution but it will work. In later versions of CMSImport I will make it possible that you can setup an Import definition for your client and that your client can execute that by a single click (and the upload of the file ofcourse) That will be better for usability.. Don't know when that will see the day of light. First I want to focus on Structured Imports.
As a work around you can create an UserControl which uploads a file to a specific folder in your Umbraco Install. Then Use CMSImport to point to that location instead of uploading a file.
When you save the wizard steps you have an right click option to run the import again. Basically that calls an url (Fiddler knows the full url and query parameters ;-))and when you are logged in you can run the import. You can use that url in your usercontrol that uploads the file and when the file is uploaded execute the import by calling that url.
Think it will be a little bit of programming but it will be much more user friendly IMHO.
Cheers,
Richard
congratulations on your 1000th post :)
and thank you too
the customer was very impressed and say they will be sending you an order shortly
thanks for the tips too
is working on a reply...