{database} is a structured collection of data.
32
votes
7answers
3k 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 ...
18
votes
4answers
2k 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.
...
17
votes
1answer
132 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 ...
17
votes
1answer
562 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, ...
14
votes
3answers
310 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
132 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
549 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
580 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
2answers
276 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
197 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. ...
9
votes
2answers
597 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 ...
9
votes
5answers
393 views
+100
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 ...
8
votes
2answers
497 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?
7
votes
2answers
2k 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?
7
votes
1answer
346 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 ...
6
votes
2answers
369 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. ...
6
votes
1answer
338 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 ...
6
votes
2answers
229 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 ...
5
votes
2answers
2k 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
2answers
174 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 ...
5
votes
1answer
776 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}}{
...
4
votes
1answer
512 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
1answer
269 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 ...
4
votes
0answers
30 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:
+ ...
3
votes
1answer
75 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
99 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
327 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
41 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 ...
2
votes
1answer
164 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
69 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
2k 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
284 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
1answer
48 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 ...
1
vote
1answer
191 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 ...
1
vote
2answers
358 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 ...
1
vote
3answers
226 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 ...
1
vote
1answer
129 views
find and sort selected words
I am writing a book, where in i have to call back the selected words in different context. Here is my MWE
\documentclass[a4paper,10pt]{article}
%For multiple index
\usepackage{imakeidx}
\makeindex ...
1
vote
2answers
881 views
Article organizers: refbase, I,Librarian or something else?
I hope this is the right place to ask this. I think it's extremely likely other TeX users have experienced the same problem I have, given its use in the academic world.
So, I have an ever-growing ...
1
vote
0answers
98 views
How can I typeset with LaTeXDB using XeLaTeX?
Related question
Using the sample code on this site, http://hgesser.com/software/latexdb/workshop.html, I would like to
query my MySQL database and typeset using XeLaTeX.
This is because all of ...
0
votes
1answer
208 views
DB dump into LaTeX with Python and R?
I have quite a large index. I am planning to create a full-blown DB for it and later export the information to LaTeX. I am comfortable with R and Python so I would like to work with them but I feel ...
0
votes
0answers
69 views
How do I create a visually pleasing tree hierarchy from a difficult to read CSV File (MySQL Export)?
Ok here is the deal: I am working on an endangered language project. The data is contained in a MySQL database. I can run a query to produce a hierarchy, but the hierarchy is difficult for humans to ...
0
votes
0answers
251 views
automated MySQL schema to LaTeX conversion? [closed]
I am documenting a database in LaTeX, and I would like to be able to update the table descriptions automatically based on the current state of the database.
I know phpmyadmin has some functionality ...
