Aperture Faces are Keywords in LR but with brackets in text file so not included in export BUT won't show up in SQ editor, how to mass edit?

[Benzin]

I used Apple Aperture for years and in fear of discontinuity switched to LR now at version 6.14. Now I noticed not all keywords are included in export and found out that Aperture Faces are converted to LR Keywords but they are in brackets in the Export Keywords text file meaning the are not included in exports. I downloaded an SQLite editor but in the Keywords section where 0 or 1 marks if that keywords is included in exports there are none of these Apple Faces to Keywords converted keywords. Where are they? They are clearly included in the exported keyword list text file.

I would not like to edit single one these keywords in LR Keyword list by right clicking and editing tag and selecting Include in export but I would like to mass edit the zeros to ones. Anyone know how to do it?

[GoldingD]

Filter all images on keyword containing exactly. Select all of those, change the keyword.

[Benzin]

Thanks, do you mean in Library Module, left window Catalog > All Photographs, top Library Filter > Keywords and select a certain keyword and then in right window change it? I have hundreds of faces so this is a tedious task in any manual way. Direct editing with SQLite editor would have been a great workaround. And also the Aperture face keyword "John Smith" is exactly the same as I have in working LR created "John Smith" keywords so there is no telling which is which in Library Filter > Keywords method.

[Benzin]

This is crazy. Now the SQLite editor shows also keywords generated from Aperture Faces (what I can tell by the number of all keywords, came up from around 40 to 500) and I see 0 or 1 in the Include in exports column. And I changed nothing in my tryout workflow. Now I just copied one "1" and pasted that to my filtered "0" rows and now the brackets are gone from the Export Keywords text file so now all keywords should be included when I do my photo export.

Things seem to magically fix themselves once you start questioning.