Search for project

More than 2000 projects issued through our platform and this
amount increases very fast.

Translating Microsoft Access database table into XML (ID:1999)

Project Creator: Teutonic
FC Member For 6569 Days
Credits 20
Completed Proj. Num. 0 / 1
Total payment USD
Avg Daily Online
0.00 h (From 21/5/2007)
Available on MSN/Skype No
Last Login 3/4/2007
Peers Rating 0.00%
      
Budget: Less than 250
Created: 3/2/2007 8:31:50 PM EST
Bidding Ends: 3/5/2007 8:31:50 PM EST
( Expired )
Development Cycle: 7 Days
Bid Count: 14
Average Bid: 391.43  
Project Description:

I am seeking somebody to develop a method for translating a Microsoft Access database table into XML.

The Access table is a single table and represents a hierarchical tree structure. The following example illustrates the table format :

NodeID  NodeLevel  NodeOrder  NodeParentID  NodeCode  NodeName
1  0    1        FOO    Food
2  1    1    1    FRU    Fruit
3  2    1    2    APL    Apple
4  2    2    2    PEA    Pear
5  2    3    2    CHE    Cherry
6  1    2    1    VEG    Vegetable
7  2    1    6    BRO    Brocolli
8  2    2    6    CAR    Carrot


The XML file should, be a tree structure and look as follows...

<Node>
  <NodeID>1</NodeID>
  <NodeLevel>0</NodeLevel>
  <NodeOrder>1</NodeOrder>
  <NodeParentID></NodeParentID>
  <NodeCode>FOO</NodeCode>
  <NodeName>Food</NodeName>
  <Node>
    <NodeID>2</NodeID>
    <NodeLevel>1</NodeLevel>
    <NodeOrder>1</NodeOrder>
    <NodeParentID>1</NodeParentID>
    <NodeCode>FRU</NodeCode>
    <NodeName>Fruit</NodeName>
    <Node>
      <NodeID>3</NodeID>
      <NodeLevel>2</NodeLevel>
      <NodeOrder>1</NodeOrder>
      <NodeParentID>2</NodeParentID>
      <NodeCode>APL</NodeCode>
      <NodeName>Apple</NodeName>
    </Node>  
    <Node>
      <NodeID>4</NodeID>
      <NodeLevel>2</NodeLevel>
      <NodeOrder>2</NodeOrder>
      <NodeParentID>2</NodeParentID>
      <NodeCode>PEA</NodeCode>
      <NodeName>Pear</NodeName>
    </Node>  
    <Node>
      <NodeID>6</NodeID>
      <NodeLevel>1</NodeLevel>
      <NodeOrder>2</NodeOrder>
      <NodeParentID>1</NodeParentID>
      <NodeCode>VEG</NodeCode>
      <NodeName>Vegetable</NodeName>
    </Node>  
  </Node>
  <Node>
    <NodeID>2</NodeID>
    <NodeLevel>1</NodeLevel>
    <NodeOrder>1</NodeOrder>
    <NodeParentID>1</NodeParentID>
    <NodeCode>FRU</NodeCode>
    <NodeName>Fruit</NodeName>  
    <Node>
      <NodeID>7</NodeID>
      <NodeLevel>2</NodeLevel>
      <NodeOrder>1</NodeOrder>
      <NodeParentID>6</NodeParentID>
      <NodeCode>BRO</NodeCode>
      <NodeName>Brocolli</NodeName>
    </Node>  
    <Node>
      <NodeID>8</NodeID>
      <NodeLevel>2</NodeLevel>
      <NodeOrder>2</NodeOrder>
      <NodeParentID>6</NodeParentID>
      <NodeCode>CAR</NodeCode>
      <NodeName>Carrot</NodeName>
    </Node>  
  </Node>
</Node>


The above is only a small sample project. Depending on the success we have with this, we will consider posting more and larger projects in the future.



Job Type Visual Basic 
Attached Files: 20070302202913.txt

Bids placed

(There are 14 bids on this project, these are listed below)
 
Contact*:
Email*:
Telephone:
(Include country code)
Enquiry*