Upland OL User community

Output to a folder based on the file name

#1

I am not how to do this. I have a process set up and the output is a pdf. That’s fine. I need to take that pdf and put it in a folder based on file name. For example -

pdf names = abc_123456, abc_789321
folder names = 10547821 and 10854954
Pdf file abc_123456 needs to go into folder 10854954
Pdf file abc_789321 needs to go into folder 10547821

My original input data is xml. I do have a csv file with 400 folders names and which files need to go into what folder. Its basically two columns. Column one = 123456, Column two = 10854954 and so on.

How can I get the pdf’s in the corresponding folders?

Thanks
Amy

#2

You could load up the CSV file into Workflow’ Data repository. Then use that to check on the filename to know which folder to use.

#3

How do you create your pdf? If you have the corresponding folder name for the output pdf in xml you can directly write to that folder!?

If you create the pdf files in Connect you can use the folder name per record as metadata in the filename mask (e.g. ${segment.metadata.column2}/${segment.metadata.column1}.pdf). Of course you have to select absolute path at output folder.

#4

That is my problem. I do not have Column two (folder name) but I do have Column One to name the pdf. I have a separate .csv file that has the file name to folder name mapping.