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

Question

Question

Custom Query using a direct connection to an Excel file in the repository.

asked on April 3, 2014

I am building a workflow whose starting condition will be when an Excel file is placed in the repository.  The first step in the workflow is to use the Custom Query activity to query the Excel file (I know this isn't best practice, but it works for the situation). I have the workflow functioning when the file is placed on the local machine, but I can't get it to open the file when the file is in the repository.  Is this possible?

 

0 0

Answer

SELECTED ANSWER
replied on April 3, 2014 Show version history

Ok, the ODBC driver will need to know where to access the excel file and it can't be supplied with a Laserfiche login to go get it :)

 

If you go to your administration console and configure a default repository under server settings then you should be able to access all files in that repository by the following path \\lfservername\lf. Test it out in Windows Explorer. You will notice none of the files have extensions, but if you open the excel file in excel, it will open as a native excel file.

 

If you only have one workflow instance running at a time you could copy the excel file to a temporary folder with a specific name that the ODBC connection is expecting.

 

Otherwise you may need to programmatically configure your ODBC connection strings.

 

 

Edit: LF handles sharing based on Access Rights for Windows Authenticated users but this could cause other security vulnerabilities as tags and scope do not exist in Windows. The more secure method may be to temporarily export the excel file to a hard drive.

 

0 0

Replies

replied on April 3, 2014

What connection are you using? ODBC?

0 0
replied on April 3, 2014

Yes, sorry.  Direct Connections using the ODBC Data Source Type.

0 0
replied on April 3, 2014

Cool.  Not the answer I was hoping for, but it makes sense.  Thanks!

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

Sign in to reply to this post.