Transfinder AdHoc? Is it possible?

[Charles McLaughlin]

Has anyone got a transfinder adhoc that pulls the actual residence address as well as restricts the data to students actually enrolled? If so could you send along a screen shot of your field choices?  When I use "ActiveToday = True" I am getting some kids who now may have kids of their own... Campus is looking into that issue but I am about out of time.  After about 5 days (between everyone's emergencies) of trying to get the data out of IC in a useable form and using just the stock tools I am out of time.  I am just going to have to take a flat dump of students and hand remove all the duplicates created by household records.  I have tried a mutitude of different manipulations and ended up with very creative fails..  Thanks for any ideas!

Chuck

[Reggie Lizzotte]

This is what I have used to get the addresses.

I use IC ad hoc reporting; Data Export; to csv (Excel).

I then open the file in Excel and sort by last, First,  contacts.seq.

I then remove dups; data; Remove Duplicates; unselect all; then check the student.studentnumber.

You may NOT need all the columns that I chose but it might get you started.

I'm sure some one else has a better mousetrap.

Reggie

Reginald Lizzotte

Database Specialist

Ellsworth School Department

207 667-6241 Ext 3025

rliz...@ellsworthschools.org

On Tue, Nov 17, 2015 at 3:50 PM, Charles McLaughlin <cmclau...@sacopeevalleyschools.org> wrote:

Has anyone got a transfinder adhoc that pulls the actual residence address as well as restricts the data to students actually enrolled? If so could you send along a screen shot of your field choices?  When I use "ActiveToday = True" I am getting some kids who now may have kids of their own... Campus is looking into that issue but I am about out of time.  After about 5 days (between everyone's emergencies) of trying to get the data out of IC in a useable form and using just the stock tools I am out of time.  I am just going to have to take a flat dump of students and hand remove all the duplicates created by household records.  I have tried a mutitude of different manipulations and ended up with very creative fails..  Thanks for any ideas!

Chuck

**************************************************************************************

MSAD#55 Confidentiality Notice:  The information contained in this message (including any attachments) may contain privileged and/or confidential information protected from disclosure by the Family Educational Rights and Privacy Act (FERPA). It is intended solely for the use of the addressee. Any disclosure of the document is strictly prohibited outside the scope of the service for which you are receiving the information. If you have received this communication in error, please notify sender immediately and delete the material from any computer.

--
You received this message because you are subscribed to the Google Groups "MaineICUsersGroup" group.
To unsubscribe from this group and stop receiving emails from it, send an email to MaineICUsersGr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

---

The information transmitted herein is intended only for the person or entity to which it is addressed and may contain confidential material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited.  If you received this in error, please contact the sender and delete the e-mail and any attachments from any computer.

[Charles McLaughlin]

Again Thanks so much!  We got the first sheet off this morning.  We hadn't found the contact.seq - that really helped!