User:Nichalp/Upload script/csv fields

	Nichalp's upload script
Script information
Author	Nichalp
Talk	Talk
Main page	Upload script
Language	Perl
Version	1.0 + 1.3.1
Description	Automates mass uploading of images with metadata
Licence	GPLv3
Formats supported	JPG/JPEG
Scripts
Scripts	csv creator.pl; upload.pl
Help files
Running the script	Main page
Installation	Installation
Spreadsheet information	csv fields explained
CSV example	upload.csv
Spreadsheet tips	Spreadsheet tips

The following are the fields for the CSV (comma separated values) file for the Upload Script. The headings in red are compulsory.

Current name
Description
Permission
Category 1

You may also want to see upload.csv for a completed example and also some Spreadsheet tips to speed up work.

Current name

This is the file name that exists in the current directory. Do not delete or modify in the spreadsheet.

New name

Optional

If you would like to rename the file, enter the new file name. Remember to add the extension *.jpg to the name.

Description lang

Optional Defaults to "en" if left blank

Two letter ISO 639-1 language code for the description (eg. en, hi, fr).

More information: http://en.wikipedia.org/wiki/List_of_ISO_639-1_codes

Description

Compulsory

Enter a succinct description on what the subject is about. Make sure the description matches the language code specified above. (If you want to add additional languages, we'll come to that later)

Date

Date of the photograph in the ISO 8601 format. The date is generated from the Exif information from the CVS_creator.plx file. Leave as is to avoid unforseen issues. More information: http://en.wikipedia.org/wiki/ISO_8601

Author name

Optional
Your real name if you wish to use it. It will be used to embed your name in the image Exif data, as well as on the image page.

Permissions

Compulsory

Enter the numeric equivalent of the licence (0-7) See below for the options:

More information: http://commons.wikimedia.org/wiki/Commons:Licensing

Number	Licence template	Description
0	User defined.	You will be asked to type in the licence at each step.
1	{{Cc-by-sa-3.0,2.5,2.0,1.0}} + {{GFDL}}	Dual licence under GFDL and Creative Commons share-alike versions 3.0, 2.5, 2.0, and 1.0. A user is free to use any of the five offered licences.
2	{{Cc-by-sa-3.0}}	Licence under the Creative Commons version 3.0
3	{{Cc-by-sa-3.0,2.5,2.0,1.0}}	Licence under the Creative Commons share-alike versions 3.0, 2.5, 2.0, and 1.0. A user is free to use any of the four offered licences.
4	{{Cc-by-sa-3.0}} + {{GFDL}}	Dual licence under the Creative Commons Share Alike version 3.0 and GFDL
5	{{PD-self}}	Release the work into Public Domain. You thereby release all claims to the work.
6	{{Cc-pd}}	Released explicitly into the public domain by its author, using the Creative Commons Public Domain Dedication
7	{{Cc-by-3.0}}	Creative Commons Attribution Licence v3.0

Category 1

Compulsory

Adds a descriptive category. You must enter a category before uploading an image. Do not add the "[[category:" prefix and wikilink.

Caution: Make sure that the category exists else before uploading.

Category 2

Optional

Appends an optional category. Leave blank otherwise.

Category 3

Optional

Appends an optional category. Leave blank otherwise.

Category 4

Optional

Appends an optional category. Leave blank otherwise.

Category 5

Optional

Appends an optional category. Leave blank otherwise.

Xform

Optional

The Transform field. Set a value in this field to perform image transformations such as lossless rotation, greyscale conversion, and flipping.

You can use jpegtran to perform the manipulations before uploading OR add a template for RotateBot to rotate images after uploading. If you use the rotatebot parameters, {{Rotate}} is added to the page with the necessary rotation values. At 18:00 UTC, Rotatebot will rotate the image to the correct orientation. If you do not have jpegtran installed, use the equivalent rotatebot values.

Note: All rotation values are expressed as clockwise rotations.

Note:- You can add only one of the following values to the Xform field.

Transformation values, select one option
Value	Description
1 or blank	No transformation
Values for jpegtran transformations
2	Flipped horizontal
3	Rotate 180°
4	Flipped vertically
5	Transposed
6	Rotate 90° CW (clockwise)
7	Transverse
8	Rotate 270° CW (clockwise)
9	Convert to Greyscale - Removes all colour information
Rotatebot parameters
90	Rotate 90° CW (clockwise)
180	Rotate 180°
270	Rotate 270° CW (clockwise)

Coordinate type

Optional

This parameter is used for the geo-location templates. There are two format options: the decimal notation and degree-minute-second.

Values	Description
blank	Defaults to the decimal degree notation
d	Decimal degree notation
dms	Switches to the degree-minute-second notation

Lat deg

Optional -> Required if longitude value is entered
Enter the latitude value of the camera position not the subject. Do not add N or S.
You can use google earth or google maps to determine the coordinates. In case of google maps, click the Link button to get the coordinate information.
To convert between the DMS and Dec try this.

Decimal notation

For decimal notation, add the full latitude value here.
A precision of four decimal places is sufficient to achieve a 7 m resolution accuracy.
Caution: Your spreadsheet software might truncate the decimal places to two places. Make sure you change the autoformatting settings to allow more than two decimal place, and then change the formatting type to "text". When saving the file, check the formatting.

DMS

For DMS (degree-minute-second) notation, enter only the degree value here.

Lat min

Optional

The minutes for the latitude in DMS format. The decimal notation ignores this field.

Lat sec

Optional

The seconds for the latitude in DMS format. Seconds can have a decimal component. (eg 34.23") The decimal notation ignores this field.

Lat ref

Required if longitude value is entered

Valid parameters: N and S

Long deg

Optional -> Required if latitude value is entered
Enter the latitude value of the camera position not the subject. Do not add E or W.
You can use google earth or google maps to determine the coordinates. In case of google maps, click the Link button to get the coordinate information.
To convert between the DMS and Dec try this.

Decimal notation

For decimal notation, add the full latitude value here.
A precision of four decimal places is sufficient to achieve a 7 m resolution accuracy.
Caution: Your spreadsheet software might truncate the decimal places to two places. Make sure you change the autoformatting settings to allow more than two decimal place, and then change the formatting type to "text". When saving the file, check the formatting.

DMS

For DMS (degree-minute-second) notation, enter only the degree value here.

Long min

Optional

The minutes for the longitude in DMS format. The decimal notation ignores this field.

Lat sec

Optional

The seconds for the longitude in DMS format. Seconds can have a decimal component. (eg 34.23") The decimal notation ignores this field.

Long ref

Required if latitude value is entered

Valid parameters: E and W

Type

Optional

Redundant on Commons, as most images are at lowest scale. The defaults are type:landmark. These parameters should be given only if values different from the defaults are desired.

Type of geo coordinate. These parameters should be given only if values different from the default scale is desired. Valid parameters:

Type	Description	Scale
country	Country/Region	1:10,000,000
state	Where applicable (for states, provinces and other first-level country subdivisions)	1:3,000,000
adm1st	Administrative unit of country, 1st level (district, province, county)	1:1,000,000
adm2nd	Administrative unit of country, 2nd level	1:300,000
city	City, town or village, unspecified population. Will be treated as a minor city.	1:100,000
airport		1:30,000
mountain	peaks, mountain ranges	1:100,000
isle	Isles, islands	1:100,000
waterbody	Bays, fjords, lakes, reservoirs, ponds, lochs, loughs, meres, lagoons, estuaries, inland seas...	1:100,000
forest	Forests and woodlands	1:50,000
river	Rivers and canals	1:100,000
glacier	Glaciers, ice caps	1:50,000
edu	Schools, colleges, universities	1:10,000
pass	mountain passes	1:10,000
railwaystation	stations and stops of railway, train, railroad, metro, rapid transit, underground, subway, elevated railway, etc.	1:10,000
landmark	Cultural landmark, building of special interest, tourist attraction and other points of interest.	1:10,000

Scale

Optional

Map scale 1:N. Resets the scale. These parameters should be given only if values different from the defaults are desired. Make sure only a numeric value is given. (eg 100000)

Redundant on Commons, as most images are at lowest scale. The defaults are scale:5000. These parameters should be given only if values different from the defaults are desired.

Region

Optional

Region of coverage specified as an ISO 3166-1 alpha-2 country code, or an ISO 3166-2 region code. (eg IN-MH – for Maharashtra, India) See also:

Source

Optional

Specifies, where present, the data source and data source format/datum, and optionally the original data, presented in parentheses. This is initially primarily intended for use by geotagging robots, so that data is not blindly repeatedly copied from format to format and Wikipedia to Wikipedia, with progressive loss of precision and attribution.

All coordinates should be referenced to the en:WGS84 datum, the one supported by GPS systems and Google Maps. References taken from printed maps are unlikely to use this datum, and lead to inaccuracies in the order of hundreds of metres. National Grid reference systems use a local datum so will provide the wrong result.

Examples

A location sourced from the public domain GeoNet Names Server database would be tagged as "source:GNS". No datum or format information is needed, since by default all Wikipedia coordinates are in latitude/longitude format based on the WGS84 datum. Similarly, U.S. locations sourced from the similar public domain GNIS database would be tagged as "source:GNIS".
A lat/long geotag derived from a Ordnance Survey National Grid Reference NM 435 355 found in the English-language Wikipedia would be tagged as "source:enwiki-osgb36(NM435355)"

Heading

Compass point

Optional

Used to indicate the direction the camera was pointing at. It is given as degree values 0-360 (clockwise with north as 0) or a compass point abbreviation as defined in w:Boxing the compass. (Example: heading:NW)

You can use either a compass point abbreviate defined below, OR a valid degree value (0 to 360 [both inclusive]). Omit the ° degree sign.

Valid abbreviations
Abbr	Compass point	True heading
N	North	0.00°
NbE	North by east	11.25°
NNE	North-northeast	22.50°
NEb	Northeast by north	33.75°
NE	Northeast	45.00°
NEbE	Northeast by east	56.25°
ENE	East-northeast	67.50°
EbN	East by north	78.75°
E	East	90.00°
EbS	East by south	101.25°
ESE	East-southeast	112.50°
SEbE	Southeast by east	123.75°
SE	Southeast	135.00°
SEbS	Southeast by south	146.25°
SSE	South-southeast	157.50°
SbE	South by east	168.75°
S	South	180.00°
SbW	South by west	191.25°
SSW	South-southwest	202.50°
SWbS	Southwest by south	213.75°
SW	Southwest	225.00°
SWbW	Southwest by west	236.25°
WSW	West-southwest	247.50°
WbS	West by south	258.75°
W	West	270.00°
WbN	West by north	281.25°
WNW	West-northwest	292.50°
NWbW	Northwest by west	303.75°
NW	Northwest	315.00°
NWbN	Northwest by north	326.25°
NNW	North-northwest	337.50°
NbW	North by west	348.75°

With Google Earth it's possible to have a full screen size compass overlay to help find the correct heading. Compass_overlay.kml can be added to "My Places" and displayed when necessary.

Altitude

Optional

Altitude value in metres only. The value can be positive or negative. This value will be embedded in the Exif data. Do not add any units such as m or metres.

To ascertain the altitude from the latitude and longitude, you can use google earth, or Topocoding.

Other versions 1

Optional

Use this field if there are any related image files such as a monochrome version. Add just the file name without the "[[Image:" prefix and wikilink.

Other versions 2

Optional

Same as the previous field.

Description lang 2

Optional

Adds an optional description language code. See #Description lang

Description 2

Optional

Add an optional language description. See #Description

Description lang 3

Optional

Same as the above parameter.

Description 3

Optional

Same as the above parameter.

Embed exif?

If left blank, the script will automatically embed Exif data. Enter N to prevent Exif values from being written. If you have not installed the ExifTool library, set this to N to avoid unforeseen errors.

Caption

Optional

A caption to the image. A caption should be smaller than the description. This value will be embedded in the Exif data.

Country

Optional

Country/Region where the photograph was taken. This value will be embedded in the Exif data.

State

Optional

State/province where the photograph was taken. This value will be embedded in the Exif data.

Place

Optional

Place where the photograph was taken. This value will be embedded in the Exif data.

Website

Optional

Website of the photographer. This value will be embedded in the Exif data.

Keywords

Optional

Keywords relating to the image. This value will be embedded in the Exif data.

Camera info?

Optional

This field is used to add camera information to the image. If left blank, the script will automatically skip the addition of camera information template. Enter Y to load the template with the image.

See Template:Photo Information

Camera Model

Optional

Camera information. This field is generated from the Exif information from the CVS_creator.plx file.

See Template:Photo Information

Aperture

Optional

Photograph aperture details. This field is generated from the Exif information from the CVS_creator.plx file.

See Template:Photo Information

Shutter

Optional

Camera shutter details. This field is generated from the Exif information from the CVS_creator.plx file.

Note: By default the ' (single quote) character is added before the shutter field to prevent spreadsheets from autoformatting the value as a date.

See Template:Photo Information

Film

Optional

By default, the text is entered is "Digital". If optical image, then change to mention the film used.

See Template:Photo Information

ISO

Optional

Photograph ISO details. This field is generated from the Exif information from the CVS_creator.plx file.

See Template:Photo Information

Lens

Optional

Camera lens information. This field is generated from the Exif information from the CVS_creator.plx file. Edit this to include the type of lens used.

See Template:Photo Information

Flickr?

Optional

This field is used to add Flickr information to the page. If you have uploded the same image on [www.flickr.com Flickr], you can activate the template by entering Y

See Template:Flickr-self

Flickr URL

Optional Required if the "Flickr ?" parameter above is set to "Y"

URL of the photograph on Flickr

Flickr image title

Optional

The title of the same image on Flickr.

Flickr photographer URL

Optional

Your Flickr user account URL. Optional parameter

Flickr photographer location

Optional

The location where you are based.

Other information

Optional

Any other information that you wish to add to the image page.