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