"Thanks, Alex --
I was able to install and configure a MySQL database on my machine (key step was actually creating the database from the MySQL client, then FL took it from there!). I have further succeeded in pulling in table data into excel using…"
FrontlineSMS allows you to text message with large groups of people anywhere there is a mobile signal.
Jeff Seaman's Discussions
Database corruption
1 Reply
I've been using Frontline forms for a little while, and have run into quite a few issues that can I've only been able to fix by deleting the databases and restarting Frontline.Some of the problems…Continue
Started this discussion. Last reply by Morgan Belkadi Aug 9, 2010.
Export of forms data to Access?
9 Replies
Hello,I am trying to find a way to automatically export forms data to an Access database once it is sent to the server (maybe using external commands?). But the extent of my knowledge doesn't include…Continue
Started this discussion. Last reply by Jay Jun 2, 2011.
Gifts Received
Jeff Seaman has not received any gifts yet
Jeff Seaman's Page
Latest Activity
Alex Anderson replied to Jeff Seaman's discussion Export of forms data to Access?"Hi Jay,
If you use a MySQL database with FrontlineSMS, I expect you could poll this periodically from Excel using VBA. I've no experience with VBA though, so I can't suggest much more than that.
Alex"
kiwanja replied to Jeff Seaman's discussion Export of forms data to Access?"Hi jay
We did talk about the potential of allowing incoming Form data to trigger an action in "External Commands", which could have written the data to an external database, CSV, or whatever. We're not planning on doing much…"
Jay replied to Jeff Seaman's discussion Export of forms data to Access?"I'd like to do something similar to Jeff, without necessarily having to export data into a CSV. It would be ideal if Forms data could appear automatically in an Excel spreadsheet, in real time.
Like Jeff, I'm not much of a coder, but my…"
Morgan Belkadi replied to Jeff Seaman's discussion Database corruption"Hi Jeff,
this is quite unexpected with the default database!
Can you reproduce the problem, and then us your logs through the help menu?
We'll take a look at this as soon as possible.
Cheers,
Morgan"
Jeff Seaman posted a discussionDatabase corruption
I've been using Frontline forms for a little while, and have run into quite a few issues that can I've only been able to fix by deleting the databases and restarting Frontline.Some of the problems are:-no forms sent to mobile client-when editing forms, changes are not saved after hitting the 'save' button-forms copy in reverse order-unable to delete forms-unable to export forms data (the unexpected error screen pops up)I was wondering if there is a reason that the database is apparently…See More
Jeff Seaman replied to Peter J. Bury's discussion Propose a new group: Water Sanitation Hygiene (or WASH)"Hi Peter,
I think this is a great idea. I am doing monitoring in a WASH related field (household water projects in Cambodia), and a group like this would be awesome.
-Jeff"
Jeff Seaman replied to varun bj's discussion Unable to send form to mobile"I had a similar number sequence in the messages tab after a request from the client phone.
AD0373206F6C6400066F7665722035001B4F746.......
I actually received a form on the phone though. I hope it works on your other phones.
-Jeff"
Jeff Seaman replied to varun bj's discussion Unable to send form to mobile"I also have found a very similar solution.
I had added the country code to the contact information, but had left in an unnecessary zero (i.e. +855-077-xxx-xxx). Sending messages from the contact to FLSMS was fine and vice versa, except for forms.…"
Jeff Seaman replied to varun bj's discussion Unable to send form to mobile"I have had the same problems, but all the issues occurred after forms had been working fine for 3 weeks.
I've re-installed the FLSMS app on the client phone, reset network access permission, and deleted the FLSMS database, but nothing works.…"
Jeff Seaman replied to Peter Holt's discussion FrontlineSMS. forms"Ohhhh, that explains it. Thanks for the info."
Jeff Seaman replied to Peter Holt's discussion FrontlineSMS. forms"Hi Morgan,
Not quite. I am actually only using 1 contact (I am still doing some testing). I have about 10 forms, and am trying to get 2 forms onto the receiving phone. When I request new forms from the FLSMS server, it sends all 10 (including the…"
Jeff Seaman replied to Peter Holt's discussion FrontlineSMS. forms"Hi Graham,
I also had some difficulties with this. I am using a Huawei E1750 and sending forms to a Nokia 2690. What seemed to work for me was making sure the modem plugged into the compute before starting FLSMS. But maybe there is more to it, and I…"
Morgan Belkadi replied to Jeff Seaman's discussion Export of forms data to Access?"Hi Jeff,
in order to have your existing data exported somewhere else, you'll have to write a quick script which would read:
- either the exported CSV file
- or the current database, which must be in a file if you use the default h2 database…"
Jeff Seaman replied to Jeff Seaman's discussion Automatic export of forms data?"I kind of had a feeling I might have to do something with SQL and maybe ODBC. But I may be jumping the gun a bit as I can't even manually export the data into an existing Access database; which is what I am trying to work towards.I've…"
Profile Information
- Why are you interested in FrontlineSMS? How did you hear about it? (To help us filter out spammers, we need as MUCH detail as possible, else we may not be able to approve your request. If you'd rather not share this information openly please email info@frontlinesms.com before joining)
- I am interning with an NGO and piloting a monitoring methodology using Frontline SMS. I am from Canada, and I need to figure out how it works, implement it, work out the kinks, and then train a whole bunch of national staff.
- Tell us about you. (Please also add an image to your profile)
- I'm a 23 year old Canadian, just finished university, and am interning with Samaritan's Purse Canada, but am working for a partner organization called Hagar Cambodia. I am loving the country, but not loving the heat.
- Website:
- http://jeffseaman.wordpress.com/
Comment Wall
- No comments yet!
Videos
© 2013 Created by kiwanja.net.
Powered by
