Importing - Excel sheet not picked up from import definition
When importing from a location, let's say c:\projects\project\docs\things.xlsx. When I create an import definition (and save it). When I execute it again, it won't pickup the updated Excel sheet. It happens in 6.0. So what I do for workaround is editing the import definition, choosing the xlsx again, and press save.
Side issue: when I do that, some fields of the import definition are not remembered and I must manually make them empty by selecting --ignore-- and saving the definition again.
I'm able to reproduce if you would like to take a look (remote control) just drop me a mail.
This is because the file is read from the location and then will be cached for x minutes, I'll check if i can add a dependency on the source location to invalidate the cache, The other issue is because it automaps after after uploading the new document.. This is done because sometimes you have like 10 properties extra then they will be automapped . I will check if I can change that to not automap.
I will log this issue as a tick for the 2.3.2 service release.
I'm using CMSimport Pro V2.3.3 with excel as the data source and suffering from this problem that Merijn reported, namely that when I execute a saved import definition it does not use my latest and greatest excel data.
How can I force it to reload the spreadsheets from my desktop?
Also and annoyingly it loads content a second time rather than updating the existing items, thus doubling the number of items in the content tree. At completion it reports that it has updated the correct number of nodes.
I'm working around this by deleting the content and recreating the import definition every time - but now want to simplify the procedure so that I can hand it over to an editor.
If you add the Excel document on a location Umbraco/CMSImport can access then you can point to that url. For example if you create a data folder in your Umbraco installation and add the excel file there then it will be picked up. Web applications can never access the desktop so that will not work.
I'm intersted in the loads content second time issue since that should not happen. Which version of Umbraco are you using? I've experienced some issues with Umbraco V6 like the ones Merijn reported but thought I had them all covered now in 2.3.3.
Could it be possible that most of the documents exists in the recycle bin. Just tested agaisnt 4.11.8 and items got updated correctly. If the documents are not in recycle bin folder I'm interested in your spreadsheet and screenshots how you mapped the items if possible? Think easiest to send to [email protected] during the weekend (we also have a bank holiday on Monday) I'm not behind a computer all the time but will check if I have some time.
Importing - Excel sheet not picked up from import definition
When importing from a location, let's say c:\projects\project\docs\things.xlsx. When I create an import definition (and save it). When I execute it again, it won't pickup the updated Excel sheet. It happens in 6.0. So what I do for workaround is editing the import definition, choosing the xlsx again, and press save.
Side issue: when I do that, some fields of the import definition are not remembered and I must manually make them empty by selecting --ignore-- and saving the definition again.
I'm able to reproduce if you would like to take a look (remote control) just drop me a mail.
Hi Merijn,
This is because the file is read from the location and then will be cached for x minutes, I'll check if i can add a dependency on the source location to invalidate the cache, The other issue is because it automaps after after uploading the new document.. This is done because sometimes you have like 10 properties extra then they will be automapped . I will check if I can change that to not automap.
I will log this issue as a tick for the 2.3.2 service release.
Cheers,
Richard
Ha Richard,
Thanks for solving!!!! being kind and having a look :-)!
Merijn
You are welcome, but it's not solved yet....
Hi Richard
I'm using CMSimport Pro V2.3.3 with excel as the data source and suffering from this problem that Merijn reported, namely that when I execute a saved import definition it does not use my latest and greatest excel data.
How can I force it to reload the spreadsheets from my desktop?
Also and annoyingly it loads content a second time rather than updating the existing items, thus doubling the number of items in the content tree. At completion it reports that it has updated the correct number of nodes.
I'm working around this by deleting the content and recreating the import definition every time - but now want to simplify the procedure so that I can hand it over to an editor.
Regards
John P
Hi John,
If you add the Excel document on a location Umbraco/CMSImport can access then you can point to that url. For example if you create a data folder in your Umbraco installation and add the excel file there then it will be picked up. Web applications can never access the desktop so that will not work.
I'm intersted in the loads content second time issue since that should not happen. Which version of Umbraco are you using? I've experienced some issues with Umbraco V6 like the ones Merijn reported but thought I had them all covered now in 2.3.3.
Thanks,
Richard
Hi Richard
Ah, obvious when you see it. Thank You.
RE: loading twice - I probably should have created this as a separate thread.
I'm using umbraco v 4.11.8 (Assembly version: 1.0.4869.17899)
The spreadsheet is available if that helps. It has Categories(4), Sub-categories(26), and products(824).
Rgds
John P
Hi John,
Could it be possible that most of the documents exists in the recycle bin. Just tested agaisnt 4.11.8 and items got updated correctly. If the documents are not in recycle bin folder I'm interested in your spreadsheet and screenshots how you mapped the items if possible? Think easiest to send to [email protected] during the weekend (we also have a bank holiday on Monday) I'm not behind a computer all the time but will check if I have some time.
Thanks,
Richard
is working on a reply...