Latest news 2024-03-02: Ebook sale (3rd–9th March 2024): short story cybercrime fiction Unsocial Media free; short story noir crime fiction I’ve Heard the Mermaid Sing free; crime fiction novel The Private Enemy US$1.99; illustrated children’s story The Foolish Hedgehog US$0.99. For further details, see latest blog post.

Bug Tracker RSS feed

I’m currently working on a major new version of the datatool package. This may take a while. Please be patient. (Experimental version available for testing.)

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

Sign in to subscribe to notifications about this report.

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.

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

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.

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.

Page permalink: https://www.dickimaw-books.com/bugtracker.php?key=43