Database definition
Top  Previous  Next


The following list describes the database fields available as of version 2.7 of CodedColor. The list is subject to change in later versions. Some fields like "UserData" are currently not used and reserved for later versions. The database can be exported into XML, so the data can be viewed in the Microsoft Internet Explorer.

Extract of the field definition file
Workdirectory\Data\Files.tdf


[FID]  
DataType=ftAutoInc  
Description_EN=Unique record identifier  
Description_DE=Primärschlüssel   
 
[Checked]  
DataType=ftBoolean  
Description_EN=Include in albums and printing  
Description_DE=Bilder ausgewählt (z.B. für Alben, Export, Druck)  
 
[Volume]  
DataType=ftString  
Description_EN=Volume or CD label  
Description_DE=Datenträger Bezeichung  
 
[VolumeID]  
DataType=ftInteger  
Description_EN=Volume or CD serial number  
Description_DE=Datenträger Seriennummer  
 
[DrvType]  
DataType=ftInteger  
Description_EN=Removable: 2; fixed: 3; remote: 4; CD drive: 5  
Description_DE=Wechselspeicher: 2; Festplatte: 3; Netz: 4; CD: 5  
 
[FilePath]  
DataType=ftString  
Description_EN=Path and name of local file  
Description_DE=Dateiname inkl. Pfadangabe  
 
[FileSize]  
DataType=ftFloat  
Description_EN=Filesize in bytes  
Description_DE=Größe der Datei in Byte  
 
[FileDate]  
DataType=ftDateTime  
Description_EN=date when file was last modified  
Description_DE=Letzte Änderungsdatum der Datei  
 
[FileAttr]  
DataType=ftInteger  
Description_EN=File attributes  
Description_DE=Attribute der Datei  
 
[Created]  
DataType=ftDateTime  
Description_EN=Creation time of filesystem  
Description_DE=Erstelldatum der Datei  
 
[FileUrl]  
DataType=ftString  
Description_EN=Adress of remote file  
Description_DE=Verknüpfungsziel der Datei oder Internetadresse  
 
[OrgDate]  
DataType=ftDateTime  
Description_EN=Time of photo or file creation stamp  
Description_DE=Aufnahmedatum des Fotos oder Erstelldatum der Datei  
 
[Title]  
DataType=ftDropdown  
Description_EN=Titel  
Description_DE=Titel des Fotos bzw. der Datei  
 
[Description]  
DataType=ftMemo  
Description_EN=File annotation  
Description_DE=Beschreibung des Fotos bzw. der Datei   
 
[Keywords]  
DataType=ftCheckList  
Description_EN=List of words for searching  
Description_DE=Liste von Schlagwörtern zum katalogisieren des Fotos bzw. der Datei   
 
[UserData]  
DataType=ftMemo  
Description_EN=Additional user fields (IPTC)  
Description_DE=Weitere Felder (IPTC)  
 
[ImageData]  
DataType=ftMemo  
Description_EN=EXIF image information  
Description_DE=EXIF Informationen (z.B. von der Kamera)  



2010 © 1STEIN GmbH - CodedColor

CodedColor PhotoStudio by 1STEIN is a Windows photo viewer and editor to organize, edit, resize, reformat, correct, compare, sort, watermark, annotate and print digital images, and to edit EXIF and IPTC data in digital photos. You can rename multiple images, remove scratches, create panorama pictures (stitch), convert RAW photos (from Canon, Nikon, Olympus, etc. cameras), send images via Skype, send photo SMS, burn digital watermarks, correct colors, run a screenshow, convert and correct JPEG images in a batch process, rename fields, open pictures and image folders from the Explorer, generate a webalbum in HTML and compress JPG images. The CodedColor full version is not free, but during registration you can choose the Freeware edition, in which some functions are deactivated. After the download you can try the PhotoStudio shareware for 30 days without any restrictions. The CodedColor software interface looks very similar to ACDSee, is easier to use than Photoshop and more versatile than Picasa and Irfanview, but still contains editing and correction features as effective as Paintshop. Have a look at our Before / After tutorials, in order to get an idea of the powerful editor capabilities. The software comes with a detailed handbook and a fast database to store EXIF / IPTC data and color informationen. CodedColor PhotoStudio is a powerful and versatile photo organizer and image editing software for digital camera users. The user friendly interface includes features like photo editing & printing, web & flash album galleries, slide shows, photo management & cataloging, custom sorting, IPTC & EXIF editor and display, GPS tagging, perspective correction, barrel distortion, effects, thumbnail generation, resize & resample images, jp2000, batch conversion, database keyword searching, red eye removal, color / sharpness / brightness & contrast correction, artefacts removal, clone brush, scanner & TWAIN import, screen capture, lossless JPEG rotation, transparency (alpha channel), gamma correction, print ordering and screenshows with many transition effects, watermark text, image annotations, panorama stitch & animation, video capture, PDF album export, photo layouts, collages, frames, shadows, histograms, automatic white balance, skype photo sharing, etc. Opens and converts all common image formats: BMP, WMF, GIF, JPEG, JPEG2000, TIFF, PCX, PNG, PSP, PSD, PCD, and all current RAW formats. Visit the CodedColor FotoStudio homepage to learn more and download a free copy! Includes BYNGO MMS messenger and CodedColor Publisher, a versatile photo layout and DTP tool, from which you can order individual photobooks through KODAK.