Automate field insertion for many variables

[invaricconsulting]

I am looking to see if there is a way, perhaps with some variation on the FusionPro.Fields/AddVariable examples on the forum, to automatically insert a few hundred variables into four pages of price lists.

 

The catch is, the client says the field names do not stay the same. So right now they have a monthly process of having to manually insert the variables, in numerical order, in FusionPro.

 

Any ideas or suggestions appreciated.

[Dan Korn]

I am looking to see if there is a way, perhaps with some variation on the FusionPro.Fields/AddVariable examples on the forum, to automatically insert a few hundred variables into four pages of price lists.

Sure, you can call FusionPro.Composition.AddVariable in a loop in OnRecordStart, something like this:

for (var fieldNum = 1; fieldNum <= 300; fieldNum++)
   FusionPro.Composition.AddVariable("Custom Var " + fieldNum, "Custom Value " + FormatNumber("000", fieldNum));

The catch is, the client says the field names do not stay the same. So right now they have a monthly process of having to manually insert the variables, in numerical order, in FusionPro.

That implies that there needs to be some kind of field mapping set up. This isn't impossible to do, but I can't offer any specific suggestions without more information about the field names in the data and the variable names used in the job. I'm also not quite sure what you mean by, "in numerical order." An example may be helpful.

[invaricconsulting]

I'm also not quite sure what you mean by, "in numerical order." An example may be helpful.

Right, I should have added that the lists are in order by part number lowest to highest, however I am going to see if the client would be O.K. with doing that sort in the data. I'lll try this loop out. Thanks Dan.