Report overwritten solution

Ignition
1

Hi,
I have report triggered by PLC tag indicating that the process is over. Usually there might 7-8 triggers per shift. The report is executed and saved in the directory for that purpose, but every new generated report overwrites the previous one, since they have the same name. I was wondering what workaround to find, any ideas?

2

Put the timestamp with minutes and seconds into the filename?

2 Likes
3

If the report name is, for example, MachineNo1, how the new name with the timestamp will look like?

4

You can format it as you choose;

e.g. MachineNo1_20210623_17_01_03.PDF

5

I meant how to include the timestamp like variable in my script?

6

Use a fileName parameter in the settings

# Executes and distributes the report to save a PDF
now = system.date.now()
date = system.date.format(now , "yyyy-MM-dd HH:mm:ss")
fileName = "MachineNo1 _%s" % date
settings = {"path":"C:\\Ignition Reports", "fileName":fileName, "format":"pdf"}
system.report.executeAndDistribute(path="My Report Path", project="My Project", action="save", actionSettings=settings)
2 Likes
7

Use system.date.now and format it before adding to the filename

from the manual

# Executes and distributes the report to save a PDF
settings = {"path":"C:\\Ignition Reports", "fileName":"Report.pdf", "format":"pdf"}
system.report.executeAndDistribute(path="My Report Path", project="My Project", action="save", actionSettings=settings)
3 Likes
8

@Matrix_Engineering LOL, beat you by mere seconds :slight_smile:

9

Thanks a lot, guys!

10

There is a small Python syntax issue in your script, dkhayes117, and I could not find solution.
image
system.report.executeAndDistribute accepts only arguments in quotes (" ") after “fileName”:, but then logically the report name stops to be variable.

11

you sure you did this?

12

Yes it works for me, just ran it and it produced

>>>MachineNo1_2021-06-24 08:14:32

EDIT: Make sure you use the correct variable in your settings

{ ... "fileName":fileName, ... }
13

If you try the 3 rows above in Script Console and print fileName, indeed error does not pop up.
But if I trigger the script, I get the error below:

image
image755×33 4.35 KB

if I place the fileName in quotes, I do not get error (which means the other parameters in the script are OK), but I do not get variable report name.
image

14

Ah hm try system.date.format(now , "yyyy-MM-dd-HH-mm-ss")
And be sure there is no space before the date.
Might be that filenames cant have “:” in it

You defintly should not put quotes around fileName, cuz its a variablename not a string

1 Like
15

That was it! “:” replaced with " - ", and issue solved.
Thank you!

1 Like
16

hehe forgot about that xd