The solution to the problem is to remove the RecSep attribute from the RecordDef
and add it to the end of the line. See EOL below

<SequenceDef Name="TC00" MinOccur="0" MaxOccur="0" >
<RecordDef Name="Field" MinOccur="1" MaxOccur="1" MapToXml="No" ><FieldDef
Name="RECORDTYPE" MinFieldLength="1" MaxFieldLength="1"
ValidValue="D"/></RecordDef>
<RecordDef Name="Field" MinOccur="0" MaxOccur="1" MapToXml="No" ><FieldDef
Name="COMPANYCODE" MinFieldLength="0" MaxFieldLength="3" InvalidChars="\N"
/></RecordDef>
<RecordDef Name="Field" MinOccur="0" MaxOccur="1" MapToXml="No" ><FieldDef
Name="COMPANYNAME" MinFieldLength="0" MaxFieldLength="20" InvalidChars="\N"
TrailingFillerChars=" " /></RecordDef>
<RecordDef Name="Field" MinOccur="0" MaxOccur="1" MapToXml="No" ><FieldDef
Name="COMPANYADDRESS" MinFieldLength="0" MaxFieldLength="100" InvalidChars="\N"
/></RecordDef>
<RecordDef Name="Field" MinOccur="1" MaxOccur="1" MapToXml="No" ><FieldDef
Name="EOL" ValidValue="\N" MapToXml="No" /></RecordDef>
</SequenceDef>


--- In xmlconvert@yahoogroups.com, "andrewd.tenney" <andrewd.tenney@...> wrote:
>
> Hi All,
>
> I have a fixed flat file that has a line terminating character earlier than
expected and I'm getting an error message saying "The bad record begins with:"
>
> For instance the line below (terminates with a \N)
>
> "DBOBBOBS SHOP"
>
> is not picked up by the following definition because
> 1) the company name field in the above is only 9 characters (as opposed to 20)
> 2) the company address is not present and is 0 characters
>
> <RecordDef Name="TC00" RecSep="\N" MinOccur="0" MaxOccur="0" >
> <FieldDef Name="RECORDTYPE" MinFieldLength="1" MaxFieldLength="1"
ValidValue="D" MapToXml="No" />
> <FieldDef Name="COMPANYCODE" MinFieldLength="3" MaxFieldLength="3" />
> <FieldDef Name="COMPANYNAME" MinFieldLength="20" MaxFieldLength="20" />
> <FieldDef Name="COMPANYADDRESS" MinFieldLength="100" MaxFieldLength="100" />
>
>
> Is there any way to map this file using xflat?
>
> Thanks
> Andrew
>

When loading a file with the following definition the last record in the file
may not contain a "\N" at the end of the file. In this case the last record will
cause an error saying "Description: Unrecognizable record."

<RecordDef Name="detail_record" FieldSep="," RecSep="\N" MinOccur="0"
MaxOccur="0" >
<FieldDef Name="date" QuotedValue="Yes" />
<FieldDef Name="amount" QuotedValue="Yes" />
<FieldDef Name="description" QuotedValue="Yes"/>
</RecordDef>


Is it possible to include a flag at the RecordDef lay that if the EOF flag is
met that the record should also be terminated???

Thanks
Andrew

Hi All,

I have a fixed flat file that has a line terminating character earlier than
expected and I'm getting an error message saying "The bad record begins with:"

For instance the line below (terminates with a \N)

"DBOBBOBS SHOP"

is not picked up by the following definition because
1) the company name field in the above is only 9 characters (as opposed to 20)
2) the company address is not present and is 0 characters

<RecordDef Name="TC00" RecSep="\N" MinOccur="0" MaxOccur="0" >
<FieldDef Name="RECORDTYPE" MinFieldLength="1" MaxFieldLength="1" ValidValue="D"
MapToXml="No" />
<FieldDef Name="COMPANYCODE" MinFieldLength="3" MaxFieldLength="3" />
<FieldDef Name="COMPANYNAME" MinFieldLength="20" MaxFieldLength="20" />
<FieldDef Name="COMPANYADDRESS" MinFieldLength="100" MaxFieldLength="100" />


