Page 1 of 1

photo information

Posted: 25 Apr 2022, 20:56
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

Re: photo information

Posted: 26 Apr 2022, 17:01
by Jan
Hi, there is no option to load information from external files, all information are stored in database in Phoca Gallery :idea:

Jan

Re: photo information

Posted: 26 Apr 2022, 17:59
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 ?

Re: photo information

Posted: 27 Apr 2022, 13:29
by serged
Or another solution : Is it possible to update directly the database ?

Re: photo information

Posted: 27 Apr 2022, 13:52
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

Re: photo information

Posted: 27 Apr 2022, 13:59
by serged
You have a description of the tables used by Phoca ?

Re: photo information

Posted: 27 Apr 2022, 14:06
by Jan
See:
administrator/components/com_phocagallery/install/sql/mysql/install.utf8.sql

Jan

Re: photo information

Posted: 27 Apr 2022, 14:19
by serged
OK Thank you
I will study it

Re: photo information

Posted: 28 Apr 2022, 13:11
by Jan
Ok