Author Topic: out.txt file missing  (Read 1146 times)

athegn

  • Jr. Member
  • **
  • Posts: 11
out.txt file missing
« on: August 24, 2018, 02:40:35 PM »
I have exiftool installed on my desktop at:-

C:\Users\alanf\Desktop\exiftool.exe

I have an image folder on my desktop at:-

C:\Users\alanf\Desktop\Ramblers_Matching

I drag the Rambers_Matching folder to the exiftool icon and the command box runs then closes but there is not an out.txt file on my desktop.

Am I looking in the correct place for this file?

StarGeek

  • Global Moderator
  • ExifTool Freak
  • *****
  • Posts: 2516
Re: out.txt file missing
« Reply #1 on: August 24, 2018, 03:16:07 PM »
exiftool doesn't create an out.txt file by default.  You probably have to create a batch file in order to redirect into a single file.  Or you could rename exiftool to exiftool(-w .txt -all).exe and when you drop the Ramblers_Matching folder on it, it will create a matching text file for each file in Ramblers_Matching with the tag listing.

May I ask where you got the idea that exiftool would create an out.txt file?
Troubleshooting hints:
* When posting, include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).
* Double all percent signs (%) in a Windows batch file.
* If your GPS coords are negative, make sure and set the GpsLatitudeRef and GpsLongitudeRef tags correctly.

athegn

  • Jr. Member
  • **
  • Posts: 11
Re: out.txt file missing
« Reply #2 on: August 24, 2018, 03:51:58 PM »
I found this command from Phil??

exiftool -filename -gpslatitude -gpslongitude -T DIR > out.txt

and assumed that a txt file would be created in the DIR

I now have the individual txt files for each image.jpg

I suppose there is no way I could output a single CSV txt file for all images in one folder?

athegn

  • Jr. Member
  • **
  • Posts: 11
Re: out.txt file missing
« Reply #3 on: August 24, 2018, 03:55:12 PM »

StarGeek

  • Global Moderator
  • ExifTool Freak
  • *****
  • Posts: 2516
Re: out.txt file missing
« Reply #4 on: August 24, 2018, 06:27:58 PM »
The > out.txt is what creates the out.txt file.  It is called file redirection and a propery of the command line.  In order to create a drag and drop to do that would require the creation of a batch file.

I suppose there is no way I could output a single CSV txt file for all images in one folder?

Yes, there absolutely is a way.  On the command line you would type:
exiftool -csv >out.csv DIR
where you would replace DIR with the path to the target directory.

To create a drag and drop icon, you would have to create a batch file.  This works for Windows 10, but I think it would work for Win 7/8

Right click on the desktop, select New->Text Document
Right click the new text document, select edit.  This will open up notepad
Copy this and paste it into the empty document
   exiftool -csv %*  >out.csv
and then save and close notepad
Rename the text document so that it ends in .bat instead of .txt.  If you have file extensions hidden, then post back and I'll find instructions on how to change that.

You can then drag directories on the .bat file and it will create a csv file in the parent directory of the one you dropped.  If need something more complex, then we can work on that next.
Troubleshooting hints:
* When posting, include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).
* Double all percent signs (%) in a Windows batch file.
* If your GPS coords are negative, make sure and set the GpsLatitudeRef and GpsLongitudeRef tags correctly.

athegn

  • Jr. Member
  • **
  • Posts: 11
Re: out.txt file missing
« Reply #5 on: August 25, 2018, 06:37:10 AM »
I am not sure I completely understand these instructions.

I have created on My Desktop:-

exiftool.bat containing:-

exiftool -csv %*  >out.csv

If I drag my Matching folder over the bat file I get a Libre Office Calc file with Cell A1 containing:-

C:\Users\alanf\Desktop>exiftool -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv -csv C:\Users\alanf\Desktop\Ramblers_Matching   1>out.csv

I guess what I am missing is to tell the bat file what I want it to extract?

What I want is three collumns containing:-

File Name, GPS Latitude, GPS Longitude







Phil Harvey

  • ExifTool Author
  • Administrator
  • ExifTool Freak
  • *****
  • Posts: 14759
    • ExifTool Home Page
Re: out.txt file missing
« Reply #6 on: August 25, 2018, 07:34:49 AM »
I don't understand how you get a file like that.  But to extract specific tags, you would do this:

exiftool -csv -gpslatitude -gpslongitude %* > out.csv

You should get SourceFile as the first column, which hopefully will be OK, but contains the full path to the file.  If you want just the FileName too, you can add that to the command.

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

