Import field values
By Loupida on Tuesday, 22 July 2014
Posted in Tips & Tricks (Not Supported)
Replies 3
Likes 0
Views 1K
Votes 0
Hello guys,

I'm facing to a big job that i can't achieve manually, because i must enter more than 500 values in a Checkbox field i created in a Group ; so i'm wondering if there is any way to do it automatically, like a sql query that will allow me to import values in the field or something. I'm not a developer and i'm not at ease with sql queries. Help please.

Regards.
Hello Loupida,

Sorry but I don't really understand what you are trying to achieve here but if you want to insert values for custom fields for a group or user, you'll need to insert them into the table jos_social_fields_data.
Mark
·
Tuesday, 22 July 2014 13:25
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Mark,

Actually, i'd like know the sql query synthax i may execute to insert several values in table jos_social_fields_data just once, from PhpMyAdmin, so i could get field values right in my site for a Checkbox Group field one
Loupida
·
Tuesday, 22 July 2014 17:06
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Loupida,

I can't really give you the syntax because they are all dependent on the field id's and it varies depending on the fields that you have created. If you really need to refer to the existing SQL structure, you can take a look at the model file in /administrator/components/com_easysocial/models/fields.php
Mark
·
Tuesday, 22 July 2014 22:49
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post