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

learn more… | top users | synonyms

4
votes
1answer
223 views

Datatool : How to pick manually some rows in a specific order

I've got a large multi-purpose database and i would like to pick several items in it (using labels) and print them in the given order, not the database order or any entry-related order. For example, ...
3
votes
1answer
412 views

Datatool and multiple files

I am trying to achieve the same goal as I tried with pgfplotstable as in this question for which I got good help from the author of pgfplotstable (Dr. Christian Feuersänger) himself. Hence this ...
8
votes
1answer
315 views

Datatool and currency-type data

The package datatool gives me some headaches with the currency-type fields. My data is a test.csv file exported from Excel, without header: a,"$100,090.06 ","$107,578.03 ",0.129565278 ...
2
votes
1answer
145 views

Why does \DTLgetkeyforcolumn not work?

I'm currently learning how to use the datatool package. I have a lot of .txt-files that need to be processed automatically. But if datatool loads a wrong kind of .txt-file I need to be able to check ...
3
votes
1answer
286 views

Column format datatool

all. Suppose I have a csv file (let's call it data.csv): Solution,mol/L,Volume(mL),delta_v(mL),moles HNO3,16,5,0.2,3.125E-4 NaOH,6,20.2,0.2,3.367E-3 H2O,1;200,5,2.000E-1 H2SO4,6,5.2;0.2,8.667E-4 ...
3
votes
1answer
245 views

No paragraph in datatool's DTLforeach possible when using a textblock from textpos

I'd like to print labels using the datatool and the textpos packages. Yet as soon as I insert a paragraph inside the textbox which is inside the \DTLforeach loop, I get the "Paragraph ended before ...
1
vote
2answers
349 views

how to use special character in DTLloaddb keys

\DTLsetseparator{,} \DTLloaddb[noheader,keys={Method, Accuracy, F-Measure(\%), No. of iterations}]{table2}{GDSGD_2.csv} Hi, I want to include special character in my column header, i am using ...
2
votes
1answer
1k views

How can I use \DTLloaddb package to create a table based on csv file?

I am new in Latex and I have some issues. I have succeeded in reading the .csv file: ,w5,w6,w7,w8,w9,w10,w11,w12,w13,w14,w15,w16,w17,w18,w19,w20,w21,w22,w23,w24 ...
10
votes
1answer
3k views

How to use datatool package to read a CSV files so that they can be used in tables?

I am new in latex and I have some issues. I want to read a .csv file in latex to create a table, but I don't know how. I heard that datatool package can do this, but I don't know how to use it. My ...
2
votes
1answer
456 views

Single entry in list of tables using datatool + longtable

I'm using the \DTLdisplaylongdb from datatool in order to create a multi-page table with longtable. How do I provide a caption that only shows up once in the list of tables? (Right now it's showing an ...
7
votes
4answers
406 views

How to check if a datatool db has an existing member

I would like to suppress duplicated entries in a list. The lists are comma separated lists defined in a macro as in my earlier question on Sorting Comma Separated Lists defined with, or without ...
2
votes
1answer
1k 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
244 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
273 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 ...
13
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
323 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
318 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
547 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
829 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
188 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
305 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
970 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
147 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
217 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
864 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
253 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
241 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
191 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
387 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
637 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
415 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
3k 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
584 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 ...
18
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
729 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
330 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
802 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
434 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} ...