Jump to content

Simple List Import Utility - Populating Default Display field


Recommended Posts

Evening all, 

I'm hoping to please get some help with the Simple List Import Utility if possible :) 

Basically I'm trying to import a list from a CSV using the tool but I can't seem to get the Default Display field to populate with info from the CSV, each time I do the import the Default display is populated by the Value as shown below.

SimpleListImportDefaultName.thumb.PNG.6a1606a49995ab87a8dd4c1a233db61d.PNG

Am I missing something? or is it not possible to populate the Default Display field using the import tool?

Many thanks

Link to comment
Share on other sites

Hi @Brendan,

Your query is incorrect, you are assigning "value" to disp. As the field names is already "disp", you can just suffice with :

SELECT value as val, disp FROM SomeList.csv

You can also simply "select value, disp from SomeList.csv" and code in "value" instead of "val".

You might also want to change the {.disp} to [disp] as well (in the Translations section).

I spot that what you have is part of the sample config we deliver, I'll have a look at tweaking those.

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...