Migrating from non conventional CMS

1. offizieller Beitrag

    Hi Devs!

    I would like to share same consideration about an unusual data migration, in order to have your opinion.


    I've an alien cms, and I have to migrate the galleries from this to JoomGallery in particular the data associated with each individual image.

    I thought of importing the different galleries directly starting from the images and then export from the "alien cms" the data relating to the single image and import them on JoomGallery DB in sequence for each image.


    Have you already faced similar situations?

    Do you have any advice?



    Many thanks!



    Davide

    • Offizieller Beitrag

    Hi Davide,


    what exactly is a 'alien cms'? :/

    The big question is how the information is stored in this old system?

    Is the data in database tables for categories and images as in the JoomGallery?


    There are already migration scripts for migrating from other galleries, e.g. Coppermine or 4images, see https://www.en.joomgalleryfrie…38-migration-scripts.html

    With a very large gallery you could create a new script for the migration.


    Another possibility is to use the import script from fruwolt. You can find it here: https://github.com/fruwolt/csv2joom-dev

    This also allows a larger number of images and categories to be imported and provided with the desired information via a csv file.


    Regards

    MrMusic

    Zitat von MrMusic

    The big question is how the information is stored in this old system?

    Is the data in database tables for categories and images as in the JoomGallery?

    Eh, a very very alien CMS, no table, data stored on dynamic text files, and so on, very very difficult to explain, here and exemple to a text file data:


    In the alien CMS we have for each gallery we have a .ffc file in

    "photos" which in practice only contains the list of images:


    Code
    §gallery§
images.sordone,images.svasso_piccolo,[...],images.gal_5_img_7360
§online§
true
§title§
Immagini 2017
§_sown_§,accounts.michele@users_riusa


    and then the images with relative accompanying file containing the

    text related to each image:


    so I must first analyze the gallery descriptor, recover

    all its descriptions and then generate a SQL for each gallery.


    Zitat von MrMusic

    Another possibility is to use the import script from fruwolt. You can find it here: https://github.com/fruwolt/csv2joom-dev


    I try to look inside this script, you never know...


    Many thanks for the useful information!


    Thanks!



    Davide