GERBING Software


 



faq, Questions to image data base software

1.Why is a data base more efficient as an ingenious folder structure or as thumbnail overviews or as an IPTC fulltext search?
2.Must I know how a data base works?
3.Must I really provide every foto/video with keywords?
4.What does 'free keywords' mean?
5.How to edit keywords?
6.How do I use the keywords for finding?
7.Can I show the found fotos/videos automatically as diashow?
8.May I afterwards move or copy my files and the data base on another location?
9.Why has the program no colored surface and hardly menus but is operated mainly by pressing keys?
10.Are there zoom functions?
11.Where are there further hints for the professional version?
12.Is there a version for Mac OS?
13.What is the content of the package GERBING fotoalbum?
14.How to organize a multi user environment?
15.What can be done, when runtime errors occur?
16.I suspect that the data base unnecessarily increases itself, can I do something against this?
17.How can I create a link for fotos.exe by myself?
18.Can I relocate my fotoalbum to another hard drive or to another computer?
19.I am using other software for archiving my fotos but I want to change to a database software and want to use GERBING Fotoalbum. I have about 20,000 fotos  scattered on the computer.

20.I have many fotos with geotags (GPS positions). Can I search for them with GERBING Fotoalbum?

21.How can I open various Fotoalbums from the desktop?
------------------------------------------------------------------------------------------------------------------------------------------------



faq, Answers to image data base software:

1.Why is a data base more efficient as an ingenious folder structure or as thumbnail overviews or as an IPTC fulltext search?

Among the advantages of an image data base software are: creating custom keyword fields, the use of stored queries, diverse combinations when searching for keywords with AND, OR, NOT. GERBING Fotoalbum 15 can import keywords from EXIF or IPTC fields but also write back database keywords into IPTC fields. Thus you do not need third-party software for generating metadata.

 

2.Must I know how a data base works?

No, however it is no fault because you then better understand the power of the program and can better use the functions for finding. GERBING fotoalbum uses a Microsoft Access data base or a sql server data base. There is no need to have installed Microsoft Access on your computer to run GERBING Fotoalbum. Only a few expert tasks in the Professional Version can not be executed without an installed Microsoft Access. To run the sql server version you must have installed a Microsoft sql server.


3.Must I really provide every foto/video with keywords?

Yes, but you can assign the keywords groupwise which are same for a group of files (with the tool Fotosmdb) just with Drag&Drop from the Windows Explorer. The standard data base fields are 'year situation location country people comment'. You do not need to deliver keywords for each data base field. In the extreme case you can let empty all data base fields, but it will be difficult then to find a certain foto/video.


4.What does 'free keywords' mean?

'Free keywords' means, you need not to define the keywords in a previous step. For example you can allocate a whole series of 'free keywords' to the field 'situation', as '10th anniversary class reunion goethe school'. You can define user defined keyword fields in the professional version.
 

5.How to edit keywords?

You can edit the keywords (new, change, delete) of the files easily directly in a list window. In the list window you see many lines, one line and optionally one thumbnail for every foto/video. You must have write access to edit keywords.
 

6.How do I use the keywords for finding?

At the program start you see a search mask with fields, where you shall enter your keywords. If you enter nothing, you find all files which there are in the data base. If you enter keywords, you only find the files which are described by these keywords. The user has the choice, whether he looks for free keywords or only for keywords which guaranteed are available. When you enter keywords into the search mask you can choose whether the keywords shall be connected by 'OR' or by 'AND'. Default is 'AND'. Additionaly you can search by 'AND' for the file date or part of the filename.


7.Can I show the found fotos/videos automatically as diashow?

Yes, of course. There is an automatic for ongoing fotos (slideshow, diashow) or for videos (interactively arranged film).


8.May I afterwards move or copy my files and the data base on another location?

Yes, to move the files including data base on CD or DVD or USB stick or network drives is possible without a loss of synchronisation between the files and the data base and you can also work with the CD or DVD or USB stick directly. If you move all files including the data base to a network drive you can for example create a central foto archive for all members of your company.


