{datatool} is a tool to create and manipulate databases.

learn more… | top users | synonyms

3
votes
1answer
688 views

I want to take a CSV file, process the data, and generate a report file, where can I go to learn how to do this?

I have access to MATLAB for data processing, and TeXstudio for the report. I am familiar with MATLAB about 100x more than LaTeX. The data flow I am trying to create: CSV file is generated with 50 ...
6
votes
4answers
1k views

Sending Same Letter to multiple addresses

I'm sending the same letter to multiple addresses. The addresses are stored in a csv document. I've so far created a loop to create multiple letters, but I have not been successful in finding a ...
1
vote
1answer
371 views

Custom table from csv file (multiple header rows)

I would like to create custom tables from .csv files. By custom I mean, that I only want LaTex to read in the body of the table, i.e. "a & b & ... \ ..." but I want to write my own header and ...
1
vote
1answer
114 views

Problem with gb4e's spacing when using datatool

Say that I have a .csv file with sentences in IPA, their glosses, and their translations that I want to incorporate into a document. However, using datatool to loop over the .csv doesn't work with ...
1
vote
1answer
190 views

bulk letter with datatool: how to handle linebreak csv-field

I'm generating a bulk letter using datatool. Therefore I import my data from an external csv-file using the following syntax: \documentclass[11pt]{dinbrief} \usepackage[T1]{fontenc} ...
0
votes
1answer
549 views

Dynamic Courtesy Receipt PDF Generator For PHP

The title needs a bit of help, but I'm wondering if it's possible to dynamically create a beautiful customized receipt for purchases from my website using LaTeX, where LaTeX gets its data from my ...
0
votes
0answers
55 views

Display bibtex entry in latex document

I'm trying to display a bibtex code written in a .bib file inside a document. Does anyone know how to include bibtex code, e.g. : @book{Darwin59, author={Darwin,Charles}, title={On the Origin of ...
3
votes
1answer
378 views

Mail merge using datatool with letter class

I am trying to adapt this question/answer on how to do mail merge to work with the letter document class. The linked answer works great for me, but when I try to change the document class to letter I ...
1
vote
1answer
291 views

Pie Chart with datatool

I am totally stuck with a problem. Is there any appropriate package for pie charts? I am using datatool right now. But there are a lot of problems: E.g. the labels are overlapping. Do you have any ...
2
votes
1answer
190 views

Modify Pie Charts (delete the labels)

I am totally new to LaTeX and pgfplots,... I copied an example for pie charts from another blog. The problem: I don't want the labels in my pie chart. Could you please help me? This is what I have ...
3
votes
1answer
207 views

Using \DTLforeach for defining multiple \newtcolorbox

Concerning this project, I'm now trying to define an own tcolorbox environment for every conversational partner by creating a "conversational partner database" with the datatool package and then using ...
6
votes
3answers
1k views

Use datatool to read a row from a CSV file, then use the variables in the document?

I'm confused about how to use "datatool" to read variables from a row in my database, and pass them on to be formatted in my text. I don't want to make a table, but that's about all there seems to be ...
4
votes
0answers
134 views

How can I typeset *some* fields from a (YAML) dataset?

I'm building a dataset of sorts with long strings, tags, some of which will be used for survey research (a q-sort, actually). This dataset needs to: be reasonably human-readable play nice with ...
4
votes
1answer
132 views

datatool group by?

I try to display the results of a survey where students of 2 different classes could choose their favorite subject. In the result table I find Surname, Name, ClassID, Subject. The data in the file ...
0
votes
0answers
24 views

Adding blank pages when generating multiple copies of a document [duplicate]

I'm generating multiple copies (right now, 2, but a general solution would be nice) of a letter with minor variations using datatool. I just realised that if I'm printing it double-sided. and if the ...
1
vote
0answers
690 views

