Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: is there a way to import from an old picture gallery to Coppermine ?  (Read 5981 times)

0 Members and 1 Guest are viewing this topic.

Christian-91

  • Coppermine newbie
  • Offline Offline
  • Posts: 10

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
Logged

Fabricio Ferrero

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 1997
  • From San Juan, Argentina, to the World!
    • http://fabricioferrero.com/
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #1 on: March 23, 2009, 04:25:30 pm »

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.
Logged
Read Docs and Search the Forum before posting. - Soporte en español
--*--
Fabricio Ferrero's Website

Catching up! :)

Christian-91

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #2 on: March 23, 2009, 04:33:44 pm »

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.
Logged

Nibbler

  • Guest
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #3 on: March 23, 2009, 05:10:00 pm »

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.
Logged

Christian-91

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #4 on: March 24, 2009, 09:37:11 am »

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 ?

Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9097
  • aka Frantz
    • Ma galerie
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #5 on: March 24, 2009, 09:43:53 am »

no this tool doesn't exist in Coppermine. You will have to code it yourself
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

Christian-91

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #6 on: March 24, 2009, 09:47:51 am »

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.
Logged

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #7 on: March 24, 2009, 10:08:51 am »

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.

Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9097
  • aka Frantz
    • Ma galerie
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #8 on: March 24, 2009, 10:26:31 am »

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 ...
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

Christian-91

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #9 on: March 24, 2009, 01:12:26 pm »

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 :
Logged

Christian-91

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #10 on: March 24, 2009, 01:32:12 pm »

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.
Logged

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #11 on: March 24, 2009, 01:48:53 pm »

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.
Logged

Christian-91

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #12 on: March 24, 2009, 02:04:57 pm »

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 :
Logged

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #13 on: March 24, 2009, 02:18:44 pm »

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?
Logged

Christian-91

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #14 on: March 24, 2009, 02:26:43 pm »

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.
Logged

Christian-91

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #15 on: March 24, 2009, 02:30:20 pm »

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....
Logged

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #16 on: March 24, 2009, 02:42:44 pm »

Quote
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.
  ;)
Logged

Christian-91

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #17 on: March 24, 2009, 02:49:32 pm »

  ;)
Thank you I shall admit I contradict myself !!
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9097
  • aka Frantz
    • Ma galerie
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #18 on: March 24, 2009, 03:22:09 pm »

Quote
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.
Quote
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  ;)
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: is there a way to import from an old picture gallery to Coppermine ?
« Reply #19 on: March 24, 2009, 05:40:34 pm »

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.
Logged
Pages: [1]   Go Up
 

Page created in 0.025 seconds with 21 queries.