Hi,
I search for a simple way to do this:
- copy a file named "test.xlsx" as "test2.xlsx" in the same directory and
- copy the file "test2.xlsx" obtained as "test2 - 20180725.xlsx" in the same directory
with a simple script at the end of a workbench
thank you
+11Hi,
Have you tried FileCopy writer
https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/filecopy/filecopy.htm
Pratap
+38Does it need to be a script?
You can use the file copy writer to copy and rename files at the end of your workspace
Does it need to be a script?
You can use the file copy writer to copy and rename files at the end of your workspace
+38
+11Hi,
Use another feature writer with FileCopy
Place necessary attributes with attribute creator in between
untitled.jpg
+38
e.g.
+5If you really want it in a script you could write something like this:
import os
import shutil
from datetime import date
today = date.today()
filename = FME_MacroValues['DestDataset_XLSXW']
path, fname = os.path.split(filename)
basename, extension = fname.split('.')
newfname = f'{basename} - {today.strftime("%y%m%d")}.{extension}'
newfilename = os.path.join(path,newfname)
shutil.copy(filename, newfilename)
its in python 3.6 btw.
for python 2.7
newfname = '{} - {}.{}'.format(basename,today.strftime("%y%m%d"),extension)
e.g.
The systemCaller give me that answer in the log :
SystemCaller: Executing `copy /Y C:\\Livraison AIXM 51 V2.0\\01 - Ecriture_mid_uuid/test.xlsx C:\\Livraison AIXM 51 V2.0\\01 - Ecriture_mid_uuid/tst2.xlsx'
2018-07-25 14:16:58| 17.1| 0.0|WARN |SystemCaller: Failed to Execute `copy /Y C:\\Livraison AIXM 51 V2.0\\01 - Ecriture_mid_uuid/test.xlsx C:\\Livraison AIXM 51 V2.0\\01 - Ecriture_mid_uuid/tst2.xlsx'
probably it doesn't succeed to write because it's a "/" and it needs a "\\" before "tst2.xlsx"
ima1.png
I suceed by the "attributecreator" way to copy "test.xlsx" into "tst2.xlsx" using a private attribute "dir" which is obtained with a python script
ima2.png
and here is the log for this way
ima3.png
Why is it wrong with the systemcaller ???
This way allows to change the initial place of my global work. If i put the initial folder "Livraison AIXM 51 V2.0" containing all the subfolders in another folder (ie c:\\ or c:\\users\\desktop) it works
Why not with systemcaller ?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