File `datatool.sty' not found [closed]

I am making a latex document with class {article} I want to make a page for glossaries I added the below in my preamble \usepackage{datatool} \usepackage{datatool-base} \usepackage{glossaries} ...
1
vote
1answer
105 views

Inserting names on invitations, two per page in specific locations

I am doing a wedding invitation and I want the RSVP to have the person's name on it. I also need the name to appear in another, very specific location on the invitation. The invitation only takes up ...
4
votes
1answer
281 views

Rotating a pie chart

How can I rotate a pie chart with 50,50 distribution so that it is divided vertically rather than horizontally? \documentclass{beamer} \usepackage{multicol} \usepackage{datapie} \usetheme{Warsaw} ...
2
votes
1answer
78 views

datatool: why does \DTLifstringeq not work in the address part of a bulk letter

I'm trying to create a bulk letter using the package dinbrief and datatool. I created the whole letter and except from one problem everything works fine (that's why I don't want to change any major ...
2
votes
1answer
343 views

The datatool package is not reading the csv file

I have the csv file as follows: The csv file in sublime looks like this: Now the code reads each quote and author in the quote environment at the footer in the center. But it doesn't print the ...
2
votes
1answer
1k views

The footer styling in fancyhdr - Center text

\fancypagestyle{myfancy}{ \fancyhf{} \fancyhead[LE,RO]{\slshape\nouppercase{\leftmark}} \fancyfoot[LE,RO]{\tikz[baseline={(0,0)},anchor=center] ...
3
votes
1answer
266 views

Why does datatool/pgfplots only plot for last row in table?

I'm trying to use datatool to put a bunch of circles on a pgfplots plot. I tried the following: \documentclass{article} \usepackage{datatool,tikz,pgfplots} \pgfplotsset{compat=1.9} ...
6
votes
2answers
247 views

Automatically creating a table from datatool using references in the text

This question is based on Peter Grill's answer to "Table including rows of a master table".. The function \PrintDTLTable takes an optional list of rowIDs (first row of the data file) as its first ...
5
votes
1answer
243 views

Using `ifthenelse` to combine two related functions into one

This question is based on Peter Grill's answer to "Table including rows of a master table".. The function PrintDTLTable was in Peter's original answer. I wanted a version that would run over all ...
2
votes
1answer
105 views

Handling blank rows for use with multirow automatically when using datatool

The following example code is slightly adapted from Peter Grill's answer to "Table including rows of a master table". The problem I'm having is that if I have a multirow, then I need an extra blank ...
7
votes
1answer
118 views

Multiple instances of xelatex in parallel without overwriting generated PDF's

I've one TeX file abc.tex which is executed using xelatex abc.tex to generate the PDF file abc.pdf Inside abc.tex I'm using the datatool package to read data from an external CSV file (say pqr.csv). ...
4
votes
1answer
126 views

Eso-pic and data-tool

Csv files can be easier to prepare for the person who is not used to LaTeX syntax. I would like to use a csv file containing Id, myauthor, mydate, myaddress Sebastian, 12.12.2012, XYZ road, ...
1
vote
1answer
110 views

esopic and repeating part of document

This answer nicely illustrate the use of eso-pic to repeat part of document. Repeating part of document on every page But when the text entered is large, it is cut-off from the page. It possibly ...
1
vote
1answer
383 views

Line-breaking long cell contents when using longtable through datatool

I'm trying to display a table loaded from a CSV file and displaying it like this: \DTLloadrawdb[]{myDB}{myDB.csv} \DTLdisplaylongdb[% caption={myDB caption},% label={tab:myDB},% ...
1
vote
1answer
193 views

Datatool (datagidx) index with special characters

When I define multiple terms that contain an underscore and begin with the same string ex_ 1, ex_ 2 (as shown in the example below) I get the following error: ! TeX capacity exceeded, sorry [input ...
4
votes
1answer
88 views

Indexes using datagidx where multiple terms have a single index entry

I'm building off of an example here from the LaTeX Community. What I want to do is create an index where multiple terms link to the same word in the index. So for example if the terms toyota, ford, ...
4
votes
1answer
303 views

text wrapping and \DTLdisplaydb from datatool

I'm trying to adjust width column of tabular generated by \DTLdisplaydb from datatool package like here for tabular environment. But I didn't come up with any solution. I tried something pretty bad: ...
5
votes
1answer
104 views

datatool: How to reliably store database in \AtEndDocument (or similar hook)

In a big report with many subfiles and authors, I am using the datatool package to write out some data collected across the document. At the end of the document, the data should be stored in a CSV ...
4
votes
1answer
564 views

Combining invoice and datatool to create serial invoices

I want to generate invoices based on a CSV table. My approach looks like this: \documentclass{letter} \usepackage{invoice} \usepackage{datatool} \address{ABC AG \\ Nonamestreet 4 \\ 1100 ...
5
votes
1answer
132 views

Using counter within database

I try to add a countervalue into a database. But if the database content will be printed, the value is allways the maximum value. I have a simple code example ...
4
votes
1answer
309 views

Sort database with datatool

I use the datatool package to read CSV files and print them as tables. Before printing I want to sort the rows. The problem is that the file was written with R and some rows contain normal numbers ...
2
votes
1answer
145 views

Highlight smallest number in table

I would like to highlight the smallest number in each row. How would I go about doing this. In the following for example, would like to highlight 3 and 3. \documentclass{article} ...
5
votes
1answer
564 views

Is it possible to use commands defined in DTLforeach as conditions in a tikz environment?

I have been tearing out my hair with this one all afternoon and was hoping someone could help me. Essentially the problem I have is that I'm using a DTLforeach loop to iterate over values in a .csv ...
4
votes
1answer
224 views

Datatool cannot use math macros in tabular headers from csv file

I am making a LaTeX table using a CSV file and the datatools package. Here is a minimal working example: \documentclass{minimal} \usepackage{datatool} \usepackage{filecontents} ...
5
votes
1answer
175 views

How to cherry pick from datatool DB and calculate totals

I have a CSV file with current prices/item. These prices are updated regularly. I have loaded a DB with datatool. I would like to use these prices to calculate totals according to quantities I have ...
9
votes
1answer
490 views

LaTeX's datatool package together with siunitx

I want to use the datatool package to read csv files and parse them to LaTeX tables. Furthermore I want to use siunitx to format the numbers from the csv file. Have a look at the following example: ...
8
votes
1answer
186 views

Datatool control precision

How can I bring down the number of decimal points in following code to only 2: \documentclass{article} \usepackage{datatool} \begin{filecontents*}{test2.csv} Name, Age, stDev Adam, 17.2344, ...
4
votes
2answers
416 views

How do I solve “Undefined color `\dtlpie@segcolix '”?

