You are viewing limited content. For full access, please sign in.

Question

Question

Can I use excel spreadsheet to generate folders?

asked on May 30, 2018

I have a file structure listed in an Excel spreadsheet.  I need to make folders for them in Laserfiche.  Is there a quick way to do this?

0 0

Answer

SELECTED ANSWER
replied on May 30, 2018 Show version history

My experience working with excel in Workflow hasn't been too positive so far so I suggest importing your excel into your SQL database first. This link gives you a very straight forward step-by-step guide on how you can import a CSV file (which you can easily save your excel as) into your SQL db. Just make sure that the first row of your CSV corresponds to your column headers. From there, Lidija's approach should do the job.
https://support.discountasp.net/kb/a1179/how-to-import-a-csv-file-into-a-database-using-sql-server-management-studio.aspx

Best, 

Ken

 

0 0
replied on June 27, 2018

I was able to do this successfully.  Thanks for the recommendation. 

0 0

Replies

replied on May 30, 2018

Depending how you listed it and if you have experience with Worklfow, I think you can. You would add an ODBC connection to that Excel spreadsheet, query it, then with tokens create new folders.

0 0
replied on May 30, 2018

Yes, as @████████said you can use workflow tools to to that.. If you can provide a sample of your spreadsheet which contains the folder structure it will be better.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.