I need 3 large XML files converting to Excel and delivering via drop box etc
- or -
Post a project like this2198
$$
- Posted:
- Proposals: 3
- Remote
- #1943660
- Awarded
Description
Experience Level: Intermediate
I need 4 XML files converting into CSV or Excel for using in Excel. Each file is 500k lines or less, but unzipped is quite large (400mb), as such, it is difficult to import using the standard Excel functionality without having a better computer.
In basic summary:
I need each of these 4 files downloading from the following website:
http://firds.esma.europa.eu/firds/FULINS_D_20180310_01of04.zip
http://firds.esma.europa.eu/firds/FULINS_D_20180310_02of04.zip
http://firds.esma.europa.eu/firds/FULINS_D_20180310_03of04.zip
http://firds.esma.europa.eu/firds/FULINS_D_20180310_04of04.zip
They are c.15mb each and then need to be unziped. Unzipped they will be 400mb and 500,000 lines.
Each unzipped xml needs to then be converted to MS Excel/CSV.
I have done this as an example for file 4of4 (as this is a much smaller file), please find attached. However, using just regular MS Office Excel on a standard PC limits me from doing the same for the larger files 1of4 to 3of4 - due to memory constraints. If an alternative is simple, and the data retains its parent/child structure then I am happy for any different tool to ingest the data to be used.
Happy to answer any technical questions.
I am looking for someone to set out i) the time needed ii) the indicative price and iii) include delivery by dropbox/etc.
I will need this job doing within 24 hours, and the quickest to deliver a satisfactory submission will receive the job.
Thanks in advance for reviewing. Will
In basic summary:
I need each of these 4 files downloading from the following website:
http://firds.esma.europa.eu/firds/FULINS_D_20180310_01of04.zip
http://firds.esma.europa.eu/firds/FULINS_D_20180310_02of04.zip
http://firds.esma.europa.eu/firds/FULINS_D_20180310_03of04.zip
http://firds.esma.europa.eu/firds/FULINS_D_20180310_04of04.zip
They are c.15mb each and then need to be unziped. Unzipped they will be 400mb and 500,000 lines.
Each unzipped xml needs to then be converted to MS Excel/CSV.
I have done this as an example for file 4of4 (as this is a much smaller file), please find attached. However, using just regular MS Office Excel on a standard PC limits me from doing the same for the larger files 1of4 to 3of4 - due to memory constraints. If an alternative is simple, and the data retains its parent/child structure then I am happy for any different tool to ingest the data to be used.
Happy to answer any technical questions.
I am looking for someone to set out i) the time needed ii) the indicative price and iii) include delivery by dropbox/etc.
I will need this job doing within 24 hours, and the quickest to deliver a satisfactory submission will receive the job.
Thanks in advance for reviewing. Will
Will R.
100% (3)Projects Completed
3
Freelancers worked with
3
Projects awarded
67%
Last project
17 Nov 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies