XML Export Feature

Discussions around using and interfacing with the Church MLS program.
User avatar
WelchTC
Senior Member
Posts: 2085
Joined: Wed Sep 06, 2006 8:51 am
Location: Kaysville, UT, USA
Contact:

#11

Post by WelchTC »

thedqs wrote:Sounds good though from how Tom made it sound this won't be just a green list of acronyms but all 3 letter words. When will the forums be done?
That is correct. In fact, any three letter combinations.

Tom
User avatar
thedqs
Community Moderators
Posts: 1042
Joined: Wed Jan 24, 2007 8:53 am
Location: Redmond, WA
Contact:

#12

Post by thedqs »

Actually I guess the fourms mst filter for common words because "the", "but" "and" don't return anything while MLS XML and the likes do.
- David
User avatar
WelchTC
Senior Member
Posts: 2085
Joined: Wed Sep 06, 2006 8:51 am
Location: Kaysville, UT, USA
Contact:

#13

Post by WelchTC »

thedqs wrote:Actually I guess the fourms mst filter for common words because "the", "but" "and" don't return anything while MLS XML and the likes do.
Yes it does but I'm not sure where that "common word" list is located.

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

#14

Post by russellhltn »

tomw wrote:Hey, don't push your luck. ;)
:D:D

(Too short it says - grumble, grumble...)
User avatar
bhofmann
Member
Posts: 272
Joined: Tue Feb 06, 2007 9:47 am
Location: Tulsa, OK
Contact:

#15

Post by bhofmann »

tomw wrote:Yes it does but I'm not sure where that "common word" list is located.

Tom
I can't remember what version of MySQL you are using but here are some references to updating your stopwords list. Basically you create your own list and override the default stopword list by setting the ft_stopword_file system variable.

Here is where it talks about it, http://dev.mysql.com/doc/refman/5.0/en/ ... uning.html.

Here is the current stopword list if you wanted a list to to start with, http://dev.mysql.com/doc/refman/5.0/en/ ... words.html.
rmrichesjr
Community Moderators
Posts: 3847
Joined: Thu Jan 25, 2007 11:32 am
Location: Dundee, Oregon, USA

#16

Post by rmrichesjr »

thedqs wrote:I remember that we talked before about shortening the search to 3 letters but then you have all the problems with "the" "him" "and" which causes a lot of server slowdown. Of course you could add a word blacklist. It is currently in Tom's hands. As for xml I agree that would be nice especially for 3rd part apps to have your own LDS Tech form reader or something. There is an RSS for the new threads created though.
A blacklist for short, frequently used words with essentially zero information gain is a good idea. If I understand correctly, most conventional indexing and searching systems use such a list.

Oh, and "three letter acronym (or abbreviation)" can be shortened to TLA. :-)
User avatar
WelchTC
Senior Member
Posts: 2085
Joined: Wed Sep 06, 2006 8:51 am
Location: Kaysville, UT, USA
Contact:

#17

Post by WelchTC »

bhofmann wrote:I can't remember what version of MySQL you are using but here are some references to updating your stopwords list. Basically you create your own list and override the default stopword list by setting the ft_stopword_file system variable.

Here is where it talks about it, http://dev.mysql.com/doc/refman/5.0/en/ ... uning.html.

Here is the current stopword list if you wanted a list to to start with, http://dev.mysql.com/doc/refman/5.0/en/ ... words.html.
Thanks, I'll look into it.

Tom
Locked

Return to “MLS Support, Help, and Feedback”