Find Jobs
Hire Freelancers

Import data from Google Spreadsheet to Postgres

$30-250 USD

Cerrado
Publicado hace casi 10 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 5919813

Información sobre el proyecto

2 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
2 freelancers están ofertando un promedio de $231 USD por este trabajo
Avatar del usuario
I am an expert in delivering custom scripts and willing to discuss further about the project specifications
$252 USD en 6 días
4,8 (103 comentarios)
7,1
7,1
Avatar del usuario
Google Spreadsheet provides an event for cell-changed so you could capture this event for invoking a web service. This web service will then be redirected to do the postgres update on your another server, in this case postgres.heroku.com. All web service and postgres script would be written in PHP.
$210 USD en 3 días
5,0 (15 comentarios)
4,7
4,7

Sobre este cliente

Bandera de DENMARK
Copenhagen, Denmark
5,0
165
Forma de pago verificada
Miembro desde ene 11, 2010

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.