I have the following LaTeX file: \documentclass{article} \usepackage[pdftex,active,tightpage]{preview} \setlength\PreviewBorder{2mm} \usepackage{datapie} %\usepackage{xcolor} ...
4
votes
1answer
427 views

How to draw and scale for large data values as a sparklines-like diagram with datatool & TikZ?

I want to draw rectangles by the measure of ++(1pt, 4pt) at (x, y) where x and y are based on external data, but I am unsure on how I can proceed to get a proper graph for this. The obvious ideal ...
6
votes
1answer
660 views

How to mark up different entry types (index/glossary/acronym/notation) at the same time in datagidx package?

I came across datagidx package, which is part of the datatool bundle, the killing feature of this package is that you can use it independently, not relying on external indexing applications, e.g., ...
2
votes
1answer
224 views

Datatool split page vertically

There is a CSV file, which has 1-6 records, I need to load it and display on the letter page into two columns (each row in a column is block with all text from CSV row), right column appears only for ...
7
votes
2answers
290 views

How to put content from multiple databases in one table using datatool?

Almost too easy: I have two databases "First" and "Second", both get their data from tab-delineated files "First.txt" and "Second.txt" Both contain two columns ('year' and 'number') and an equal ...
2
votes
1answer
224 views

Use \DTLifoddrow in preamble

I'm putting many tables in many files generated by csv files. I'm using datatools (opposed to say pgfplotstable) because it is much more forgiving in terms of the csv input format (e.g. it ignores ...
1
vote
1answer
191 views

envlab and datatool for labels

I'm trying to use datatool and envlab to print to and from addresses on a biglabel. Currently my code is close, but not quite there. It will print one combination of to/from on a page and with ...
5
votes
1answer
142 views

Obtain all different values of a specific column in a datatool database

how can I get all different values of a specific column in a datatool database? Example is the following table read into a datatool database: Name,Town,Age Adam,Xcity,20 Berta,Ytown,30 ...