Exporting a file list of group items

[vatolin]

Morning.

I’ld like to generate a CSV or XLS list of selected items in a group. The list should contain (a) a row for each item (b) the following columns:

• create date
• author
• title
• subject
• filename

Is there a script or another tool to settle this challenge?

Kind regards, Friedrich

[korm]

Does the script Export > Metadata as CSV do what you want? If not installed already, you can install this from the Support Assistant. There are several variations already posted in this forum if you’re interested in customizing it.

[vatolin]

@korm

Does the script Export > Metadata as CSV do what you want?

Thank you! Generally the script does what I want. But in detail:

• German umlauts - ä, ö, ü - and the German sharp s - ß - are substituted by cryptic combination of signs.
• The values in the date field are strings, which can not be transformed into date/time values.

[korm]

@vatolin

German umlauts - ä, ö, ü - and the German sharp s - ß - are substituted by cryptic combination of signs.

Might be a Unicode issue – something for Christian to look into.

Here’s another user’s variation that might be useful here:

Updated Customizable Metadata Export Script (UTF16LE)

Updated the wonderful script by Christian Grunenberg to force UTF16LE encoding during export. This script will allow you to export metadata with special characters, and then import it properly into Excel for Mac (ie no strange characters in the name). Tested with a small test set (OSX 10.7.5) with Excel for Mac 2011 v 14.4.8 Works with Cyrillic, French, Farsi, Hebrew, Vietnamese Does not handle Zhongwen, Japanese, Korean If you try it on different character sets, let me know and I will updat…

The values in the date field are strings, which can not be transformed into date/time values.

“transformed” how? Is there a particular format that you’re looking for?

As @sander did in the post mentioned above, there is script that Christian posted (somewhere, don’t have time to find it) called “customizable metadata export” that might be more in line with what you need.

[vatolin]

The values in the date field are strings, which can not be transformed into date/time values.

“transformed” how? Is there a particular format that you’re looking for?

I’ld like in Excel to define the fields in the colum as short date in order to transform the string »Samstag, 3. Dezember 2016 um 13:11:25« into »03.12.2016«.

Kind regards, Friedrich

[korm]

I updated my last post with a reference that might be helpful.

Is Excel not able to transform the date string for you?

[cgrunenberg]

@korm

@vatolin

German umlauts - ä, ö, ü - and the German sharp s - ß - are substituted by cryptic combination of signs.

Might be a Unicode issue – something for Christian to look into.

Just checked this and e.g. TextEdit, Finder and DEVONthink display/import the exported file as expected. Do you use Microsoft Excel? Maybe you have to change the used encoding.