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

Question

Question

Possibility to import a .txt or .csv file for creation of folders and bind these folders to a specific template name in LF repository

asked on August 26, 2015

Hi All,

I want to import information from a .txt or .csv file into Laserfiche. 

Infact, the file will contain the names of their planters (i.e FUEL, Planter 1, Planter 2) and when it will be imported to LF, the folder name (i.e FUEL, Planter 1, Planter 2) will be created and its sub-folders. For the folder name (i.e FUEL, Planter 1, Planter 2), I want to bind them with a template name. Is there any pre-defined format (i.e. folder creation + folders are assigned to a specific template name) that should be used for doing the import?

Thanks to advise if this is possible.

0 0

Replies

replied on August 28, 2015 Show version history

Sheila,

Is this going to be a one time import or a recurring process?  

With my level of understanding of what you want to accomplish I would recommend creating some type of stand-alone utility or service with the Laserfiche SDK Kit that would open the CSV or text file, read it a line at a time, create the appropriate folder and assign the appropriate template to the folder.  All fairly easy tasks for the SDK if you have access to a .NET developer.

 

 

 

0 0
replied on August 31, 2015

Workflow's Query Data activity has the ability to lookup into a CSV file. I would recommend that you move the CSV file into a MSSQL table as you can query into the MSSQL multiple times. If it is a text file, it may be possible to pull out the information you need using Pattern Matching.

Just make sure that the information in the file that can easily be correlated to the file that is imported.

 

0 0
replied on August 31, 2015

Hi all,

This is a one-time process as I want to create a folder structure on LF by doing the import.

 

Can you please advise how to do it using the text file procedure? "If it is a text file, it may be possible to pull out the information you need using Pattern Matching."

 

Thanks to help

 

 

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

Sign in to reply to this post.