Bug Tracker

ID	125🔗
Date:	2017-10-07 18:00:41
Status	Closed (Not a Bug)
Category	datatool
Version	v2.27
Summary	datatool + utf8 special chars in raw CSV import = sounds of breaking LaTeX

Return to Search Results

Description

MWE (test.tex, MUST HAVE TEST.CSV TO WORK):

\documentclass{article}
\usepackage[utf8]{inputenc}
\usepackage{datatool}
\begin{document}
\tableofcontents
\appendix
\section{Bill of Materials}

\DTLloadrawdb{bom}{test.csv}
\DTLdisplaydb{bom}
\end{document}

MWE (test.csv) (was UTF-8 encoded until the mojibake happened, can send separately if needed, LMK if you want a separate report about your bug report form):

"name","quantity"
"10μF 16V",5
"470Ω 1/2W",10
"33k×9",1

Salient error:

! Undefined control sequence.
\GenericError  ...                                
                                                    #4  \errhelp \@err@     ...
l.9 \DTLloadrawdb{bom}{test.csv}

Full logs:

[...]

(See [How do I get datatool to play nicely with utf8 inputenc and non-ASCII in the incoming CSV?] for more details and a non-mojibake'd test.csv btw)

MWE

Download (210B)

\documentclass{article}
\usepackage[utf8]{inputenc}
\usepackage{datatool}
\begin{document}
\tableofcontents
\appendix
\section{Bill of Materials}

\DTLloadrawdb{bom}{test.csv}
\DTLdisplaydb{bom}
\end{document}

Evaluation

(I removed the log from your message as it's too noisy. The bug report script has saved the accompanying log file.) It's not a bug as you also get an error with just:

\documentclass{article}
\usepackage[utf8]{inputenc}
\begin{document}
10μF 16V, 5
470Ω 1/2W, 10
33k×9, 1
\end{document}

and your MWE works fine with recognised UTF-8 characters. For example, if test.csv is changed to:

"name","quantity"
"éîà",1

You need to map the unrecognised UTF-8 characters (as in Alan Munn's answer) or use a UTF-8 aware engine.

Comments

0 comments.

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. 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.

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

Return to Search Results