Find Jobs
Hire Freelancers

Create Database, script to import text files on a daily basis

$300-1500 USD

Preklicano
Objavljeno pred skoraj 17 leti

$300-1500 USD

Plačilo ob dostavi
As of now, I manually get these files, and separate the data into the palmar-april-break.xls. This is a manual manipulation of the data. The [login to view URL] is a statistics file, that we’d like to have be reported into a database/table on a daily basis. More than likely we’ll have databases that will be called hotelname. Then different tables which can be created to manage the different reports that are put up on the Hotel’s servers. I would rather have the information be automatically put into the database through some type of FTP script, than to have me manually import the data each morning. The most important file is the [login to view URL] file (which is exactly how the file comes out of the server), and the [login to view URL] (which can be opened in excel), and then the out put of the data on some of the revenue splits I am interested in getting. Our server is on a UNIX based webserver, and we can easily create MySQL 100MB database there no problem, which has phpmsqladmin all installed ready to be used. I use Crystal Reports (or I am learning CR), so I’d prefer to use a db that can be reported on using that software. I anticipate this being a pretty straight forward creation of an FTP script which logs on to server, navigates to directory, grabs log files, parses into readable format (these files are all tab separated, or comma separated), uses a native mysql ms sql, or php import funtion into the database on a daily basis. If the programmer is an expert SQL programmer, perhaps they could create some views, or fucntions which we could use to report on, other wise, I can run my own reports in Crystal Reports on the database itself. Please contact me if you are interested in this project.
ID projekta: 141082

Več o projektu

25 ponudb
Projekt na daljavo
Aktivno pred 17 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna

O stranki

Zastava BERMUDA
tuckers town, Bermuda
5,0
3
Član(ica) od mar. 21, 2006

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.