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

learn more… | top users | synonyms

3
votes
1answer
149 views

Get a specific item from table using datatool and print it

I'm using datatool to load a csv table. Students names are in that table (first column first name, second column last name) and I like to print them on the exam. In a related question, I asked how to ...
5
votes
1answer
142 views

accessing data using datatool when headers aren't available

I have a series of csv files I'm expecting to receive on a regular basis, and there are two problems with these files. I am not guaranteed to have headers. I cannot rely on how many data entries ...
2
votes
1answer
186 views

How to get the last element of a specific column from a CSV file?

I have CSV files of different lengths. For example a,b,c,d,e 0,0, 5, 5, 1 0,5, 5, 11, 2 0,11, 5, 16, 1 5,0, 10, 6, 1 5,6, 10, 11, 2 I want to get the value of the last element of the c and d ...
2
votes
2answers
4k views

LaTeX Error: File datatool-base.sty not found

When I try to use \usepackage{glossaries} then I get the error message: "LaTeX Error: File datatool-base.sty not found". Is something else needed?
11
votes
3answers
440 views

No room for a new \count with datatool

This question led to a new feature in a package: datatool Update: 2013-1-19 The MWE worked fines with the new (v2.13) version of the datatool package using \DTLnewdbonloadfalse. But in my ...
7
votes
1answer
96 views

Define macro based on Datatool contents

I can define a macro of the form \csname../dirX Color\endcsname manually and use it as desired. However, I am unable to do the same thing based on the contents as read by the datatool package. The ...
8
votes
1answer
148 views

Apparent hyperref conflict with datatool and longtabu col vertical alignment?

Only when I turn on hyperref do I get a weird vertical alignment problem in the first column of a datatool-driven longtabu. Without hyperref, the rows of the first column are vertically aligned to ...
4
votes
1answer
135 views

Expansion Issue with omit list provided to \DTLdisplaydb

In my DB the number of columns is rather large. Hence, I am trying to eliminate any columns which contain only 0 entries. The number of columns, nor the column keys, are know upfront. So, I step ...
5
votes
1answer
151 views

Conflicts with Datatool and babel (french)

I am having trouble compiling a latex document using an external CSV file with datatool and using the french language from the babel package. The content of my latex file is: ...
3
votes
1answer
167 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
101 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
211 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
301 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
140 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 ...
3
votes
1answer
307 views

Using collcell package with csvsimple, or datatool

I was trying to compose an answer to Bold one cell in table using CSV reader using the collcell package, and can't seem to get it to work either with the csvsimple tabluar, nor datatool. With the ...
5
votes
2answers
328 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
287 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
575 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
141 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
153 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
314 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
716 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
86 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
157 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
232 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
149 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
200 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
352 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
298 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
131 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
255 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
216 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
307 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
908 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 ...
9
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
401 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
373 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
215 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
233 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
292 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
302 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
512 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
770 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
168 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
290 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
891 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
142 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} ...