Latest news 2020-07-03: SmashWords sale (ends 31st July 2020): 50% off crime/SF novel The Private Enemy and 100% off (free!) I’ve Heard the Mermaid Sing.

Bug Tracker

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

Report

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

\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

Comment from Nicola Talbot

Date: 2014-01-14

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

Add comment or return to search results.

Watch This Report

If you would like to be notified whenever updates are made to this report, please fill in your email address in the box below and click on "Notify Me of Changes" button. (Please ensure the address is valid.) Your details won't be passed on to third parties in line with this site's Privacy Policy.

If you supply your name, it will be used in the email greeting, which provides a more personal message, otherwise you'll just get a generic greeting. If you have previously supplied your name when signing up for notifications, you don't need to resupply it unless you want to change it.

If you have previously subscribed to notifications for this report, you can unsubscribe by clicking on the "Stop Notification" button.

The "Confirm Bug ID" field helps to protect against spambots. Please enter the bug ID (which you can find at the top of this page).

(Optional.)
E mail:
Confirm E mail:
Confirm Bug ID:

To unsubscribe from all notifications use the notifications page.

Comment

You can append a comment to the report using the form below. Comments are checked first before being added. Any spam or offensive content will be removed first according to this site's Terms of Website Use. Please bear in mind that I develop and maintain free software in my spare time. If you want commerical level support then you can hire a TeX consultant.

The "Confirm Bug ID" field helps to protect against spambots. Please enter the bug ID (which you can find at the top of this page).

(Optional. If provided, it will be shown with the comment.)
Confirm Bug ID:

You can use the following markup:

[pre]Displayed verbatim[/pre]
[tt]monospace text[/tt]
[em]emphasized text[/em]
[b]bold text[/b]
[url]web address[/url]

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

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

Click on the Preview button to preview the message.

Return to search results.