Strict Standards: Declaration of action_plugin_captcha::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /home/shared/community.kohovolit.eu/www/lib/plugins/captcha/action.php on line 15

Warning: Cannot modify header information - headers already sent by (output started at /home/shared/community.kohovolit.eu/www/lib/plugins/captcha/action.php:15) in /home/shared/community.kohovolit.eu/www/inc/auth.php on line 339

Warning: Cannot modify header information - headers already sent by (output started at /home/shared/community.kohovolit.eu/www/lib/plugins/captcha/action.php:15) in /home/shared/community.kohovolit.eu/www/inc/actions.php on line 162
napistejim:external_datasets [External datasets]
 

External datasets

There is a possibility to add external datasets containing email addresses into “Write to Them” application. It is useful, for example, when there are no official source pages to scrape containing the email addresses. E.g., the addresses can be collected “by hand”.

Generally, if you want to add an external dataset, you become the administrator of the dataset, who is responsible for the data accuracy in it. This is usually not a big task as the representatives do not change very often.

File description

The representatives' email addresses (and other information as names) should be collected into a Google spreadsheet. You need a Google account to do it.

First line of the file provides the description of columns. Some columns are required (and have reserved names), these are:

  1. email - email address
  2. first name - first name of the representative
  3. last name - last name of the representative
  4. political group:full name - political group's (e.g., political party) full name
  5. political group:short name - political group's (e.g., political party) short name (abbreviation)
  6. since - the date until the row is valid. Fill only if it's different from the date of previous elections. It must be in ISO format yyyy-mm-dd (if having problems entering it, try menu Format → Number → Plain text).
  7. until - the date until the row is valid. Fill only if it's different from the date of next elections. It must be in ISO format yyyy-mm-dd (if having problems entering it, try menu Format → Number → Plain text).

Other columns may be added and have standard names, these are

  • pre title
  • post title
  • middle names
  • disambiguation (it must be present in case more representatives have the same name)
  • sex - either m or f (stands for male or female)
  • born on
  • died on
  • political group:short name political group's (e.g., political party) name abbreviation
  • image url URL of a file with image of the representative

There may be added other non-standard columns with any name except the ones above.

Example

We want to add the representatives of the town council of Náchod.

  1. We collect the email addresses + additional info into a Google spreadsheet
  2. We publish the spreadsheet as a html file. Click menu item File → Publish to the Web…. Click Start Publishing and Ok. In the lower part Get a link to the published data, copy the link.
  3. Send the link to the administrator of the right application (e.g., it is for the Czech Republic and Slovakia).

Changes of representatives

If there is a change of representatives (one leaves, another comes): - Change the date in column until for the leaving representative. Do not delete the row! - Add a row for the new representative and change the date in column since.

Other changes mark directly by changing the value.

Example: Representative Adam left on 21st of December 2012 and representative Betty replaced him. We change the column until in Adam's row to 2012-12-21. We add a new row for Betty, having 2012-12-21 in since column.

 
napistejim/external_datasets.txt · Last modified: 29.01.2012 21:54 by 85.160.118.214
 
Except where otherwise noted, content on this wiki is licensed under the following license:CC Attribution 3.0 Unported
Recent changes RSS feed