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

Question

Question

Extract Laserfiche Data to Excel via query/data source

asked on October 10 Show version history

Question relating to Laserfiche 10.2.1.953. I am wanting to get data straight from the Laserfiche repository either directly in Excel using the Data Source/Power Query area, without having to run reports inside Laserfiche and manually export them to Excel.

 

Is this possible and how do I set it up? The report I currently manually use simply exports field text/values from document meta-data that we have keyed in.

0 0

Replies

replied on October 11 Show version history

You can attach to the repository database and directly query the metadata. I would recommend creating a read-only database user for that purpose.

If you want a scheduled export of data based on searches, using Workflow, you might give Jason's answer here a look.

If you can describe a little bit about what you need to report on, we can help with specific queries.

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

Sign in to reply to this post.