{database} is a structured collection of data.
5
votes
2answers
1k 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 ...
31
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 ...
9
votes
2answers
586 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 ...
13
votes
1answer
513 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, ...
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.
...
3
votes
1answer
94 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 ...
9
votes
2answers
553 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 ...
6
votes
2answers
228 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 ...
3
votes
1answer
65 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
...
2
votes
1answer
42 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 ...
0
votes
1answer
205 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 ...
9
votes
3answers
194 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. ...
1
vote
0answers
95 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 ...
1
vote
2answers
329 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
1answer
187 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 ...

