Creating drop-down list

[MikeVM]

Hi,

 

I have to create template when client can select "office location" from pre-defined library list - as drop-down menu. My problem is that this list is about 250 locations long. Is there is any option to upload, let's say, Excel file to library instead of manually typing and adding all 250 locations?

 

TIA

[jstehman]

Hello Michael,

There isn't a way to do it in bulk at this time but I've submitted an enhancement request to our product development team, it is ticket FPW-19855.

 

Jeff Stehman

Technical Support | PTI Marketing Technologies | Printable Technologies, Inc.

jstehman@pti.com | www.pti.com

858.847.6622 direct | 800.220.1727 office

[FreightTrain]

TIA/MikeVM

You will need to have all the addresses in an External Data File (XDF) as tab or comma delimited. One of the columns in the main data source (with the values eventually in your drop-down) should have values matching in the XDF.

 

Then in a rule you will call out to the XDF tell it to loop through and match the office location value from the Main data source (which will be a list in MCC) to the value in your XDF. Also in the rule you will return your address content to display in the template using tags, so make sure your "Treat return strings as Tagged text" option is checked in the rule.

 

Attached is a sample with the address content on the left side of the postcard coming from the XDF file: Postcard_XDFAddress.zip

 

Hope this helps

Postcard_XDFAddress.zip

[FreightTrain]

One more important point! You will upload your XDF file into MarcomCentral separately from the template files: Catalog > Form/Template Setup > External Data Files

 

This way if you need to update your address list (XDF) you can just replace it and also update your drop-down in the form for the customer.

[MikeVM]

Thanks, I'll try and let you know if this work for me