With AutoGallery SQL it is possible to import a large number of permanent galleries into your database in two quick steps. This is a nice feature if you
have a large number of sponsor galleries that you want to add as permanent galleries.
The Import File
To import galleries you will need to place them in a text file, with one gallery per line. This file will need to be named perm.txt.
Each line should have pipe (|) delimited data, with each field representing one piece of information about the gallery. The pieces may
be in any order, but that order must remain the same throughout the file. For example:
James|Description of gallery 1|http://www.galleryurl.com/pages/gallery1.html|Hardcore|15
Frank|Description of gallery 2|http://www.galleryurl.com/pages/gallery2.html|Teen|12
Edward|Description of gallery 3|http://www.galleryurl.com/pages/gallery3.html|Amateur|16
The above example has three galleries each with a name, description, gallery URL, category, and number of thumbnails. Once you have your
file in the proper format, you can upload it to the data directory of your AutoGallery SQL installation.
Make sure you upload in ASCII mode
Control Panel Interface
Once the perm.txt file has been uploaded, you can begin the import process through the control panel. Locate and click on the Import Galleries
link in the Permanent Galleries section of the control panel menu. AutoGallery SQL will load a page where you will see the first line of your perm.txt
file split out into it's individual fields. On the right hand site of the Import Permanent Galleries box you will see drop down menus. From these menus
you will need to select what each field represents.
There are also 5 additional fields you will need to fill in: Location, Start Date, Expire Date, Position, and Weight. Each of these items are covered
in the Permanent Galleries
section of the manual. The only field which you can leave blank is the Position field.
If it is left blank, the galleries will appear in random positions.
If one of the pieces of data for the gallery does not fit into any of the drop down menu options, select the Skip option. AutoGallery SQL will ignore all Skipped
fields when importing the galleries.
Once you have each of the fields setup how you want it, press the Import Galleries button. AutoGallery SQL will begin importing the galleries from the
perm.txt file. Once it is complete, it will return you to the same page with information on how many galleries were imported.
Only galleries which fit into one of your categories will be imported. Any galleries that do not match one of your existing categories will be skipped
over and not imported into the database.
During the importing process it is not possible to create thumbnails for the imported galleries. To do that you need to manually create them through
the Manage Galleries interface.