Lukket

Save data from Google Spreadsheet to Postgres.

We are running a Postgres on [url removed, login to view] (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 (GS from now on) columns with postgresql columns. In a test spreadsheet have the columns:

id

adate

adate_time

text

and the create table statement should be:

create table atable (id int primary key, thedate date, thedate_time timestamp(6), the_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.

It should not be possible to add nor delete postgresql rows from the GS.

If you need one, you get a linux server for solving this project. Our preferred programming language is PHP.

Please ensure that editing multiple cells in one go works. Also, ensure that if there are formulas in the cells, then it is the resulting values that get saved in the DB and not the formulas themselves.

Max price for this project is 100$. The reason for this is that there is a proof of concept of this project here: https://docs.google.com/spreadsheets/d/1F5Ss3iy135tL_MyUFK15oB9Qz4JBj2zXU1ybMoMWlAM/edit#gid=0 But if you find anything in that implementation contradicting the above requirements, then please ask me. For example I cannot see that cells with red background ever get a white background again after submitting the query to the server. The server software (to actually update the database) has not been implemented in that proof of concept.

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 [url removed, login to view] username in this form: [url removed, login to view] You of course need to also submit a bid via Freelancer.com.

Færdigheder: Google App Engine, PHP, PostgreSQL

Se mere: where to find app freelancer, where to find a freelancer, where find php freelancer, where can you get freelancer, where can i get freelancer, want to add in freelancer com, using google spreadsheet, submit google app, spreadsheet script google, spreadsheet script, script google spreadsheet, script for google forms, save freelancer, red programming language, red engine, primary data, price for freelancer app, preferred freelancer in freelancer com, postgresql freelancer, one key data, ok google freelancer, make your own programming language, linux programming freelancer, i want editing from freelancer, is freelancer com 100 free

Om arbejdsgiveren:
( 165 bedømmelser ) Copenhagen, Denmark

Projekt-ID: #6024753

8 freelancere byder i gennemsnit $143 for dette job

SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: [url removed, login to view] Mere

$210 USD in 5 dage
(250 bedømmelser)
7.9
ifti24vw

Hi, I have read your requirements and hope that I will be able to complete your task. Please feel free to knock me if you want me to work for you. Thanks in advance for your time and have a nice day. - Ifti

$133 USD in 5 dage
(55 bedømmelser)
6.2
pablotorres

La propuesta todavía no ha sido proveída

$100 USD in 5 dage
(81 bedømmelser)
5.6
GeorgeKazi

Hi! I'm an experienced Google scripts developer. I have reviewed the project brief and I understand what needs to be done. I would love the opportunity to work on your project and I can start right away. Please contac Mere

$100 USD in 5 dage
(10 bedømmelser)
4.2
alltechinfohub

Dear Sir/Madam, We have gone through your requirements, & seen your specifications. We are glad to inform you that We are a company consisting a team of Well Experienced : 1. Word-Press Developers 2. PHP Devel Mere

$150 USD in 4 dage
(12 bedømmelser)
3.8
threadsafe

Hi, I read the requirements and found them sufficiently clear to build the automation. I need one clarification regarding the sync process. I defined changes initiating at each end (GS and Heroku), and their order (1 Mere

$100 USD in 5 dage
(1 bedømmelse)
0.3
itzdipu

A proposal has not yet been provided

$200 USD in 5 dage
(0 bedømmelser)
0.0
danielrobertus

Hi, I currently work as MIS Specialist in a Bank in my country. i am experienced in developing web using java or PHP in variety of applications, such as Grade Reporting for Education, Payment System for Education, I Mere

$150 USD in 5 dage
(0 bedømmelser)
2.0
tj90

Dear Employer I can make those appliaction for You, but in those time I will take 250 EURO for that. I have 9 years experience in Java development. I can deliver high quallity solution with after release support. Mere

$277 USD in 5 dage
(0 bedømmelser)
0.0