Outputing Multiple Files based on data

DCS · January 6, 2014

k... here goes....

Using 9.1 Windows

We have a project that need to output multiple files based on a specific data field. I have accomplished that with PTI's help. What I am wondering is this.

I have a data file with 760 names, addresses and other misc data. There is a field named "Plan" which changes from person to person. There are 100 different data strings that can possibly be assigned to each person's "plan". I have sorted the data so it is in order of the "plan" field (so the first 51 have the same plan , the next 32 have the same plan, etc.)

On output is it possible to tell FP to create a folder named whatever is in the "plan" field and create multiple pdfs within that folder? When it finishes that bunch of 51, create a new folder named the next "plan" and output it's files.

Sorry so long and winded, but any help would be appreciated

Thanks

Mike

Dan Korn · January 7, 2014

On output is it possible to tell FP to create a folder named whatever is in the "plan" field and create multiple pdfs within that folder? When it finishes that bunch of 51, create a new folder named the next "plan" and output it's files.

Not with FusionPro 9.1, no. However, we are adding this functionality to FusionPro 9.2.

DCS · January 7, 2014

Great!!

When could we expect to see 9.2?

Dan Korn · January 7, 2014

When could we expect to see 9.2?

I don't have any release date for you, but we're working on it. My best guess (although this isn't official) is by the end of this quarter.

jwhittaker · January 7, 2014

Mike

I have a job I do every 4 months or so and it's kind of like this. I have changed some of the code to make it more like your example.

My output folders are always the same names so I made a folder on my desktop called AllPlans and then made sub folders called Plan1, Plan2, Plan3, etc

You could then search your Plan field for the correct file location and then name the output file with the plan and name.

var str = ToLower(Field("Plan"));

if (str.search("plan1") != -1)

outpath = "/Users/MacPro/Desktop/AllPlans/Plan1/";

else if (str.search("plan2") != -1)

outpath = "/Users/MacPro/Desktop/AllPlans/Plan2/";

else if (str.search("plan3") != -1)

outpath = "/Users/MacPro/Desktop/AllPlans/Plan3/";

else if (str.search("plan4") != -1)

outpath = "/Users/MacPro/Desktop/AllPlans/Plan4/";

filename = Str(Field("Plan") + "-" + Field("Name"));

outfile = outpath + filename;

if (FieldChanged("Plan"))

FusionPro.Composition.OpenNewOutputFile(outfile + "." + FusionPro.Composition.outputFormatExtension);

DCS · January 7, 2014

Thanks Jon, I will give it a try

DCS · January 7, 2014

This is what i got... I am getting errors

I think it has to do with my path

var str = ToLower(Field("WelcomePackageCode"));

if (str.search("74289NY0010001-01ONEC") != -1)

outpath = "c:/Files/7-7 to Print/74289NY0010001-01ONEC/";

else if (str.search("74289NY0010001-01ONEE") != -1)

outpath = "c:/Files/7-7 to Print/74289NY0010001-01ONEE/";

else if (str.search("74289NY0010001-01ONES") != -1)

outpath = "c:/Files/7-7 to Print/74289NY0010001-01ONES/";

else if (str.search("74289NY0010001-01ONFM") != -1)

outpath = "c:/Files/7-7 to Print/74289NY0010001-01ONFM/";

else if (str.search(74289NY0020001-01ONEC") != -1)

outpath = "c:/Files/7-7 to Print/74289NY0020001-01ONEC/";

else if (str.search("74289NY0020001-01ONEE") != -1)

outpath = "c:/Files/7-7 to Print/74289NY0020001-01ONEE/";

else if (str.search("74289NY0020001-01ONES") != -1)

outpath = "c:/Files/7-7 to Print/74289NY0020001-01ONES/";

else if (str.search("74289NY0020001-01ONFM") != -1)

outpath = "c:/Files/7-7 to Print/74289NY0020001-01ONFM/";

filename = Str(Field("WelcomePackageCode") + " " + Field("LastnameRP") + "_" +

Field("firstnameRP") + " " + Field("SubscriberID"));

outfile = outpath + filename;

if (FieldChanged("WelcomePackageCode"))

FusionPro.Composition.OpenNewOutputFile(outfile + "." + FusionPro.Composition.outputFormatExtension);

Edited January 7, 2014 by DCS

jwhittaker · January 8, 2014

What are the error messages?

I work on a mac and it's a little different than a pc. I know I had a problem with the number of chars in the length of the path. I also didn't use any special chars. One thing is that when I assign the data to the str variable I made it to lower case and you are search for uppercase. Another thing Dan Corn said somewhere is to put in \\ instead of single \ in the path but he also said you could put forward slashes to / instead. Just giving you some options to try.

outpath = "c:\\Files\\7-7 to Print\\74289NY0010001-01ONES\\";

step · January 8, 2014

Couple of issues I see here. First, you are setting the value of the "WelcomePackageCode" to all lowercase and then searching it for uppercase letters. Secondly, I think you also need to escape spaces in your path. I think you could simplify your code to look like this:

outpath = "c:\\Files\\7-7\ to\ Print\\" + Field("WelcomePackageCode") + "\\";
filename = Field("WelcomePackageCode") + " " + Field("LastnameRP") + "_" + Field("firstnameRP") + " " + Field("SubscriberID");
outfile = outpath + filename;

if (FieldChanged("WelcomePackageCode"))
   FusionPro.Composition.OpenNewOutputFile(outfile + "." + FusionPro.Composition.outputFormatExtension);

DCS · January 8, 2014

Thanks Guys for all the help...

was playing around late into the night...

(obviously I am a complete noob to this)

couple of issues....

1. I get it to make a file named properly but only the first one of the "plan"

the rest just get named 1.pdf, 2.pdf , etc.

2. I can't seem to get the composed files into their proper folders. They are being made in my directory that the original PDF is in, even after I code the "//"

Thanks Again

Mike

jwhittaker · January 8, 2014

Mike

Just checking that you already made the folders in the path you are using. They have to be created by you because PTI can't make them yet.

I just noticed that I have a field that is unique to all records that is in the if (FieldChanged("Dealer Code")).

Do you have a field that is unique maybe the name field you can put in the

if (FieldChanged("Name")) instead of if (FieldChanged("WelcomePackageCode"))

Also you are using the \\ not // right?

DCS · January 9, 2014

thanks for the help once again....

This is what I have and I am getting this error:

OnNewOutpuFile, Line 19: Syntax Error: missing ) after argument list

here is the code:

var str = ToLower(Field("WelcomePackageCode"));

if (str.search("74289NY0010001-01ONEC") != -1)

//outpath = "c:\Files\7-7 to Print\74289NY0010001-01ONEC\";