photo information

Phoca Gallery - image gallery extension
serged
Phoca Enthusiast
Phoca Enthusiast
Posts: 65
Joined: 25 Apr 2022, 20:50

photo information

Post by serged »

I am working for a photo club, and I am looking for a tools to manage own photos we present in evening meeting and competition

So is it possible to load from a external file like csv informations for photos
- name (different for each)
- date of a display session
- name of the dips
- grade in competition
- more informations


and do different galleries with these informations

Best regards
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49138
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: photo information

Post by Jan »

Hi, there is no option to load information from external files, all information are stored in database in Phoca Gallery :idea:

Jan
If you find Phoca extensions useful, please support the project
serged
Phoca Enthusiast
Phoca Enthusiast
Posts: 65
Joined: 25 Apr 2022, 20:50

Re: photo information

Post by serged »

what a shame , when you have hundred of photo to load

I know that the information is the database, but it is not possible when you load the photos, to load these informations from an external file ?

Otherwise is it possible to have the name of the photo given by the filename of the photo ?
serged
Phoca Enthusiast
Phoca Enthusiast
Posts: 65
Joined: 25 Apr 2022, 20:50

Re: photo information

Post by serged »

Or another solution : Is it possible to update directly the database ?
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49138
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: photo information

Post by Jan »

Hi, I didn't do such action yes, so I would recommend using e.g. phpMyAdmin directly - using SQL, etc.

In Phoca Gallery, you can create galleries fast - copy the files to server and add them to system. But if you need to add some additional info like description, etc. and not add them manually for each photo, then maybe some prepared SQL should be done :idea:

Jan
If you find Phoca extensions useful, please support the project
serged
Phoca Enthusiast
Phoca Enthusiast
Posts: 65
Joined: 25 Apr 2022, 20:50

Re: photo information

Post by serged »

You have a description of the tables used by Phoca ?
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49138
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: photo information

Post by Jan »

See:
administrator/components/com_phocagallery/install/sql/mysql/install.utf8.sql

Jan
If you find Phoca extensions useful, please support the project
serged
Phoca Enthusiast
Phoca Enthusiast
Posts: 65
Joined: 25 Apr 2022, 20:50

Re: photo information

Post by serged »

OK Thank you
I will study it
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49138
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: photo information

Post by Jan »

Ok
If you find Phoca extensions useful, please support the project
Post Reply