Excel XML Spreadsheet Project

Færdiggjort Opslået Dec 13, 2009 Betalt ved levering
Færdiggjort Betalt ved levering

This is a very simple project that should not take more than a couple of hours.

In the attached .zip file, you will find 6 files, two of which are excel files and 4 of which are xml files. I need various things added in bulk to the columns in the excel files, and then I need those excel files transformed to XML files identical to the XML files also attached.

First, please open the two excel files. We'll begin with airport_code. Essentially, I am creating a search widget that is going to allow people to search for flights and hotels (all of the information is contained within the two excel files). 90% of the users who use this widget are going to be located in the United States... therefore, we are going to need to give the user the option to search "Domestic" or "International". If the user selects Domestic, it will ONLY give the rows under "airport_codes" that have "United States" under Column B and the rows under "hotel_city" that have "United States" under Column A. If the user selects "International", it will simply give ALL the results in both of the respective excel files.

So for the file [login to view URL], we are going to need to copy EVERY entry in the airport_codes excel file that has United States in Column B and create an excel file just for those entries. So we will have two excel files for flights, one of them with ONLY United States entries and one of them with ALL entries. Then, we are going to need to play with some of the entries in bulk to make sure that the entries in the XML file look exactly how we need for them to look in our widget. I would like for you to make all of these changes in the excel file and then also add them to the XML file similar to how the XML files are currently formatted.

Domestic Flights:

In the excel file, for domestic, the XML file for each row is going to need to be read like this: "Miami, FL (MIA) - Miami Intl". (Currently it reads "mia Miami FL Miami Intl" but this is not the way I would like it). Looking to the excel columns, this will be Column D, Column E, Column F, Column G for the Excel file. Also, to make sure the format is perfect, every entry in column D needs to have a comma and a space after it. Every entry in column E needs a space after it. Every entry in column F needs to be in CAPS with parenthesis around it followed by a space a dash and another space. Then column G can remain as-is. Once all of the entries in the excel file have been properly done, all of these entries must be added to an XML file identical to [login to view URL], with one row per line. Please send me both the newly created Excel file and newly updated XML file.

International Flights:

International flights is going to be VERY similar to Domestic Flights, but please replace Column E with Column C, and put a comma and space after the entries in Column C. So for domestic, the XML file for each row is going to need to be read like this: "Miami, US (MIA) - Miami Intl". Looking to the excel columns, this will be Column D, Column C, Column F, Column G for the Excel file, with all the same commas and whatnot that was added for domestic. Once all of the entries in the excel file have been properly done, all of these entries must be added to an XML file identical to [login to view URL], with one row per line. Please send me both the newly created Excel file and newly updated XML file.

No matter whether it is Domestic and International, the XML file has to be sorted in alphabetical order in by Column D. Column D (the city) is always going to be the first thing that is seen in each row in the XML files.

Hotels:

Hotels are very simple. First of all, open up hotel_city. Please copy every entry with "United States" in column C and paste them into their own Excel file. Then just convert Column D of the new file to an XML file named [login to view URL] (similar to the one attached) and then convert Column D of the Excel file with ALL cities (hotel_city) to an XML file named [login to view URL] similar to [login to view URL] attached. Please send me both the newly created Excel files and newly updated XML files.

VERY IMPORTANT: Everything need to be in alphabetical order based upon the first letter of the entry. You are probably going to need to make sure all of these are in order and double check what you have because it looks like the entries for the United States are in order based upon the state, so you need to make sure that it is in order solely by Column D.

This is a very simple project for anyone who knows the basics of this type of stuff. Please make sure you pay VERY close attention to what is asked because I don't have much time to ensure that everything is done perfectly.

Thanks!

Excel XML

Projekt ID: #570499

Om projektet

25 bud Remote projekt Aktiv Dec 14, 2009

Tildelt til:

mbro

please check your PM. thanks

$40 USD in 0 dage
(1 bedømmelse)
1.2

25 freelancere byder i gennemsnit $82 timen for dette job

srinichal

Solution will be provided and can pay me after a demo

$180 USD in 3 dage
(20 bedømmelser)
5.6
agihcam

Please check PMB.

$180 USD in 2 dage
(39 bedømmelser)
5.1
lucky2gaf

Hi, please view my PM for details, thanks.

$200 USD in 2 dage
(49 bedømmelser)
5.4
Naumaan

Please check PM

$30 USD på 1 dag
(8 bedømmelser)
3.6
counterpuncher

For your consideration...

$30 USD in 3 dage
(3 bedømmelser)
2.9
mcosgrove

Hi there, please check your PM - I've submitted my proposal. Regards, Michael

$30 USD in 0 dage
(1 bedømmelse)
1.0
yama1981

I have checked your requirements and can say this can done in 2 hours max once your say yes for me. Thanks, yama

$40 USD på 1 dag
(0 bedømmelser)
0.0
qwerty011

Hi, I am interested. Please check PM.

$60 USD på 1 dag
(0 bedømmelser)
0.0
prameelarani

I worked with this kind of projects which involves integrating excel with xml.

$200 USD in 2 dage
(0 bedømmelser)
0.0
$100 USD in 30 dage
(0 bedømmelser)
0.0
Sonir

I understand the demand, and am willing to do it. Regards,

$120 USD in 3 dage
(0 bedømmelser)
0.0
bhogal79

Hi Iam very much interested in your project and can deliver it on and before time

$30 USD på 1 dag
(0 bedømmelser)
0.0
luckyriya

i can do this work i have seen the details give me chance.

$61 USD in 6 dage
(0 bedømmelser)
0.0
injkiran

Hi! I am willing to provide desired best resutls with in a day with respect to details that you are going provide!

$120 USD in 0 dage
(0 bedømmelser)
0.0
futureshine

hi, I am professional in Excel and XML, let me do it for you plz.

$30 USD på 1 dag
(0 bedømmelser)
0.0
mohamedfarshad

I've been uploading files to different sites. Experienced in keeping files to website servers. Send me detailed info regarding the work.

$50 USD in 2 dage
(0 bedømmelser)
0.0
whitenet

Hi, I always maintain the required quality with required Time. Thanks.

$30 USD in 2 dage
(0 bedømmelser)
0.0
poojapatel22

Please check PMB for Details.

$150 USD in 3 dage
(0 bedømmelser)
0.0
surk89

Based on the project, i can make it cheap and fast.

$50 USD på 1 dag
(0 bedømmelser)
0.0
benjunya

Hi, Please review your PM for details of my bid. Thanks.

$30 USD på 1 dag
(0 bedømmelser)
0.0