Parsing sync'd datafile
Posted: February 20th, 2018, 3:34 am
Hello everyone,
I am a new user to CSPro (2 weeks) as I was recently brought on as a programmer in a department that uses it. I am really blown away by how easy it is to use, and have already created some stellar surveys that utilize android's GPS and Camera, and also successfully sync back to dropbox. I doubt I could have accomplished all this so quickly and painlessly with another program.
That being said, I wanted to reach out to the community here to see if someone has already done what I would like to do. At our shop, we feel it would be easier for our reporting to occur if we use a DB to house the data after we are done using CSPro as our front-end to capture that data. To this effect, I would like to create a script (python?) on our server that runs and checks for a recently added data file from the field and then parses that data file for insert into the DB.
This script would run periodically quite often in an attempt to achieve as near to real time data as possible. Understanding CSPro's usage, I'm very aware such a parsing script would be 2 fold - 1 to actually parse the file, and 2 to act as a "key" to explain the dictionary (Field Name/start/length) to that parse.
Has anyone created or explored a parsing script that can be passed a dictionary definition sheet to act as a key for parsing?
Or perhaps, are there any plans upcoming to include the likes of an XML data file as an output sync option?
I know I could download the file manually and use the numerous export options that are available in the CSPro software itself, but my initial aim is to try and automate this process and again achieve a seamless, real-time quality from the data entry back to the central server.
Thank you all for your time. I look forward to continuing to develop in this software and to become a helpful member of this community.
Cheers,
Marc
I am a new user to CSPro (2 weeks) as I was recently brought on as a programmer in a department that uses it. I am really blown away by how easy it is to use, and have already created some stellar surveys that utilize android's GPS and Camera, and also successfully sync back to dropbox. I doubt I could have accomplished all this so quickly and painlessly with another program.
That being said, I wanted to reach out to the community here to see if someone has already done what I would like to do. At our shop, we feel it would be easier for our reporting to occur if we use a DB to house the data after we are done using CSPro as our front-end to capture that data. To this effect, I would like to create a script (python?) on our server that runs and checks for a recently added data file from the field and then parses that data file for insert into the DB.
This script would run periodically quite often in an attempt to achieve as near to real time data as possible. Understanding CSPro's usage, I'm very aware such a parsing script would be 2 fold - 1 to actually parse the file, and 2 to act as a "key" to explain the dictionary (Field Name/start/length) to that parse.
Has anyone created or explored a parsing script that can be passed a dictionary definition sheet to act as a key for parsing?
Or perhaps, are there any plans upcoming to include the likes of an XML data file as an output sync option?
I know I could download the file manually and use the numerous export options that are available in the CSPro software itself, but my initial aim is to try and automate this process and again achieve a seamless, real-time quality from the data entry back to the central server.
Thank you all for your time. I look forward to continuing to develop in this software and to become a helpful member of this community.
Cheers,
Marc