04-10-2008, 04:45 AM
|
#2 (permalink)
|
| Courtauld Institute of Art Join Date: Jan 2007 Location: London UK
Posts: 36
Rep Power: 0  | Hi James,
Our student records are all kept on SITS which we export on a yearly basis onto RE. We export the student info over at the start of the year and then after graduation we update the affected students, change them to alum and record what their degrees were.
The exports are never easy as there is a lot of mopping up to do (ie 1 person might have 3 address lines , then their age in the 4th column and then a 2nd person might have 1 address line and their age would appear in the 2nd column.) However, I would imagine that this is all down to how they enter data in the registry.
The actual transfer is done by exporting from SITS into a csv and then importing this into RE using the import feature.
I suppose if I could change improve anything it would be to design my import for Raiser's Edge and then have a custom export from SITS so that I could get what I wanted at the click of a button.
__________________ Lee Harrison
Database Coodinator
Courtauld Institute of Art |