[double first] WCBS Pass export to engage

[wickit]

Hi

I have just looked at the excel template Double first have sent over...

Holy cow........

 

Has anyone done the transfer, if so how did you populate the data, when we asked for help, they just said "good luck".

Does anyone have a sql query that I can use to get the data into my excel, my SQL know how is very limited.

 

HELP

thx in advanced

[vikpaw]

No experience of PASS, but you could ask for help.

 

The DF spreadsheets are pretty standard, and it's worth taking the care to fill comprehensively even if it has to be done manually.

 

One tip: If it's not already inherent in the data, take a unique ID field from PASS for students and then create a user-defined-field for it in Engage, there should be columns that allow for this. This will allow checking later. Do the same for Parents and Staff too.

 

How does Pass work in terms of keeping access to data after you leave? Hopefully you can at least keep a full backup of the SQL for reference.