Static logo and barcode should appear based on customer requirement

I'm not too sure I completely understood your request, but it sounds to me that it could be achieved in Excel...

What about adding columns with formulas that would say "If customer EGP choice is yes, then return EGP logo path"?

Same with Height and Weight : if columns are numbers, then returns HWlogo path. And 2 other columns to concatenate your text "Height (in): to (value)".

Of course, you can hide/protect these columns.

See example below (but note it's an French version of Excel so french formulas aren't going to help you much):

Kasyan's solution is free. Thank you, Kasyan!

Em Software's InData for InDesign is one such merge solution that one can test the data and only use applicable field values in the merge process. It uses what are called prototypes, which really is scripting that is evaluated and processes the data during the merge. I use their products quite frequently (that plugin and their Tagged Text plugin). these prototypes can be as simple as what you show above to quite complex (complex enough one may have less hair getting it written).

Yep, this option costs money. Some think a lot, some find it reasonable. If you did as much pulling in data from databases of all stripes as I do...I see it as cheap. It's the one of a set of plugins I upgrade religiously.

Mike

Hi there,

The solution to your problem is scripting.

The main problem with data merge is it doesn't allow you to apply logic: e.g. if the cell in EGP column is yes, use this template, if no, use that one.

I am not an expert in data merge -- I've never used it for real work -- but I consider it a poor man automation feature: it's free, but it doesn't do all that what you want. Scripting, on the contrary, is totally flexible and allows you to achieve exactly what you want, but you usually have to pay to developer, or learn how to script yourself.

Also, there's a number of plugins that may come in handy to you -- for example EasyCatalog -- but I've never used them so don't want to talk about what I don't know. I guess, in essence, they have the same issue as data merge: you're supposed to have identical number (structure) of elements in each record (in Excel) and in the layout (in InDesign).

If you decide to have a script developed, the main difference for you will be that you'll have to use labeled frames (the Script Label panel) instead of field placeholder text.

And finally -- the cherry on the cake -- scripting allows you to read data directly from Excel to InDesign without using CSV or tab/comma delimited TXT as intermediary format. Here I wrote and give away for free the functions that fetch data from Excel. I used the mix of three programing languages: JavaScript (the most popular scripting language for InDesign), VBS (to read data from Excel on Windows) and AppleScript (to read data from Excel on Mac).

Hope it helps.

— Kas