Creating a CSV in the Cloud

asked on June 15, 2020 • Show version history

Running into a few problems exporting a CSV file of metadata in the Cloud.

When I choose to download a report of my search results and choose to create a CSV, it comes out as a TSV (Tab Seperated Values) even though the extension is .CSV

Workflow has always been a good alternative to ensure we can output any kind of CSV that we need, however in Cloud I see no option to write text. In an On-Prem there is also no direct option to write text to a file, but with a combination of C# and the ability to Attach Electronic Documents from a server disk, we can write text. I do not see either C# Scripting or Attach Electronic Document from a Server Disk available in the Cloud.

0 0

replied on June 19, 2020

Hi Chad,

Could you help clarify your use case here. Does find/replace tab->comma work for your needs? Is this something that you are preferring to do manually and would just use workflow as a workaround, or are you looking to automate this task?

In terms of Cloud workflow, we are adding support for scripting with the upcoming 2020.3 release. Using the SDK this would allow you to achieve what you are talking about with using workflow to generate and upload a CSV.

0 0

replied on June 19, 2020

This is for an integration, that expects a CSV output file. Allowing us to move metadata from Laserfiche to the other software.

They can perform tasks like find replace, or open in Excel and re-save. However if we can eliminate these steps in integrations it prevents user error.

When the scripting feature is released, will it include an ability to import documents from the disk and some working disk space to write to?

1 0

replied on June 19, 2020

Thanks for the explanation.

To clarify for scripting from Cloud Workflow, on initial release the script will run using the remote agent infrastructure, so documents would be created on external disk space. The SDK supports document import, if your goal is to bring generated documents into the repository. Alternatively, you would be able to send the CSV to the other application using the script directly if that is needed for the specific integration.

1 0

replied on June 22, 2020

Ok, so we could at least get it to a hard disk, right now it looks like tab delimited is our only option though. Just wanted to make sure I was not missing anything. Thank you

0 0

Question

Question

Replies

Sign in to reply to this post.