Sharepoint CSV Export Issue

Question

We are trying to run a bot that exports a list to a CSV file so that we can work with it from there. When on my user account, I am able to export the list to a CSV without any issues. When trying to do this from the bot's account however on the VM, the downloaded spreadsheet that I get on Excel only contains the column headers with all the columns being empty and it drops down to a 1 KB file, losing all of that data from Sharepoint. We have tried on Chrome and on Microsoft browsers. It worked one time on Edge, but every attempt since then has given the same result with an empty table. Any suggestions/similar issues?

Answer 1

Hi Thomas Pericak,

Thanks for the updates. if the issue doesn’t happen under InPrivate mode, this may indicate the issue related to browser cache. I would suggest you try clear Browser cache and check the result. Check the link on how to clear Cache in Edge(steps is the same in Chrome as New Edge is Chromium): View and delete browser history in Microsoft Edge. Or you may try download another browser like Firefox, use this and check the result.

If you have multiply accounts and would like to sign in them on one device at the same time, it could be a good idea to sign in them in different browsers, in that way you may avoid issue caused by browser cache or account conflict.

Best Regards,

Clark

Answer 2

Hello Clark,

The problem has been solved and appears to have been related to the cache as you said. We added steps to our bot to clear the cache on Chrome before starting it's normal process every time and that is working. Thank you very much for your help!

Answer 3

Hi Thomas Pericak,

Welcome to post back and share any updates you get with us.

Best Regards,

Clark

Answer 4

Clark,

Thank you for the quick response! So I am able to export to csv when I do this task inPrivate. For the sake of the bot not having to put sign-in information every time since it is an inPrivate window, do you have any ideas what could be causing this to work only inPrivate and how we could fix it in the normal browser? The bot has full control permission and I added the edit permission to be safe. So far inPrivate is the only solution.

Answer 5

Hi Thomas Pericak,

I go through the post carefully, based on the description, it seems that you get no data in exported csv file when login in SharePoint with your Bot account. As for the issue, here are some suggestions:

1. When you export the list, please make sure you change to “All items” view with no filters. Then export the list again and check the result.
2. Try open the list under inPrivate mode, then export the list and check the result.
3. Assign Edit permission to the bot account for the list. Then export the list again and check the result.
4. To check if the issue related to VM environment, try login the account on local devices, export the list and check the result.

If the issue still persists, could you please share information below with us for further troubleshooting?

1. Are you using any scripts?
2. If you create a new list with some simple records in it, can you export the list normally with bot account?
3. What if you export the list from Local machine?

Regards,

Clark