FROM XML TO DBF

[tomtagaris]

I have e file xls
How can I extract its contents and pass them to a DBF file
Thanks for help

[HGAutomator]

Hi Tom,

I searched around for xml to dbf code, but so far could only find a dbf_to_xml routine.

I used the commercial CoolUtils XML converter, to generate the attached.

[HGAutomator]

Also this, from WhiteRock software. It's a single dbf as opposed to several in the last sample.

It looks like there are some string conversion problems, perhaps related to Unicode.

[Claudio Ricardo]

Hi... Try open with LibreOffice Calc (Similar to MsOffice Excel but open source and free !)
fix column width, and save to " dBase .dbf " I always do it, never fail !

[dragancesu]

XML is an interesting format, basically an TXT file that you read as text
but you can see the structure in it, in this case the record is INVOICE

Code: Select all

    <invoice>
      <uid>767DE28C469B8930A2262FC9660FBC93E5E6CB08</uid>
      <mark>400000000090274</mark>
      <issuer>
        <vatNumber>300950992</vatNumber>
        <country>GR</country>
        <branch>0</branch>
      </issuer>
      <counterpart>
        <vatNumber>029690710</vatNumber>
        <country>GR</country>
        <branch>0</branch>
        <address>
          <postalCode>25001</postalCode>
          <city>ΚΑΛΑΒΡΥΤΑ</city>
        </address>
      </counterpart>
      <invoiceHeader>
        <series>0</series>
        <aa>7465</aa>
        <issueDate>2020-10-11</issueDate>
        <invoiceType>1.1</invoiceType>
        <vatPaymentSuspension>false</vatPaymentSuspension>
        <currency>EUR</currency>
        <movePurpose>1</movePurpose>
      </invoiceHeader>
      <paymentMethods>
        <paymentMethodDetails>
          <type>5</type>
          <amount>0</amount>
        </paymentMethodDetails>
      </paymentMethods>
      <invoiceDetails>
        <lineNumber>1</lineNumber>
        <netValue>96.6</netValue>
        <vatCategory>2</vatCategory>
        <vatAmount>12.56</vatAmount>
      </invoiceDetails>
      <invoiceSummary>
        <totalNetValue>96.6</totalNetValue>
        <totalVatAmount>12.56</totalVatAmount>
        <totalWithheldAmount>0</totalWithheldAmount>
        <totalFeesAmount>0</totalFeesAmount>
        <totalStampDutyAmount>0</totalStampDutyAmount>
        <totalOtherTaxesAmount>0</totalOtherTaxesAmount>
        <totalDeductionsAmount>0</totalDeductionsAmount>
        <totalGrossValue>109.16</totalGrossValue>
      </invoiceSummary>
    </invoice>

notepad++ displays xml nicely

the problem is that the tags are long and the dbf fields are limited to 10 characters
I think it is not difficult to write a program that will write this data into the appropriate structure

[IMATECH]

hb_mxml ! read and write XML files


https://groups.google.com/g/harbour-use ... zLOPY6AQAJ

[edk]

See this tool:

XmlToPrg.7z

(3.09 KiB) Downloaded 138 times

You can generate a prg which can be helpful for parsing the xml and writing the read data to the DBF.
You can also put the read data in an array and then process its contents.
Your sample xml file contains 999 invoices, but I "don't like" the Greek city and street names written in it. The xml file is declared as UTF-8, but Greek letters appear strangely for me.

greek utf8.png (82.88 KiB) Viewed 5114 times

[AUGE_OHR]

hi,

hb_mxml ! read and write XML files

is hbmxml avaiable for HMG

i did found hbmxml.LIB but that is for BCC or MSVC

[IMATECH]

for sure:

sources
c:\hmg\harbour\contrib\hbmxml

lib
c:\hmg\harbour\lib\libhbmxml

[AUGE_OHR]

hi

lib
c:\hmg\harbour\lib\libhbmxml

found it, thx