Is there any way to map this file using xflat?

Thanks
Andrew

It looks like the .exe relies on Microsoft JVM and not the Sun Java JVM.
Microsoft JVM is no longer available. So, is there a way to call the exe?

I want to use XFlat and possibly XMLConvert with .NET applications to convert
legacy flat files into XML.

Any help/ ideas is appreciated.

TIA

Hi,
I have to delete files after conversion, but flatToXml() method don't
close the flat file reader if it thrown an exception.
May help me?
Thanks.

Hi,
in Javadoc you say that "the flatToXml() method will close the flat
file reader and the XML writer before returning or throwing an exception".
I have tested this function and the funtion actually close the flat
file reader before returning but it don't close the reader throwing an
exception.
It is possible resolve this problem in that way?
Thanks for your help!

Hi,
I'm using this function.
i have to delete, after conversion,  the flat files but delete
function return always false.
May help me?
Thanks.

Free screen capture software ,
http://www.horizon33.weebly.com/ ,Limited Offer!.

Free screen capture software ,
http://www.horizon33.weebly.com/ ,Limited Offer!.

Free screen capture software ,
http://www.horizon33.weebly.com/ ,Limited Offer!.

Free screen capture software ,
http://www.horizon33.weebly.com/ ,Limited Offer!.

I will be out of the office starting  12/23/2008 and will not return until
01/05/2009.

If there a CDS issue or inquiry, please contact Ono Pannunzio at
905-273-1508

CONFIDENTIALITY WARNING
This communication, including any attachments, is for the exclusive use of
addressee and may contain proprietary and/or confidential information. If you
are not the intended recipient, any use, copying, disclosure, dissemination or
distribution is strictly prohibited. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this communication
and destroy all copies.

AVERTISSEMENT RELATIF À LA CONFIDENTIALITÉ
Ce message, ainsi que les pièces qui y sont jointes, est destiné à l’usage
exclusif de la personne à laquelle il s’adresse et peut contenir de
l’information personnelle ou confidentielle. Si le lecteur de ce message
n’en est pas le destinataire, nous l’avisons par la présente que toute
diffusion, distribution, reproduction ou utilisation de son contenu est
strictement interdite. Veuillez avertir sur-le-champ l’expéditeur par retour
de courrier électronique et supprimez ce message ainsi que toutes les pièces
jointes.

Free screen capture software ,
http://www.horizon33.weebly.com/ ,Limited Offer!.

I have Java 6 on my Windows 2003 server. i am getting 'microsoft
virtual machine not found" then a 'class not registered' error. I see
where the classpath may need to be registered but don't see anyplace to
put a classpath into my advanced, only the  generic 'path' statement.
Please advise. Thanks!
James Taylor
Operations Manager - CyberlinkASP

what happens when you run it against the executable?

I have this document:


Message-ID: <18782981.1075855378110.JavaMail.evans@thyme>
Date: Mon, 14 May 2001 16:39:00 -0700 (PDT)
From: phillip.allen@...
To: tim.belden@...
Subject:
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-From: Phillip K Allen
X-To: Tim Belden <Tim Belden/Enron@EnronXGate>
X-cc:
X-bcc:
X-Folder: \Phillip_Allen_Jan2002_1\Allen, Phillip K.\'Sent Mail
X-Origin: Allen-P
X-FileName: pallen (Non-Privileged).pst


