Exporting metadata from Multiple Flows in a single project

Is there a way to export all the metadata from multiple flows in a single project to a .csv file?

File > Export > Text will produce a CSV will of the text items in a project (metadata and dynamics/tempos/text frames). Then you can filter by flow and type to get what you want.

Thanks for the help. I extracted this way before and tried it again. It gives me a very large spreadsheet and one column has every item (Composer, Copyright, etc.) in it. I guess I need to figure out how to manipulate that data in a spreadsheet program. I was hoping that it would categorize it a little better.

What were you expecting? (And how would Dorico know what you were expecting?)

It’s one row per text item, with each item tagged in some way. If you sort the sheet by the Type column, all of the flow metadata starts with “Flow Info”, so they all show up together. You could use a formula in Excel to extract the bit after “Flow Info”, and combine that with the flow number column.

Thanks. I have started to figure out some formulas to do this.

I was hoping that items such as “Title” would all be in one column. Composer all in one column.

I wasn’t expecting Dorico to know what I was expecting.

Just asking for advice.

The CS in CSV stands for comma-separated. If the CSV file is opened in a text editor, there should be commas separating each item of information. When importing it into a spreadsheet application, you might need to specify what the separators are. At least on the Mac version of Microsoft Excel, with a new blank spreadsheet open and then having chosen File > Import and selected the file, an import “wizard” opens up asking how the data should be treated. The second screen shows this:

“Comma” should be the only Delimiter selected.

1 Like

That would work if Dorico were exporting only the flow/project metadata. But since it’s exporting all text data (which can be very useful!), each row has to have a way of identifying one piece of text, whatever it is.

1 Like

Thank you for the help. I understand the huge volume issue I am dealing with now. I just need to get better manipulating data in Numbers (Excel) once I extract the data.

1 Like

Using Numbers (rather than Excel) to open a CSV file I was presented with this showing at the top right of the table.

Clicking on it then displayed this.

If Fixed Width is selected, then all the information will be put into one column.
If Delimited is selected, the type of Delimiter (Separator) can then be set to tab, comma, semicolon or space. After choosing comma and then clicking Update Table, the data should be separated into columns.

And I wasn’t being judgemental - just curious.

The information imported properly (comma delimited). It just needs some stuff changed from columns to rows, etc in order for me to use the data like I need. My issue is more of spreadsheet adjustment rather than anything I am getting from Dorico.

OK. I was just going on what you had written in your second post in this thread.

Gotcha.

I have a feeling that Excel has a Transpose feature which will sort of flip the data so that columns become rows and vice versa. I have never used it, but have seen it mentioned somewhere.

I have discovered the same. I was trying to use Numbers on a Mac. It does not have the transpose feature that Excel has.

This might help:

although it could depend on which version of Numbers you are using (ie it might be a fairly recent addition which is only in newer versions of Numbers).