Hello there!

What exactly do you mean by: "the day before"? You are talking about the creation date, the last modified date of the files or something else?

Hi Codex, Thanks for help.

I wish he would show me the files with extension *.tif with the creation date when the previous day.

Sorry for my bad English, I'm using a translator, I am Brazilian.

Abs

I have attached a sample job. If it is not what you need, let me know.

Wonderful, you're a genius.

It worked perfectly.

Now, as the report is issued, the fields appear below?

Date Modified
Author
Title
Subject
Comments

Thanks in advance.

Do you have Microsoft Excel installed in the machine? If yes, then it would be more practical to generate the report in an xls file, since there are many fields that you want to retrieve. Notice, that I'm talking about Microsoft Excel specifically. If you do not have it installed, we have 2 options:

1) Either generate the report in txt format (or csv which is text in its basis)
2) Or create the report in html format

So, which option do you prefer? Xls, txt, csv or html? Keep in mind that in order to create the report in xls format, Microsoft Excel must be installed

Yes, I have Excel installed.

However, the fields

Date Modified
Author
Title
Subject
Comments

I do not know how winautomation will recognize those fields.

Thank you.

Hm... The fields that you are referring to are probably metadata. Can you attach a sample tif file with all the fields that you mentioned so that I can experiment a bit on it?

I sent the file attached to your e-mail.

Regards

WinAutomation does not natively support reading of metadata. This is why I have used a small command line application that does exactly that. How you can execute the job that I attached:

1) Go to the following website: http://www.sno.phy.queensu.ca/~phil/exiftool/ and download the Windows executable (direct link can be found here).

2) Unzip the file exiftool-x.xx.zip that you just downloaded
 
3) Rename the file: exiftool(-k).exe file to exiftool.exe

4) Move the file exiftool.exe to the C:\ directory

5) Import the job that I attached and set the appropriate directory in action no.4 ("Get Files in Folder")

6) Execute the job

Notice, that the last action that saves the Excel file is disabled so that you can see the results of the process. You can of course enable it and set the name that will be used to save the Excel file.

Let me know if it works as expected :-)

Wow! this is fantastic!

it worked perfectly, that was exactly what I wanted, helped me a lot!

unintentionally abuse, What is the parameter that I use to save the file with the name of the date of the day?

Tks

If you are talking about the Excel file name (in the Close Excel action), you can find specific details in the job that I attached.

I have added a comment that explains how you can do it:

How To Apply Various Elements in the file name:

Year (number): %CurrentDateTime.Year% (e.g. 2009)
Month (number): %CurrentDateTime.Month% (e.g. 12)
Day (number): %CurrentDateTime.Day% (e.g. 29)
Day (text): %CurrentDateTime.DayOfWeek% (e.g. Tuesday)

Thank you very much!

Now it's perfect!

This program is great, I'll have to buy the company and I recommend the software to all my friends!

Thanks

I am evaluating winautomation for a project I am working on and this example is very close to what I want to do.

I have a folder with several jpg files.  I want to read the metadata from each file and create a text file for each image with the same name as the jpg file and containing all metadata.

How would I modify this sample to do this.

Marshall