XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Jon RobertsSubject: EDIFACT import error
Author: Jon Roberts
Date: 18 Feb 2008 07:59 AM
Guys,

Sorry if this is a stupid question, but I'm pretty new to this. We're starting an EDI project with a key customer who uses EDIFACT messages.

We're hoping to us StylusStudio to convert to XML to integrate with our in house system (VisualStudio.Net + SQL Server).

The EDI template we had worked, but the first genuine data example we tried generated this error:

[EDI43] ERROR Invalid character SUB (\u001a)
Dialect: EDIFACT
Version: syntax=3;message=D/96A;table=D96A
Segment: UNZ (line 1447)
Position: UNZ03
Native error: 21, in table: 0085

I've looked through the source file, but can't see what's wrong. I'm just opening the file using the standard EDI converter. I can provide the file if anyone else wants to test it, but don't want to make it public as it may contain client data (without opening it, I can't be 100% sure!).

There are a number of settings on the EDI converter import dialogue - not sure if I need to be specifying anything other than the defaults.

Any advice gratefully received.

Jon

Postnext
Tony LavinioSubject: EDIFACT import error
Author: Tony Lavinio
Date: 18 Feb 2008 10:13 AM
The problem is most likely an errant control-Z at the end of the
file. Sometimes if files are transferred by FTP in 'ascii' mode
or are edited by certain editors that character gets added to the
end.

Stylus Studio is checking the characters in the data stream against
what the standard says are allowable, and that's where the error is
coming from.

It can be solved by relaxing the handling of invalid characters
slightly.

Change these two settings when you do the import:
'Character repetoir overrides' to 'REPLACE'
'Invalid character replacement character' to 'TAB'

This will cause any invalid characters in the data stream to be
replaced by TAB characters, which will be dropped by the parser.

Hope this helps.

Posttop
Jon RobertsSubject: EDIFACT import error
Author: Jon Roberts
Date: 18 Feb 2008 06:34 PM
Hi Tony,

Thanks for your response. Your suggestions have sorted the import error - thanks.

Now I've got to make sense of the data!

Its appreciated, none the less.

Cheers

Jon

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.