File Copy

[softdealer]

We have been currently using a map for a file copy process. Currently it will process the data then archive them in this structure \\servername\folder1\folder2\year. Problem that I have is I have to manually change all the maps to switch the year. How can I do it so that it reads the sys year and wont have to modify the maps?

 

[rarunprasad]

Hi

You could declare a field as Date with YYYY as the pattern and then use the CURRENTDATETIME function to retrieve the year.

HTH

Arun

 

[mallooni]

In a rule you could use

"\\servername\folder1\folder2\" + FROMDATETIME(CURRENTDATE(),"{CCYY}")

YM

 

[repanzer]

If the input file is the file your want to copy, in an output card field:

=PUT(“FILE”, “\servername\folder1\folder2\” +
WORD(WORD(GETFILENAME(inputfilecard),"\",-1),"."1) +
FROMDATETIME(CURRENTDATE(),"{CCYY}")+".txt", PACKAGE(inputfilecard))

I believe I had some problems at one point with all the functions in one output field, so I built the values in the other output fields before I did the put:

outfield1=WORD(WORD(GETFILENAME(inputfilecard),"\",-1),"."1)
outfield2=FROMDATETIME(CURRENTDATE(),"{CCYY}")
outfield3==PUT(“FILE”, “\servername\folder1\folder2\” +outfield1+"_"+outfield2+".txt", PACKAGE(inputcardfile))