Home› General support

Import in SQL

TSTM Member
in General support
Today I installed Zenphoto but I actually like to import some data in the table 'albums' and 'images'.

I have a table which can create 1000 albums with animal names. I don't have those folders/albums on my pc and I don't want to add them piece by piece. So it seems there is no other way than import my list with albums.

When I create a table with an unique id, just like the rows created by the admin, it appears in PhpMyAdmin in 'albums' without any problems.

Then, when I visit the admin, the albums won't appear and while visiting the admin the system will just reset 'my just imported albums list' and arrrghh...the old settings are there again. E.g. when I add 'Species one" in the admin, and delete this album record in SQL it will appear again in the admin when I refresh the admin page.
It looks like Zenphoto remembers everything. Even old - deleted - maps still appear in the folder 'cache', why not simple delete?

How is it possible that Zenphoto is able to remember this data while deleting it in SQL?

Is there a way to import my data into the tables?

Comments

  • sbillard Member
    I do not think I really understand what you are saying. However, some basics for you:

    Zenphoto is filesystem based. So the image files and album folders must exist. If they do not exist there is no way you can make them show up. Records for "missing" items may well be cleaned from the database.

    Zenphoto imports data from image metadata, so it can re-populate its database even if you delete the records. You can manage this by enabling/disabling fields it will import.

    If you create a database table that does not reflect the structure of the filesystem it is the same as having the files/folders missing.

    You say that the albums do not exist on your PC. Is your PC where you are installing Zenphoto? if so your plight is hopeless.

    If you are simply trying to find a way to get the database information into your install that does contain the folders then your best bet would be to create XMP files for each album/image in your database. Create them in the same filesystem structure as the gallery and FTP them there.

    You will need to be sure that the xmpMetadata plugin is enabled so the data will be processed.
Sign In or Register to comment.