Another mapping program

Use this forum to discuss issues that are not found in any of the other clerk and stake technology specialist forums.
User avatar
mkmurray
Senior Member
Posts: 3241
Joined: Tue Jan 23, 2007 9:56 pm
Location: Utah
Contact:

Postby mkmurray » Wed Oct 07, 2009 11:49 am

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.
Many questions are already answered on the LDSTech wiki. Check it out!

RossEvans
Senior Member
Posts: 1346
Joined: Wed Jun 11, 2008 9:52 pm
Location: Austin TX
Contact:

Postby RossEvans » Wed Oct 07, 2009 11:52 am

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.)

lajackson
Community Moderators
Posts: 10291
Joined: Mon Mar 17, 2008 10:27 pm
Location: US

Postby lajackson » Wed Oct 07, 2009 11:58 am

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]

RossEvans
Senior Member
Posts: 1346
Joined: Wed Jun 11, 2008 9:52 pm
Location: Austin TX
Contact:

Postby RossEvans » Wed Oct 07, 2009 12:04 pm

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:

russellhltn
Community Administrator
Posts: 31096
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Postby russellhltn » Wed Oct 07, 2009 12:05 pm

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.
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.

So we can better help you, please edit your Profile to include your general location.

rmaughan
New Member
Posts: 32
Joined: Mon Feb 05, 2007 10:47 am
Location: Colorado Springs

Postby rmaughan » Wed Oct 07, 2009 12:09 pm

Am I allowed to jumble up the order of the rows (not columns) in the CSV file -- or does that also mess up WardMap?

RossEvans
Senior Member
Posts: 1346
Joined: Wed Jun 11, 2008 9:52 pm
Location: Austin TX
Contact:

Postby RossEvans » Wed Oct 07, 2009 12:12 pm

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.

User avatar
hpaulsen
Member
Posts: 112
Joined: Fri Mar 09, 2007 12:53 pm
Location: Barstow, CA
Contact:

Postby hpaulsen » Wed Oct 07, 2009 12:30 pm

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).

nutterb
Member
Posts: 276
Joined: Tue Feb 10, 2009 7:06 am
Location: Berea, KY, USA

Postby nutterb » Thu Oct 08, 2009 5:51 am

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)

techgy
Community Moderators
Posts: 3183
Joined: Sun Jan 13, 2008 6:48 pm
Location: California

Postby techgy » Wed Oct 14, 2009 4:34 pm

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??
Have you read the Code of Conduct?


Return to “General Clerk Discussions”

Who is online

Users browsing this forum: No registered users