topic Access and update data from a ERP system in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/access-and-update-data-from-a-erp-system/m-p/782584#M6460 <HTML><HEAD></HEAD><BODY><P>What would be the easiest way to access and update data from our ERP system&nbsp;(IFS) through a combination of&nbsp;Collector and Survey123? We are looking at work order information&nbsp;related to poles. The work orders come from the ERP system while the geography comes from our GIS database.</P><P></P><P>I'm currently thinking something along the lines of extracting data from the ERP system through a database view which in turn will update a table at regular intervals through a Scheduled Task which&nbsp;will be&nbsp;joined to the poles feature class. We will need to have the possibility to work with data offline in Collector and as far as I know feature services does not work with database views. The field workers need to see the work orders in Collector from where they will open Survey123.</P><P></P><P>Pdf-files of current emergency respons protocols etc.&nbsp;stored in&nbsp;the ERP system related to specific areas needs to be accessed by Collector or Survey123 in both online and offline mode.&nbsp;It's the offline mode part that is challenging in this regard.</P><P></P><P>Data from the surveys collected in the field needs to go back to and update the ERP system. Could this be done by way of a map/feature service for instance? Other suggestions?</P><P></P><P>Not quite sure how&nbsp;to accomplish this, any input would be appreciated.</P></BODY></HTML> Thu, 25 Jan 2018 15:32:24 GMT ChristineLarsen 2018-01-25T15:32:24Z Access and update data from a ERP system https://community.esri.com/t5/arcgis-survey123-questions/access-and-update-data-from-a-erp-system/m-p/782584#M6460 <HTML><HEAD></HEAD><BODY><P>What would be the easiest way to access and update data from our ERP system&nbsp;(IFS) through a combination of&nbsp;Collector and Survey123? We are looking at work order information&nbsp;related to poles. The work orders come from the ERP system while the geography comes from our GIS database.</P><P></P><P>I'm currently thinking something along the lines of extracting data from the ERP system through a database view which in turn will update a table at regular intervals through a Scheduled Task which&nbsp;will be&nbsp;joined to the poles feature class. We will need to have the possibility to work with data offline in Collector and as far as I know feature services does not work with database views. The field workers need to see the work orders in Collector from where they will open Survey123.</P><P></P><P>Pdf-files of current emergency respons protocols etc.&nbsp;stored in&nbsp;the ERP system related to specific areas needs to be accessed by Collector or Survey123 in both online and offline mode.&nbsp;It's the offline mode part that is challenging in this regard.</P><P></P><P>Data from the surveys collected in the field needs to go back to and update the ERP system. Could this be done by way of a map/feature service for instance? Other suggestions?</P><P></P><P>Not quite sure how&nbsp;to accomplish this, any input would be appreciated.</P></BODY></HTML> Thu, 25 Jan 2018 15:32:24 GMT https://community.esri.com/t5/arcgis-survey123-questions/access-and-update-data-from-a-erp-system/m-p/782584#M6460 ChristineLarsen 2018-01-25T15:32:24Z Re: Access and update data from a ERP system https://community.esri.com/t5/arcgis-survey123-questions/access-and-update-data-from-a-erp-system/m-p/782585#M6461 <HTML><HEAD></HEAD><BODY><P>I'm&nbsp;in a similar situation using Survey&nbsp;for data collection to go into an&nbsp;asset management system. That is a<SPAN>&nbsp;loaded question though and probably no easy answer - but I like the idea.&nbsp;</SPAN></P><P></P><P><SPAN>We pulled existing data out of our asset management system to csv format and use pulldata functions for identifying existing assets and updating incomplete attribute information while also collecting new features.&nbsp;As far as I am aware, you cannot&nbsp;dynamically read in that data from an ERP system into an existing published Survey. I don't know if it is possible to automate the process of pushing survey results&nbsp;out and back into an ERP system, though I am curious if anyone is doing this as it would save us a lot of time on the back end.</SPAN></P></BODY></HTML> Thu, 25 Jan 2018 23:01:48 GMT https://community.esri.com/t5/arcgis-survey123-questions/access-and-update-data-from-a-erp-system/m-p/782585#M6461 AdamDaily 2018-01-25T23:01:48Z