Guys,
We want to transfer data collected to our ERP software. We are currently using ERP next. Is there anyone who has worked on such integration. I am new to programming but has worked as a product manager. I am doing this as a pilot for not for profit enterprise. So I am would require a lot of help on this.
One way I thought of is
Since the data captured is not dynamic. I will get the data in csv format on my email and upload it on ERP next.
Please let me know if someone can help. I am ready to grind here to get this completed.
Thanks,
Deepak
If your ERP has csv-import capabilities, you have two options:
(1) write a script that you can schedule (e.g., using cron (crontab) or
Windows Task Scheduler ) to run periodically.
The script runs ODK Briefcase via its command line interface to pull data
down from ODK Aggregate then
publishes that data to a csv that is then uploaded to the ERP.
(2) set up a publisher to Fusion Tables to Google Sheets. Then use either a
scheduled periodic script or use trigger events on those two services to
publish the data into your ERP via the Google app script mechanisms (
https://developers.google.com/apps-script/guides/triggers/events )
and ( https://developers.google.com/apps-script/advanced/fusion-tables )
#2 could also be used if the ERP has something other than csv-import.
ยทยทยท
On Tue, Mar 21, 2017 at 1:16 AM, wrote:
Guys,
We want to transfer data collected to our ERP software. We are currently
using ERP next. Is there anyone who has worked on such integration. I am
new to programming but has worked as a product manager. I am doing this as
a pilot for not for profit enterprise. So I am would require a lot of help
on this.
One way I thought of is
Since the data captured is not dynamic. I will get the data in csv format
on my email and upload it on ERP next.
Please let me know if someone can help. I am ready to grind here to get
this completed.
Thanks,
Deepak
--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com