DXL import problem

hcl-bot · June 26, 2003, 8:35am

Hello,

I was trying to create a form by DXL and then importing the file into a database. Reason is that we have to create an inputform of 1000 fields for some backend system. We don’t want get RSI, we don’t want to bore ourselves with Copy/Paste, we were not allowed to use HTML or XML, so bound by everything, we thought we could escape using DXL.

Everything went OK, until the moment of importing. I have overcome several problems, but the last one makes me desperate.

The error is: cannot convert text to a number.

But I don’t want to convert some place somewhere text into a number!? I don’t give any order for it.

When I import the file, I let my file be validated before reading, and I don’t get any error on that.

This is the code, which creates a tabbed table and some buttons in order to change the tabs.

<?xml version='1.0' encoding='UTF-8'?>

  <button name = 'Exploitatie kasstroom balans' type = 'normal' bgcolor='system' edge='rounded' wraptext='true' widthtype='fitcontent'>

    <font color='white' name='serif' style = 'normal' size='10pt'/>

    Exploitatie kasstroom balans

    <code event='click'>

      <formula>Field $CatName:='Exploitatie kasstroom balans';@Command([RefreshHideFormulas])</formula>

    </code>

  </button>

   <button name = 'Kredietbehoefte' type = 'normal' bgcolor='system' edge='rounded' wraptext='true' widthtype='fitcontent'>

     <font color='white' name='serif' style = 'normal' size='10pt'/>

     Kredietbehoefte

     <code event='click'>

       <formula>Field $CatName:='Kredietbehoefte';@Command([RefreshHideFormulas])</formula>

     </code>

    </button>

  <table htmlid='CatName' columnspacing='0.05in' rowspacing='0.05in' colorstyle='solid' leftmargin='1in' rowdisplay='compute' widthtype='fixedleft'>

     <tablecolumn width='6in'/>

     <tablerow name='Exploitatie kasstroom balans'>

        <tablecell>

           <block>

              <table columnspacing='0.05in' rowspacing='0.05in' colorstyle='solid' leftmargin='1in' rowdisplay='all' widthtype='fixedleft'>

                 <tablecolumn width='2.5in'/><tablecolumn width ='2in'/>

             <tablerow><tablecell><par>Omzet drank huidig</par></tablecell><tablecell><par><field kind='editable' type='number' name='ei0002'/></par></tablecell></tablerow>

             <tablerow><tablecell><par>Aflossing leningen  huidig</par></tablecell><tablecell><par><field kind='editable' type='number' name='ei0003'/></par></tablecell></tablerow>

             <tablerow><tablecell><par>Personeelskosten, totaal nieuw</par></tablecell><tablecell><par><field kind='editable' type='number' name='ei0004'/></par></tablecell></tablerow>

             <tablerow><tablecell><par>Inkoop drank via derden hinc </par></tablecell><tablecell><par><field kind='editable' type='number' name='ei0005'/></par></tablecell></tablerow>

             <tablerow><tablecell><par>Aantal m2 effectieve horecaruimte</par></tablecell><tablecell><par><field kind='editable' type='number' name='ei0006'/></par></tablecell></tablerow>

             <tablerow><tablecell><par>Verschil winst  HINC _ Nieuw _ 10</par></tablecell><tablecell><par><field kind='editable' type='text' name='ei0007'/></par></tablecell></tablerow>

             <tablerow><tablecell><par>Vrije cashflow</par></tablecell><tablecell><par><field kind='editable' type='number' name='ei0008'/></par></tablecell></tablerow>

             <tablerow><tablecell><par>Vrije cashflow _ 0</par></tablecell><tablecell><par><field kind='editable' type='text' name='ei0009'/></par></tablecell></tablerow>

             <tablerow><tablecell><par>Ondernemingsvorm</par></tablecell><tablecell><par><field kind='editable' type='text' name='ei0010'/></par></tablecell></tablerow>

              </table>

          </block>

      </tablecell>

    </tablerow>

    <tablerow name='Kredietbehoefte'>

       <tablecell>

          <block>

             <table columnspacing='0.05in' rowspacing='0.05in' colorstyle='solid' leftmargin='1in' rowdisplay='all' widthtype='fixedleft'>

                 <tablecolumn width='2.5in'/><tablecolumn width ='2in'/>

                 <tablerow><tablecell><par>Koopsom goodwill</par></tablecell><tablecell><par><field kind='editable' type='number' name='ei0012'/></par></tablecell></tablerow>

             <tablerow><tablecell><par>Koopsom overig bedrijf</par></tablecell><tablecell><par><field kind='editable' type='number' name='ei0013'/></par></tablecell></tablerow>

             <tablerow><tablecell><par>Saldo bestaande AL</par></tablecell><tablecell><par><field kind='editable' type='number' name='ei0014'/></par></tablecell></tablerow>

             <tablerow><tablecell><par>wordt saldo verrekend met nieuwe financiering</par></tablecell><tablecell><par><field kind='editable' type='text' name='ei0015'/></par></tablecell></tablerow>

             <tablerow><tablecell><par>Saldo overige schulden</par></tablecell><tablecell><par><field kind='editable' type='text' name='ei0016'/></par></tablecell></tablerow>

             <tablerow><tablecell><par>verstrekker</par></tablecell><tablecell><par><field kind='editable' type='text' name='ei0017'/></par></tablecell></tablerow>

             <tablerow><tablecell><par>wordt saldo verrekend met nieuwe financiering</par></tablecell><tablecell><par><field kind='editable' type='text' name='ei0018'/></par></tablecell></tablerow>

              </table>

            </block>

       </tablecell>

     </tablerow>

   </table>

Could someone please help me…

THANKS IN ADVANCE

Loek Bergman

hcl-bot · June 27, 2003, 4:58am

Subject: DXL import problem

The first problem is the 1.0.1 as version. It can’t convert that to a number, I replaced it with 6. Then you get the error ‘unknown DXL class library error’ - very helpful.If you reduce it to the following it runs without error (I simply cut out all but the last table section) so you will have to build it up slowly from there.

<?xml version='1.0' encoding='UTF-8'?>

Koopsom goodwill

Koopsom overig bedrijf

Saldo bestaande AL

wordt saldo verrekend met nieuwe financiering

Saldo overige schulden

verstrekker

wordt saldo verrekend met nieuwe financiering

hcl-bot · June 27, 2003, 9:53am

Subject: RE: DXL import problem

Hello Haydn,

You’re great!

It works now.

I copied/paste all parts into a new file and it worked. Wow, I would never have guessed the versionnumber, because that is one of the few pieces of data I got from code which ought to work.

Thank you very much,

Have a nice weekend, just like I will have.

Greetings,

Loek

hcl-bot · June 26, 2003, 11:32pm

Subject: DXL import problem

I think your problem is caused by the fact that you have HTML tags inside the DXL document. The XML parser comes across these HTML tags and will not know what to do with them.

I think you need to use something like CDATA to prevent the XML parser from reading the HTML.

This link might help:

http://www.w3schools.com/xml/xml_cdata.asp

hcl-bot · June 27, 2003, 6:03am

Subject: RE: DXL import problem

Hi Kieren,

Thank you for your response.

I looked at your link and CDATA is indeed an option for at least the labels I have to use.

There are a lots of ‘>’ in them.

I tested the DXL in XML Trace Editor and that program didn’t have any problem with the code itself. The tags want be the problem.

Thanks for your link, I put it immediately in my favorites.

With kind regards,

Loek Bergman