![]() |
|
Question about ... migration - Printable Version +- ZenphotoCMS Forum (https://forum.zenphoto.org) +-- Forum: Support (https://forum.zenphoto.org/forum-1.html) +--- Forum: General support (https://forum.zenphoto.org/forum-4.html) +--- Thread: Question about ... migration (/thread-8528.html) |
Question about ... migration - wibbi - 2018-03-02 Hello, I am now looking for different ways of migration and want to inform myself about this. 1.) The first option would be to first scan all images from ZenPhoto and then to expand the ZenPhoto database with the titles, description, tags, etc, using the data from the Gallery3 database. Is it OK if ~15000 image files are saved in the folder /albums and then the admin page "Albums" is called up, or is this overloading the system? Respectively, where is the point where the images are scanned / recognized? 2.) The second option would be to fill the ZenPhoto database untouched with the data from the Gallery3 database. Since I do not know which tables and columns in the ZenPhoto database necessarily have to be filled out. Other problems will be to show in ZenPhoto the parent album thumbs which are manually selected in Gallery3. If you have information and ideas I am very happy about it. Question about ... migration - acrylian - 2018-03-02 The gallery part of Zenphoto (btw, it is Zenphoto, not ZenPhoto! ;-)) scans on discovery. There is a "Database refresh" button on the overview page that really scans the complete albums folder and matches the database with it. This is also to be used if anything gets out of sync. Which it does if you for example delete via ftp in a subfolder that never gets visits so it never gets updated. Again, if anything is in the database that has no equivalent on the file system it will be considered gone. So you have to have your images/albums present when you edit the database as it otherwise will be for nothing. Generally this applies to migrations, too: Question about ... migration - wibbi - 2018-03-02 OK, thanks. Scanning of folders and their images and subfolders: Scanning of subfolders and their images and subfolders: So, it is always scanned only one level down. First Question: Does a server tolerate 15000 image files on database refresh? (no overload or timeout?) Question about ... migration - wibbi - 2018-03-04 OK, ~15000 images with once scanning over the album Edit Page is no problem. But you should have already/befor set the dropdown "Show X album levels" to the existing folder depth. With me it stopped in the middle once. After reloading (F5) the rest was loaded. Maybe a button ("load albums and images") would be better than the pure pageview. So you could make the "Show X album levels" setting beforehand. Question about ... migration - acrylian - 2018-03-04 This was added because it did kill installations with lots of albums and subalbums in the past. That's why it is an option. Again the principle of Zenphoto is to discover on request. Otherwise use the "database refresh" button to scan everything. Question about ... migration - wibbi - 2018-03-04 "Refresh the Database"-Button in the "Overview" Page? In addition: I had deactivated "Show album thumb". Question about ... migration - acrylian - 2018-03-04 Yes, that button. It syncs the database with what is on the file system on request. And the whole albums folder. Yes, album thumb disabling is good but a lot of nested albums can cause a lag as well as images and subalbums need to be counted. Therefore you can choose how much to display. Question about ... migration - wibbi - 2018-03-04 New question: I notice that the Gallery3 content (title, desc) is stored without HTML Question about ... migration - wibbi - 2018-03-09 Currently problems with migration with apostrophes in title and description, like "cat's toys". Question about ... migration - acrylian - 2018-03-10 A little more info like what the actual issue (= error message) is would help. Probably an encoding issue. Question about ... migration - wibbi - 2018-03-10 Hey acrylian, it was just an interim message. I have already migrated the albums and photos. I migrated albums and images separately. Also to keep an overview, if there are mistakes. There is still a script missing for the tags. For this it needs a SQL Tripple Inner Join. Read the README. Question about ... migration - acrylian - 2018-03-10 All right, no problem, sounded like you would need help. Let me know once this guide is complete and we gladly link to it from our user guide somewhere. Question about ... migration - wibbi - 2018-03-10 For my purposes, I only need a simple SQL inner join to migrate the tags, but let me see if I can do it with a tripple. Question about ... migration - wibbi - 2018-03-11 There is a problem. The image migration script has an error. In Gallery3, two images in the same album/folder can have the same "weight" (sort order number). Difficult to solve. Apart from that, a first test works with the triple inner join for the tags. Question about ... migration - wibbi - 2018-03-12 The sort order bug is fixed for albums and images and the scripts extremely accelerated. What were minutes ago are now seconds. Question about ... migration - wibbi - 2018-03-14 The script for migrating tags for the images is ready. Question about ... migration - wibbi - 2018-03-16 There were a few tags on the albums. |