9.Why has the program no colored surface and hardly menus but is operated mainly by pressing keys?

The program has an 8-year maturity time from 1997 to 2005 behind itself before it was introduced to the public. In this maturity time the program was judged again and again by its users (programmer colleagues, friends, members of the family), examined and rubbed smooth, with the result:
-we do not want and need functions, for which there is already different software.
-we want to see fotos on the screen, which fill out the screen and therefore no title bars and no menu bars.
-we want to come to the result with few mouse clicks or keystrokes.


10.Are there zoom functions?

Yes


11.Where are there further hints for the professional version?

You get access to further hints for the professional version, if you download and install the shareware version. Then read in the file Fotos.chm under 'search criteria', please. The help file describes all functions, thus also those of the Professional version.


12.Is there a version for Mac OS?

No, is not intended also.


13.What is the content of the package GERBING fotoalbum?

-BatchHistogramCorrection.exe program for histogram correction for pale images in batch mode
-BatchHistogramCorrection.chm associated help file
-Diashow.exe program to display fotos without the use of a data base
-Diashow.chm associated help file
-fotos.exe Program for looking for fotos/videos in the data base and to display them
-Fotos.chm associated help file
-Fotosmdb.exe Tool to 'Create new data base records' in the data base (with Drag&Drop) and to examine for valid contents
-Fotosmdb.chm associated help file
-RenamMdb.exe Tool Tool to the simultaneous and corresponding change of filename of Fotos/Videos both in the data base and in the folder
-RenamMdb.chm associated help file


14.How to organize a multi user environment?

15.1. What is a multi user environment?
That means you install 'GERBING Fotoalbum' on a local network computer. There is also a sql server version since version 13.4.0. The following description is valid for the access version.
There can be organized two variants of a multi user environment:
1. All users get write access for the data base fotos.mdb.
2. Only one administrator gets write access for the data base fotos.mdb. All other users get read access. But the users must be conscious that temporary lockings can arise, if a user wants to change the language without informing the other users. Or if several users work with the function 'first hit per year' simultaneously.
to 2:
You then avoid all problems which can occur at variant 1. Special tasks lie in the responsibility of one administrator.
----------------------------------------------------
15.2. How  to install GERBING Fotoalbum in a local network?
1. How must it be installed?
The fotoalbum must reside on a network folder. It must be installed there. Any user who wants to start the fotoalbum from the network folder can but does not need to install once the GERBING Fotoalbum on his computer using his user account. By installing on your computer, you can save network overhead, because then you can use the fotos.exe on the computer. When fotos.exe starts you must select the database fotos.mdb on the network (hold shift key at startup ). When the installation is omitted on the users computer and the user has no administrator rights, he gets an error message when starting fotos.exe saying 'You need administrator rights ...'. If the user has administrator rights, he must select the language at the first start then he can work.
2. Results for wrong sharing the network folder. The network folder must be released with full access. If this is not the case, there are the following reactions:
runtime error ‘3050‘ File could not be locked
3. Countermeasures if the .chm help files are not displayed, but only a message 'Navigation to the webpage was canceled'. For such cases a registry change helps:
HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/HTMLHELP/1.x/
create a key (right mouse button on 1.x)
key: ItssRestrictions
create a DWORT under this key (with right mouse button in the right pane): MaxAllowedZone
enter value 3
4. What happens when multiple users with write access to fotos.mdb want to change the same record?
After changing and moving to a different record, the user sees again the old content in the record he believes to have changed. It is possible that the user is not not paying attention and does not notice this condition. Therefore there is in the filename list the 'refresh button'  to work in multi user environments. Each user should click the 'refresh button'  immediately before the proposed change to a specific record. So changes become visible, which were made by other users and the user can be sure that his own change is updated.
 

15.What can be done, when runtime errors occur?

1. Download the latest Download file.
2. If runtime errors happen during standard functions like display of the found fotos/videos or when you create new data base records you then can assume that something is fault on your PC because it works at thousands of other PC. Try to install the software on another PC. Read also under News
 

