MLS Export Formats...

Discussions around using and interfacing with the Church MLS program.
User avatar
Mr. M-p40
Member
Posts: 58
Joined: Wed Apr 18, 2007 10:31 am
Location: Anderson, CA
Contact:

MLS Export Formats...

Postby Mr. M-p40 » Thu Aug 07, 2008 12:38 pm

I was wondering if the MLS export formats had changed recently?
[color=black][font=Trebuchet MS][size=84]Mr. M[/color][/SIZE][/font]
[color=black]-----------------------------------------------------------------------[/color]
Visit me virtually anytime. ;)

http://www.mariohipol.com

User avatar
childsdj
Community Moderators
Posts: 258
Joined: Wed Feb 07, 2007 9:51 am

Postby childsdj » Thu Aug 07, 2008 2:19 pm

They have since MLS 2.8.3 I believe. The export is now a vcard format. I think that is the only current option, but should also have the csv export ability as well some time in the future.

User avatar
Mikerowaved
Community Moderators
Posts: 3131
Joined: Sun Dec 23, 2007 12:56 am
Location: Layton, UT

Postby Mikerowaved » Thu Aug 07, 2008 3:14 pm

Hummm... I don't see a vcard option for Export. I only get the standard .CSV file (using MLS 2.8.3_13810). Whether the actual structure of the file has changed from before, I can't say. I don't use it much myself.

I like to use an often overlooked method of pulling up an Abbreviated Ward List, then click Edit-->Copy to file and save it. The only gotcha is it saves it with the extension of .CSV, but it's NOT in Comma Seperated Value format, it's TAB delimited. IMO, they should not use the .CSV unless it fits the format. Anyway, I find this file much easier to use when creating my awesome looking Ward lists, rather than parsing the entire Membership dump.

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

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

Postby RossEvans » Thu Aug 07, 2008 4:14 pm

AFAIK, there are six export files available at the ward level, all in .csv format. I know of no documentation, except for that in this unofficial list at LDSclerks.org.

Two of the files -- PalmFamily.csv and PalmIndividual.csv -- have no column headers, and the first of these has an annoyingly complex structure with some troublesome embedded Line Feeds. The other files are conventional, flat .csv files with column headers, which are sort of self-explanatory.

I don't think anything has changed recently, but I have only been using these files for the past three months after a long hiatus. I hazily remember similar export files being available in the old MIS system, where at least their layout was documented.

User avatar
childsdj
Community Moderators
Posts: 258
Joined: Wed Feb 07, 2007 9:51 am

Postby childsdj » Fri Aug 08, 2008 8:11 am

My mistake, it will be out in the next release (MLS 2.9).

User avatar
Mr. M-p40
Member
Posts: 58
Joined: Wed Apr 18, 2007 10:31 am
Location: Anderson, CA
Contact:

Postby Mr. M-p40 » Fri Aug 08, 2008 9:38 am

DJC wrote:My mistake, it will be out in the next release (MLS 2.9).


Will this mean they are replacing the CSV formats?
[color=black][font=Trebuchet MS][size=84]Mr. M[/color][/SIZE][/font]
[color=black]-----------------------------------------------------------------------[/color]
Visit me virtually anytime. ;)

http://www.mariohipol.com

User avatar
mkmurray
Senior Member
Posts: 3241
Joined: Tue Jan 23, 2007 9:56 pm
Location: Utah
Contact:

Postby mkmurray » Fri Aug 08, 2008 9:43 am

Mr. M wrote:Will this mean they are replacing the CSV formats?

Not according to DJC's earlier statement...
DJC wrote:They have since MLS 2.8.3 I believe. The export is now a vcard format. I think that is the only current option, but should also have the csv export ability as well some time in the future.

Apparently they hope to restore CSV in the future. I'm only guessing, but in light of others mentioning on other threads that sometimes it wasn't a true CSV export, perhaps they are planning to clean it up and have it be a true CSV file format.

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

Postby RossEvans » Fri Aug 08, 2008 9:49 am

mkmurray wrote:Not according to DJC's earlier statement...

Apparently they hope to restore CSV in the future. I'm only guessing, but in light of others mentioning on other threads that sometimes it wasn't a true CSV export, perhaps they are planning to clean it up and have it be a true CSV file format.


The current export files are in true CSV fomat (although the two Palm-formatted files stretch the defiinition with embedded Line Feeds). I think DJC is talking about a future release of a VCard format.

User avatar
mkmurray
Senior Member
Posts: 3241
Joined: Tue Jan 23, 2007 9:56 pm
Location: Utah
Contact:

Postby mkmurray » Fri Aug 08, 2008 9:55 am

boomerbubba wrote:The current export files are in true CSV fomat (although the two Palm-formatted files stretch the defiinition with embedded Line Feeds). I think DJC is talking about a future release of a VCard format.

Yes, vCard export will be out in the 2.9 release of MLS (according to DJC). He also mentioned that CSV would possibly resurface in some future release of MLS after 2.9. I was trying to guess if there were going to be changes to those CSV exports. Perhaps my guess at "true CSV format" was misguided; maybe there will be more fields included in the future CSV exports?

Maybe I should just quit guessing? :rolleyes:

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

Postby RossEvans » Fri Aug 08, 2008 11:18 am

mkmurray wrote:Maybe I should just quit guessing? :rolleyes:


DJC can speak for himself, but I think he meant to say that his original post was mistaken.

I can confirm empirically that all six .csv export files exist in MLS today. I export five of them every week.


Return to “MLS Support, Help, and Feedback”

Who is online

Users browsing this forum: No registered users and 1 guest