Script To Convert Xml File To Csv
Required skills: CSV, XML, Conversion, Script, Programming
Hi,
I need a script that will convert xml files to csv format.
The budget for this is $ 10 to $ 30.
The xml files always have the same data format, and csv file always has the same column headers - only the records change for each file.
Each tag in the xml file needs to be the column header in the csv file.
Also change any of the records with the text in CAPITALS to just First Letter Capital Of Each Word Only.
In column headers, replace _ with a space " ". (shown in example below)
There will be some code for characters like & for the "&" sign - can you change it so the "&" sign shows in the csv. here is an example line of code from the xml file with that data:
<NATURE_OF_BUSINESS>RETAIL MEN'S & WOMEN'S CLOTHING AND ACCESSORIES</NATURE_OF_BUSINESS>
In the csv, the data for that line would be: Retail Men's & Women's Clothing And Accessories
The column header would be: Nature of Business
Size of xml file: 500kb to 50Mb
Sample of 2 records from xml file:
<G_FORMS>
<ORGANISATION_ID2>110404782</ORGANISATION_ID2>
<BUSNME_ID2>2166647</BUSNME_ID2>
<NAME>INTIME ON LAKE ST</NAME>
<ORGANISATION_NUM>BN21666477</ORGANISATION_NUM>
<REGISTRATION_START_DATE>17-JUN-10</REGISTRATION_START_DATE>
<COMMENCEMENT_DATE>14-JUN-10</COMMENCEMENT_DATE>
<NATURE_OF_BUSINESS>RETAIL MEN'S & WOMEN'S CLOTHING AND ACCESSORIES</NATURE_OF_BUSINESS>
<BQ1_RECEIVED>16-JUN-10</BQ1_RECEIVED>
<BQ1_FORM>BQ1A</BQ1_FORM>
<BQ1_EFFECTIVE></BQ1_EFFECTIVE>
<LIST_G_ADDRESS_ID>
</LIST_G_ADDRESS_ID>
<LIST_G_ROLE_ID>
<G_ROLE_ID>
<PROP_ROLE>7137026</PROP_ROLE>
<PROP_REPRESENTEE>JUDITH ANNE BEARD</PROP_REPRESENTEE>
<PROP_ADDRESS>2500548</PROP_ADDRESS>
<PROP_START>14-JUN-10</PROP_START>
<PROP_ORG>110404782</PROP_ORG>
<F_ADDRESS_PROP>0</F_ADDRESS_PROP>
<P_ADDRESS_PROPRIETOR>Started 14/06/2010 JUDITH ANNE BEARD at 33 MEGAN CLOSE FRESHWATER QLD 4870 </P_ADDRESS_PROPRIETOR>
</G_ROLE_ID>
</LIST_G_ROLE_ID>
<LIST_G_RES_ROLE>
</LIST_G_RES_ROLE>
<LIST_G_PPOB_ORGANISATION_ID>
<G_PPOB_ORGANISATION_ID>
<PPOB_ORGANISATION_ID>110404782</PPOB_ORGANISATION_ID>
<PPOB_ADDRESS_ID>13785941</PPOB_ADDRESS_ID>
<PPOB_START_DATE>14-JUN-10</PPOB_START_DATE>
<PPOB_END_DATE></PPOB_END_DATE>
<P_PPOB_ADDRESS>Started 14/06/2010 at 84 LAKE STREET CAIRNS QLD 4870 AUSTRALIA</P_PPOB_ADDRESS>
<F_PPOB_ADDRESS>0</F_PPOB_ADDRESS>
</G_PPOB_ORGANISATION_ID>
</LIST_G_PPOB_ORGANISATION_ID>
<LIST_G_EMAIL_ORGANISATION_ID>
</LIST_G_EMAIL_ORGANISATION_ID>
<LIST_G_ANZSIC_ACTIVITY_CODE>
</LIST_G_ANZSIC_ACTIVITY_CODE>
<CF_G_FORMS>1</CF_G_FORMS>
<P_NAME>BN21666477 INTIME ON LAKE ST</P_NAME>
<F_NAME>0</F_NAME>
</G_FORMS>
<G_FORMS>
<ORGANISATION_ID2>110404758</ORGANISATION_ID2>
<BUSNME_ID2>2166648</BUSNME_ID2>
<NAME>SMELLY MELLY DELI</NAME>
<ORGANISATION_NUM>BN21666489</ORGANISATION_NUM>
<REGISTRATION_START_DATE>17-JUN-10</REGISTRATION_START_DATE>
<COMMENCEMENT_DATE>02-JUL-10</COMMENCEMENT_DATE>
<NATURE_OF_BUSINESS>SELLING CHEESE AND ANTIPASTO</NATURE_OF_BUSINESS>
<BQ1_RECEIVED>16-JUN-10</BQ1_RECEIVED>
<BQ1_FORM>BQ1A</BQ1_FORM>
<BQ1_EFFECTIVE></BQ1_EFFECTIVE>
<LIST_G_ADDRESS_ID>
<G_ADDRESS_ID>
<OPOB_ADDRESS_ID>13785954</OPOB_ADDRESS_ID>
<OPOB_ORGANISATION_ID>110404758</OPOB_ORGANISATION_ID>
<OPOB_START_DATE>17-JUN-10</OPOB_START_DATE>
<F_OPOB_ADDRESS>0</F_OPOB_ADDRESS>
<P_OPOB_ADDRESS>Started 17/06/2010 at 57-89 GRAFTON STREET CAIRNS QLD 4870 AUSTRALIA</P_OPOB_ADDRESS>
</G_ADDRESS_ID>
</LIST_G_ADDRESS_ID>
<LIST_G_ROLE_ID>
<G_ROLE_ID>
<PROP_ROLE>7137028</PROP_ROLE>
<PROP_REPRESENTEE>MELISSA JODY MCTAVISH</PROP_REPRESENTEE>
<PROP_ADDRESS>13785950</PROP_ADDRESS>
<PROP_START>17-JUN-10</PROP_START>
<PROP_ORG>110404758</PROP_ORG>
<F_ADDRESS_PROP>0</F_ADDRESS_PROP>
<P_ADDRESS_PROPRIETOR>Started 17/06/2010 MELISSA JODY MCTAVISH at 454 SEVERIN STREET MANUNDA QLD 4870 AUSTRALIA</P_ADDRESS_PROPRIETOR>
</G_ROLE_ID>
</LIST_G_ROLE_ID>
<LIST_G_RES_ROLE>
</LIST_G_RES_ROLE>
<LIST_G_PPOB_ORGANISATION_ID>
<G_PPOB_ORGANISATION_ID>
<PPOB_ORGANISATION_ID>110404758</PPOB_ORGANISATION_ID>
<PPOB_ADDRESS_ID>13785951</PPOB_ADDRESS_ID>
<PPOB_START_DATE>17-JUN-10</PPOB_START_DATE>
<PPOB_END_DATE></PPOB_END_DATE>
<P_PPOB_ADDRESS>Started 17/06/2010 at 454 SEVERIN STREET MANUNDA QLD 4870 AUSTRALIA</P_PPOB_ADDRESS>
<F_PPOB_ADDRESS>0</F_PPOB_ADDRESS>
</G_PPOB_ORGANISATION_ID>
</LIST_G_PPOB_ORGANISATION_ID>
<LIST_G_EMAIL_ORGANISATION_ID>
</LIST_G_EMAIL_ORGANISATION_ID>
<LIST_G_ANZSIC_ACTIVITY_CODE>
</LIST_G_ANZSIC_ACTIVITY_CODE>
<CF_G_FORMS>1</CF_G_FORMS>
<P_NAME>BN21666489 SMELLY MELLY DELI</P_NAME>
<F_NAME>0</F_NAME>
</G_FORMS>
I need a script that will convert xml files to csv format.
The budget for this is $ 10 to $ 30.
The xml files always have the same data format, and csv file always has the same column headers - only the records change for each file.
Each tag in the xml file needs to be the column header in the csv file.
Also change any of the records with the text in CAPITALS to just First Letter Capital Of Each Word Only.
In column headers, replace _ with a space " ". (shown in example below)
There will be some code for characters like & for the "&" sign - can you change it so the "&" sign shows in the csv. here is an example line of code from the xml file with that data:
<NATURE_OF_BUSINESS>RETAIL MEN'S & WOMEN'S CLOTHING AND ACCESSORIES</NATURE_OF_BUSINESS>
In the csv, the data for that line would be: Retail Men's & Women's Clothing And Accessories
The column header would be: Nature of Business
Size of xml file: 500kb to 50Mb
Sample of 2 records from xml file:
<G_FORMS>
<ORGANISATION_ID2>110404782</ORGANISATION_ID2>
<BUSNME_ID2>2166647</BUSNME_ID2>
<NAME>INTIME ON LAKE ST</NAME>
<ORGANISATION_NUM>BN21666477</ORGANISATION_NUM>
<REGISTRATION_START_DATE>17-JUN-10</REGISTRATION_START_DATE>
<COMMENCEMENT_DATE>14-JUN-10</COMMENCEMENT_DATE>
<NATURE_OF_BUSINESS>RETAIL MEN'S & WOMEN'S CLOTHING AND ACCESSORIES</NATURE_OF_BUSINESS>
<BQ1_RECEIVED>16-JUN-10</BQ1_RECEIVED>
<BQ1_FORM>BQ1A</BQ1_FORM>
<BQ1_EFFECTIVE></BQ1_EFFECTIVE>
<LIST_G_ADDRESS_ID>
</LIST_G_ADDRESS_ID>
<LIST_G_ROLE_ID>
<G_ROLE_ID>
<PROP_ROLE>7137026</PROP_ROLE>
<PROP_REPRESENTEE>JUDITH ANNE BEARD</PROP_REPRESENTEE>
<PROP_ADDRESS>2500548</PROP_ADDRESS>
<PROP_START>14-JUN-10</PROP_START>
<PROP_ORG>110404782</PROP_ORG>
<F_ADDRESS_PROP>0</F_ADDRESS_PROP>
<P_ADDRESS_PROPRIETOR>Started 14/06/2010 JUDITH ANNE BEARD at 33 MEGAN CLOSE FRESHWATER QLD 4870 </P_ADDRESS_PROPRIETOR>
</G_ROLE_ID>
</LIST_G_ROLE_ID>
<LIST_G_RES_ROLE>
</LIST_G_RES_ROLE>
<LIST_G_PPOB_ORGANISATION_ID>
<G_PPOB_ORGANISATION_ID>
<PPOB_ORGANISATION_ID>110404782</PPOB_ORGANISATION_ID>
<PPOB_ADDRESS_ID>13785941</PPOB_ADDRESS_ID>
<PPOB_START_DATE>14-JUN-10</PPOB_START_DATE>
<PPOB_END_DATE></PPOB_END_DATE>
<P_PPOB_ADDRESS>Started 14/06/2010 at 84 LAKE STREET CAIRNS QLD 4870 AUSTRALIA</P_PPOB_ADDRESS>
<F_PPOB_ADDRESS>0</F_PPOB_ADDRESS>
</G_PPOB_ORGANISATION_ID>
</LIST_G_PPOB_ORGANISATION_ID>
<LIST_G_EMAIL_ORGANISATION_ID>
</LIST_G_EMAIL_ORGANISATION_ID>
<LIST_G_ANZSIC_ACTIVITY_CODE>
</LIST_G_ANZSIC_ACTIVITY_CODE>
<CF_G_FORMS>1</CF_G_FORMS>
<P_NAME>BN21666477 INTIME ON LAKE ST</P_NAME>
<F_NAME>0</F_NAME>
</G_FORMS>
<G_FORMS>
<ORGANISATION_ID2>110404758</ORGANISATION_ID2>
<BUSNME_ID2>2166648</BUSNME_ID2>
<NAME>SMELLY MELLY DELI</NAME>
<ORGANISATION_NUM>BN21666489</ORGANISATION_NUM>
<REGISTRATION_START_DATE>17-JUN-10</REGISTRATION_START_DATE>
<COMMENCEMENT_DATE>02-JUL-10</COMMENCEMENT_DATE>
<NATURE_OF_BUSINESS>SELLING CHEESE AND ANTIPASTO</NATURE_OF_BUSINESS>
<BQ1_RECEIVED>16-JUN-10</BQ1_RECEIVED>
<BQ1_FORM>BQ1A</BQ1_FORM>
<BQ1_EFFECTIVE></BQ1_EFFECTIVE>
<LIST_G_ADDRESS_ID>
<G_ADDRESS_ID>
<OPOB_ADDRESS_ID>13785954</OPOB_ADDRESS_ID>
<OPOB_ORGANISATION_ID>110404758</OPOB_ORGANISATION_ID>
<OPOB_START_DATE>17-JUN-10</OPOB_START_DATE>
<F_OPOB_ADDRESS>0</F_OPOB_ADDRESS>
<P_OPOB_ADDRESS>Started 17/06/2010 at 57-89 GRAFTON STREET CAIRNS QLD 4870 AUSTRALIA</P_OPOB_ADDRESS>
</G_ADDRESS_ID>
</LIST_G_ADDRESS_ID>
<LIST_G_ROLE_ID>
<G_ROLE_ID>
<PROP_ROLE>7137028</PROP_ROLE>
<PROP_REPRESENTEE>MELISSA JODY MCTAVISH</PROP_REPRESENTEE>
<PROP_ADDRESS>13785950</PROP_ADDRESS>
<PROP_START>17-JUN-10</PROP_START>
<PROP_ORG>110404758</PROP_ORG>
<F_ADDRESS_PROP>0</F_ADDRESS_PROP>
<P_ADDRESS_PROPRIETOR>Started 17/06/2010 MELISSA JODY MCTAVISH at 454 SEVERIN STREET MANUNDA QLD 4870 AUSTRALIA</P_ADDRESS_PROPRIETOR>
</G_ROLE_ID>
</LIST_G_ROLE_ID>
<LIST_G_RES_ROLE>
</LIST_G_RES_ROLE>
<LIST_G_PPOB_ORGANISATION_ID>
<G_PPOB_ORGANISATION_ID>
<PPOB_ORGANISATION_ID>110404758</PPOB_ORGANISATION_ID>
<PPOB_ADDRESS_ID>13785951</PPOB_ADDRESS_ID>
<PPOB_START_DATE>17-JUN-10</PPOB_START_DATE>
<PPOB_END_DATE></PPOB_END_DATE>
<P_PPOB_ADDRESS>Started 17/06/2010 at 454 SEVERIN STREET MANUNDA QLD 4870 AUSTRALIA</P_PPOB_ADDRESS>
<F_PPOB_ADDRESS>0</F_PPOB_ADDRESS>
</G_PPOB_ORGANISATION_ID>
</LIST_G_PPOB_ORGANISATION_ID>
<LIST_G_EMAIL_ORGANISATION_ID>
</LIST_G_EMAIL_ORGANISATION_ID>
<LIST_G_ANZSIC_ACTIVITY_CODE>
</LIST_G_ANZSIC_ACTIVITY_CODE>
<CF_G_FORMS>1</CF_G_FORMS>
<P_NAME>BN21666489 SMELLY MELLY DELI</P_NAME>
<F_NAME>0</F_NAME>
</G_FORMS>
Posted In:XMLProgramming |
Related projects:
Convert One File To Tableless
e HTML issue: (some site stats are on top of the pages but the move with another td that shows random quotes, it needs to be fixed.. you'll see what i mean when you start the project)
What You need:
You need to be able to convert the file to tableless, and must understand the php smarty template engine, so you know how it works.
This should be a quick project, probably wont take more than an hour to finish probably less though, since it's only one file.
What You need:
You need to be able to convert the file to tableless, and must understand the php smarty template engine, so you know how it works.
This should be a quick project, probably wont take more than an hour to finish probably less though, since it's only one file.
Convert TDB File to ASCII by munagapatiravi
Can anyone help with a program to convert .TDB file to ASCII format or a CSV file? I've attached a sample file, if not a program I could provide all the files if you can convert them into ASCII
Additional files submitted:
gpox.zip
Additional files submitted:
gpox.zip
Convert XML file to CSV format with headings
Additional files submitted: (Files are only available for logged in users)
PO_S90873146.xml
samplecsv.csv
Convert Xml File To Csv
Hi,
I have an xml file, and need to convert it to csv.
Also change any of the records with the text in CAPITALS to just First Letter Capital Of Each Word Only.
Looking for fast turnaround
I have an xml file, and need to convert it to csv.
Also change any of the records with the text in CAPITALS to just First Letter Capital Of Each Word Only.
Looking for fast turnaround
Convert XML file to CSV
y broken down into fields.
Thank you!
Additional files submitted: (Files are only available for logged in users)
Restaurant+Listing+Form.csv
Thank you!
Additional files submitted: (Files are only available for logged in users)
Restaurant+Listing+Form.csv
Xml-file To Mysql Php Script
a from a XML-File to 2 MySql Data Tables, written in PHP.
There are only 5 value for each record that i need from the XML-file. I will give you the key-names.
You must run some checks, if record already exists or not, create a new top-record and add some sub-records.
I think the work for the script will take about 2-3 hours.
I will send you the XML-File, the import description, the import rules and the table-structure.
There are only 5 value for each record that i need from the XML-file. I will give you the key-names.
You must run some checks, if record already exists or not, create a new top-record and add some sub-records.
I think the work for the script will take about 2-3 hours.
I will send you the XML-File, the import description, the import rules and the table-structure.
PHP Script to Convert XML 2 CSV Files
xample of the XML and CVS formats.
Additional files submitted: (Files are only available for logged in users)
Archive.zip
Additional files submitted: (Files are only available for logged in users)
Archive.zip
Convert Xml File To Sql File
i want to convert my xml file (17Mb) to sql file.
Convert Xml File To Amazon
Hi all.
I have 2 wholesalers that have XML Data feed they can provide me.
I'm am looking for a simple solution to convert my XML files to my Amazon Pro Merchant Account format so i can just convert the files like 1 a week and upload to Amazon.
So i need like a small script or program that will do that for me. Its easy to build it i think so.....
You need to know how to do it and maybe did it before. Please no games
I have 2 wholesalers that have XML Data feed they can provide me.
I'm am looking for a simple solution to convert my XML files to my Amazon Pro Merchant Account format so i can just convert the files like 1 a week and upload to Amazon.
So i need like a small script or program that will do that for me. Its easy to build it i think so.....
You need to know how to do it and maybe did it before. Please no games
Process to pull data out of XML file into CSV file by gil3000
rder #, order total, etc. This XML file is in a format assigned by the fulfillment house, so orders can be accepted by their system.
There is a second party that also needs a daily order summary sent, but this party requires a simplified version of the summary sent as a simple .csv (comma delimited) text file with 21 fields.
I need a windows-machine based process that can pull the relevant data out of the XML file and output a .csv file with that data.
There is a second party that also needs a daily order summary sent, but this party requires a simplified version of the summary sent as a simple .csv (comma delimited) text file with 21 fields.
I need a windows-machine based process that can pull the relevant data out of the XML file and output a .csv file with that data.
Program to convert excel file to XML
r>
Additional files submitted: (Files are only available for logged in users)
applet_demo_users.xlsx
applet_demo_xml.xml
Additional files submitted: (Files are only available for logged in users)
applet_demo_users.xlsx
applet_demo_xml.xml
Convert xml file/feed to a readable rss feeds by jpservicez
Dear programmers,
I have few xml files that i would like to convert to rss feeds..
here is a copy of the xml..
http://pf.tradedoubler.com/export/export?export=true&zip=true&a=989268&format=xml&programId=3431&pfId=3232
What am looking for is a small php code that can convert this file to rss feeds. I will now display this on my webpage..
Thanks
Joseph
http://www.shoppersbase.com
I have few xml files that i would like to convert to rss feeds..
here is a copy of the xml..
http://pf.tradedoubler.com/export/export?export=true&zip=true&a=989268&format=xml&programId=3431&pfId=3232
What am looking for is a small php code that can convert this file to rss feeds. I will now display this on my webpage..
Thanks
Joseph
http://www.shoppersbase.com
Python application that converts XML file to SQLite
work with big XML files like 1 GB or 5 GB.
- Every function, method, variable, loop etc. must have comments in the code.
Environment:
- The application must develop with Python.
- The application must be able to work under Sun Solaris OS (It has Python 2.4.6)
In order to develop application, sample XML and XSD files will be sending. We also send some tables that show an example of the final result that we expect.
- Every function, method, variable, loop etc. must have comments in the code.
Environment:
- The application must develop with Python.
- The application must be able to work under Sun Solaris OS (It has Python 2.4.6)
In order to develop application, sample XML and XSD files will be sending. We also send some tables that show an example of the final result that we expect.
Python application that converts XML file to Microsoft Acces
database file with "Door" and "Window" tags.
- You are expected to make it work with maximum performance and need to explain why you are choosing certain method.
- The application is expected to work with big XML files like 1 GB or 5 GB.
It must develop with Python.
- Every function, method, variable, loop etc. must have comments in the code.
In order to develop application, sample XML and XSD files will be sending.
- You are expected to make it work with maximum performance and need to explain why you are choosing certain method.
- The application is expected to work with big XML files like 1 GB or 5 GB.
It must develop with Python.
- Every function, method, variable, loop etc. must have comments in the code.
In order to develop application, sample XML and XSD files will be sending.
HTML5 Formular send XML file to server FTP
click on the submit button
5- the submit button will send a xml file to the FTP server
6-The XML file will have the same name of the ID field
7-The XML file have all the variabels fields
I use the FTP server like a DropBox, i will have all the XML files.
Each file XML will have the ID.Caption of the field.
PS: I dont have a Http server, and i dont have Mysql or others, just FTP Server.
Thanks :)
5- the submit button will send a xml file to the FTP server
6-The XML file will have the same name of the ID field
7-The XML file have all the variabels fields
I use the FTP server like a DropBox, i will have all the XML files.
Each file XML will have the ID.Caption of the field.
PS: I dont have a Http server, and i dont have Mysql or others, just FTP Server.
Thanks :)
I need a tool of XML file to word format
s" symbolic="yes" fixed-width="yes" bold="no" italic="no" font-size="12" font-color="#000000" rotation="0" angle="0" x="119.636" y="74.601" base="82.797" width="27.96" height="10.8">world</TOKEN>
</TEXT>
</PAGE>
</DOCUMENT>
</TEXT>
</PAGE>
</DOCUMENT>
Utility/script to convert ASCII string to BIN
from batch file that creates ASCII string 48-96 char long and saves it as a text file.
3 This utility/script reads the text file and creates .bin file. I other words .bin file
is a sring of hex equivalents of the ASCII string.
4 It should take name and path of the text file and the .bin file from the batch file.
Deliverables are the utility/script and well commented source code.
3 This utility/script reads the text file and creates .bin file. I other words .bin file
is a sring of hex equivalents of the ASCII string.
4 It should take name and path of the text file and the .bin file from the batch file.
Deliverables are the utility/script and well commented source code.
Convert Video file to Flash in perl by baobcs
I need a perl script to convert video file such as: avi,wmv.... to flash
Here is what the script do:
1. Read a video file on the server and capture 1 frame and save to server
2. Convert movie to Flash and save to the same directory
Here is what the script do:
1. Read a video file on the server and capture 1 frame and save to server
2. Convert movie to Flash and save to the same directory
Convert Pdf File To Text File
Convert pdf file to word document or text file. Here is a link to the pdf file:
https://www.scriptlance.com/f/?PKWW0D2H
PDF file need to be converted to text file or word document.
Convert flash file to HTML5 for mobile devices compatibility
Convert flash file to HTML5 for mobile devices compatibility
