Đang Thực Hiện

134242 Scripts to map a flatfile DB

Hello there,

We are an auto classifieds web site for a small region in Washington state.

We have a flatfile database (tab-separated values text file) which we need to map to a different field order to create feeds for the aggregator sites Oodle and Googlebase. The records are automobile for sale listiings.

Since these two sites have different feed specifications, we need two scripts/applets -- one for mapping our database to Googlebase format, and one for mapping to Oodle format.

We have thus far been doing this mapping manually, so we will be able to provide not only the source database but also examples of what the results of the script should look like.

To give you more of an idea of what we require, here are some more specifics:

On our flatfile database, the fields (all just text) are:

1 category

2 year

3 make

4 model

5 description

6 price

7 phone

8 city

9 ID/picfilename

10 check

11 stockno

12 storelink

13 storename

14 storeaddress

15 state

16 zip

17 faxmail

It's not important to understand what these field names mean ... just to be able to map the fields as specified below:

GoogleBase Mapping Script:

What GoogleBase requires is a tab-delineated flatfile, like ours, but in this field order: (our corresponding fields in parentheses)

title [concatenate(2) (3) (4) + the text "at [url removed, login to view]"]

......example: "1997 Honda Civic at [url removed, login to view]"

color (left empty)

condition (text "used" for all records)

description(5)

expiration_date (Current date+14 days in MM-DD-YYYY format)

ID/picfilename(9)

image_url [concatenate "[url removed, login to view]"(9)".gif"]

......example: "[url removed, login to view]"

link [concatenate "[url removed, login to view]"(9)]

......example: "[url removed, login to view]"

location [concatenate (14), (8), (15), (16)]

make(3)

mileage (left empty)

model(4)

price(6)

price_type (left empty)

quantity (text "1" for all records)

category(1)

vin (left empty)

year(2)

Note that some fields are created by combining the text from other fields, and some fields are deliberately left empty.

Also, if the "creation_date" and "expiration_date" fields are too difficult to generate, we would be willing to accept a script which left those fields empty as well so that we could manage them manually.

Oodle Mapping Script:

What Oodle requires is a tab-delineated flatfile, like ours, but in this field order: (our corresponding fields in parentheses)

category(1)

ID/picfilename(9)

title [concatenate(2) (3) (4) + the text "at [url removed, login to view]"]

......example: "1997 Honda Civic at [url removed, login to view]"

link [concatenate "[url removed, login to view]"(9)]

......example: "[url removed, login to view]"

address(14)

city(8)

country (text "US" for all records)

neighborhood (left empty)

state(15)

zip(16)

body type (left empty)

color (left empty)

condition (left empty)

create_time (Current date in MM-DD-YYYY format)

dealer(13)

description(5)

expiration_date (Current date+14 days in MM-DD-YYYY format)

image_url [concatenate "[url removed, login to view]"(9)".gif"]

......example: "[url removed, login to view]"

mileage (left empty)

model(4)

price(6)

priv. Party (text "no" for all records)

VIN (left empty)

year (2)

We would prefer that these two scripts be written as Java applets, so that we could run them on our Macintosh platform at the office.

However, PERL/CGI or any other kind of scripts which can run on our Linux/Apache web server would also be acceptable. In that case the scripts might include a prompt to upload the appropriate source file, and would create a new mapped file on a local directory of our server that we could reach by FTP.

Although they might sounds complex at first, I believe that these two scripts could be written quite quickly by an experienced programmer.

We will try to post on the PMB both the source database and versions of our database properly-formatted as Oodle and GoogleBase feeds. Please contact us with any questions and ideas, and we look forward to working with you.

Please do not bid without first reading our entire project description above.

Kỹ năng: Bất kì công việc gì, HTML, Java, JSP, Perl, PHP

Xem thêm: www vin com, which country need programmer, what should i look for in a programmer, what kind of programmer do i need, what is upload mean, what is a database programmer, what do i give to a programmer, server scripts, reach local, programmer web directory, price for a php programmer, php scripts for sale, php programmer reading, party city com, order a web programmer, need a programmer for a small project, it programmer names, i have an idea but need a programmer, gif programmer, ftp server zip, contact to create a web, category php id, what is perl used for, s+db, map database

Về Bên Thuê:
( 101 nhận xét ) Olympia, United States

Mã Dự Án: #1880414

Đã trao cho:

mohameddd

Kindly Check PMB

$60 USD trong 0 ngày
(56 Đánh Giá)
5.1