Importing Data into Custom Metadata Fields

[nigelesque]

Thank you chrillek. I have tried the script addition, but get this error message:

when I try to save.

FYI, The pseudo-csv was copied and pasted from within DT.

[nigelesque]

On a related query, how would I change the script to place the ‘cite’ reference string into the Finder Comments field? Is that doable?

This relates to the query here: Some questions to Custom Metadata - #10 by BLUEFROG
Finder Comments seems to be the only general text metadata field that syncs with DTTG – is that right?

[BLUEFROG]

Did you do this as I instructed…?

Importing Data into Custom Metadata Fields

I suspect you either don’t have the matching files in the database or you have more than one. Either condition is considered an error according to the script. Do a search for one of the missing item’s name in quotes.

---

Finder Comments seems to be the only general text metadata field that syncs with DTTG – is that right?

In a currently accessible way, yes.

[chrillek]

Replacing this
& '"'
with that
& "'"
should remedy the error. I’m really not an AppleScript person

[nigelesque]

@BLUEFROG

Did you do this as I instructed…?

Sorry, yes. Have tried with several, and each time the search returns just the one instance of the pdf file (plus the csv file which contained that reference).

[nigelesque]

Thanks – yes, that worked.

@chrillek

Then have a look at DT’s protocol.

How do I do that?

[nigelesque]

@nigelesque

On a related query, how would I change the script to place the ‘cite’ reference string into the Finder Comments field? Is that doable?

Is this doable?

[chrillek]

In the Windows menu:

[nigelesque]

Problem solved!

The issue was that I was importing the pdf files and the csv and immediately running the script. In each batch there were at least a few files that were of kind ‘PDF document’, which DT was still running OCR on when the script was run. Problem solved by waiting for all to be converted to ‘PDF+Text’. Also solved the quirk of one cite being applied to the csv itself.

So sorry for the time wasted on this, but I’m very grateful for your help.

[BLUEFROG]

You’re welcome and no time was wasted.