Question

Asked on 2007-12-23 at 19:57:37ID: 25011760

How to convert XML to .dbf format (visual foxpro)

by: cncuong250

Rating9.0Excellent

Hi experts,
I would like to convert XML into .dbf table (visual foxpro format). Here is XML (quite long) :

<?xml version="1.0" encoding="UTF-8" ?>
- <IPDRDoc xmlns="http://www.ipdr.org/namespaces/ipdr" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="DOCSIS-3.5-A.0.xsd" docId="CB17325E-0000-0000-0000-001B8FEC7001" creationTime="2007-12-22T13:51:10Z" IPDRRecorderInfo="SCTV_Q6_C7246.sctv.com.vn" version="3.5-A.0">
- <IPDR xsi:type="DOCSIS-Type">
  <IPDRcreationTime>2007-12-22T13:51:10Z</IPDRcreationTime>
  <CMTShostname>SCTV_Q6_C7246.sctv.com.vn</CMTShostname>
  <CMTSipAddress>10.0.96.1</CMTSipAddress>
  <CMTSsysUpTime>8559983</CMTSsysUpTime>
  <CMTScatvIfName>Cable3/0</CMTScatvIfName>
  <CMTScatvIfIndex>4</CMTScatvIfIndex>
  <CMTSupIfName>Ca3/0-upstream3</CMTSupIfName>
  <CMTSupIfType>129</CMTSupIfType>
  <CMTSdownIfName>Ca3/0-downstream</CMTSdownIfName>
  <CMmacAddress>00-0E-09-1F-A4-55</CMmacAddress>
  <CMipAddress>10.0.98.14</CMipAddress>
  <CMdocsisMode>1.1</CMdocsisMode>
  <CMCPEipAddress>222.255.213.243</CMCPEipAddress>
  <Rectype>1</Rectype>
  <serviceIdentifier>87</serviceIdentifier>
  <serviceClassName />
  <serviceDirection>2</serviceDirection>
  <serviceOctetsPassed>21905</serviceOctetsPassed>
  <servicePktsPassed>191</servicePktsPassed>
  <serviceSlaDropPkts>0</serviceSlaDropPkts>
  <serviceSlaDelayPkts>0</serviceSlaDelayPkts>
  <serviceTimeCreated>8425000</serviceTimeCreated>
  <serviceTimeActive>1347</serviceTimeActive>
  </IPDR>
- <IPDR xsi:type="DOCSIS-Type">
  <IPDRcreationTime>2007-12-22T13:51:10Z</IPDRcreationTime>
  <CMTShostname>SCTV_Q6_C7246.sctv.com.vn</CMTShostname>
  <CMTSipAddress>10.0.96.1</CMTSipAddress>
  <CMTSsysUpTime>8559983</CMTSsysUpTime>
  <CMTScatvIfName>Cable3/0</CMTScatvIfName>
  <CMTScatvIfIndex>4</CMTScatvIfIndex>
  <CMTSupIfName>Ca3/0-upstream3</CMTSupIfName>
  <CMTSupIfType>129</CMTSupIfType>
  <CMTSdownIfName>Ca3/0-downstream</CMTSdownIfName>
  <CMmacAddress>00-0E-09-1F-A4-55</CMmacAddress>
  <CMipAddress>10.0.98.14</CMipAddress>
  <CMdocsisMode>1.1</CMdocsisMode>
  <CMCPEipAddress>222.255.213.243</CMCPEipAddress>
  <Rectype>1</Rectype>
  <serviceIdentifier>88</serviceIdentifier>
  <serviceClassName />
  <serviceDirection>1</serviceDirection>
  <serviceOctetsPassed>38197</serviceOctetsPassed>
  <servicePktsPassed>183</servicePktsPassed>
  <serviceSlaDropPkts>0</serviceSlaDropPkts>
  <serviceSlaDelayPkts>0</serviceSlaDelayPkts>
  <serviceTimeCreated>8425000</serviceTimeCreated>
  <serviceTimeActive>1347</serviceTimeActive>
  </IPDR>

I am using visual fox 7.0.
Thank you in advance.

Related Solutions

Solution

Access this solution immediately by signing up as a member of FoxproAnswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.

About this Solution
Sign up Now to View This Solution
Zone
general
Tags
foxpro visual xml convert dbf
Participating Experts
1
Solution Grade
B

Replies

 by: CaptainCyril

Posted on 2007-12-24 at 01:47:26ID: 26150281

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: cncuong

Posted on 2007-12-24 at 19:11:42ID: 26150282

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: CaptainCyril

Posted on 2007-12-25 at 01:00:07ID: 26150283

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Log In

Forgot your password?Sign up

Top Experts

  1. pcelba

    4,240

    0 points yesterday

    Profile
  2. mozner

    2,000

    0 points yesterday

    Profile
  3. mbarbir

    1,912

    0 points yesterday

    Profile
  4. jrbbldr

    1,500

    0 points yesterday

    Profile

BrowseAre you an Expert?