Suljettu

Integration of Google Spreadsheets with Backend Systems

We have a number of processes running over Google Spreadsheets (relevant for the current project are timesheets, vacation planning sheets and expenses).

We now need to consolidate the whole data flow in a MySQL database that is communicated from a MS Access application. (Please note the definition of our constellation: "MySQL - MS Access"! It is a question of adding one more driver, but the discrepancies in terms of SQL syntax vs. MSSQL are at some points rather considerable).

The solution we need has to function over Google Docs API. There is a certain number of predefined functionality that we need:

- The data that is entered in the Google Spreadsheet has to be validated vs. the MySQL data model, and the user working with Google Docs has to receive a notification:

a) the cells in the Google spreadsheets are colored red,

b) user receives an email on the errors she has committed,

c) if a user doesn't fill out the timesheet for the last 72 hours, she will receive a notification email,

d) if a user receives 3 notifications, a notification email is sent to her manager,

...

We have a lot of stuff to be included here. At the moment we would like to receive a quote on the above points.

Please describe the ways to implement the functionality above. We will not take into consideration any generic bids.

Good luck!

We are somewhat puzzled by the current state of the the Freelancer.com site: there is a huge amount of bugs!!!

As we understand it: our project is not visible on the portal. We tried to apply to the Support, but no answer yet.

Good developers, we are waiting for your offers! Thx!

Taidot: Excel, Java, Microsoft Access, Visual Basic, Visual Basic for Apps

Näytä lisää: google spreadsheet database backend, question manager, java notification, google. docs, good c vs, generic data access, docs. google, timesheets, t-sql with, spreadsheet google, google sheets api, google google docs, google docs is, good docs, docs.google.docs, sql integration, spreadsheets, spreadsheet API, java backend, google spreadsheets, google java api, google docs mysql, access google spreadsheet, google api java, access timesheet database

Tietoa työnantajasta:
( 0 arvostelua ) Germany

Projektin tunnus: #1708657

5 freelancers are bidding on average $1480 for this job

Krusche

Here is our bid according to your main project.

2400 $ USD 60 päivässä
(32 arvostelua)
6.3
amfuries

################### ******************* WE HAVE DONE THE SAME APPLICATION PLEASE CHECK THE PM **************** #############

1000 $ USD 10 päivässä
(3 arvostelua)
3.2
surajddk

Hi, I have nearly 10 years experience with PHP, MySql & SQL based Database processing. Also I am working with Google APIs. I can start your project, I want more details about your project. Please reply via a PM.

1000 $ USD 10 päivässä
(2 arvostelua)
2.5
RFE5n7Po2

Custom software development - <b><i>Removed by Admin</i></b>

1500 $ USD 1 päivässä
(0 arvostelua)
0.0
rahulgu

I am having a good experience in different field .worked for 7 years for different part of the globe now setting my own firm . you will definately like my work. Give me this opportunity to develop your web page so eve Lisää

1200 $ USD 20 päivässä
(0 arvostelua)
0.0
satyaprakash57

Dear Sir, I am expert in vb and writing Macro. I can do [url removed, login to view] give me a chance.

1300 $ USD 20 päivässä
(0 arvostelua)
0.0