Global Price list tool

This project builds from two small phases:

Phase one base on win32 application that get CSV file with my company price list and convert it to xml file base on schema that I will provide.

Phase two bases on win32 application that use the xml file and display it in treeview with some number manipulation.


the file is Global price list.

it build like this :


Cisco Clean Access,,,,,
,Cisco Clean Access (CCA) Server,,,,
,,CCA-100-SM-BUN-K9,NAC App-Clean Access Svr+Mgr SW Bundle -max 100 users,S,"$5,995"
,,CCA-MGR-FB-K9,NAC App-Clean Access Mgr SW Failover -max 20 Servers,S,"$22,995"
,,CCA-MGR-K9,NAC App-Clean Access Mgr SW -max 20 Servers,S,"$14,995"
,,CCA-MGR-LT-FB-K9,NAC App-Clean Access Mgr Lite SW Failover -max 3 Servers,S,"$7,995"
,,CCA-SVR-500UL-K9,NAC Appliance-Server License Upgrade (500-1500 users),S,"$15,995"
,,CCA-SVR-FB-K9,NAC Appliance-Clean Access Server SW Failover Bun (1500),S,"$52,995"
,,CCA-SVR-K9,NAC Appliance-Clean Access Server SW (1500users),S,"$34,995"
Cisco Wide Area Application Engine (WAE),,,,,
,Cisco File and Wide Area Application Engine Products,,,,
,,WAE-512-K9,"Wide Area Application Engine 512, 1GB MEM, No HDD Incl.",C,"$5,200"
,,WAE-612-K9,"Wide Area Application Engine 612, 2GB MEM, No HDD Incl.",C,"$11,000"
,,WAE-7326-K9,"Wide Area Application Engine 7326, 4GB MEM, No HDD Incl.",N/A,"$36,000"
,,WAE-7341-K9,"Wide Area Application Engine 7341 12GB RAM, HDD Incl",C,"$53,000"
,,WAE-7371-K9,"Wide Area Application Engine 7371 24GB RAM, HDD Incl",C,"$129,000"
,System Bundles,,,,
,,SE512-IPROXY-K9,"Security / iProxy WAE-512 bundle, 1GB MEM, No HDD Incl.",D,"$5,200"
,,SE612-IPROXY-K9,"Security / iProxy WAE-612 bundle, 2GB MEM, No HDD Incl.",D,"$11,000"
,,SE7326-IPROXY-K9,"Security / iProxy WAE-7326 bundle, 4GB MEM, No HDD Incl.",D,"$36,000"
,Cisco File Engine Software Options,,,,


I need it be output like this

<Cisco Clean Access>
<Cisco Clean Access (CCA) Server>
<Product>
<ID>CCA-100-SM-BUN-K9</ID>
<Description>NAC App-Clean Access Svr+Mgr SW Bundle -max 100 users</Description>
<Service>S</Service>
<Price>$5,995<Price>
</Product>
<Product>
<ID>CCA-MGR-FB-K9</ID>
<Description>NAC App-Clean Access Mgr SW Failover -max 20 Servers</Description>
<Service>S</Service>
<Price>7,995<Price>
</Product>
</Cisco Clean Access (CCA) Server>
</Cisco Clean Access>

<Cisco Wide Area Application Engine (WAE)>
<Cisco File and Wide Area Application Engine Products>
<Product>
<ID>WAE-512-K9</ID>
<Description>Wide Area Application Engine 512, 1GB MEM, No HDD Incl.</Description>
<Service>C</Service>
<Price>$5,200<Price>
</Product>
.
.
.

</Cisco File and Wide Area Application Engine Products>
<System Bundles>
<Product>
<ID>SE512-IPROXY-K9</ID>
<Description>Security / iProxy WAE-512 bundle, 1GB MEM, No HDD Incl.</Description>
<Service>DC</Service>
<Price>$5,200<Price>
</Product>
.
.
.
</System Bundles>
</Cisco Wide Area Application Engine (WAE)>


The field in the CSV file are Main, Sub, Product, Description, Service , price....

The app should have select file dialogue box that get the csv file and dialogue box to save the xml file.