Hi, I'm looking on purchasing CMSImport for the update feature. I used this plugin to my previous cms to Umbraco, but now I have about 1,000 nodes to update and I don't want to do it manually!
I saw that CMSImport can update nodes when in Pro version. How does it works? I add a column in my csv with the nodes ID to map the good update to the good nodes? Also, I'm on a temporary server with a temporary url during developpement, will I have trouble to migrate the pro version to my production server?
The update functionality works only when you imported the documents the first time with Pro also. With the Pro version you specify a primary key column in your datasource durimg Import. CMSImport will add a relation and during the next import this relation will be used to determine if the record was allready imported or if it is a new one.
No not out of the box. You'll have to program a few lines of code to determine the update yourself using teh event system, or build the relationtable yourself.
Hi Richard, I just bought CMSImport pro version and I'm trying to figure out how update content works. My nodes already existed, so I export all the data to a csv file. I erased all nodes. So it's as they never existed. In my csv, I added a row called ID (which is the node number). Then I try to upload the new data and the import failed.
What am I doing wrong? I want to able to edit the csv file and update nodes frequently.
What is the error that you get? A more detailed description of the error is stored in the UmbracoLog table. If the error is vague you can send the csv to richard[at]soetemansoftware[dot]nl also and I will have a look
The error is bacause the installer failed to install the database tables (you needed dbo rights to install). You can man perform a manual install which is describes in chapter 9 of the manual which can be found at http://www.cmsimport.com/documentation.aspx
How update nodes feature works
Hi, I'm looking on purchasing CMSImport for the update feature. I used this plugin to my previous cms to Umbraco, but now I have about 1,000 nodes to update and I don't want to do it manually!
I saw that CMSImport can update nodes when in Pro version. How does it works? I add a column in my csv with the nodes ID to map the good update to the good nodes? Also, I'm on a temporary server with a temporary url during developpement, will I have trouble to migrate the pro version to my production server?
Thank you for your answers!
Hi,
The update functionality works only when you imported the documents the first time with Pro also. With the Pro version you specify a primary key column in your datasource durimg Import. CMSImport will add a relation and during the next import this relation will be used to determine if the record was allready imported or if it is a new one.
You can read more about this functionality in the manual which can be found at http://www.cmsimport.com/documentation.aspx
Hope this helps you,
Richard
Ok thank you... so there's no way to update some info in lots of node at same time if they already exist. Ok, I'll think about that.
Hi,
No not out of the box. You'll have to program a few lines of code to determine the update yourself using teh event system, or build the relationtable yourself.
Cheers,
Richard
Hi Richard, I just bought CMSImport pro version and I'm trying to figure out how update content works. My nodes already existed, so I export all the data to a csv file. I erased all nodes. So it's as they never existed. In my csv, I added a row called ID (which is the node number). Then I try to upload the new data and the import failed.
What am I doing wrong? I want to able to edit the csv file and update nodes frequently.
Thank you again!
Hi,
What is the error that you get? A more detailed description of the error is stored in the UmbracoLog table. If the error is vague you can send the csv to richard[at]soetemansoftware[dot]nl also and I will have a look
Cheers,
Richard
Hi, I can't see the table because I can't access it. In cmsimport I got
Invalid object name 'CMSImportRelation'.
Hi,
The error is bacause the installer failed to install the database tables (you needed dbo rights to install). You can man perform a manual install which is describes in chapter 9 of the manual which can be found at http://www.cmsimport.com/documentation.aspx
Cheers,
Richard
Hi, you were right! The database... now it works perfectly.
Perfect!
is working on a reply...