{datatool} is a tool to create and manipulate databases.
1
vote
0answers
20 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
41 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 ...
2
votes
1answer
28 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
119 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
65 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
81 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) ...
28
votes
1answer
760 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
57 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}
...
2
votes
1answer
78 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
86 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
89 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 ...
1
vote
2answers
1k 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
241 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
66 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
93 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
71 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
90 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
94 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
64 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
118 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
141 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 ...
3
votes
2answers
73 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
2answers
171 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 ...
6
votes
1answer
198 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
329 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
112 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
98 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 ...
4
votes
1answer
148 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
329 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
58 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 ...
1
vote
1answer
83 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
180 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 ...
3
votes
1answer
596 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
95 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
132 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
205 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
185 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
80 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
153 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
136 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
155 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 ...
0
votes
0answers
70 views
I need a work-around for using \package{datatool} in LyX [closed]
http://www.lyx.org/trac/ticket/8174 explains the error.
I need a work-around please.
2
votes
1answer
493 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
...
4
votes
1answer
1k 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
265 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 ...
0
votes
0answers
149 views
Beamer slide table with data tool [closed]
I'm trying to include in a beamer presentation a table automatically loaded from a csv file. I'm doing the following
\usepackage{datatool}
\usepackage{siunitx}
\usepackage{booktabs}
...
7
votes
4answers
304 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
734 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
148 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 ...
0
votes
0answers
282 views
Certificates with datatool [closed]
I want to import data from a CSV to a LaTeX file with the datatool package, but I get error messages like:
Undefined control sequence.
Missing } inserted.
Missing } inserted.
Missing \cr inserted.
...
