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

learn more… | top users | synonyms

3
votes
1answer
155 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
95 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
200 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
249 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
118 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 ...
5
votes
2answers
289 views

Can't use utf8 encoding with datatool

I am using datatool to manage tables and I am getting errors when the data.csv file (encoded either as UTF-8 or ANSI) has characters like 'á'. I can get it around by having data.csv encoded as ANSI ...
7
votes
1answer
255 views

Storing unexpanded macro definitions (including #1, #2, …) for later use (now includes full usecase)

Preliminary Info I'm working on a new LaTeX package to make scoping more flexible. To do this I'll be capturing and reintroducing user defined commands behind the scenes. (For a comprehensive ...
6
votes
1answer
483 views

How can I convert structured LaTeX file *to* CSV data

I am using a structured format to print patient's documenatation using LaTeX. The structure is like this: Demography Name Surname Age/Sex Address Clinical Details History, Past History, Personal ...
1
vote
1answer
137 views

datatool and pgfmath option [closed]

Compiling this file \documentclass{article} %\usepackage[math=fp]{datatool} \usepackage[math=pgfmath]{datatool} \DTLloaddb{scores}{sample-student-records.csv} % ...
3
votes
1answer
139 views

datatool repeat row

I intend to create a document where parts of the text are read from the entries of a .csv file using the package datatool (version 2012/09/25 v2.11., updated manually under debian). Everything works ...
6
votes
1answer
272 views

File ended while scanning use of \@dtl@trim

I am trying to compile latex code that imports CSV into a longtable (ltxtable). The code has been compiled successfully in windows while it makes error in Mac OS X. \documentclass{article} ...
1
vote
2answers
609 views

How to use \hlines and | column separators in a csv table uploaded with datatool

Hi I've been trying to use the datatool package to get data from csv files easily into documents as formatted tables. I seem to keep getting the lines on the first column shifted down by a row. If I ...
4
votes
1answer
81 views

Spurious blank space when adding a member to a database within \foreach

The MWE adds blank space proportional to the maximum value of the \foreach iteration: Why is this and how do I eliminate this additional space? Note: This problem seems similar to an earlier ...
2
votes
1answer
135 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
225 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 ...
5
votes
1answer
931 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
133 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
181 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
316 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
275 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
120 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
232 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
205 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 ...
0
votes
2answers
264 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
807 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 ...
7
votes
1answer
2k 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
357 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
354 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
190 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
212 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
1k 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
264 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
287 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
484 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
725 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
160 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
280 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
811 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
140 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
194 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
715 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
208 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
209 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
162 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
359 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
501 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
348 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
532 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 ...