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

learn more… | top users | synonyms

4
votes
1answer
206 views

Enumerated sorted list with datatool

How can I adapt a sorted list so that it becomes an enumerated sorted list? Here is the sorted list I currently have. \documentclass{report} \usepackage{enumitem} \usepackage{datatool} ...
-2
votes
1answer
243 views

Data conversion (datatool, fp) [closed]

Ich bin auf der Suche nach einer Möglichkeit aus einer Datei folgender Struktur 1,a 2,a 2,a 2,a 3,a 3,a 4,a 4,a 4,a 4,a 5,a 5,a 6,a 6,a 7,a folgendes zu machen 1 1 2 3 3 2 4 4 5 2 6 2 7 1 (Das A ...
6
votes
1answer
1k views

Command \AtBeginEnvironment already defined

I am pretty new to LaTeX. With windows, Miktex/Texmaker pretty-much takes care of package installation whenever needed, but on Ubuntu I have been downloading needed packages from CTAN and installing ...
1
vote
1answer
176 views

Adding condition to \DTLplot (dataplot package)

I'm working with the package datatool for a while now, and I'd like to make graphs of my created databases. But I do not want to plot all rows in my database so I'd like to use the condition. This is ...
4
votes
1answer
227 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
418 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
317 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
146 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
289 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
251 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
359 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 ...
11
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
461 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
409 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
249 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
292 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
324 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
321 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
557 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} ...
11
votes
2answers
839 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
189 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
307 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
978 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
218 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
875 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
256 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
245 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
194 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
659 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
418 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
599 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
776 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
338 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
808 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
437 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} ...