question

Thijs Damsma avatar image
0 Likes"
Thijs Damsma asked Jason Lightfoot edited

How can I export a processflow List as csv or excel table?

I have a list in my processflow, for which I have defined a few columns via the "advanced" button, so that it has several columns when I view the entries via the "View Entries" option. Now I want to export exactly what I see when I press view entries as either a csv or xlsx file, but I can't get it to work.

Using the eyedropper on the table yields

MODEL:/Tools/ProcessFlow/ProcessFlow/In vlissingen>stats/instances/ProcessFlow/list

But the resulting excel file only has a single column titled onPull containing only zeros.

Choose One
listsexport
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Matt Long avatar image
0 Likes"
Matt Long answered Jason Lightfoot edited

There currently isn't an automated mechanism to export data from a List. What you see in the List Entries and List Back Orders tables are compiled data from a specific structure stored in the List. The easiest way to copy the data would be to manually open the Entries/Back Orders, select the columns you want to copy and use Ctrl + C to copy the data, then Ctrl + V to paste the data into an Excel Workbook.

· 2
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

fiz avatar image fiz commented ·

Hi Matt, is this still available? I am unable to see your answer as I have the same question.

1722907742518.png

0 Likes 0 ·
1722907742518.png (67.3 KiB)
Jason Lightfoot avatar image Jason Lightfoot ♦♦ fiz commented ·

This is a problem with the site software. I've edited the posts to make them visible. Note that if your process Flow list is pointing to a Global List you can use Table.query() to access and copy that data.

0 Likes 0 ·