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