StarGeek

  • Global Moderator
  • ExifTool Freak
  • *****
  • Posts: 2516
Re: out.txt file missing
« Reply #7 on: August 25, 2018, 12:25:00 PM »
I can't figure out how that happened either.  I can't replicate it here.  Without any requested tags, it makes a large csv file with all available tags.

I'm assuming there's a -csv for each file in the test directory.
Troubleshooting hints:
* When posting, include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).
* Double all percent signs (%) in a Windows batch file.
* If your GPS coords are negative, make sure and set the GpsLatitudeRef and GpsLongitudeRef tags correctly.

athegn

  • Jr. Member
  • **
  • Posts: 11
Re: out.txt file missing
« Reply #8 on: August 25, 2018, 12:27:14 PM »
My Matching folder contains both the image files i.e. jpg and the txt files generated from exiftool.

If I now create a bat file with:-

exiftool -csv -gpslatitude -gpslongitude %* > out.csv

and drag my Matching folder over the icon all I get out.csv with:-

C:\Users\alanf\Desktop> in Cell A1

The same result if I seperate the jpg and txt into two different folders. out.csv still just has:-

C:\Users\alanf\Desktop> in Cell A1

What am I doing wrong.

Alan Clifford

  • ExifTool Freak
  • *****
  • Posts: 386
    • A selection of Alan Clifford's photographs
Re: out.txt file missing
« Reply #9 on: August 25, 2018, 01:17:46 PM »
I've had a beer so this may come across as a bit rude.  If so, sorry.  Give up on dragging and dropping.  Just use the command line.

StarGeek

  • Global Moderator
  • ExifTool Freak
  • *****
  • Posts: 2516
Re: out.txt file missing
« Reply #10 on: August 25, 2018, 01:30:21 PM »
Can you attach your bat file to a post here or link it from something like dropbox?

Does the icon for the batch file look something like this:
Troubleshooting hints:
* When posting, include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).
* Double all percent signs (%) in a Windows batch file.
* If your GPS coords are negative, make sure and set the GpsLatitudeRef and GpsLongitudeRef tags correctly.

StarGeek

  • Global Moderator
  • ExifTool Freak
  • *****
  • Posts: 2516
Re: out.txt file missing
« Reply #11 on: August 25, 2018, 01:34:06 PM »
I've had a beer so this may come across as a bit rude.  If so, sorry.  Give up on dragging and dropping.  Just use the command line.

Heh, for me, at this point, I'm more interested in the puzzle of why it isn't working.  Solving athegn's problem is now just a happy side effect of solving this riddle. 
Troubleshooting hints:
* When posting, include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).
* Double all percent signs (%) in a Windows batch file.
* If your GPS coords are negative, make sure and set the GpsLatitudeRef and GpsLongitudeRef tags correctly.

athegn

  • Jr. Member
  • **
  • Posts: 11
Re: out.txt file missing
« Reply #12 on: August 25, 2018, 05:28:28 PM »
Only a beer?

I have had a beer and three glasses of wine; so better leave this until tomorrow!

athegn

  • Jr. Member
  • **
  • Posts: 11
Re: out.txt file missing
« Reply #13 on: August 26, 2018, 09:41:47 AM »
Yes Bat file icon does look like that.

Copy/Paste from bat file:-

exiftool -csv -gpslatitude -gpslongitude %* > out.csv

StarGeek

  • Global Moderator
  • ExifTool Freak
  • *****
  • Posts: 2516
Re: out.txt file missing
« Reply #14 on: August 26, 2018, 10:00:39 PM »
I'm pretty much out of ideas.  Copy/pasted your command into my batch it it works fine.

My last question is a stretch.  What version of exiftool are you running.  Type exiftool -ver into the command line.  Also, maybe there's another, very old, copy of exiftool hiding on your computer?
Troubleshooting hints:
* When posting, include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).
* Double all percent signs (%) in a Windows batch file.
* If your GPS coords are negative, make sure and set the GpsLatitudeRef and GpsLongitudeRef tags correctly.

athegn

  • Jr. Member
  • **
  • Posts: 11
Re: out.txt file missing
« Reply #15 on: August 27, 2018, 12:09:55 PM »
I am being a really silly boy.

My opening post said:-

I have exiftool installed on my desktop at:

I don't actually have it installed in Windows just an icon on my Desktop.

Should I install it in Windows and if so how?

Have I downloaded the correct file?