(which will also contain some other content below that I'll need to
convert to XML, but I'm just focusing on this part for now)


and I'm trying to convert it to XML using this custom XFLAT Schema:


<?xml version='1.0'?>

<XFlat Name="email_schema" Description="Schema for email flat file">
     <SequenceDef Name="E-mail">


             <ChoiceDef Name="choice_of_one" MapToXml="No"
                        MinOccur="0" MaxOccur="15">

                 <RecordDef Name="Message-ID" RecSep="\N" MapToXml="No">
                     <FieldDef Name="label"
                               ValidValue="Message-ID:"
                               NullAllowed="No"
                               MapToXml="No"/>
                     <FieldDef Name="Message-ID"/>
                 </RecordDef>

                 <RecordDef Name="Date" RecSep="\N" MapToXml="No">
                     <FieldDef Name="label"
                               ValidValue="Date:"
                               NullAllowed="No"
                               MapToXml="No"/>
                     <FieldDef Name="Date"/>
                 </RecordDef>

                 <RecordDef Name="From" RecSep="\N" MapToXml="No">
                     <FieldDef Name="label"
                               ValidValue="From:"
                               NullAllowed="No"
                               MapToXml="No"/>
                     <FieldDef Name="From"/>
                 </RecordDef>

                 <RecordDef Name="To" RecSep="\N" MapToXml="No">
                     <FieldDef Name="label"
                               ValidValue="To:"
                               NullAllowed="No"
                               MapToXml="No"/>
                     <FieldDef Name="To"/>
                 </RecordDef>

                 <RecordDef Name="Subject" RecSep="\N" MapToXml="No">
                     <FieldDef Name="label"
                               ValidValue="Subject:"
                               NullAllowed="No"
                     <FieldDef Name="Subject"/>
                 </RecordDef>

                 <RecordDef Name="Mime-Version" RecSep="\N" MapToXml="No">
                     <FieldDef Name="label"
                               ValidValue="Mime-Version:"
                               NullAllowed="No"
                               MapToXml="No"/>
                     <FieldDef Name="Mime-Version"/>
                 </RecordDef>

                 <RecordDef Name="Content-Type" RecSep="\N" MapToXml="No">
                     <FieldDef Name="label"
                               ValidValue="Content-Type:"
                               NullAllowed="No"
                               MapToXml="No"/>
                     <FieldDef Name="Content-Type"/>
                 </RecordDef>

                 <RecordDef Name="Content-Transfer-Encoding"
RecSep="\N" MapToXml="No">
                     <FieldDef Name="label"
                               ValidValue="Content-Transfer-Encoding:"
                               NullAllowed="No"
                               MapToXml="No"/>
                     <FieldDef Name="Content-Transfer-Encoding"/>
                 </RecordDef>

                 <RecordDef Name="X-From" RecSep="\N" MapToXml="No">
                     <FieldDef Name="label"
                               ValidValue="X-From:"
                               NullAllowed="No"
                               MapToXml="No"/>
                     <FieldDef Name="X-From"/>
                 </RecordDef>

                 <RecordDef Name="X-To" RecSep="\N" MapToXml="No">
                     <FieldDef Name="label"
                               ValidValue="X-To:"
                               NullAllowed="No"
                               MapToXml="No"/>
                     <FieldDef Name="X-To"/>
                 </RecordDef>

                 <RecordDef Name="X-cc" RecSep="\N" MapToXml="No">
                     <FieldDef Name="label"
                               ValidValue="X-cc:"
                               NullAllowed="No"
                               MapToXml="No"/>
                     <FieldDef Name="X-cc"/>
                 </RecordDef>

                 <RecordDef Name="X-bcc" RecSep="\N" MapToXml="No">
                     <FieldDef Name="label"
                               ValidValue="X-bcc:"
                               NullAllowed="No"
                               MapToXml="No"/>
                     <FieldDef Name="X-bcc"/>
                 </RecordDef>

                 <RecordDef Name="X-Folder" RecSep="\N" MapToXml="No">
                     <FieldDef Name="label"
                               ValidValue="X-Folder:"
                               NullAllowed="No"
                               MapToXml="No"/>
                     <FieldDef Name="X-Folder"/>
                 </RecordDef>

                 <RecordDef Name="X-Origin" RecSep="\N" MapToXml="No">
                     <FieldDef Name="label"
                               ValidValue="X-Origin:"
                               NullAllowed="No"
                               MapToXml="No"/>
                     <FieldDef Name="X-Origin"/>
                 </RecordDef>

                 <RecordDef Name="X-FileName" RecSep="\N" MapToXml="No">
                     <FieldDef Name="label"
                               ValidValue="X-FileName:"
                               NullAllowed="No"
                               MapToXml="No"/>
                     <FieldDef Name="X-FileName"/>
                 </RecordDef>
             </ChoiceDef>
     </SequenceDef>
</XFlat>



Can someone tell me what I need to do, or what I'm doing wrong?


Thanks!

If i have 1,000-5,000 records in csv format , how do i convert it to
xml format/file, do i use the only available attributes?
Thanks

Hi,

I just downloaded the SW, but it keeps telling me that I need to read
the agreement, yet there's no checkbox to accept the terms. Is there
something that you have to manually edit to get the SW running?

Thanks
Dave

Licensed copy of XML Convert 2.2.
Copyright (C) 1999 - 2007 Unidex, Inc. All rights reserved.
You may use this software only if you have read the license agreement
and accept its terms.
For more information, please visit http://www.unidex.com/.

I do use it from command line ;

java xml2flat xxxx.xx xxx.xx


I use a .dtd to help set up the flatfile specification
The bigger issue is figuring out how to know when the file has
completed translating successfully because it has no error reporting ...

--- In xmlconvert@yahoogroups.com, "wquatan" <wquatan@...> wrote:
>
> HI,
>
> I have two questions :
>
> 1. Is it possible to use xmlconvert from command-line ?
> 2. I understood xmlconvert uses XFLAT for the flatfile specification,
> but is it possible to use a XSD to define the XML-layout ?
>
> Thanks
>

HI,

I have two questions :

1. Is it possible to use xmlconvert from command-line ?
2. I understood xmlconvert uses XFLAT for the flatfile specification,
but is it possible to use a XSD to define the XML-layout ?

Thanks

CASUAL BROWSING MAKES U EARNING









For more details please log on to

http://www.moreinfo247.com/9955758/CB

PLEASE COMPLETE THE FOUR STEPS TO STEP UP YOUR FUTURE

STEP 1.FILL THE FORM AND SIGN UP, NEXT WINDOW OPENS

STEP 2.CLICK THE PROCEED BUTTON AT THE END OF THE PAGE,

STEP 3.FILL YOUR PROFILE,SUBMIT

STEP 4.CONFIRM YOUR REGISTRATION

YOU CAN JOIN MEMBERS ONLY AFTER YOU  CONFIRM YOUR REGISTRATION
YOU will paid IN US$ for Each member joining under you.THEY ALSO SHOULD
CONFIRM  THEIR REGISTRATION .  FOR THIS You can use
free ads or yahoo groups to reach members as i reached you.Daily I am
posting in 50 groups,
and I am able to join at least 5 members a day. It is not hype I am
earning Y to wait
You cannot go wrong with this program. Do not delay in your
decision of accepting it as your full-time income. While you may not
become rich overnight, You WILL become independent

Further contact : please contact in my E-mail Gokilanr@...

NOTE: THIS MESSAGE IS SENT TO INTERESTED MEMBERS OF THE GROUP OTHERS
PLEASE IGNORE.

Hi:

I have a project where I need to export XML files in several formats
into a MySQL database. Would XML Convert be able to put the data into
a format that would be easily imported by MySQL?

Thanks!

Can any one tell me whether it is possible to convert XML to SAS
without SAS environment?

Hi Dominic.

Would you please upload the XML file?

Thanks.

Bob

--- In xmlconvert@yahoogroups.com, DVieira@... wrote:
>
> I'm wondering if someone can help.  I have binary data or unreadable
data
> in an xml field and I want to flatten the data to a flat file.  The
data is
> variable so i not do specify a min or max attribute however when I
run the
> exe i receive an error message indicating "Description:character not
> allowed".  I suspect the xmlconvert utility is validating that the
field is
> ascii, is there a way to turn this off?
>
> Dominic Vieira
> Symcor Inc.
>
> Ph:  905-273-1532
> Email: dvieira@...
>

I'm wondering if someone can help.  I have binary data or unreadable data
in an xml field and I want to flatten the data to a flat file.  The data is
variable so i not do specify a min or max attribute however when I run the
exe i receive an error message indicating "Description:character not
allowed".  I suspect the xmlconvert utility is validating that the field is
ascii, is there a way to turn this off?

Dominic Vieira
Symcor Inc.

Ph:  905-273-1532
Email: dvieira@...