List Manager Forum

How to note multivalues in CSV import

User moon_1262 2021-12-20 10:54:03

Joomla 3.10.4
List Manager 2.7.3

Hi,

I would like to import a CSV file with a multivalue column in it so that it would populate a multivalue field in my list. But don't know how to separate text values that I want in my multivalue field… If I check an exported CSV (export data to csv format), the text multivalues are space separated but if my values have text with spaces in them, I don't understand how that could work.

Don't know if I made myself clear…

Regards,
--
Pascal

Moonsoft support 2021-12-20 13:01:44

Hi,
yes, you can upload multiple values data with spaces inside. You only need to mark the separated values with # , like this

option number1#option number2#option 3

in order to match these values with the ones configured at your multiple field configuration.

Hope this helps

User moon_1262 2021-12-20 17:50:00

Whoa ! That's some precious info ! I'll make sure I record that in multiple places !

--
Pascal

...
Support/development 40 hours

With the peace of mind of having a professional team at your service (20% discount)

Buy now!
...
CalcBuilder

Create dynamic calculators

Buy now!