Click here to Skip to main content
15,895,011 members
Articles / Programming Languages / Visual Basic

PeopleTrac – People Management for Not-For-Profit Organizations

Rate me:
Please Sign up or sign in to vote.
4.91/5 (10 votes)
3 Jan 2012CPOL6 min read 24K   877   13  
Demonstrates several LightSwitch capabilities including WCF-RIA services, Native SQL, Name and Addres merge purge
Loading PeopleTrac Test Data

The Screen "XXLoad Test Data" (under "Misc Other") provides the ability to load data in these Excel files:
	PeopleTracMailCodes
	PeopleTracPeople
	PeopleTracSeasons
	PeopleTracSubscriptionTypes
	PeopleTracMailLists
	PeopleTracMailListCodes

THey should be loaded in that order into a completely empty data base. The test data depends on ID being assigned correctly. 

You can use the excel file "PeopleTracImportedPeople" to import people for update. When you run the Calculate Match Scores you should get a variety of match, almost match, and non-mathc

You can use the excel file "PeopleTracExternalList" to add people to the External List. These will not be updated to the database, but can optionall be included in a mailing

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions