İptal Edildi

MySQL: Copy CSV file into MySQL database

Quotation Required:

I have a job which consists of several related activities. I’m looking for a quote either for the entire job, or any part of it (I’m willing to hire different people for different parts). Following is a description of the job and a specification.

Please note: This specification is written by a non-technical person. Consequently, parts of it may not make sense or may request that things be done in one way, when another approach would be much easier and logical. Consequently, please feel free to disagree with the specification and specify an alternative approach.

Objective:

I have a MySQL database which is used to store property descriptions. In other words, each “record” would describe one property (type of house, price, house details, etc.). A colleague has a similar database, but stores slightly different information for each house. My objective is to take the properties on his database and move them onto my database. As he updates his database daily, I will need to copy his properties onto my database on a daily basis.

I do not have direct access to his database. However, he will put the property details into files which I have FTP access to. He has 8 agents working for him, and for each agent there will be:

• One CSV (Comma Separated Value??) file which has all the properties for that agent. There is one record per property (each record having 50 fields).

• For most properties there will be a number of JPG photos. Each property with photos will have one file, with between 1 and 6 photos.

Required work

For each agent, I need to:

1. FTP the property file and photos onto my internet site directory

2. Copy the property file details into my SQL database. This involves not only a copy, but a certain amount of reformatting as my database has slightly different fields than his. For example, in my SQL field PROPERY-TYPE I have either “House” or “Apartment”. He has either “H” or “A”. I’ve written the Algorithm for the conversions required, but this needs to be converted to the appropriate language. To avoid duplicate property descriptions, the software will need to check the PROPERY-ID field of the record to determine if the property is already in the database (if so, it should overwrite the existing description rather than add a new one).

3. Extract the photos from each photo file, assign them appropriate names, and then copy them to my photo directory. Each file can contain between 1 and 6 photos

4. The SQL database will then need to have the corresponding property record updated to contain the names of the corresponding photos.

This needs to be automated as much as possible.

Quotation

Ideally I would like to have an approximate quote for points 1 to 4 above. However, I would accept quotes for individual items.

I believe that step 1 above can be done with a few simple commands which effectively copy an entire directory from my colleague’s site to mine. I have not yet confirmed this.

I believe that step 2 above is relatively straight-forward coding. I’ve written a detailed specification which states exactly what must be done for each field, so little or no design work is required. Just coding.

As I haven’t provided a detailed specification, I do not expect an exact quote. However, I’m looking for a rough indication and comments on what approach (e.g. what language/application and why) would be used to do the above. Any quote provided is non-binding (after all, I can’t ask for a firm quote until I’ve provided the detailed specification.

For some of this work there may be existing applications, which merely need to be configured. I’m quite willing to accept a quotation which involves purchase of an off-the-shelf application and configuration thereof (for one or more parts of the above job, this may be a more economical approach).

The response to this job description (both price and suggested approach) will be used to choose the programmer, who will then be provided a more detailed description.

Regards,

Doug Stewart

Beceriler: Veri Girişi, Perl, PHP, Python, Visual Basic

Daha fazlasını görün: mysql copy csv, who needs a perl programmer, what's an algorithm, what's algorithm, what is the algorithm, what is sql coding, what is hire purchase, what is algorithm design, what is a database programmer, what is a copy, what can i do with php and mysql, what algorithm, the parts house, the hire firm, sql database programmer, simple file database, simple algorithm example, request specification, property id, property agents, programmer names, programmer mysql, programmer it job description, programmer 2 job description, price file

İşveren Hakkında:
( 4 değerlendirme ) Bois de Gand, France

Proje NO: #35787

45 freelancer bu iş için ortalamada 689$ teklif veriyor

pan09

please check pmb

in 15 gün içinde1500$ USD
(209 Değerlendirme)
7.4
cstl

Our bid is 499 $ for the whole project. Bid includes development , deployment and testing. we offer 30 days free support. We are ready start and can complete it in 15 working days. We send daily reports and we communic Daha fazlası

in 15 gün içinde499$ USD
(22 Değerlendirme)
6.9
natgeo

Please see PMB for details. Thanks

in 3 gün içinde300$ USD
(157 Değerlendirme)
7.0
inavigator

we can do this for you

in 30 gün içinde1000$ USD
(12 Değerlendirme)
6.9
websoftinfo

Our bid is for really very high quality work for your MySQL: Copy CSV file into MySQL database that will be made to be upgradable in case you need some upgrades in future. We will always be available for upgrades. Our Daha fazlası

in 35 gün içinde1500$ USD
(66 Değerlendirme)
6.4
ndinfosys

Dear sir, I have study your detail requirements and ready to solve it. I have specify my job portion in pmb. Kindly check it. Thanking you Andey.

in 7 gün içinde345$ USD
(47 Değerlendirme)
6.3
inteconssoftware

pls see pmb

in 7 gün içinde1500$ USD
(5 Değerlendirme)
5.8
MaxPowers

I commonly work with remote files and databases. I have several methods for extracting your friends information and reformatting it for your server. I have posted more details in your PMB

in 2 gün içinde400$ USD
(33 Değerlendirme)
5.7
Shahyar7

Greetings I have more than 7 years experiences in Perl/MySQL programming. Also I'm expert in file type convertying and content comparing. I can do all 4 parts of your program by myself. My work is guaranteed. Paymen Daha fazlası

in 20 gün içinde700$ USD
(37 Değerlendirme)
5.7
GuruDeveloper

I can do it!

in 10 gün içinde699$ USD
(30 Değerlendirme)
5.7
BilalNiaz

Hi, This is only a placeholder bid. Please see PMB for details. Thanks, Bilal Niaz

in 3 gün içinde360$ USD
(23 Değerlendirme)
5.4
wherrelz

Please contact to complete

in 15 gün içinde500$ USD
(9 Değerlendirme)
5.4
msgaruba

Please view pmb thanks

in 15 gün içinde500$ USD
(14 Değerlendirme)
5.3
phpfunk

I have developed similar systems for other large companies with 'distributed' data using PHP, perl and a crontab. What OS does your server run? I am confident that the entire process can be automated. It is possible Daha fazlası

in 10 gün içinde500$ USD
(19 Değerlendirme)
4.9
SVTechnologies

Dear Client ---- Thanks you for opportunity to bid on your project ---- We have already experience of working on related projects and customising different opensource scripts according to the need of clients -- Daha fazlası

in 5 gün içinde300$ USD
(13 Değerlendirme)
4.7
SOFTWAREALLIANCE

Excellent work ! ! ! Hello! 100% guaranteed of high quality and professional work, as we are the experts in web and programming. Our company has been in the sphere of webdesign and programming for 7 years already, a Daha fazlası

in 14 gün içinde700$ USD
(2 Değerlendirme)
5.0
webdreamer

Dear sir, We are experts in data migration and cleansing and can do this job for you in Perl/CGI. Please check your PMB for more details. Kindly visit us at [url removed, login to view] Thanks!!

in 10 gün içinde500$ USD
(7 Değerlendirme)
4.4
rahmanali

I have 7 years Experience in WEB DEVELOPMENT,SOFTWARE DEVELOPMENT and SEARCH ENGINE OPTIMIZATION. I can Provide you the solution. I will start ASAP

in 15 gün içinde1500$ USD
(22 Değerlendirme)
4.2
toma

Hi. Point 1 and 2 would be done together. There would be no need to DOWNLOAD the files, i would just OPEN them REMOTLY and than would put them into MySQL (of course i would first know your stucture and your fiends Daha fazlası

in 4 gün içinde500$ USD
(4 Değerlendirme)
4.0
gogetter

As I Understand, this project involves: 1. Getting CSV and Image files through FTP 2. Transforming Data present in CSV (according to algorithms that you have prepared) 3. Updating a database with transformed data Daha fazlası

in 12 gün içinde800$ USD
(1 Değerlendirme)
4.0