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

learn more… | top users | synonyms

4
votes
1answer
289 views

How to draw and scale for large data values as a sparklines-like diagram with datatool & TikZ?

I want to draw rectangles by the measure of ++(1pt, 4pt) at (x, y) where x and y are based on external data, but I am unsure on how I can proceed to get a proper graph for this. The obvious ideal ...
5
votes
1answer
440 views

How to mark up different entry types (index/glossary/acronym/notation) at the same time in datagidx package?

I came across datagidx package, which is part of the datatool bundle, the killing feature of this package is that you can use it independently, not relying on external indexing applications, e.g., ...
2
votes
1answer
173 views

Datatool split page vertically

There is a CSV file, which has 1-6 records, I need to load it and display on the letter page into two columns (each row in a column is block with all text from CSV row), right column appears only for ...
6
votes
2answers
186 views

How to put content from multiple databases in one table using datatool?

Almost too easy: I have two databases "First" and "Second", both get their data from tab-delineated files "First.txt" and "Second.txt" Both contain two columns ('year' and 'number') and an equal ...
2
votes
1answer
144 views

Use \DTLifoddrow in preamble

I'm putting many tables in many files generated by csv files. I'm using datatools (opposed to say pgfplotstable) because it is much more forgiving in terms of the csv input format (e.g. it ignores ...
1
vote
1answer
143 views

envlab and datatool for labels

I'm trying to use datatool and envlab to print to and from addresses on a biglabel. Currently my code is close, but not quite there. It will print one combination of to/from on a page and with ...
5
votes
1answer
99 views

Obtain all different values of a specific column in a datatool database

how can I get all different values of a specific column in a datatool database? Example is the following table read into a datatool database: Name,Town,Age Adam,Xcity,20 Berta,Ytown,30 ...
4
votes
1answer
144 views

Search specific entries in database

I have written a command, which takes five arguments to interpolate between two points. Now I tried to get the two points from an csv file. \documentclass{article} \usepackage{expl3} ...
3
votes
1answer
193 views

Problems in creating graphs using dataplot

I have four simple databases: db1 dy,volume 2009,120000 2010,160000 2011,400000 2012,650000 2013,1000000 2014,1500000 db2 dy,volume 2009,400000 2010,500000 2011,1600000 2012,2200000 2013,2500000 ...
3
votes
1answer
185 views

Reading datafile entry by entry

In order to use pstricks in a certain fashion, I would like to access a datafile line by line, inside a multido loop. For example, let's say my file is called Datafile.dat. It contains the (x,y) ...
31
votes
1answer
990 views

Helping cardinals elect the new Pope

Yes, we are talking about TeX and friends! Edit: I decided to move the background motivation to the end of the question, since it seems to be kind of off-topic in the TeX context. The following code ...
3
votes
1answer
91 views

datatool: get rid of a specific character

How can I get rid of a character while loading a table from a file with datatool? In my case, I like to get rid of every double quote that appears within the data. \documentclass{minimal} ...
3
votes
1answer
172 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
150 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
203 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 ...
3
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
477 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
98 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
153 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
145 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
160 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
177 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
106 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
221 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
348 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
151 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 ...
4
votes
1answer
353 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
356 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
303 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 ...
7
votes
1answer
640 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
148 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
161 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
350 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
786 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
91 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 ...
3
votes
1answer
175 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
240 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
160 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
209 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
393 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
308 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
136 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
269 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
227 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
324 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
987 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
426 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
394 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 ...