{database} is a structured collection of data.

learn more… | top users | synonyms

34
votes
7answers
6k views

Is it possible to connect a database to LaTeX to produce data-driven documents?

I'm starting to write a LaTeX-based reference manual, and have realised that a lot of my needs could be solved by writing a database and then producing the reference manual from that. Lots of my pages ...
21
votes
4answers
4k views

Symbols for Outer Joins

I'm looking for a way to typeset the symbols for outer joins, that is ⟕ U+27D5 onward. There seems to be nothing in symbols-a4. Note that I'm not looking for ⋊ U+22C9 as this represents a semijoin. ...
20
votes
1answer
254 views

Using \fontdimen as an array to store data

Reading through pi.tex, I discovered the trick of using \fontdimen as an array of dimensions (which is equivalent to storing integers between ±(2^31-1)sp). Namely, \font\x=cmr10 at 1sp % or whatever ...
18
votes
2answers
1k views

draw colored world/US map in LaTeX

I'm trying to draw maps similar to these in a LaTeX pdf document: I want to auto-generate them from a list of pairs (country,color) to determine the colors. I have found the package pst-map2dII ...
18
votes
1answer
792 views

Is there any package for LaTeX dealing with a database?

Is there any package for LaTeX dealing with a database (with some of the fields being LaTeX code). For example, given a collection of problems with fields {id, name, author, refs, statement, ...
16
votes
3answers
532 views

List of People analog to Bibliography

In my document I emphasize names that are mentioned and now I want to provide some additional information about them in an appendix. Currently I do something like: \documentclass{scrartcl} ...
14
votes
2answers
203 views

Use TeX macros to store multiple data

I'm trying to use TeX macros to store multiple data such as website url/name. Here is an example : \documentclass{article} \def\Google{{http://www.google.com}{Google Search}} \makeatletter ...
14
votes
1answer
1k views

Drawing relationships between elements of a database

I am looking into a feasible way of drawing relationships between Elements from a database. An example: Element x is related to Element Y via the Role "sister". Relationships exist in the form 1:1, ...
10
votes
2answers
946 views

DB diagram's (entity relationship) - tikz chamfered rectangle with split zones

I try to draw an association type for an entity-relationship diagram. How can I draw a chamfered rectangle with split parts=2 or 3 ? I found this ref : Horizontally enlarged hexagon with TikZ but it ...
10
votes
6answers
908 views

A collection of LaTeX equations?

I saw a web-site someday -- it had lots of codes for formulas from many fields of knowledge -- all categorized and searchable. So that when You teach, say, electrodynamics You could come there and get ...
10
votes
2answers
779 views

pgfplotstable or datatool?

What are differences, which to use for including .csv, .tsv files ? Datatool ? pgfplotstable ? I've seen at question : How typeset a numeric table from a CSV file how person asked about fixing ...
10
votes
2answers
296 views

How to manage pictures in a single file to be easily picked by the main file?

I'm writing a paper with many TikZ pictures. To keep the main file readable, I keep the pictures as separate files, but unfortunately I have now too many files. What is a nice solution to keep all the ...
9
votes
3answers
247 views

I have a generated database and need to look up values

A database in a format that can be freely defined had entities with the following attributes: ID, HEXNUMBER, LATEXFORMULA, LITERAL. The ID is unique and can contain numbers, dots and dashed. ...
8
votes
2answers
730 views

Is it possible to use sql database for BibTeX?

I have and extensive database with references in form of an SQL database. How can I use this information in BibTeX?
8
votes
2answers
4k views

Database Entity Relationship Diagram

Is there a package that will allow me to create a database entity relationship diagram such as the one below?
8
votes
2answers
1k views

Mail-merging documents from a database

I use the term database loosely here -- it can be an actual database, or a spreadsheet (in any format including CSV) or can be package-dependent. Is there a way to create mail-merged documents ...
7
votes
2answers
637 views

How to create form letters from spreadsheet data in ConTeXt?

In LaTeX, one can use datatool to build simple form letters. As an example, the data is stored in a spreadsheet or CSV file, like this: Name,Amount,Date "Mr. White","$300","Dec. 2, 1911" "Mr. ...
7
votes
1answer
640 views

How can I convert structured LaTeX file *to* CSV data

I am using a structured format to print patient's documenatation using LaTeX. The structure is like this: Demography Name Surname Age/Sex Address Clinical Details History, Past History, Personal ...
7
votes
1answer
443 views

Public storage of TeX templates

It exists a public storage of TeX templates? I mean that people could search a template that is standardized or just nicely formated eg. Dr thesis, official papers, books, articles and so ... It ...
7
votes
2answers
412 views

build dynamic documents from a Textdatabase

I need a dynamic solution to produce questionnaires from a database of questions which gets updated from time to time. I thought of LaTeX for set out the layout but the question is whether LaTeX can ...
6
votes
1answer
318 views

Does a (Lua) approach exist, to read XML data into a .tex file?

I am having a lot of data in .xml files which look like this: <DATA> <NAME="name" /> <VERSION="1" /> <VARIABLES> <TEST> <ELEMENT atr="0" ...
6
votes
1answer
707 views

Which database documentation software do you use for LaTeX (in Linux)?

I am looking for a database documentation software where I want to incorporate the output in LaTeX. I want to show the table structures, primary keys and other related information. I found ...
5
votes
2answers
3k views

Formatting complex table from CSV using datatool

I have this csv file, formatted like this one: Store,Product 1,Product 2,Product 3,Product 4,Product 5,Sub Total Store 1,15,99,299,75,292,780 Store 2,33,353,429,283,561,1659 Store ...
5
votes
1answer
905 views

Drawing paths with TikZ from a DB with DataTool

I have written this code and it works: ... \DTLsetseparator{;} \DTLloaddb[noheader]{DBcurva}{Curvas.csv} \begin{tikzpicture} \foreach \columna in {1,3,...,\DTLcolumncount{DBcurva}}{ ...
5
votes
1answer
158 views

Using BibTex as a general database for generating a table

I want to create an overview table of some data. More specifically, I have some named objects and for each of these I have some properties. Example data and schematic of output: + ...
4
votes
1answer
690 views

SQL Markup and CSV Formatting in LaTeX

I have had a quick look for similar questions but I couldn't find anything, so apologies if this is a duplicate. Firstly, I am looking for a way to grab information from external source files (i.e. ...
4
votes
2answers
56 views

Is there a way to store information in something like an array

I'd like to store some basic information on people in a file, and want to be able for LaTeX to process this information. More specifically, I'd like to store something like: id:john1; fname: John; ...
4
votes
2answers
179 views

Accessing MySQL or SQLite from Lua(La)TeX

I thought it would be possible to access MySQL or SQLite from Lua(La)TeX, but couldn't google up anything on the topic. Please give me pointers to: Snippets / Examples / Documentation on that, if ...
4
votes
1answer
643 views

TikZ ER diagrams: really can't underline keys?

I'm creating an ER diagram with the TikZ ER library. The manual warns that although key attributes are conventionally underlined, it is hard to implement in TeX and the library uses italics instead. ...
4
votes
1answer
174 views

LaTeX block conditional including

I am researching possibility of building an automatic brief datasheet template in LaTeX, taking data straight out of a database. The database connection part is possible and can be done with such ...
4
votes
0answers
100 views

LuaTeX/ConTeXt connect to SQL Server

I am looking to connect ConTeXt to a SQL Server database. I have looked through the manuals, and even read pragma-ade's SQL PDF (which, for me, seems a bit abstract). I am not extremely familiar with ...
3
votes
3answers
65 views

automatic list/table rendering

i'm looking for a solution to automatically render data lists. In the current scenario, my input data is a list of strings, which should be displayed in a three column list w/ sequential numbers: ...
3
votes
2answers
45 views

On sorting a string with multiple entries

In my LaTeX-file I create a variable \authors which could have content: [Doe] John Doe; [Potter] Harry Potter; [Clinton] Bill Clinton; [Obama] Barack Obama; ... This is dynamically created, so I ...
3
votes
1answer
192 views

Problems in creating graphs using dataplot

I have four simple databases: db1 dy,volume 2009,120000 2010,160000 2011,400000 2012,650000 2013,1000000 2014,1500000 db2 dy,volume 2009,400000 2010,500000 2011,1600000 2012,2200000 2013,2500000 ...
3
votes
1answer
177 views

Spurious blank space when loading a datatool database

I am getting spurious blank spaces inserted upon loading a dtltool db. The MWE below produces links to all the image files named with a prefix the same as the .tex file: But if I comment out the ...
3
votes
2answers
410 views

Weird error when using datatool's `\DTLaddall` in a `\DTLforeach`

Given test.csv containing: donor,core,non-core Norway,137.6,111.4 The Netherlands,116.6,85.8 and data-problem.tex containing: \documentclass{article} \usepackage{datatool} \begin{document} ...
3
votes
1answer
59 views

Create spreadsheet corresponding to \item's

I am writing a mathematics book. For each example, I would like to store a few attributes, including: -The source -Whether I have checked the problem -The difficulty of the problem (etc.) ...
3
votes
0answers
114 views

Database of names similar to bibliography in arabic

The example is with the particular case of Arabic, but could be extended to a more general case. When writing academic papers containing Arabic names, each journal has a particular transliteration ...
3
votes
0answers
70 views

Is there anything like biblist for use with BiBLaTeX?

Is anyone aware of a modern tool that can be used with BiBLaTeX to produce a structured list of an entire BiBTeX database, like to old biblist under LaTeX 2.09?
3
votes
1answer
125 views

How do I install and use nlatexdb? (or latexdb, ratexdb)?

This question is related to this question regarding typesetting a MySQL database using UTF-8 encoding with Xelatex. I ask this in desperation as it involved printing 552 rows for my thesis! I need ...
2
votes
1answer
240 views

How to display a specific entry from an external data source input?

I have a data.txt file and it contains an array of numbers, I included it in the preamble of the .tex file, now I would like to display some specific entry from the data file, not the whole data set ...
2
votes
1answer
526 views

Import data from a spreadsheet into latex and create multiple pdf files for each row in LaTeX

I have a form which I assign to people to fill them out as a google form, and get the responses in a spreadsheet (xlsx or ods file formats). I need to file a report based on their answers, which means ...
2
votes
1answer
276 views

Could I insert the elements of a mdb or csv base in Latex?

I want to insert some information from a csv text file or from a mdb (MS data base) base into a latex document. For example I have a document with math exercises and I would like to insert the first ...
2
votes
3answers
448 views

Dealing with solutions within parts of exercises

I am trying to create a database of maths questions and answers in TeX form. The idea is that a simple command such as \getfromDB{101} will pull the text from the database of the question numbered ...
2
votes
1answer
104 views

Comprehensive list of possible fields in APA6

I'm coming into a situation where users have uploaded thousands of documents (all non-published). There are only basic elments stored currently, including Title, Author, Year. Some fields contain ...
2
votes
1answer
6k views

bibtex issue : Warning--I didn't find a database entry for “birks”

I'm having an issue using bibtex with pdflatex. Here is the file biblio.bib I'm using (with this exact format) : @Book{physiqueNucleaire, author = "Claude le Sech and Christian Ngô", title = ...
2
votes
1answer
344 views

disabling line breaks in datatool table

I have a csv file containing a list of names with addresses. I'm using the datatool package to load these and output stickers (using the labels package) for envelopes. This is done using \DTLforeach. ...
2
votes
0answers
100 views

Reusing / inserting text in different publications from a text database

Update: A solution has been worked out here: String comparison in \ifthenelse Another way of reusing text could be done with the extract package as mentioned here. I am working on the translation of ...
1
vote
4answers
109 views

Browsing BibTeX databases [duplicate]

Is there a good software for browsing BibTeX databases? I have a .bib file with roughly 100 entries and it is becoming harder and harder to look up papers to cite. What I would like is something with ...
1
vote
2answers
781 views

How to use \hlines and | column separators in a csv table uploaded with datatool

Hi I've been trying to use the datatool package to get data from csv files easily into documents as formatted tables. I seem to keep getting the lines on the first column shifted down by a row. If I ...