Importing Permanent Galleries

Introduction

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

Important Notes

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.