Ignition open a file that is being name while running a batch file (name is not fixed)

Ignition
, ,
1

Greetings all,

Is there a way for me to open a file in Ignition without knowing the file name but only using the file path?

Let say I run a script to execute the batch file as below

@ECHO OFF
ECHO THIS IS AUTO GENERATION OF GZ FILE
SET GZPATH=C:“Program Files (x86)”\GnuWin32\bin
SET FILESPATH=C:\Users\Administrator\Documents\Testing
SET SAVELOCATION=C:\Users\Administrator\Documents
SET TIMESTAMP=%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%

for /f “tokens=2 delims==” %%a in (‘wmic OS Get localdatetime /value’) do set “dt=%%a”
set “YY=%dt:~2,2%” & set “YYYY=%dt:~0,4%” & set “MM=%dt:~4,2%” & set “DD=%dt:~6,2%”
set “HH=%dt:~8,2%” & set “Min=%dt:~10,2%” & set “Sec=%dt:~12,2%”

set “datestamp=%YYYY%%MM%%DD%” & set “timestamp=%HH%%Min%%Sec%”
set “fullstamp=%YYYY%%MM%%DD%%HH%%Min%%Sec%”

ECHO COMPRESSING…
%GZPATH%\gzip -c “%FILESPATH%\data1.xls” > %SAVELOCATION%\LKMS_STOCK_%fullstamp%.gz
ECHO DONE.
PAUSE

Is it possible for me to find the gz file using Ignition without manually navigation? (if I don’t know the gz file name as it is a timestamp)

2

You mean like assuming it’s the latest one?

import glob
import os

path = 'C:\Users\Administrator\Documents\*.gz'

files = glob.glob(path)

print max(files, key = os.path.getctime)
3

Yes!!. This is what I have been looking for. Thanks mate much appreciate. =)