User:Nichalp/Upload script/csv fields

From Wikimedia Commons, the free media repository
Jump to: navigation, search
Nichalp's upload script
Nichalp upload script icon.svg
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.

  1. Current name
  2. Description
  3. Permission
  4. 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[edit]

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

New name[edit]

  • 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[edit]

  • Optional Defaults to "en" if left blank

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

Description[edit]

  • 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[edit]

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[edit]

  • 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[edit]

  • Compulsory

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

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[edit]

  • Compulsory

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

  • Nuvola apps important yellow.svg Caution: Make sure that the category exists else before uploading.

Category 2[edit]

  • Optional

Appends an optional category. Leave blank otherwise.

Category 3[edit]

  • Optional

Appends an optional category. Leave blank otherwise.

Category 4[edit]

  • Optional

Appends an optional category. Leave blank otherwise.

Category 5[edit]

  • Optional

Appends an optional category. Leave blank otherwise.

Xform[edit]

  • 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.

  • Nuvola apps kate.png Note: All rotation values are expressed as clockwise rotations.
  • Nuvola apps kate.png 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[edit]

  • 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[edit]

  • 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.
  • Nuvola apps important yellow.svg 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[edit]

  • Optional

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

Lat sec[edit]

  • 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[edit]

  • Required if longitude value is entered

Valid parameters: N and S

Long deg[edit]

  • 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.
  • Nuvola apps important yellow.svg 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[edit]

  • Optional

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

Lat sec[edit]

  • 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[edit]

  • Required if latitude value is entered

Valid parameters: E and W

Type[edit]

  • 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

See also:

Scale[edit]

  • 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.

See also:

Region[edit]

  • 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[edit]

  • 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)"


See also: http://en.wikipedia.org/wiki/Wikipedia:WikiProject_Geographical_coordinates#Parameters

Heading[edit]

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.

See also: http://en.wikipedia.org/wiki/Wikipedia:WikiProject_Geographical_coordinates#Parameters

Altitude[edit]

  • 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[edit]

  • 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[edit]

  • Optional

Same as the previous field.

Description lang 2[edit]

  • Optional

Adds an optional description language code. See #Description lang

Description 2[edit]

  • Optional

Add an optional language description. See #Description

Description lang 3[edit]

  • Optional

Same as the above parameter.

Description 3[edit]

  • Optional

Same as the above parameter.

Embed exif?[edit]

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[edit]

  • Optional

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

Country[edit]

  • Optional

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

State[edit]

  • Optional

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

Place[edit]

  • Optional

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

Website[edit]

  • Optional

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

Keywords[edit]

  • Optional

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

Camera info?[edit]

  • 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[edit]

  • Optional

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

See Template:Photo Information

Aperture[edit]

  • Optional

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

See Template:Photo Information

Shutter[edit]

  • Optional

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

  • Nuvola apps kate.png 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[edit]

  • Optional

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

See Template:Photo Information

ISO[edit]

  • Optional

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

See Template:Photo Information

Lens[edit]

  • 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?[edit]

  • 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[edit]

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

URL of the photograph on Flickr

Flickr image title[edit]

  • Optional

The title of the same image on Flickr.

Flickr photographer URL[edit]

  • Optional

Your Flickr user account URL. Optional parameter

Flickr photographer location[edit]

  • Optional

The location where you are based.

Other information[edit]

  • Optional

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