Bug Tracker

ID	43🔗
Date:	2013-10-05 06:48:44
Status	Closed (Can Not Replicate)
Category	datatool
Version	1.0
Summary	I am not able to compile tex file created for displaying database. The `\DTLdisplaydb` gives missing number inserted error.
OS	Ubuntu 13.04

Return to Search Results

Description

I imported a .csv file using datatooltk-gui after enabling `map tex characters when importing data from csv or SQL because there is a e-mail field which contains data that contains @. I created the small file attached below. It doesn't compile in latex. I can send the .dbtex file also if necessary.

MWE

Download (178B)

\documentclass{article}
\usepackage{datatool}
\input{macs-re-registration-contact-details-only-for-tex.dbtex}
\begin{document}
\DTLdisplaydb{macs-june-2013}
\end{document}

Evaluation

The @ character isn’t a special character so there’s no need to map it. Example CSV file (test.csv):

Name,Email
Jane Doe,jane.doe@example.com
John Smith,john.smith@example.com

Calling datatooltk from the command line (no mapping):

datatooltk --csv test.csv --output test.dbtex --name test

Document code:

\documentclass{article}

\usepackage{datatool}

\input{test.dbtex}

\begin{document}
\DTLdisplaydb{test}
\end{document}

This compiles correctly and works as expected. Also works with --map-tex-specials (which is what the GUI does with the “map TeX special characters” option enabled):

datatooltk --csv test.csv --output test.dbtex --name test --map-tex-specials

However, there are no special characters to map so there’s no difference in the created .dbtex files. Without further information to reproduce the error I’ll have to close this.

Comments

1 comment.

🔗Comment from Nicola Talbot 🦜
Date: 2014-01-14 00:00:00

Can you send the .dbtex file? Or copy and paste contents of it in the comments box.

Replying to Comment #17:

Name (optional):

Are you human? Please confirm the bug report ID (which can be found at the top of this page) or login if you have an account. All guest comments have to be manually checked before they appear on the page. There are too many bots trying to spam the site to allow unauthenticated users to post without verification.

Confirm ID:

Comment:

You can use the following markup:

Block:

[pre]Displayed verbatim[/pre]
[quote]block quote[/quote]

In line:

[tt]code[/tt]
[file]file/package/class name[/file]
[em]emphasized text[/em]
[b]bold text[/b]
[url]web address[/url] [sup]superscript[/sup]
[sub]subscript[/sub]

Ordered list:
[ol]
[li]first item[/li]
[li]second item[/li]
[/ol]

Unordered list:
[ul]
[li]first item[/li]
[li]second item[/li]
[/ul]

You can use the Preview button to review your message formatting before submitting.

Add Comment