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?
Question
Question
Answer
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
Replies
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.
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.