Extracting ZIP file CSVs from a sharepoint account.

[alexloudon]

Hi there,

It is possible to exctract multiple ZIP files from a sharepoint folder?

So far I haven't been able to find a way to do it. 

Thanks!

[SeanAdams]

Hey @alexloudon - I've not come across this myself - but an approach to tackle this would be to tackle this as a single-file solution (i.e. get this running for 1 file) and then wrap this in a batch macro and run this once per file?

If this doesn't work - I'd probably revert to:

- Negotiate with the data providers to give me a DB connection to point to

- if this doesn't work, can they put this data on a network path instead

- if this doesn't work, is there a possibility to automate moving the files with some python

Good luck @alexloudon - if you find a solution - well worth posting it here to add to the body of knowledge.

Sean