Posts tagged with Data migration

excel_send List View 1.84 Excel to Lightroom

Post updated 5 March 2016: I’ve just uploaded the next version of ListView. The zip file also includes an Excel add-in that can send data directly from Excel to Lightroom. At the moment this is writeback is limited to Windows users – Apple broke the mechanism I’ve been using – and it does require some Excel skill. But I just don’t think there is an easier way to get external metadata into Lightroom.

How do I migrate from Extensis Portfolio to Lightroom?

While Extensis is good at exporting all metadata, importing data into Lightroom is liable to be the problem. Lightroom has no built-in tool to import text data, though there is a plug-in called LRTransporter, and I have ListView.

Even with these plug-ins, you require a fair amount of skill and patience, and will have to deal with text file formats (encoding) and glitches caused by non-English characters. Also the metadata itself may have no corresponding place in Lightroom. For example, if you have a multiple value custom field in Extensis, what does that become in Lightroom? Lightroom doesn’t provide custom fields, so you’d be reliant on a plug-in, but even plug-in custom fields can’t have multiple value. So you’d probably want to make your Extensis multiple values into Lightroom keywords.

If you have JPEGs and TIFs, making Portfolio embed the metadata in the files may be the easiest approach for most folk. more…