Phil Harvey

  • ExifTool Author
  • Administrator
  • ExifTool Freak
  • *****
  • Posts: 14759
    • ExifTool Home Page
Re: out.txt file missing
« Reply #16 on: August 27, 2018, 12:44:31 PM »
Right.  Follow all 4 steps in the Windows install instructions.

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

athegn

  • Jr. Member
  • **
  • Posts: 11
Re: out.txt file missing
« Reply #17 on: August 27, 2018, 01:14:17 PM »
I have followed those steps, have rebooted pc, used exiftool -ver and got 11.10.

In C:\Windows\exiftool.exe Details File version  11.1.0.0
File size 8,366,080 bytes

Dragged Matching images file over bat icon but still Out.csv only shows

C:\Users\alanf\Desktop> in cell A1?

Phil Harvey

  • ExifTool Author
  • Administrator
  • ExifTool Freak
  • *****
  • Posts: 14759
    • ExifTool Home Page
Re: out.txt file missing
« Reply #18 on: August 27, 2018, 01:20:24 PM »
Maybe try changing the .bat file to this, just to be sure you are executing the correct exiftool:

C:\WINDOWS\exiftool.exe -csv -gpslatitude -gpslongitude %* > C:\Users\alanf\Desktop\out.csv

Also, I have set the path to the output .csv file to your desktop because I don't know where it would go when you run the .bat by dragging and dropping.

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

StarGeek

  • Global Moderator
  • ExifTool Freak
  • *****
  • Posts: 2516
Re: out.txt file missing
« Reply #19 on: August 27, 2018, 01:44:14 PM »
Also, I have set the path to the output .csv file to your desktop because I don't know where it would go when you run the .bat by dragging and dropping.

In the batch file I created at the start of this, it would end up in the parent directory of the directory I dropped onto the batch file.  Which, in the case of dropping a desktop directory would be harder to find.
Troubleshooting hints:
* When posting, include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).
* Double all percent signs (%) in a Windows batch file.
* If your GPS coords are negative, make sure and set the GpsLatitudeRef and GpsLongitudeRef tags correctly.

athegn

  • Jr. Member
  • **
  • Posts: 11
Re: out.txt file missing
« Reply #20 on: August 27, 2018, 05:03:04 PM »
Get different result now.

Drag Matching file over bat icon. Quick flash of command prompt  then nothing.

bat file contents

C:\WINDOWS\exiftool.exe -csv -gpslatitude -gpslongitude %* >
C:\Users\alanf\Desktop\out.csv

Sorry but got chased out to go to dinner; better come back tomorrow.

StarGeek

  • Global Moderator
  • ExifTool Freak
  • *****
  • Posts: 2516
Re: out.txt file missing
« Reply #21 on: August 27, 2018, 05:44:29 PM »
Put
pause
on a new line at the end of the batch file.  I was able to get it to flash like that while testing and it meant that it wasn't able to find exiftool.  The pause command will hold the window open long enough to be able to read the output, which should be an error of some sort.  You can then copy/paste it here.
Troubleshooting hints:
* When posting, include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).
* Double all percent signs (%) in a Windows batch file.
* If your GPS coords are negative, make sure and set the GpsLatitudeRef and GpsLongitudeRef tags correctly.

athegn

  • Jr. Member
  • **
  • Posts: 11
Re: out.txt file missing
« Reply #22 on: August 31, 2018, 09:52:57 AM »
Sorry for my late return to this; went hiking for few days - the images I am looking at are hiking images.

Anyway, as expected, my fault.

I had:-

C:\WINDOWS\exiftool.exe -csv -gpslatitude -gpslongitude %* >
C:\Users\alanf\Desktop\out.csv

Not:-

C:\WINDOWS\exiftool.exe -csv -gpslatitude -gpslongitude %* > C:\Users\alanf\Desktop\out.csv

i.e. all on one line.

Now have my spreadsheet with the required information.

Thank you for your patience.

Rudy

  • Newbie
  • *
  • Posts: 1
Re: out.txt file missing
« Reply #23 on: March 02, 2019, 04:45:24 PM »
Who says reading the forums for your answer never works? This is what I needed! Between StarGeek's
Quote
build a batch file
and Phil Harvey's
Quote
C:\WINDOWS\exiftool.exe -csv -gpslatitude -gpslongitude %* > C:\Users\alanf\Desktop\out.csv
I got everything I needed -- a file with FILENAME, LAT, LONG for everything I drop on it.  Thanks guys!!