Find Jobs
Hire Freelancers

Import data from Google Spreadsheet to Postgres.

$30-250 USD

Stengt
Lagt ut nesten 10 år siden

$30-250 USD

Betalt ved levering
We are running a Postgres on [login to view URL] (please create your own free database for solving this project). We also have a Google Spreadsheet and we want you to make it so that saving data in that Google Spreadsheet will save data in the postgresql database. I do not want this done by syncronizing every fifth minute, but rather using events that trigger saving in Postgres immediately. Before the saving has completed, then please make the background color of the cell that was updated red, and turn it back to the color that it originally had after the saving has completed. Please do not save all the table every time, just the changed cell. The column a in the spreadsheet will be equal to the "id" column of the postgresql table. Please hardcode the mappings of google spreadsheet columns with postgresql columns. In a test spreadsheet have the columns: id (int) date (date) date time (timestamp(6)) text (varchar(99999)) Please set the validation rules for the columns in the google spreadsheet, and ensure that no values will make your script unable to sync (apart from dates before 1970 and after 2030). The syncing needs to be within seconds usually. If you need one, you get a linux server for solving this project. Our preferred programming language is PHP. Max price for this project is 130$, you are welcome to open-source your solution and/or sell it, to for example ([login to view URL]!/Google%20Docs/PostgreSQL). I just want updates in the future if you continue using the source code for a closed source project. And I need this within 5 days from you starting the project. To ensure that you have actually read all these requirements, I will only consider bids where I can find your freelancer.com username in this form: [login to view URL] You of course need to also submit a bid via Freelancer.com.
Prosjekt-ID: 5926913

Om prosjektet

3 forslag
Eksternt prosjekt
Aktiv 10 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
3 freelancers are bidding on average $154 USD for this job
Brukeravatar
If ID column of the postgres table is spreadsheet columns shouldn't it have a column for a row as well? Sorry for the bid over budget and sorry for not filling out your google docs form.
$200 USD om 5 dager
5,0 (59 omtaler)
5,8
5,8
Brukeravatar
Hello again, Can i use pentaho kettle DI sync data between google docs and your postgresql ? We can set up kettle di to run as schedule on your server to sync data. Best regards, Thanh
$133 USD om 5 dager
4,9 (22 omtaler)
5,2
5,2
Brukeravatar
Hi, I'm a professional DataBase Administrator and web designer. I can do your project for 5 days 130$, high quality code. I have my own linux servers. Sincerely yours, Eric
$130 USD om 5 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

DENMARKs flagg
Copenhagen, Denmark
5,0
165
Betalingsmetode bekreftet
Medlem siden jan. 11, 2010

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.