Page 5 of 9

Posted: Wed Oct 07, 2009 11:49 am
by mkmurray
RussellHltn wrote:I'd suggest editing the file with a text editor such as notepad. It's ugly, but it works.
Better yet, correct them in MLS. If you're not the guy, then make a list of changes and get it to the Membership clerk.

Posted: Wed Oct 07, 2009 11:52 am
by RossEvans
mkmurray wrote:Better yet, correct them in MLS. If you're not the guy, then make a list of changes and get it to the Membership clerk.

His problem is that he is a stake clerk. All such edits must be made in ward MLS. (I suppose he could send the files to the ward clerks to make corrections.)

Posted: Wed Oct 07, 2009 11:58 am
by lajackson
boomerbubba wrote:His problem is that he is a stake clerk. All such edits must be made in ward MLS.

Another training opportunity on the importance of accuracy in membership records. [grin]

Posted: Wed Oct 07, 2009 12:04 pm
by RossEvans
lajackson wrote:Another training opportunity on the importance of accuracy in membership records. [grin]

And another opportunity to lament the fact that MLS provides no tools for validating and standardizing addresses.:mad:

Posted: Wed Oct 07, 2009 12:05 pm
by russellhltn
boomerbubba wrote:His problem is that he is a stake clerk. All such edits must be made in ward MLS. (I suppose he could send the files to the ward clerks to make corrections.)
And he probably wants to get his map sometime this month. ;)

Long term, that is the right way to do things.

Posted: Wed Oct 07, 2009 12:09 pm
by rmaughan
Am I allowed to jumble up the order of the rows (not columns) in the CSV file -- or does that also mess up WardMap?

Posted: Wed Oct 07, 2009 12:12 pm
by RossEvans
robm wrote:Am I allowed to jumble up the order of the rows (not columns) in the CSV file -- or does that also mess up WardMap?

The developer (or experimentation) would have to answer that for sure. My bet is that it doesn't matter.

Posted: Wed Oct 07, 2009 12:30 pm
by hpaulsen
robm wrote:So in the short term I was opened the membership.csv file in excel and hand tweaked and fixed most of the problems with the addresses. However, after I save the file and try to load it into WardMap, it just sits there trying to import and does nothing.
This may be more trouble than it's worth, but if you open the unedited file in WardMap, then click on the offending addresses, you can place them on the map yourself. Look up the locations with whatever geocoder you prefer, find out where they are, and point them out on the map. WardMap will remember these locations, so you'll never have to do the same address twice (unless you move to a different computer).

Posted: Thu Oct 08, 2009 5:51 am
by nutterb
robm wrote:Oh...boy, gonna make me write a perl script -- hmm, seems like this could be a problem someone else has already solved. Maybe Google has my answer...

Thanks for the info--
This is a problem I experience regularly with work. My solution is to use a program called R to read in the Excel CSV, then export it to a new file. R will write the csv file in the format WardMap is looking for. As long as you don't open it in Excel, you should be okay.

It's an extra step, but it let's me use the convenience of Excel spreadsheets while still getting the format that I need.

R Foundation for Statistical Computing

Sample code to import data
Import <- read.table( [FILENAME], header=TRUE, sep=",")

Sample code to export data

write.table( Import, [FILENAME], quote=TRUE, sep=",", row.names=FALSE)

Posted: Wed Oct 14, 2009 4:34 pm
by techgy
robm wrote:I am a stake clerk and am trying to use the WardMap program -- I noticed that we had a large number of addresses that could not be mapped and this was mostly due to spelling errors, abbreviations, and missing information in the address fields in the membership.csv file......
I'm having a similar problem with a Singles Branch. I've exported the membership.csv file and loaded it into WardMap (twice). Both times it counts the correct number of members - around 80, but every address except one is not mapped. During the mapping process 79 of the 80 addresses are noted as errors.

I've checked the csv file and the addresses appear to be correct, although they are scattered around a bit - perhaps by a few miles instead of a few blocks. The single address that's mapped is no different than any of the 79 addresses that are not mapped.

I've had no problems at all installing the program for the wards in our stake.
One more thing....I've not edited in any way the CSV file that's exported from MLS.

Suggestions? Is a branch csv file different from a wards??