SIMS.net report problem

[localzuk]

Does anyone know how to get sims.net reports to output the following:

Pupil full name, Year, Reg group, address, parent/contact name, priority, number

I thought of doing it this way:

Pupil name, year, reg, address, UPN - In one report

Parent name, priority, contact name, home number, mobile number, work number, other number, UPN

But if there are multiple contacts, it doesn't output the UPN each time, it leaves it blank.

Any ideas?

[rob_f]

Isn't there a supress duplicates or similar named checkbox on one of the last screens of the report wizard? Have you tried that?


Rob.

[localzuk]

Isn't there a supress duplicates or similar named checkbox on one of the last screens of the report wizard? Have you tried that?


Rob.

Yep, it simply either outputs duplicate contacts or not. It doesn't affect the blank UPN on separate parent entries

[rob_f]

Erm, don't really know then. We did a very similar report to list absent pupils along with all contact phone numbers a while ago, however i'm no longer with the school so don't have access to SIMS to have a look at how we did it. It was something along the lines of setting up an RTF report template to hold it IIRC.

Sorry!

[localzuk]

Erm, don't really know then. We did a very similar report to list absent pupils along with all contact phone numbers a while ago, however i'm no longer with the school so don't have access to SIMS to have a look at how we did it. It was something along the lines of setting up an RTF report template to hold it IIRC.

Sorry!

It also has to be in csv format, for inputting into another database.

[rob_f]

If this is something that would ordinarily be done by technical users, and not on a frequent basis, i would suggest putting together a bit of a script/program to do the following:

load the csv line by line value by value into a 2d array
if currentline(upn value)==null then set currentline(upn value) to previousline(upn value)
spit the array back out to a csv

[localzuk]

If this is something that would ordinarily be done by technical users, and not on a frequent basis, i would suggest putting together a bit of a script/program to do the following:

load the csv line by line value by value into a 2d array
if currentline(upn value)==null then set currentline(upn value) to previousline(upn value)
spit the array back out to a csv

It isn't going to be a simple script though, as the goal is to set up the report to run automatically, then have a php script which runs at a certain time, drops all the data from a table (or 3 as the case may be) and import all the new data.

But it seems that I am going to have to bite the bullet and write a script to do a lot of work on the data - such as stripping non-numeric characters from phone number fields and putting them in comment fields separated from the number.

What should have been a simple thing has turned into a complex issue. As seems to be the norm with SIMS.net.