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

learn more… | top users | synonyms

3
votes
1answer
228 views

Alignment of logo in first and second page of a certificate

I was preparing a certificate. I was stumbled on this behavior: The logo (on north west side) and the text between two logos (Department of....etc) are not maintaining the same alignment from page 1 ...
3
votes
2answers
245 views

\DTLdeletedb (from datatool package) has no effect within \foreach

This question led to a new feature in a package: datatool \DTLgdeletedb is available in (v2.13) and later. I am trying to use a \foreach loop to iterate over a few items. For each iteration ...
11
votes
5answers
2k views

What is the proper way to create a horizontal table?

I want to have a horizontal table, like this: However, when using the usual method of creating a table, it quickly becomes a pain having to pre-define the number of columns (especially since I ...
4
votes
1answer
307 views

One cell too many with datatool and longtable

I am aware of the previous post datatool with longtable, but it didn't solve my problem. I've a document with 10 tables or so, for each table I use this piece of code: \DTLsetseparator{;} ...
5
votes
2answers
306 views

Datatool, Two DB rows per table row, vertically ordered

So after searching for some hours I'm surprised that there wasn't any useful solution to find. I import a CSV table using datatool. That table only consists of 3 narrow columns, but I got a lot of ...
4
votes
2answers
526 views

Datatool, UTF8 and Export to a file

The title contains the problem: I have a datatool table, which contain accented characters (öäü) and I want to export the table into a CSV file : \documentclass{article} \usepackage[utf8]{inputenc} ...
10
votes
2answers
779 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 ...
1
vote
0answers
177 views

Skipping blank fields for address labels using datatool and envlab [closed]

I am trying to process the following into Avery 5160 mailing labels, using the \skipblank code that someone else posted on this site to suppress blank lines: \documentclass[10pt]{letter} ...
3
votes
1answer
297 views

Using dcolumn assignment with datatool

I seem unable to use columns defined with dcolumn with datatool. For example if my table is table1.csv events,100,10 \usepackage{dcolumn} ...
7
votes
3answers
928 views

datatool with longtable

I have a CSV file that has many rows. I want to typeset these rows into a table using longtable and datatool package. However just before before the "lastfoot" (which says concluded) I am getting ...
1
vote
1answer
143 views

Envlab and datatool: Error: missing number

Running the following through LaTeX gives me a "Missing number" error: \documentclass[12pt]{letter} \usepackage[c5envelope,noprintreturnaddress,capaddress]{envlab} \usepackage[latin1]{inputenc} ...
3
votes
2answers
209 views

Datatool : can't use \DTLreplaceentryforrow in nested loop “foreach”

In the following MWE (which make no real sense, but which is minimal:) ) I have two nested DTLforeach loops. The values displayed in the line "%for debugging" show the expected behaviour for the ...
4
votes
1answer
807 views

How to refer to the absolute row number in a \DTLforeach loop

Consider the following MWE : \documentclass[12pt]{article} \usepackage{datatool} \begin{document} \DTLnewdb{table} \DTLnewrow{table} \DTLnewdbentry{table}{a}{hallo} \DTLnewdbentry{table}{b}{non} ...
5
votes
1answer
240 views

datatool: getting a specific value given the value of another column

I am certain this is patently obvious, but the solution is eluding me... Given a dataset stored in CSV: ID, col1, col2, col3 KEY-1, foo bar, baz KEY-2, alice, bob, chuck I would like to ...
5
votes
1answer
231 views

How do I get the number of rows of a datatool table?

I create a table as follows: \usepackage{datatool} \begin{document} \DTLnewdb{MaTable} \end{document} This table may be filled with several occurrences of \DTLnewrow{MaTable} ...
3
votes
1answer
179 views

difficulty with datatool + keyval

I want to define a command with key arguments, which stores something in a table with help of the package datatool. My attempt is : \documentclass[12pt]{scrartcl} \usepackage{keycommand} ...
8
votes
1answer
378 views

Difficulty with datatool

I want to use the command \DTLstoreinitials from package \usepackage{datatool} in the following way : \newcommand{\extractInitials}[1]{% \DTLstoreinitials{#1}{\userInitials}% ...
4
votes
2answers
602 views

Tab separated files with datatool package?

The documentation of the package datatool says that the \DTLsettabseparator command changes the separator in .csv-Files from the default comma to the tab character. What it really does for me is ...
2
votes
1answer
398 views

Comment character in datatool AND ignore empty lines?

Here is a minimal example on using the datatool package: \documentclass[a4paper,10pt]{minimal} \usepackage[utf8]{inputenc} \usepackage{datatool} \begin{document} {\DTLsettabseparator% ...
12
votes
4answers
2k views

Is there a pure LaTeX or TeX package for chart drawing?

We are creating an easy-to-use LaTeX template for our institution. I'd like to have a pure LaTeX way to create simple bar graphs and pie charts. Does anything exist? I can certainly throw the students ...
1
vote
1answer
569 views

LaTeX datatool problems

I'm using datatool package on a LaTeX document. I use it to write labels. I have the addr on a CSV file. The problem is that I'm unable to write more that 25 labels. It seem like if datatool can't ...
17
votes
2answers
3k views

How typeset a numeric table from a CSV file

I have a CSV file (db.txt)like this: 30.0, 0.0, 0.0 60.0, 1.9098, 5.8779 90.0, 6.9098, 9.5106 120.0, 13.09, 9.5106 150.0, 18.09, 5.8779 180.0, 20.0, 0.0 I need to typeset it. My ...
6
votes
2answers
595 views

skipping the first line of a data file for pgfplotstable

I need to skip the first row of a csv file, which is auto-generated by some magic measurement apparatus. It contains its own filename as the first line. The second line contains the column names (no ...
5
votes
2answers
3k 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 ...
3
votes
1answer
324 views

Using datatool on files with lines breaks

I have a generated CSV file which has line breaks (newline characters) in values. They are properly quoted. When reading this data with DTLloadrawdb LaTeX complains as those line breaks still breaks ...
5
votes
1answer
777 views

Datatool error: undefined control sequence \begin

I'm using datatool to make a mail merge. I have my .csv file. I've defined my \DTLloaddb{indirizzi}{/home/kde/Dropbox/edile_150/consulenti_arezzo.csv} and if I use \DTLdisplaydb{indirizzi} I have my ...
3
votes
2answers
410 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} ...