Suljettu

Saving CSV files from Google Smartsheet to use as reference data

I'm new to Freelancer and this is my first project. Thanks for taking the time to read about our quest to automate this processes in our business.

Our company uses Google Smartsheet platform to track information about our Work orders/Job numbers for the transportation services we provide.

Each row in the google smartsheet has a unique sequential work order/Run# number assigned to it (Eg. RUN# VTIA0905). Each row in has information about the load, customer details and truck assigned to undertake the delivery. This smartsheet forms the master data for our company, mainly due to the webform that effortlessly collect the data while we are on the move from our mobiles.

We use goCanvas platform for mobile data collection for guys in the field. Data from Smartsheet is currently being exported into excel, saved as CSV and then uploaded to the Canvas cloud to work as reference data for the Canvas mobile apps.

This function is currently done manually causing delays when Canvas mobile applications become outdated any time a new job is added to smart sheet and the reference file is not updated in Canvas. .

We are looking for a solution that monitors Smartsheet for data changes and updates the CSV reference data in Canvas accordingly. Alternatively this solution could run and update every minute or so.

The solution we are looking for:

• Must extract run# information from Smartsheet, using the Smartsheet API or similar, to determine if the sheet has changed since the last time it was checked for changes. If it has, the smartsheet will need to be exported and saved as cvs file to be uploaded as Canvas reference data.

We have a Microsoft server hosted and could run some form of middleware software on this cloud based server, to make the updates of the reference data work.

Our ultimate goal is to build a proprietary system that may run on its own data collection software.

Taidot: Excel, tietojärjestelmäarkkitehtuuri, Tietojen kaavinta verkosta

Näytä lisää: read csv files complete data vb net, php upload csv files save database code, extract data multiple csv files, data extraction csv files database, can use sql pull csv files, use dao read csv files, reading csv files contain file data, use google finance historical stock data excel, car data csv files, use script file edit csv files, google map api save map data, google maps import csv files, macro copy data csv files folder, swf flash data display time csv files, tools extract data csv files, nmea data google kml files use, google base csv files

About the Employer:
( 0 reviews ) Durban, South Africa

Projektin tunnus: #13107336

12 freelanceria on tarjonnut keskimäärin 19877 R tähän työhön

srinichal

I am expert with a proven track record in automation and would like to deliver the project to your specifications

21176 R ZAR 6 päivässä
(123 arvostelua)
7.3
Vlzinch

Do you feel it is sensible to use Google Smartsheet as our main form of data base? We like the team work collaboration of Smartsheet. I think this is quite good idea if you have not big team, but i am pretty sure you a Lisää

21176 R ZAR 7 päivässä
(46 arvostelua)
6.9
riskypathak

Hello. I have read your existing process of downloading data from Google Smartsheets and then exporting to CSV files and then uploading to GoCanvas APIs. I understand that this manual process is cumbersome and can pro Lisää

21176 R ZAR 30 päivässä
(53 arvostelua)
7.3
Eagles90

Do you feel it is sensible to use Google Smartsheet as our main form of data base? We like the team work collaboration of Smartsheet. No, it does not but if you just allow people after hiring the project that they can Lisää

18529 R ZAR 30 päivässä
(38 arvostelua)
6.0
aanvikm

Do you feel it is sensible to use Google Smartsheet as our main form of data base? We like the team work collaboration of Smartsheet. Hello Sir, Considering your current scenario and the description provided I believe Lisää

18529 R ZAR 30 päivässä
(25 arvostelua)
6.0
schoudhary1553

A proposal has not yet been provided

21176 R ZAR 2 päivässä
(106 arvostelua)
6.1
keshavkalra90

Do you feel it is sensible to use Google Smartsheet as our main form of data base? We like the team work collaboration of Smartsheet. hmm it's upto you but it's good if you have multiple vendors using this but i recom Lisää

25588 R ZAR 30 päivässä
(70 arvostelua)
6.2
SiroosJafary

Do you feel it is sensible to use Google Smartsheet as our main form of data base? We like the team work collaboration of Smartsheet. There are plenty of other solution which are some sort of shared databases and are g Lisää

17647 R ZAR 30 päivässä
(54 arvostelua)
5.7
15882 R ZAR 40 päivässä
(22 arvostelua)
5.3
18529 R ZAR 10 päivässä
(45 arvostelua)
5.4
wee493

Do you feel it is sensible to use Google Smartsheet as our main form of data base? We like the team work collaboration of Smartsheet. Yes I think if it's working just fine in your current situation and if bridging the Lisää

20588 R ZAR 30 päivässä
(34 arvostelua)
5.2
prem89k

Do you feel it is sensible to use Google Smartsheet as our main form of data base? We like the team work collaboration of Smartsheet. I will be only guage this after you explain how the smartsheets is helpful to your b Lisää

18529 R ZAR 30 päivässä
(7 arvostelua)
4.6