Data Transformation and Import

Ukończone Opublikowano Aug 31, 2010 Płatność przy odbiorze
Ukończone Płatność przy odbiorze

Develop a batch application in language of choice which can be installed/run on Windows XP, NT, Vista, 7 operating systems which can load, transform, merge, import customer flat file format product data into our proprietary format and the post to our server for import. Detailed mapping/import rules will be provided for both customer data format and our format. The task will involve the following actions:

1) retrieve product data from our web services publishing system (via http api calls)

2) load into local memory

3) load customer data from single format local flat file (xls spreadsheet) and convert to our data structure.

4) create/update/delete data loaded from our server with updates from customer file

5) post updates to our server (http api calls)

6) create detailed import report

7) post import notes/comments to our system (http api call)

The application/utility should be launchable via a batch/command file with appropriate arguments including customer id, local customer import file name, working directory for reports, downloaded data files from our servers, etc.

Detailed mapping, transformation rules, and reporting requirements will be provided in full specification.

A proprietary language scripting function will also be provided which implements the majority of requirements in this task. This script will be extremely valuable for reference in understanding various api calls to our system, mapping details, etc. We strongly recommend that this script be translated into the language of your choice as a starting point for this job since it implements approximately 60-70% of the full requirements for this project.

Our basic publishing system data structure and communication with our api is documented on our web site in the following articles/pages.

[login to view URL]

[login to view URL]

[login to view URL]

In addition to the above defined structure, this project will also require use of several import files which allow customers to define classification hierarchies and related item details. The flat file (tab-delimited) structure of each of these files will be provided in the full project specification as required.

## Deliverables

Please find attached a zip file containing

1) Customer data file saved to tab-delimited text format ([login to view URL])

2) Excel mapping and report specifications from the customer on how to interpret their spreadsheet data file (Converter Tool Requirements Addendum(4-08-10).xls)

3) Simple Catalog-On-Demand web services import format ([login to view URL]) - Note that project will require loading and creating this basic structure along with 2-3 other flat files for classification hierarchy and related items information.

Inżynieria Microsoft Zarządzanie projektem Instalowanie skryptów Shell Script Architektura oprogramowania Testowanie oprogramowania Pulpit systemu Windows

Numer ID Projektu: #3691724

O projekcie

23 ofert Zdalny projekt Aktywny Sep 4, 2010

Przyznany użytkownikowi:

randyj5150

See private message.

$510 USD w ciągu 28 dni
(3 ocen)
3.9

23 freelancerów złożyło ofertę za $686 w tym projekcie

themexlx

See private message.

$637.5 USD w ciągu 28 dni
(119 Oceny)
7.7
MuktoSoftware

See private message.

$510 USD w ciągu 28 dni
(414 Oceny)
7.4
novepi

See private message.

$850 USD w ciągu 28 dni
(47 Oceny)
6.2
heisenbug

See private message.

$850 USD w ciągu 28 dni
(14 Oceny)
5.1
seanwilliamsvw

See private message.

$637.5 USD w ciągu 28 dni
(26 Oceny)
4.9
wuxiinfotech

See private message.

$850 USD w ciągu 28 dni
(3 Oceny)
4.6
somaniac

See private message.

$425 USD w ciągu 28 dni
(8 Oceny)
4.3
coordl1n8w9

See private message.

$850 USD w ciągu 28 dni
(11 Oceny)
4.3
happydotnet

See private message.

$552.5 USD w ciągu 28 dni
(20 Oceny)
4.3
frostfiretulsavw

See private message.

$637.5 USD w ciągu 28 dni
(23 Oceny)
3.4
ovidiuvatamanu

See private message.

$701.25 USD w ciągu 28 dni
(10 Oceny)
3.1
jeeves85

See private message.

$721.65 USD w ciągu 28 dni
(9 Oceny)
3.3
matthewpocock

See private message.

$680 USD w ciągu 28 dni
(3 Oceny)
3.6
j3pro

See private message.

$425 USD w ciągu 28 dni
(5 Oceny)
4.2
Rampayoda

See private message.

$850 USD w ciągu 28 dni
(4 Oceny)
4.7
iandaviesvw

See private message.

$850 USD w ciągu 28 dni
(0 Oceny)
0.0
waleedwlz

See private message.

$425 USD w ciągu 28 dni
(0 Oceny)
0.0
erpoojasharma

See private message.

$850 USD w ciągu 28 dni
(1 Ocena)
0.0
amitusaineu

See private message.

$850 USD w ciągu 28 dni
(0 Oceny)
0.0
softtechent

See private message.

$850 USD w ciągu 28 dni
(1 Ocena)
3.6