Citation lists

From refbase


How to use 'in-text-citation'?

The main idea behind the in-text-citation-feature of refbase is to include reference-marks (cite-keys) within the text. Later, you have to copy the complete text into the refbase-form. Refbase will extract these cite-keys and find the related references in the database. With this list of references, refbase can create the desired citation-list.

As cite-keys you can use the serial number of the reference or a self-defined cite-key.

OK, how to do:

  • write your text, including citations
  • include the corresponding cite-key after your citation. You have to embed the cite-key within special characters (start- and end-delimiter), whereby the default characters are curly braces ('{cite-key}')

example: citation the references with serial numbers 1, 3 and 4 of the initial refbase installation

The ecology of polar seas was described before (Hobson et al. 1995{3};
Chapelle and Peck 1999{1}; Aberle and Witte 2004{4}). Nevertheless, you 
should keep in mind, that there are other interesting fields in marine research ;-)
  • when you've finished your text, create your citation list
  • log in at your refbase installation
  • follow the link 'extract citation' in the footer of the refbase-page
link to the 'export-citation'-page'
link to the 'export-citation'-page'
  • copy the complete text (including all figures and other embedded objects) into the form at this page
  • you have to specify your delimiters (if you use your own characters)
  • you can define the display style (Web or Print)
  • when using refbase-0.9.0 or greater, you can choose the output format (html, rtf, pdf, LaTeX, Markdown, ASCII)
  • after a click on the Cite-button, you should get your citation list (see picture)

Note: With this method, it is possible to create citation lists for large documents, too. We have tested documents with hundreds of pages and hundreds of citations.

Is 'in-text-citation'-available as plugin for MS Word or OpenOffice?

Since refbase is a platform independent reference managing package and is intended for use with a broad variety of software packages (from simple text editors to all the office packages), we didnt had the time to develop specialized Add-Inn to integrate the refbase functionality into programs like MS Word or OpenOffice Writer.

Nevertheless, it is possible to use refbase in these programs as a very powerfull tool to manage your references and to create very fast your citation list. Additionally, the functionality of these programs can be used to enhance the work with your references. You will find more information in this wiki about the usage of refbase within MS Word and OpenOffice.

Sort order

Two different things can influence the sorting of your results:

  • When refbase creates a citation list (list of references), then the sort order is controlled by MySQL. There are sort order definitions for several languages available in MySQL. The default definition is a sort order commenly used in Sweden (MySQL is swedish), which (of course) consider swedish special characters.

Example: When you have (e.g.) author-names with special characters (like German 'ö') and you like to sort it after German collation rule ('ö' similar to 'oe' and therefore after 'o'), you probably have to check and to change your MySQL-settings

  • If the forenames of authors are sometimes abbreviated and sometimes not, this can cause problems

MySQL sort order style (collation rule)

The MySQL-collation rule is controlled by the database-/table-/field- 'Collations' (see the MySQL-Website for more Infos)

To find out, which collation rule is used in your MySQL-installation, please execute the following commands at your MySQL-Server:

SHOW VARIABLES LIKE '%character%';
SHOW VARIABLES LIKE '%collation%';

The standard-'Collation' is 'latin1_swedish_ci' and should be OK for most needs.

  • First example: German

As example, we like to explain the German sorting style: To insert 'Ö' at 'O' or at 'OE', the collation rules 'latin1_german1_ci' or 'latin1_german2_ci'have to be used. At the MySQL-website you get this information:

The latin1_german1_ci and latin1_german2_ci collations are based on
the DIN-1 and DIN-2 standards, where DIN stands for Deutsches Institut
für Normung (the German equivalent of ANSI). DIN-1 is called the
'dictionary collation' and DIN-2 is called the 'phone book collation'.
- latin1_german1_ci (dictionary) rules:
- Ä = A
- Ö = O
- Ü = U
- ß = s
- latin1_german2_ci (phone-book) rules:
- Ä = AE
- Ö = OE
- Ü = UE
- ß = ss
  • Second example: Spanish

In the 'latin1_spanish_ci collation', 'ñ' (n-tilde) is a separate letter between 'n' and 'o'.

You will find more information at the MySQL-website.

But keep in mind, that the sort order for an english journal is probably different to German collation rules ;-)

Fornames and sort order

The sort order is a bit incorrect, when you use abbreviated and fully written forenames in your databse. That means, you should use everytime (e.g.) 'Steffens, M' OR everytime 'Steffens, Matthias' to avoid problems.

Known problems and their solution

  • copying the reference list into office-programs

We cannot control what is coppied into the clipboard by the browser. Therefore in some cases, errors occur while copying the reference list into an office program. E.g. if you are using firefox and WinWord or Openoffice, all formattings are lost. Until we have a better solution, we offer a workaround: Create your reference-list within MS Internet Explorer. This browser will copy the text into the clipboard as table. This table can be copied into your office-program (MS WinWord or OpenOffice). Please select the table and go to the menu 'table' (in both office packages). There you should find a field 'convert' (something like this...). In this menu-point please click on 'table to text'. Now you should have a right formatted text.