database, cities , regions

More
9 years 2 weeks ago #53788 by micker
Replied by micker on topic database, cities , regions
you need to adapt your database to flexicontent dependencie mode => adding a valuegrp colum
after you do a sql request to your database (check tooltip all is in)
for country
Code:
SELECT yourvaluecountry AS value,yourtextcountry AS text, youvaluegroupcountry AS valgrp FORM yourdatabasecountry
for city you need same valgroup in your database to link country to city (ex france => toulouse::france, lyon::france etc)
Code:
SELECT yourvaluecity AS value,yourtextcity AS text, youvaluegroupcity AS valgrp FORM yourdatabasecity
for this field use Cascade after field => select the country field

i repeat if you didn't have any sql experience it will be complex, and we can't do it for you in free support ;)

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

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

More
9 years 2 weeks ago #53793 by ggppdk
Replied by ggppdk on topic database, cities , regions
Hello

ok you could also use this SQL file without any change,
-- just execute it in phpMyadmin

after doing that, i will give you the configuration that you can use to cascade the fields

-- alternatively you can execute the SQL file via a Joomla extension:
miwisoft.com/joomla-extensions/mijosql-joomla-database-manager


-- 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
9 years 2 weeks ago #53794 by rsgitu
Replied by rsgitu on topic database, cities , regions
ggppdk already installed MijoSQL in joomla ,,, already ran the mysql file ,, they already appear in phymyadmin ,,, now only do they appeared as an option .... in creating fields in FC , ​​how do ?

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

More
9 years 2 weeks ago #53803 by micker
Replied by micker on topic database, cities , regions
please re read my message about create a select field all is in

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

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

More
9 years 2 weeks ago #53827 by ggppdk
Replied by ggppdk on topic database, cities , regions
Hello

you will need v3 BETA6:
github.com/FLEXIcontent/flexicontent-cck/releases

which is almost done, but if your site is new then just download: v3 BETA6 nightly 4
and then create and configure 3 select fields in DB mode


-- 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
9 years 2 weeks ago - 9 years 2 weeks ago #53844 by rsgitu
do not be angry ... - I downloaded and installed the new version - is getting very good --FC doing excellent work --- and still free - just that- " I can not " "do not know " ,,, create fields ,, State > City> Region > Categories etc .. :( - forgot to say - it would be nice that these fields - were shown - in breadcrumbs
Last edit: 9 years 2 weeks ago by rsgitu.

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.830 seconds
Save
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