Rev Author Line No. Line
228 kaklik 1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
2 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3  
4 <html xmlns="http://www.w3.org/1999/xhtml">
5 <head>
6 <title>singapore - Development</title>
7 <link rel="stylesheet" type="text/css" href="docstyle.css" />
8 </head>
9  
10 <body>
11  
12 <h1>singapore - Development</h1>
13  
14 <p>The information in this file is for people who wish to contribute to
15 singapore, modify it or understand how it works.</p>
16  
17 <ul>
18 <li><a href="#csvformat">CSV database format</a></li>
19 <li><a href="Readme.html">General readme</a></li>
20 <li><a href="Advanced.html">Advanced features</a></li>
21 <li><a href="Translation.html">Translating singapore</a></li>
22 </ul>
23  
24  
25 <h2><a name="csvformat">CSV database format</a></h2>
26  
27 <p>If you choose to use metadata files then each gallery must
28 contain a CSV (comma separated values) file called metadata.csv
29 containing the information about images in the gallery and the gallery itself.
30 CSV files can be edited manually (in a text editor such as Notepad)
31 or using a spreadsheet application (such as MS Excel). Care must be taken when using
32 Excel to save using commas as the separator character and not tabs or semi-colons.</p>
33  
34 <p>The first line of each file stores human-readable descriptions of the fields
35 and is ignored by singapore. The second line stores information about this
36 gallery:</p>
37  
38 <pre>
39 field 0
40 the filename of the image used to represent the gallery in the gallery list
41 field 1
42 (not used)
43 field 2
44 the owner of the gallery
45 field 3
46 space-separated list of usergroups
47 field 4
48 gallery permission flags
49 field 5
50 space-separated list of categories the gallery belongs in (not used)
51 field 6
52 gallery name/title
53 field 7
54 artist name (optional)
55 field 8
56 artist email (optional)
57 field 9
58 copyright holder (optional)
59 field 10
60 description of the gallery (optional)
61 field 11
62 short summary of the gallery (optional)
63 field 12
64 human-readable date (optional)
65 field 13 onwards
66 (not used)
67 </pre>
68  
69 <p>Each of the following lines (3 - ...) represents an image in the gallery.
70 The format is as follows:</p>
71  
72 <pre>
73 field 0
74 the filename of the image
75 field 1
76 the filename of the thumbnail image
77 field 2
78 the owner of the image
79 field 3
80 space-separated list of usergroups
81 field 4
82 image permission flags
83 field 5
84 space-separated list of categories the image belongs in (not used)
85 field 6
86 image name/title
87 field 7
88 artist name (optional)
89 field 8
90 artist email (optional)
91 field 9
92 copyright holder (optional)
93 field 10
94 description of the image (optional)
95 field 11
96 location that the image was taken/made/represents (optional)
97 field 12
98 date taken/made (optional)
99 field 13
100 make and model of camera used (optional)
101 field 14
102 make and model of lens used (optional)
103 field 15
104 make and type of film used (optional)
105 field 16
106 darkroom manipulation (optional)
107 field 17
108 digital manipulation (optional)
109 </pre>
110  
111 <p><em>$Date: 2004/10/15 18:53:36 $</em></p>
112  
113 </body>
114 </html>