16.I suspect that the data base unnecessarily increases itself, can I do something against this?

It is a known behaviour of a Microsoft Access data base that it blows up after some time. If you suspect this, start 'Fotos.exe' and end the program immediately by clicking the close cross. You get some reference values for a better assessment here. A data base with 10.000 records is about 2,5 MB large, a data base with 50.000 entries is about 12,0 MB large.


17.How can I create a link for fotos.exe by myself?

Sometimes it happens, that you can not find the program group 'GERBING Fotoalbum' or it was deleted or what else so ever. Now you stand before the problem to create the link 'Fotos ' by yourself. Here you get a description how to create this link in XP. In later operating systems it is similar:
1.Use the Windows Explorer and open the folder where you want to create the link, for example C:\Documents and Settings\all users\Desktop
2.Click in the menu bar on File -> New -> Link. Then the window 'Create link' opens.
3.Click now on Search... and select the folder where 'fotos.exe' has been installed, this is by default C:\Program Files\GERBING Fotoalbum. After having selected fotos.exe it will be entered left from Search...
4.Enter a name for the link, for example 'Fotos' and click on 'Finish'


18.Can I relocate my fotoalbum to another hard drive or to another computer?

19.1.Tip for the relocation of a fotoalbum from one location to another on the same computer:  Another location can be a different hard drive, an external hard drive, an USB stick, a drive on the network. You must observe the rules of the trinity than you can move or copy the fotoalbum by the windows explorer to the new location. That is all you have to do. If you run 'fotos.exe' from the new location, it just has to work as at the old location.
19.2.Tip for the relocation of a fotoalbum from one computer to another:  This is basically the same as the relocation of a fotoalbum from one location to another on the same computer. If on the other computer is not yet installed 'GERBING Fotoalbum', you must install the program, i.e. you must run the installation file 'GERBING Fotoalbum.msi'. Select at any case a destination folder other than the location of the relocated fotoalbum.

.

19.I am using other software for archiving my fotos but I want to change to a database software and want to use GERBING Fotoalbum. I have about 20,000 fotos  scattered on the computer

The most important step is that you combine all foto/video files below one folder (fotoalbum folder). Under the fotoalbum folder you should create year folders (four-digit years) under the year folders you can but do not need to create other folders. In the fotoalbum folder must run GERBING Fotoalbum or must be installed there. You then create the database quite easily, if your fotos contain IPTC fields. If this is not the case, you should create the database step by step by the function Check3 of the tool Fotosmdb. Step by step take a group of fotos that can be described with the same keywords. You do this until the function Check3 does not report errors. If you then want to attach individual key words to your fotos, you have to either scroll through the fotoalbum or search at first for known keywords.

 


20.I have many photos with geotags (GPS positions). Can I search for them with GERBING Fotoalbum?
Yes, under the following conditions:
1.You need the professional version to search for user defined database fields.
2.You must create the following user defined database fields: GPSLatitude and GPSLongitude. In the access version it must be data type Double and in the sql server version the data type float. For this you contact the Access administrator or SQL Server administrator.
3.1 When you add new geo-tagged fotos into the database you need to define from which EXIF field the fields GPSLatitude or GPSLongitude should be filled, eg EXIF-​​GPSLatitude and EXIF-GPSLongitude.
3.2 You can also subsequently let fill the fields GPSLatitude and GPS Longitude, see Filename list -> select and execute an action... -> field update by repeated import
4.When searching, you have to search for the user defined database fields GPSLatitude and GPSLongitude. This is done via the button 'user defined fields ...' -> search fotos with GEO position -> then draw a rectangle with the mouse on a Map Neck you selected. The fotos then found are from this area.


21.How can I open various Fotoalbums from the desktop?

There are two variants:
1.You click on the desktop icon 'GERBING Fotoalbum' while holding down the Shift key. Then a window opens where you must select the fotos.mdb.
2.You create yourself a shortcut for each fotos.exe you want  to open from the desktop. This is done using the right mouse button.