Convert Excel to custom XML

Ukończone Opublikowano Dec 13, 2006 Płatność przy odbiorze
Ukończone Płatność przy odbiorze

Here is what we are trying to do: Often times we need to import shippments into our MIS system wich is running SQL 2000. There can be hundreds of planned shippments. Current work on this for a customer that is going to have 1800 planned shipments. I spoke with our MIS company and they said yes it can be done however the excel file needs to be formatted into a specific form of XML. So essentially the program would look at the field header of the excel document (Display on one side), show a list of fields available in planed shipments then allow you to map one to the other and format it using XML encoding that I have its a pretty simple format. But I need a vehical that is simple that I can get any of the Office people here to use here.

**Here is a sample of one record:**

___________________________________________

60543

**1**

**1500**

**Wells Real Estate**

**6200 The Corners Pkwy**

**Atlanta**

**GA**

**30092**

**7702438226**

_____________________________________

**I will provide a list of available field to import into there is about 28 possible field.? not all will be used, on every record.**

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):

a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

* * *This broadcast message was sent to all bidders on Thursday Dec 14, 2006 7:22:28 AM:

Thank you all for you comments. This was my first posting. I have now included some sample files. Sorry about that.

The result of this program would be an XML file. I can then go inside MIS program and they have their own import utility. I just need the files formatted correctly.

Let me know if there is any other questions.

Thanks to all, This site will be a good resource.

Cory

## Platform

Windows XP is fine would be nice to run on bost Mac and PC but not a big deal.

PHP XML

Numer ID Projektu: #3959464

O projekcie

31 ofert Zdalny projekt Aktywny Dec 14, 2006

Przyznany użytkownikowi:

terrybalcom

See private message.

$212.5 USD w ciągu 3 dni
(19 ocen)
5.4

31 freelancerów złożyło ofertę za $141 w tym projekcie

pr0digysl

See private message.

$255 USD w ciągu 3 dni
(168 Oceny)
10.0
sharckuletz

See private message.

$212.5 USD w ciągu 3 dni
(96 Oceny)
6.4
schandraram

See private message.

$191.25 USD w ciągu 3 dni
(125 Oceny)
6.7
indyprof

See private message.

$21.25 USD w ciągu 3 dni
(119 Oceny)
6.1
shibaevv

See private message.

$212.5 USD w ciągu 3 dni
(16 Oceny)
6.1
Eyedevelop

See private message.

$93.5 USD w ciągu 3 dni
(81 Oceny)
5.8
ravitejasudhee

See private message.

$170 USD w ciągu 3 dni
(48 Oceny)
5.4
brianstanek

See private message.

$255 USD w ciągu 3 dni
(52 Oceny)
5.5
LongTermCoder

See private message.

$212.5 USD w ciągu 3 dni
(7 Oceny)
4.6
sistemsl

See private message.

$68 USD w ciągu 3 dni
(36 Oceny)
4.6
felixrii

See private message.

$238 USD w ciągu 3 dni
(19 Oceny)
4.8
klarakarl

See private message.

$127.5 USD w ciągu 3 dni
(15 Oceny)
4.3
systemautom

See private message.

$127.5 USD w ciągu 3 dni
(20 Oceny)
4.5
CarlR

See private message.

$72.25 USD w ciągu 3 dni
(50 Oceny)
4.5
dennisgrant

See private message.

$170 USD w ciągu 3 dni
(7 Oceny)
4.2
indrasyafruddin

See private message.

$127.5 USD w ciągu 3 dni
(6 Oceny)
3.7
CoDecode

See private message.

$153 USD w ciągu 3 dni
(14 Oceny)
3.6
shaon007

See private message.

$127.5 USD w ciągu 3 dni
(14 Oceny)
3.7
freelancecoderz

See private message.

$42.5 USD w ciągu 3 dni
(20 Oceny)
3.2
rosamvw

See private message.

$85 USD w ciągu 3 dni
(4 Oceny)
2.6