I'm happy to announce the first release of Ward Roster on the Android Marketplace.
Here's an overview of how to use it.
1. Download the app.
2. Obtain the Membership.csv file from a ward clerk
3. Place the Membership.csv file on the sdcard in a WardRoster directory
4. Run the app
5. Press the MENU button
6. Choose Import from CSV (depending on the size of your ward, it could take 5-10 minutes, don't worry, this is only necessary once after pulling a new data file)
7. Enjoy!
Please post any issues you might have with this version under this post.
Subscribe to:
Post Comments (Atom)
Congratulations on the app.
ReplyDeleteJust to manage users' expectations, they should be aware that the MLS export data files used by this app contain confidential information and are intended for leadership use. Just make sure your bishop is aware and gives you permisssion to use them.
One more suggestion about privacy and policy: It would be wise to delete the Membership.csv file (and similar MLS export files in the future) from the SD card after their contents have been loaded into the app's database. That deletion, which could be programmed to occur automatically, would make this app compliant with the Church policy requirement that such data be password-protected. The SD card is not.
ReplyDeleteAbsent such automatic deletion, users are advised to delete the file(s) manually.
One thing that is annoying is that while the main display is organized by household, the displayed name is only that of the head-of-household.
ReplyDeleteSo the app's main directory displays
DOE, John
instead of
DOE, John & Jane
I put the csv file in the membership directory but it won't pull it into the app UI
ReplyDeleteD360,
ReplyDeleteCan you give me more detail on what you are experiencing? Is an error thrown? Usually an import takes a good few minutes, depending on the size of your ward. Is there any pause? If there is no pause, it is not finding your file. Make sure the path is correct, it should be /sdcard/WardRoster/Membership.csv Make sure the case matches perfectly. Let me know how that goes.
Love the concept of the program. I was really hoping that someone would make something like this for the android, but...
ReplyDeleteI can't get the program to load the csv file. I placed it in the ward roster file it created on my sd card, then hit import and nothing happened. Just a blank black screen. Even went back and renamed the ward file to Membership.csv to see if that helped but still nothing...
No progress bar, no error just a blank screen.
Is their a differance between the MLS crv file the clerk has and the crv file you can download from your ward web page?
ReplyDeleteQ,
ReplyDeleteThanks for the input. I'll look into that. I've heard from some that it is working, so I'll have to dig in to see why it is not working for some. I'll add some messaging so that I have a better idea of what is happening, based on the message returned. Stay tuned for an updated version.
Also, I appreciate the feedback, as that will help make this app better.
Q,
ReplyDeleteWow, it looks like we posted at the same time!
In answer to your second question, the answer is absolutely yes. The CSV file provided by the ward clerk has a lot more data. Here's the first several columns in the CSV file that the ward clerk could provide:
"Indiv ID","Full Name","Preferred Name","MRN","HofH ID","HH Position","HH Order","Phone 1","Phone 2"
This data file also includes ordinance dates,membership numbers, etc.
Well that might be the whole issue right there. I was loading the csv file from the ward login.
ReplyDeleteI might suggest that you make it compatable with the downloadable csv file on the individual ward page. That way I don't have to track down my membership clerk. Plus I don't really want or need membership numbers or ordinence dates.
Q,
ReplyDeleteThat's a great idea. I hadn't considered that, but it would definitely make the app more useful and broaden the scope of users for it.
well that would explain my issues too, I was getting the csv from my ward's web site log in.....
ReplyDeleteI tried uploading the Membership.csv file from the stake computer, and it worked just fine. However, the app seems to be limited to only a certain number of rows. I can only get about A-H to show up. This is a great app idea, and I appreciate the innovation. Thanks.
ReplyDeleteMr. Boy,
ReplyDeleteI'd never tried with the stake file, so that's great news that it works too.
What does the limitation with rows seem to be? Is there a certain number it reached when it stopped? What happened when it reached x number of rows? Any information you can provide will help me improve the app.
Thanks for the feedback!
It puts out 1108 rows in order, just as it appears it should be. This puts ours halfway through the "I's". Then it gives an additional 12 random rows from the J - Z letters. I tried reloading and refreshing, and it gives me the same results. The program does not give any indication that something is wrong. Those are just the final results. As opposed to being an issue with the row count, could there be a limitation on the data? The stake Membership.csv file is 1.5 Mb.
ReplyDeleteWould love to use the app, but similar to "Q" who posted on Oct 10, downloaded to: E:WardRoster/Directory.csv tried to import, blank, black screen. Nothing. Tried to rename the file to Membership.csv, same results. Any ideas?
ReplyDeleteI downloaded the app, downloaded the csv file from the lds.org, put it on the SD Card and imported it. Sample line:
ReplyDelete"LastName, FirstName,""(xxx) xxx-xxxx"",""12345 AnyWhere Ln"",""Tampa, Florida 33333"","""","""",""MyEmail MyEmail at xyz.net "",""MySon Name"""
It shows up as:
LastName,FirstName,(xxx) xxx-xxxx and OverView screen no MySon Name and Contact has City,State Zip
BlankLine with a comma and
12345 (HyperLinked) and Street Address.
What did I do wrong?
Dave,
ReplyDeleteI looked at your example and it looks like the CSV file you pulled is double quoting. For example, there are two quotes after the comman and before your sons name, then 2 more after your sons name. There should only be one set of quotes.
Also, what browser are you using? Google Chrome is known to cause some issues.
Same problem with website directory. Don't know if you've had a chance to look into it but just in case you have, it's still an issue. I'd go to the clerk but I just have no use/right to the extra information. Thanks for taking the time to make such a great app!
ReplyDeleteThanks for the great idea for the app. Look forward to using it after the bugs get worked out.
ReplyDeleteI to can't install the app because I have the csv off the website and not the one you get from your local ward clerk.
I downloaded csv file from lds.org and placed in in the ward roster file on my sd card. when I run the app I get no csv file found. Tried deleting and reloading the app and same result. Any ideas how to get program to find the csv file?
ReplyDelete