Hi
I try to download in a csv file the metadata registred in Excel files. (subject and title)
I can see that the metadata exists in the files but anywhere in Xmp Dubli Core Shema xmp-dc else in an other file in FlahPix
So I can't build the command line to extract them
I try this
exiftool.exe -XPComment -csv -r -lang fr -charset latin -ext xls -ext xlx -ext xlsx -ext xlsm -xmp-dc:all - table > table_sourcefile.csv
and other whithout any success
I think that I don't use the command -ext:all
Other wise it seems to be possible to do something like this - ext"?" to select all the files ase xls xlms xlsx and so on
Thanks for your help
Maybe try something like this:
exiftool -charset latin -xmp:all -csv -ext xls -ext xlms -ext xlsx ... DIR > out.csv
- Phil
Edit: I see this is very close to what you have already tried. I tested this myself for a few XLS files, and they didn't seem to have any XMP metadata. The format does support XMP metadata, but perhaps it just isn't being written to the file?
Hi Phil
Thank's a lot buts las I dont'get the metadata
I'm sure that's the metada exist and I can see them using a soft named metadata++ (which is build on exiftools)
But microsoft love to give us dark nightmare >:( to there users
So you will find in attached file a snapshot of it if you want i can send you an excel flile
Send me the Excel file and I'll take a look. My email is philharvey66 at gmail.com
- Phil
Thanks a lot that's done
I get this with the file you sent:
> exiftool -xmp:all -csv "Fiche passagers.xlsx"
SourceFile,Title,Subject,Creator
Fiche passagers.xlsx,Fiche de renseignement passager,Plan de voyage Fiche passager,Pierre LIBERAS
- Phil
OK Phil
That's right BUT
not when I do the same with -r
as
exiftool -xmp:all -csv -r table > table_recap_xlsl.csv
or else I try exiftool -r -xmp:all -csv table > table_recap_xlsl.csv
It seems that the recursive fonction -r cause a disturb
else additionaly I try
exiftool -r -xmp:all -csv table
the redirection to print a file doesn't matter (of course)
What is the output of this command?:
dir table
- Phil
when I do
exiftool -r -xmp:all -csv table
I don't redirect to a file. It's just for checking in the window's command line if the redirection is not in cause.
Anyway, the correct syntax is
exiftool -r -xmp:all -csv table > table_recap_xlsl.csv
and with -r that's not ok
I need more details. What do you mean by "not ok"? What messages does ExifTool show? What is the directory listing of the "table" directory (ie. the output of "dir table" as I asked)?
- Phil
Hi
you wil find in attached file the output of dir and the the file generate by exiftool when I do
exiftool -r -xmp:all -csv table > table_recap_xlsl.csv
Perhaps you need a full dir
Sorry but I forget to tell you that's other commands quite similar runs perfectly
as for exemple
exiftool.exe -csv -r -lang fr -charset latin -ext pdf -FileTypeExtension -pdf:title -pdf:subject -pdf:author -pdf:keywords -pdf:ModifyDate table >table_recap_pdf.csv
exiftool.exe -csv -r -lang fr -charset latin -ext html -Title -description -author -Keywords -FileModifyDate -FileTypeExtension table > table_recap_html.csv
Just the same for xls meta don't give any result
It it works for other file types but not xls, then it is because the xls doesn't contain the metadata you are looking for.
(I feel we're running around in circles here.)
- Phil
The metadata are put in them as request by microsoft
I send you a snapshot of the metadata ++ application where you can see that the metadata are iregistred as xml
So I send you in attachd files a zip file containing only the xls files (that's not strategical files)
and I pass the command
exiftool -xmp:all -csv -r table_xls > table_recap_xls.csv
whitout success (no errors but
As I said previously the metadata exists (generated by the genuine microsoft application ) and as you can see on the snashot in my previous post yous can see them with metadata++ application registred as XML
PLease write me by mail
I send you the complete dir in zip files contains these xls using dropbox or else
Unfortunately, the "File not found" error is likely because of the special characters in the file name. Support for Unicode characters in Windows file names has been a real headache for me.
- Phil
Re bonjour Phil
It's easier to test in live, so I send you a onedrive's link by MP where you can download the dir including the xls file
As I said previously the metadata are generated with the excel application and you can see them using metadat++ apllication whre you can see that there are registred under xml
I use that command
exiftool -xmp:all -csv -r table_xls > table_recap_xls.csv
in attached file, you will find the target file generated by exiftool
OK. I'll look into this as soon as I get a chance. Give me a couple of days.
- Phil
Unfortunately, the "File not found" error is likely because of the special characters in the file name. Support for Unicode characters in Windows file names has been a real headache for me.
I delete this file and folder
This not product none effect and the problem stay insolved
I know that the encode char is a nightmare for all of us and microsoft add one more .
:'( :'(
Well the pb seems to come from the recursive -r option because remeber that if we test on a single file we get the metadata
Thank you take the time you need. of course and good afternoon for you
Sorry for the delay.
I don't get the same thing as you. When I run this command
exiftool -xmp:all -csv -r Table_xls > out.csv
on Windows 10 with ExifTool 11.63 I get the attached .csv output file that shows "Creator" information for all of the xlsx files (but none of the xls files).
When I look at the files individually, I see the same thing.
The file you sent earlier ("Fiche passagers.xlsx"), I get a different output than the version you sent in the whole zipped directory. The earlier version contained XMP Title, Subject and Creator, while the new one has only Creator.
So I am not able to reproduce the problems you are having.
- Phil