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 |