is there a way to import from an old picture gallery to Coppermine ?

[Christian-91]

Hi

I have already an old photo gallery made with a oracle DB and Cold Fusion (hand-made development). I would like to know if there is a way to import from the old photo gallery to Coppermine ?

Regards,

Xian

[Fabricio Ferrero]

This would change from one software to another depending on wich is the *old* software you're importing the pictures from. So there is no posibility for the dev team to come up with "Importing tools" for every old software (or new ones) that exist out there. In fact, this is something you should ask to the support of the other soft, some export feature to take your pictures to Coppermine.

[Christian-91]

Fabricio,

Thank you for your kind answer. Let me clarify my question. I would like to knwo if there is documentation for creating records in the Mysql db used by Coppermine. In that case I could insert records in the MYsql DB directly; I don't want a tool I just need to know if it is possible to create records "manually" to add add pictures.

Hoping I am clear.

Thank you.

[Nibbler]

You are asking for support, not a new feature then.

There is no documentation about the database, but there is no reason why you can't manually add data. Unless you have lots of titles/descriptions that you need to import it would be easier to just batch add the files.

[Christian-91]

Unless you have lots of titles/descriptions that you need to import it would be easier to just batch add the files.

Nibbler,

I have hundreds of photos in the gallery. The description of each photos contains the following topics :

Nom de la photo : 
Format : 
Auteur : 
Date : 
Commune : 
Site : 
Theme1 : 
Soustheme1 : 
Theme2 : 
Sousthe me2 : 
Theme3 : 
Soustheme3 :

I would like to import each photo with the corresponding description. Using an import tool or whatever, does this exists in coppermine ?

[François Keller]

no this tool doesn't exist in Coppermine. You will have to code it yourself

[Christian-91]

Bonjour

This is not very nice. If no documentation exists about the database structure in Coppermine, how to code in that case ? That seems pretty much difficult or impossible.

[Hein Traag]

If it's just the pictures and their descriptions that need to be imported into a cpg gallery then it might be worthwhile doing it "by hand". That way you get to know the batch add procedure and related procedures. Plus you can eliminate pictures that are no longer needed etc.

[François Keller]

one of the problem is that you have more custom files for picture description that Coppermine have by default.
An other thin, Coppermine works with categories and albums and in your case, you must define in wich category and album you will import each file.
a database structure documentation has been started for cpg1.5 but on this momentt only the albums table is handled.
You have to see in the pictures table to see what fields are used ...

[Christian-91]

Hi

i would like to know if it would be possible to add fields to a photo description and to request the db in order to find results :

Nom de la photo :
Format :
Auteur :
Date :
Commune :
Site :
Theme1 :
Soustheme1 :
Theme2 :
Sousthe me2 :
Theme3 :
Soustheme3 :

[Christian-91]

Hi

In fact I think Coppermine is not the tool I am searching for. Because as i can see from the examples given here, I see that there are not search features ("Search for") and not much features about categorization of the pics.

Then i will not ask here "Would you know a gallery software with those features ?" otherwise i am going to get fired from this forum.

[Hein Traag]

I think there is too much difference between what you are using now and cpg. But i can say cpg can handle the amount of pictures. Using keywords it is possible to have a search function as wel. Usage of categories is also easy to do within cpg. So basicly it comes down to rolling up your sleeves and get your hands dirty by rebuilding your gallery using cpg.

Or look around for a other gallery that might offer what you need. Asking for it will not get you kicked off the board, that would be unnescarily rude. See if menalto gallery does the trick for you.

Good luck.

[Christian-91]

Hein,

Thank you for your input !

I have to think about your suggestion. It means that do you know if it is possible to add fields for the photos like these above ? Il means moduifying the structure of the tables of the DB used by cpg. I can do it because I am a database administrator (I'm have Oracle DB's here art work); By the way I am a profesional, a developer which means that if cpg let me add columns to a table or to some tables and let me handle this, I could do the job. What do you think ? Am i the first one who wants to add fields to a photo et search abilities ?

Nom de la photo :
Format :
Auteur :
Date :
Commune :
Site :
Theme1 :
Soustheme1 :
Theme2 :
Sousthe me2 :
Theme3 :
Soustheme3 :

[Hein Traag]

Adding extra fields to a image description can be done. For example with this mod: http://forum.coppermine-gallery.net/index.php/topic,23695.0.html

But why don't you install cpg and take a look around first?

[Christian-91]

But why don't you install cpg and take a look around first?

Hein,

Because I prefer be sure to make the good choice before installing. Sometimes it may take one day or two spen installing, configurating and so on before something works and eventually to find that the product was not satifying your needs.

Thank you for you kind answer.

[Christian-91]

I have taken a look to the URL you mention, it does not seems very easy to add extra fields to photos. Quite a lot of PHP....

[Hein Traag]

By the way I am a profesional, a developer which means that if cpg let me add columns to a table or to some tables and let me handle this, I could do the job.

[Christian-91]

 

Thank you I shall admit I contradict myself !!

[François Keller]

I see that there are not search features ("Search for") and not much features about categorization of the pics.

not sure your'e right 
cpg has a search feature and you can creat as many categorie you want.

Because I prefer be sure to make the good choice before installing. Sometimes it may take one day or two spen installing, configurating and so on before something works and eventually to find that the product was not satifying your needs.

I can understant this, but we have a live-demo package (avaible here http://sourceforge.net/project/showfiles.php?group_id=89658&package_id=198891&release_id=435740)
also look at  this post http://forum.coppermine-gallery.net/index.php/topic,34418.0.html 

[Joachim Müller]

If no documentation exists about the database structure in Coppermine, how to code in that case ? That seems pretty much difficult or impossible.

By the way I am a profesional, a developer

Then you don't need a documentation: just look at the table layout - it's totally obvious what you need to do if you plan to code the importer by yourself. At least it's far from difficult or impossible. Just perform an install, create a category, observe the changes in the database. Create an album, observe the changes in the database. Upload a file, observe the changes in the database. This should give you everything you need to populate the database with your importer.
In my opinion you're asking to be spoon-fed or to have someone of the devs take care of something that is entirely your issue and none of our business. You can't expect that we provide importers for self-written apps. You can't expect that we could possibly come up with a hand-written importer for all kinds of apps. Don't get me wrong, but in my book you seem to be lacking some skills to accomplish the task. I suggest mass-mporting the pics and run with that.