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
photo information
- Jan
- Phoca Hero

- Posts: 49138
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: photo information
Hi, there is no option to load information from external files, all information are stored in database in Phoca Gallery 
Jan
Jan
If you find Phoca extensions useful, please support the project
-
serged
- Phoca Enthusiast

- Posts: 65
- Joined: 25 Apr 2022, 20:50
Re: photo information
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 ?
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

- Posts: 65
- Joined: 25 Apr 2022, 20:50
Re: photo information
Or another solution : Is it possible to update directly the database ?
- Jan
- Phoca Hero

- Posts: 49138
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: photo information
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
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
If you find Phoca extensions useful, please support the project
-
serged
- Phoca Enthusiast

- Posts: 65
- Joined: 25 Apr 2022, 20:50
Re: photo information
You have a description of the tables used by Phoca ?
- Jan
- Phoca Hero

- Posts: 49138
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: photo information
See:
administrator/components/com_phocagallery/install/sql/mysql/install.utf8.sql
Jan
administrator/components/com_phocagallery/install/sql/mysql/install.utf8.sql
Jan
If you find Phoca extensions useful, please support the project
-
serged
- Phoca Enthusiast

- Posts: 65
- Joined: 25 Apr 2022, 20:50
Re: photo information
OK Thank you
I will study it
I will study it
- Jan
- Phoca Hero

- Posts: 49138
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact: