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

Question

Question

Laserfiche writing to another systems SQL database.

asked on November 14, 2014 Show version history

Hello,

I am looking for a way to export data from templates or tokens that can be input into a Vision AP SQL database.

If we are just to write data to the SQL server, the users will not be able to recall the data since a lot of checks and balances systems are in place to prevent incorrect data in the tables and we would be bypassing those systems if we were to just write to the tables.

In the Vision system it has a process for the user to verify data prior to committing  the final changes to the SQL database for long term storage.

This opens the door for us write the data that we need just before the user verifies and commits the final changes.

 

The best way to do this in my mind is run the following command file with the metadata of Laserfiche populating the appropriate fields:

 

___________________________

Edit: File strings are too long.

___________________________

What is the best way to update these fields from Laserfiche into a text file? as long as we can populate the correct data into a text file the customer has the means for automating the process into Vision.

 

And if there are any confusion this is the process I need (Laserfiche Metadata) > (Text File) > (Vision Exicution of text file.)

 

Thanks.

0 0

Replies

replied on November 14, 2014 Show version history

Writing to a text file is not supported by any native activities, but can be pretty easily achieved through a script. If you Retrieve Field Values earlier in the workflow and then invoke the script you should be able to write all of those tokens to your text file.

https://answers.laserfiche.com/questions/58949/Generate-a-Text-File-of-Metadata

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

Sign in to reply to this post.