[sims] Importing Email Addresses into Sims.NET

[localzuk]

I'm now writing some charting software to take exam results and spew out pie charts and so on, if that's any help.

 

--

David Hicks

 

If you did it as a webpart for sharepoint, you'd be very popular!

[dhicks]

If you did it as a webpart for sharepoint, you'd be very popular!

 

We don't have a sharepoint server, so I don't have the faintest idea about how to go about writing a webpart. I simply have a Python script that chugs through a bunch of CSV files and writes PNG and PDF documents out, all indexed by an HTML file or two. No reason you couldn't simply set the script to output somewhere where your web server will be ablke to serve the files. What is it a webpart does?

 

--

David Hicks

[localzuk]

We don't have a sharepoint server, so I don't have the faintest idea about how to go about writing a webpart. I simply have a Python script that chugs through a bunch of CSV files and writes PNG and PDF documents out, all indexed by an HTML file or two. No reason you couldn't simply set the script to output somewhere where your web server will be ablke to serve the files. What is it a webpart does?

 

--

David Hicks

 

A webpart is just a compartmentalised web application that runs within sharepoint.

 

But it has to be in a .net language, and be built in a certain way. Python etc... won't work.

[p858snake]

I think it was their scan-to-SIMS product we saw last week at Sharp's showroom. It integrates a scanner with SIMS - you use a small LCD panel attached to a photocopier/scanner to pick a student and enter some details ("note from home", etc) then scan in a document that is attached to that student's SIMS record. Nice, and it looked like it worked well, but it did strke me that you could make a system like that very easily. Just get a list of students from SIMS, make each one a folder on a computer somewhere, then hook up a scanner to a dedicated PC with a small touch-screen panel attached and write a program that asks for a student name and drops scanned documents into the appropriate folder.

 

--

David Hicks

 

*Ask for a student number

 

due to you wanting it to be unique and to be put in the correct folder in cases of multiple students.

 

You would also want to run the scan in though a automated system that ads a white area at the bottom to stamp the date, time and staff member id (of the person that scanned it in) for extra protection.

[jamesb]

A webpart is just a compartmentalised web application that runs within sharepoint.

 

But it has to be in a .net language, and be built in a certain way. Python etc... won't work.

 

However, you could use an image web part and just overwrite the file each time you generated a new one.

[dhicks]

Ask for a student number

 

The user interface would let you select a user by name, but naturally you would store scanned documents linked to a unique ID, i.e. the student number produced by SIMS.

 

You would also want to run the scan in though a automated system that ads a white area at the bottom to stamp the date, time and staff member id (of the person that scanned it in) for extra protection.

 

Probably better to store that data as proper data somewhere so you can search through it later.

 

--

David Hicks

[dhicks]

A webpart is just a compartmentalised web application

 

Like a Java servlet?

 

But it has to be in a .net language

 

IronPython?

 

--

David Hicks

[localzuk]

Like a Java servlet?

 

 

 

IronPython?

 

--

David Hicks

 

Not quite like a servlet, but similar. A webpart is a dll file on a Windows machine, and it gets loaded wherever you place it on a sharepoint page.

 

And, so long as 'IronPython' works as CLR code when compiled, I don't see why not.

[MattMitchell]

I'm now writing some charting software to take exam results and spew out pie charts and so on, if that's any help.

 

Charting is OK - it's the issue of not being able to access the data within SIMS in the right way, and not being able to access it outside of SIMS without having to export it first...

[Hecate]

I'm not very expert on this but I wondered if something couldn't be done using the CTF. We just imported all our ULNs via CTF so it ought to be possible to create an XML file with the appropriate fields for email address and import a via CTF or am I being naive

[jenny_urey]

Yes, thanks, I noticed that, was going to visit when I need to do something complicated - our old system would email students their timetables, so it would be nice to do so with SIMS - but as we don't yet have a timetable in our SIMS then I'll have to wait !

 

Plus, someone is going to say can we get it to talk to moodle at some point !

 

tim

 

 

We can talk to Moodle

[KateEChappell]

Hi

 

I know this is an old thread, but I need to import about 1000 e-mails into SIMs and would like not to have to ask one of our admin staff to do this! I've downloaded AutoIt having come across this thread and although I have some programming skills, I don't have the time to play with it (thought it would be more like a macro recording, so I could cheat and actually do the first one, then check the script to see what commands to use)....does anyone have an AutoIt script (or at least something to get me started) that they would be prepared to share?

 

Cheers (hopefully) in advance

 

Kate

[MicrodigitUK]

Hi

 

I know this is an old thread, but I need to import about 1000 e-mails into SIMs and would like not to have to ask one of our admin staff to do this! I've downloaded AutoIt having come across this thread and although I have some programming skills, I don't have the time to play with it (thought it would be more like a macro recording, so I could cheat and actually do the first one, then check the script to see what commands to use)....does anyone have an AutoIt script (or at least something to get me started) that they would be prepared to share?

 

Cheers (hopefully) in advance

 

Kate

 

What about this? Never tryed it myself.

 

http://www.edugeek.net/forums/sims-bulk-import/99098-sims-bulk-import.html

[GREED]

What about this? Never tryed it myself.

 

http://www.edugeek.net/forums/sims-bulk-import/99098-sims-bulk-import.html

 

+1 for matt's solution in the link.

[vikpaw]

If you do want the patches from Capita, you can request them from your support. You'll need #17188, a script, then #17195

[matt40k]

Is that the one where you need a D: drive with a csv file? Or the one that generates it based on the admission number?

[jmak]

Welcome Kate

@MicrodigitUK's solution is popular and has an excellent reputation , but haven't tried it myself.

 

I got grumpy a couple of weeks ago because I had a big csv file of contact details referenced against admission numbers to input and wrote to Capita and told them so! After telling me several times that it wasn't possible I got a response from one of their Sys Analysts with the patches "#17188, a script, then #17195" @vikpaw mentions above and instructions on how to use them. If you'd like a copy as an alternative solution, let me know and I'll send them across. Don't know if it works as I haven't had time to try them.......

[vikpaw]

Is that the one where you need a D: drive with a csv file? Or the one that generates it based on the admission number?

CSV , but it will also work on root of C: drive now, and if required it's trivial to alter the .sql to add another IF clause or just hard code it, if indeed you have a PC without either C or D drives

I have another one that does it by admission number that was custom written for me, but locked to a particular version and when i asked for the version to be 999'ised as i like to refer to it, they sent me this new method.

[matt40k]

it's trivial to alter the .sql to add another IF clause or just hard code it

 

Ooo... what a nice way to void your warranty

 

If you want a patch altered, get them to do it, then it'll have a signature so it'll apply via dbupgrade.

[vikpaw]

It's okay, that will only happen if i find myself without a C or D drive in which case, there's probably no SIMS either and if that happened on the server, i'll be on the next flight out.

[matt40k]

ROFL!! I'll be thinking we need to re-quote for the work

[vikpaw]

ROFL!! I'll be thinking we need to re-quote for the work

You should work for Capita

[matt40k]

Na, we disagree on the percentage of that money that the customer pays, that enters my pocket at the end of the month

[jinnantonnixx]

You should work for Capita

 

He does, as do many others. They don't get paid by them, though!

[matt40k]

I wish that was true, be nice to only support 1 application.