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

learn more… | top users | synonyms

2
votes
1answer
281 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 ...
1
vote
1answer
787 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
186 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
229 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
186 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
85 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
97 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
115 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
101 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
301 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
165 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
77 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
242 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
96 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 ...
3
votes
1answer
473 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
117 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
246 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
133 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
419 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
200 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
150 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
413 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
153 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
330 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
353 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
554 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
202 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
236 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
186 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
172 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
126 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 ...
4
votes
1answer
147 views

Search specific entries in database

I have written a command, which takes five arguments to interpolate between two points. Now I tried to get the two points from an csv file. \documentclass{article} \usepackage{expl3} ...
3
votes
1answer
236 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
215 views

Reading datafile entry by entry

In order to use pstricks in a certain fashion, I would like to access a datafile line by line, inside a multido loop. For example, let's say my file is called Datafile.dat. It contains the (x,y) ...
32
votes
1answer
1k views

Helping cardinals elect the new Pope

Yes, we are talking about TeX and friends! Edit: I decided to move the background motivation to the end of the question, since it seems to be kind of off-topic in the TeX context. The following code ...
3
votes
1answer
109 views

datatool: get rid of a specific character

How can I get rid of a character while loading a table from a file with datatool? In my case, I like to get rid of every double quote that appears within the data. \documentclass{minimal} ...
3
votes
1answer
220 views

Get a specific item from table using datatool and print it

I'm using datatool to load a csv table. Students names are in that table (first column first name, second column last name) and I like to print them on the exam. In a related question, I asked how to ...
5
votes
1answer
183 views

accessing data using datatool when headers aren't available

I have a series of csv files I'm expecting to receive on a regular basis, and there are two problems with these files. I am not guaranteed to have headers. I cannot rely on how many data entries ...
2
votes
1answer
228 views

How to get the last element of a specific column from a CSV file?

I have CSV files of different lengths. For example a,b,c,d,e 0,0, 5, 5, 1 0,5, 5, 11, 2 0,11, 5, 16, 1 5,0, 10, 6, 1 5,6, 10, 11, 2 I want to get the value of the last element of the c and d ...
4
votes
2answers
5k views

LaTeX Error: File datatool-base.sty not found

When I try to use \usepackage{glossaries} then I get the error message: "LaTeX Error: File datatool-base.sty not found". Is something else needed?
11
votes
3answers
580 views

No room for a new \count with datatool

This question led to a new feature in a package: datatool Update: 2013-1-19 The MWE worked fines with the new (v2.13) version of the datatool package using \DTLnewdbonloadfalse. But in my ...
7
votes
1answer
104 views

Define macro based on Datatool contents

I can define a macro of the form \csname../dirX Color\endcsname manually and use it as desired. However, I am unable to do the same thing based on the contents as read by the datatool package. The ...
8
votes
1answer
158 views

Apparent hyperref conflict with datatool and longtabu col vertical alignment?

Only when I turn on hyperref do I get a weird vertical alignment problem in the first column of a datatool-driven longtabu. Without hyperref, the rows of the first column are vertically aligned to ...
4
votes
1answer
158 views

Expansion Issue with omit list provided to \DTLdisplaydb

In my DB the number of columns is rather large. Hence, I am trying to eliminate any columns which contain only 0 entries. The number of columns, nor the column keys, are know upfront. So, I step ...
5
votes
1answer
193 views

Conflicts with Datatool and babel (french)

I am having trouble compiling a latex document using an external CSV file with datatool and using the french language from the babel package. The content of my latex file is: ...
3
votes
1answer
215 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 ...
5
votes
1answer
111 views

Datatool DTLifnull not working

Considering the following database: Name,ID,Gender,Years in Service ,382473856,M,15 Francesca Joestar,461276432,F,10 Chan Ker Mei,463724631,F,5 Hikaru Yagami,154954739,M,10 The fist line has the ...
4
votes
1answer
248 views

Equivalent of \DTLiflastrow

With the datatool package there is a \DTLiffirstrow. I am looking for a similar command to detect the last row, \DTLiflastrow, but could not find one. I attempted to create my own but was not ...
4
votes
2answers
450 views

Automatically formatting a table from a file with a list of words

I have a list of ~1000 words in a text file. The words are listed in a text file "my_words.txt" with no breaklines as follows: word1, word2, word3, etc. I would like to display these words in a ...
4
votes
2answers
185 views

How to select specfic row for \DTLnewdbentry to apply to

After a pair of \DTLnewrow/\DTLnewdbentry which creates two rows with the key1 data, I want to add the key2 data to the earlier row. I thought that \dtlgetrow{myDB}{1} would make the current row the ...