Xporter : How to iterate over a multi-element custom field

Question

Hi,

I'm trying to iterate a custom field containing multiple value.

The field is provided by PowerDatabaseFields PRO.

I tried the following without success, it print nothing:

#{for ${CustomFieldName[11300]}}
    ${(${CustomFieldName[11300]})[n]}
#{end}

and

#{for ${CustomFieldName[11300]}}
    ${(${CustomFieldName[11300]})[n].Name}
#{end}

I also tested printing Labels field and compare it to the custom field which have similar behavior:

${CustomFieldName[11300]}
${Labels}

//print
EFR45590S###EFR47012###EPR-5590S###KSS-67115-DE###KWS-21100
R&D Symix addon warning

Santiago Estel · Answer

After updating to version 8.3.3

This is now working:

#{for Preventive Tasks}

* ${Preventive Tasks[n]}

#{end}

xavierhd · Answer

Take note that this was working with Word in Xporter V5.5.1... But since the workaround is in javascript, it should work across versions...

What I have shared had been beautified to make it more understandable, but it won't work as is. You need to uglify it to a one-liner. Make sure that the whole workaround code stand on one line (eg: No line break)

Also the since the raw output of the multi-element field was in fact a string of values separated by "###", the regex need to match the content of your multi-element field.

In my case, what I really used was this oneliner which processed two item types :

%{var re = /((?:KWS[-\w]+[\w|-]*)|(?:[A-Z]*?(?:-|)[0-9]+S[\w|-]*)|(?:KSS-[0-9]+-[A-Z]+[\w|-]*))|([A-Z]+(?:-|[0-9])+[\w|-]*)/gi; var match, outstring = ""; while(match = re.exec('${Product names[11300]}')) { if(match[1]) outstring += match[1] + "    x 1 pouch
"; if(match[2]) outstring += match[2] + "    x 5
"; }outstring}

Tips: Use some regex builder (like regex 101) to build and test your javascript regex to split the raw output of your field.

Santiago Estel · Answer

I tried your solution, but it did not work in Word. - Xporter is just printing the entire code.