{datatool} is a tool to create and manipulate databases.
2
votes
1answer
795 views
Importing CSV table - Error [closed]
I am new to LaTeX and am compiling a document right now using TeXworks. I am trying to create CSV tables into my document right now, and although I succeed in between I must have some small bug in the ...
3
votes
1answer
150 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 ...
0
votes
0answers
288 views
Certificates with datatool [closed]
I want to import data from a CSV to a LaTeX file with the datatool package, but I get error messages like:
Undefined control sequence.
Missing } inserted.
Missing } inserted.
Missing \cr inserted.
...
3
votes
2answers
168 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
765 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
202 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
255 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
416 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}
...
9
votes
2answers
594 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
128 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
241 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
2answers
609 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
124 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
164 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
564 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}
...
4
votes
1answer
156 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
175 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
140 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
321 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}%
...
3
votes
2answers
389 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
268 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
473 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 ...
15
votes
2answers
1k 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 ...
5
votes
2answers
420 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 ...
0
votes
0answers
127 views
How can I have multiple sorted lists in a single document? [closed]
Without setting up an index, is it possible to have multiple sorted (alphabetized) lists in the same document? Here is what I have thus far using the datatool package:
...
5
votes
2answers
2k 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
242 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
606 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
327 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}
...
