Find Jobs
Hire Freelancers

Python Google App Engine services to extract survey data via API for updating mysql DB

€250-750 EUR

Completed
Posted almost 9 years ago

€250-750 EUR

Paid on delivery
We do surveys via SurveyGizmo and we would like to put responses into our mysql DB hosted on Google Cloud Platform, for further analyzis. As the rest of the application is in Python / Django on Google App Engine, we would like you to continue the development on this stack. After awarded, we will give you the access of the existing code and also the environment of development. Another important point: most of the features have already prototyped in Google Apps Script / javascript This can help you to start and to build faster (and maybe cheaper ;-). We want you to develop the following 3 services (summary): 1/ Get the last 5 forms created in SurveyGizmo (SG) and populate a table with only new items - This service will be called from UI actions / ajax (via for example /puzzsurvey/refresh-last-forms) - Then it launches the call to SG and after API response update the mysql DB - Then it returns a json of the 20 last forms for the UI 2/ Get responses of a particular survey from SG to populate mysql until the survey is closed - The survey is opened during a period of time. During this period, we need to collect the data from SG and to store them in our mysql DB - So if the status of the survey is open, the service should query SG each x minutes via cron - The cron searches in DB for opened surveys, and if there is, launches via deferred a call to SG for each survey - The responses will be transformed a bit to allow the storing in the mysql schema 3/ Get filtered responses of a particular survey from SG to populate mysql candidats table - Another part of the application allows us to create scenarios to filter the candidats/responses done in SG - A filter can be translated on a list of key-value parameters which can be passed to the SG API (there is no big deal here; moreover this part is also prototyped) Passing by SG to filter seems to be faster to implement than doing it by DB; so the service will ask the SG responses corresponding to the filter, and link all the persons to the current scenario. - The filtering will be launched when we get new responses from SG (service 2/) and when the user creates/updates the scenario via the application Skills needed and operational quickly: - Python / Django - Google cloud platform: App Engine / Datastore and MySql - Converting JSON to Relational DB model - Don't be allergic to French terms in code and comments :-)
Project ID: 7626827

About the project

9 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi. Thx for inviting me to the project. Basically in general terms the project is clear, I wanted to ask if possible to take a look at the current project source code. Just want to see what is done and how it is organised. When starting from an exiting project is important to analyse it and see if I like the project. Other question is related to the UI, do you have any prototype on how it should look? Does is need to be styled and beautifully designed? I'm asking this because I'm not the pretty good at styling and things like this. Let me know this details and we can discuss more. Thx.
€750 EUR in 7 days
5.0 (133 reviews)
7.6
7.6
9 freelancers are bidding on average €646 EUR for this job
User Avatar
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi
€526 EUR in 6 days
5.0 (134 reviews)
7.0
7.0
User Avatar
A proposal has not yet been provided
€710 EUR in 15 days
4.9 (105 reviews)
6.8
6.8
User Avatar
A proposal has not yet been provided
€500 EUR in 10 days
4.8 (71 reviews)
6.0
6.0
User Avatar
Hello sir, This is jagruti and team from india, we are professional mobile application developers and web developers. I am writing in response of your job posting for the application in freelancer.com. I feel that i am suitable for this job, as we have dealt with very complex apps till now. If you feel there is mutual interest, i would welcome you to meet and learn more about me and the team. Thank you.
€526 EUR in 10 days
4.4 (7 reviews)
5.0
5.0
User Avatar
Hi, I've read your project description and I think I can complete your project. I known Google App (Java and Python) for a long time but still not do any actual project. But I think I can complete your project if I research more about it. Thank you if you read my proposal. Best regard,
€555 EUR in 15 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of FRANCE
Chatenay-Malabry, France
5.0
68
Payment method verified
Member since Apr 18, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.