{database} is a structured collection of data.

learn more… | top users | synonyms

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 ...