Forum Discussion
Please FIX Quick Edit Mode (so it doesn't create duplicate items!)
Chris Gullicksen wrote:
I usually recommend pasting in about 100 rows of data at a time and then teaching the users to watch the little pre-loader validate and save each row after their paste. They also need to know that the order of the columns, formatting and required columns in the SharePoint list should be something they should be aware of to reduce any errors doing this work.
The testing I did yesterday with half that data (~50 rows) resulted in duplicates. And, yes, I was watching the pre-loader. In reality, though, how many end users do you support that will actually chunk their data like that and be patient. Those types of people are few and far between in the Higher Ed market (we're a University).
As it turns out, I did find a workaround: go to Classic Mode. The Quick Edit function in SP2013/Classic mode - in the 10 tests I did - did NOT create duplicates. It still took a long time to import the items, but it did so cleanly. Maybe in a couple years, Microsoft will have all of the bugs worked out of "Modern" lists, libraries and pages, but until then, we need to keep telling people to use Classic, which is frankly embarrassing. "Hey, check out this new SharePoint...doesn't it look great? Oh, but for this, this and that other thing, you need to switch to Classic mode." I'm glad we get to pay Microsoft for the experience of beta testing their products.
- Glad to hear that the classic mode was the answer to your issue. I don't have access to the modern UI as I work mostly with a SharePoint 2013 environment. Hopefully in a future update Microsoft will correct the issue you found.
Actually, Chris Gullicksen, I spoke a little too soon. The same problem appeared in Classic Mode as well. Some of my colleagues are seeing the same behavior in some form or another (not all items are duplicated; different thresholds for how many can be imported with ANY dupes; etc.).
So, Quick Edit still does need some attention in order for it to work as reliably as Datasheet Mode in SP2010. I'm shocked that I'm reporting that ANYTHING in SP2010 is more reliable than SPO.
- spucelik
Microsoft
Create a PowerShell script that runs every 5 minutes (or a time frame that's tolerable) as a scheduled task that looks for new spreadsheets in a library that users put the spreadsheets. The PS Script will import the data and then mark it as "Imported" by setting a flag in the library so it does not get imported again.
