Import Excel - Photo Captions

[webowner]

Hi Phil,

I appreciate the help, but am way ahead of you. I have already reviewed the FAQ,s and still cant figure this out...

I think the best option now, is to manually add hundreds of photo captions into my Lightroom; as this way I can save the captions again.

Can you please review my .csv file and even, if possible try some exiftool commands at your end.... Obviously I know you dont have the images, but would it make any difference if the images are not contained with the the group or subgroup.... (i.e. in the .csv file - I have identified the image file as 104208234.jpg - and - did not indicate it was c:users\karen\gallery\europe\italy ) - Does that make any difference....

Hope you can continue to offer assistance, thank you so much. Unless I can get exiftool to work, I will revert to manually adding the captions.

Thank you so much.

[webowner]

Hi Phil,

Never Mind - Although I am sad to say I cannot get Exiftool to work - I am using another method, which works sooo well.

Have you heard of FotoTime... \ FotoAlbum 7
http://www.fototime.com/fotoalbum

With some slight adjustments to my .csv file - I can now successfully import Photo Captions, File data and Date the picture was taken. A lot of manual work is needed to ensure the File Name is a long sequence of numbers though, (PictureID) which I understand is similiar to your tags, and this is easily identified within the program itself...
{09B32595-6E72-4556-807E-7A25B25D7A2E}

But, good news - my captions are now being imported.

Sorry, I couldnt get exiftool to work - and am posting this \FotoAlbum\ for others who are also experiencing troubles. Although FotoTime7 is a paid program (which I paid) Import captions from Excel has never been easier.

Thank you.

[Hayo Baan]

Hi Karen (?),

Sorry to read you could not get exiftool to work for you. In my earlier answer I basically gave you the answer you needed already. Your .csv just needed one line stating the tag names for each column. I only had trouble determining the exact date tag for you. But I think you want that to be DateTimeOriginal so the first line should have simply become:

Code Select Expand

SourceFile,Description,FileName,DateTimeOriginal

But as you have already gotten around to fixing the captions as you wanted, you do not need this any longer 

Cheers,
Hayo

[webowner]

Hello Hayo,

Thank you for the reply. I did have everything in my csv file as mentioned by you, and Phil - also by looking at the FAQ's.

Unfortunately, as mentioned ExifTool would not work for me....

After many attemps - but I am pleased to say all is resolved, I have found another method - which works very well, and couldn't be easier.

That is the usage of FotoTime's Foto Album PRO version 7 program.

Thank you again, and this post can be closed 

Best regards for all who use Exiftool.