[SOLVED] Import - how to set up the differents values of a same field in access/xls file ?

More
10 years 4 months ago - 10 years 4 months ago #55254 by bendeb
Hello, :)

I use Flexicontent 3.0 Beta 6b.
And Woooh !!! It is just wonderful how this component have been upgraded since the latest version I used (2.0 )
Many features have been added, this is the best CCK I know, clearly.

But I have a very little problem. :lol:

I have create a simple text field with "Allow multiple values : YES"
So in my item form I can add multiple values, each of theses in a different text area.

I want to import a big access/xls or CSV file (with a lot of items) in Flexicontent. So there is one column for each field in my access/xls file.

The question is simple : if I can add multiple values in one field, how do I declare this on my access file ?
Is there a specific syntaxe like this ? :
Is it the same syntaxe than checklist field, with %% to separate each value ?

Thank for your answer.

Flexicontent 4.1.0b1
Joomla 3.9.18
Last edit: 10 years 4 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

More
10 years 4 months ago #55268 by ggppdk
Hello


yes you can use %%, eig

value01%%value02%%value03

but i now see a small problem the multi-value separator is not configurable, and is fixed to be %%
this should not be a problem though, because you values in CSV files can quoted and this is configurable

please update to v3 BETA7g , it fixes all know issues of v3 BETA6b,
and there are some important new features in see our "latest download" menu item:
www.flexicontent.org/downloads/latest-version.html


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
10 years 4 months ago #55279 by bendeb
Thank you ggppdk for your answer :)

I have already installed the v3 BETA7g yesterday.
I'll be back soon with anothers questions :whistle:

Thank.

Flexicontent 4.1.0b1
Joomla 3.9.18

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.531 seconds
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Save