Base de données

More
11 years 4 months ago #38541 by mtgt
Base de données was created by mtgt
Bonjour,

J'aimerai savoir comment il serait possible de copier toutes les données d'un champs pour les coller dans un autre.

Je m'explique, j'utilise 2 plugins dans 2 champs FelxiContent différents et ayant besoin des mêmes données. Voulant éviter de remplir à nouveau des centaines de champs, j'aimerai juste savoir si il y avait une méthode simple pour copier/coller en passant par PhpMyAdmin ou autre.

Mon site tourne sur Joomla 1.5

Merci par avance pour votre aide

Greg
"La vie n'est qu'opportunité !" ;-)

www.nomadsroad.com Nomads Road - Une aventure interactive autour du monde
www.voyage-australie-nz.com Infos pour préparer son voyage en Australie et en Nouvelle-Zélande

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

More
11 years 4 months ago #38548 by ggppdk
Replied by ggppdk on topic Base de données
Hello,

temporarily take your site offline, only if you have frontend EDITORs and then back-up the table:
nnn_flexicontent_fields_item_relations (i mean changes of in an item will be lost if you restore the fields values table)

(Careful not to reverse):
If your new field has id 55 and you old field has id 44
Code:
INSERT INTO nnn_flexicontent_fields_item_relations (field_id, item_id, valueorder, value) SELECT 55,item_id, valueorder, value FROM nnn_flexicontent_fields_item_relations as rel WHERE rel.field_id=44
Replace 'nnn' with your prefix

-- ALTERNATIVE: what about deleting the second field and then going to fields manager and using "Copy with values" button

after you copy the field you can go and the second field and customize its configuration

NOTE: If your second field is text searchable then you need to recalculate the search index


-- 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
11 years 4 months ago #38549 by mtgt
Replied by mtgt on topic Base de données
Thanks a lot,

I've used the second method witch wa better and faster.
I've never seen it was possible to copy a field with their data.

Thanks again, my problem is solved!

Greg
"La vie n'est qu'opportunité !" ;-)

www.nomadsroad.com Nomads Road - Une aventure interactive autour du monde
www.voyage-australie-nz.com Infos pour préparer son voyage en Australie et en Nouvelle-Zélande

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.388 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