Importing Galleries


With AutoGallery SQL it is possible to import a large number of galleries into your database in two quick steps. This is a nice feature if you are just starting your TGP and need some galleries to get going, or if you want to add a bunch of your own galleries.

Formatting Galleries

To import galleries you will need to either place them in a text file or paste them into a text box in the gallery importing interface. In either case, the format needs to be the same. There should be only one gallery per line. 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 all of the galleries. For example: The above example has three galleries each with an e-mail address, gallery URL, category, and number of thumbnails. Once you have your galleries in the proper format, you can begin the importing process.

Control Panel Interface

Locate and click on the Import Galleries link in the Manage Galleries section of the control panel menu to access the gallery importing interface. AutoGallery SQL will load a page where you will be able to tell the software if you want to import from a file that you uploaded or if you want to paste your galleries into the supplied text box. Each option is explained on the gallery importing interface. You will need to press the Analyze Input button if you have pasted data into the text box or the Analyze File button if you are importing from an uploaded text file.

After you press the correct Analyze button you will be taken to a page where you will see the first gallery split out into it's individual fields. On the right hand site of the Import Galleries box you will see drop down menus. From these menus you will need to select what each field represents. 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 SKIP fields when importing the galleries.

In addition to assigning each of the fields from the data you are importing, there are three additional items that you will need to setup. Each of those items is described below. You now have the ability to configure some options that will affect how the galleries are imported. In the Options section of the import screen you can check boxes next to each option to indicate if you want it to be applied during the import process. Each item is self-explanitory.

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 data you have provided. 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. You can prevent this from happening by using the "If a gallery does not match an existing category put it in ..." option.

The galleries that you import are not scanned during the import process. That could potentially take several hours to complete, so it is something that is better accomplished later by using the software's Gallery Scanner feature. The point of the import function is to quickly get the galleries into your database so they can be used right away. If you want to do things like automatically create thumbnails, set the gallery format, or count the thumbnails on the gallery, run the gallery scanner after you have imported the galleries.

If you are importing icons with your galleries, you will need to enter the icon identifier in the import data, and it will need to match exactly with the identifier name that has been configured in the Manage Icons control panel interface. For example, if you have an icon named Hot that displays a hot icon next to the gallery, you would need to use the identifier Hot exactly. If you want to assign multiple icons, they should be in a comma separated list like so: Hot,New

Field Formats

Some of the items that you may want to import have specific formats that must be met in order for the galleries to be imported correctly. Each of those is discussed below.