SIMS ID Interface / CommandReporter Example
I mentioned in a separate thread a while back an Access database I created which can pull photo's and other info from SIMS in to an Access database, making it easy to design your own reports containing student photo's (it's original intention being ID cards).
Well I've got it in to a more user friendly shell now ready to share with the world, so take a look at it and feel free to comment/criticize (I'm sure you will lol) and get some idea's of how you could adapt it to your needs.
By the way, I am currently the only person who has ever used it, therefore testing is at a minimal, but I'll do my best to resolve any problems people have with it as and when I get the time to look at them.
- Download the attached ZIP file, and extract it to a suitable directory (I had some trouble using it on network drives due to restrictions in place, try running it from a local HDD if you have trouble).
- Run "RegGif89.bat" (this just runs RegSvr32 on the included "Gif89.dll", necessary for the loading GIF used in the system)
- In SIMS.net, go to "Reports > Import" and browse for the included RptDef file ("ID_REPORTS.RPTDEF")
- Finally, check that "Config.ini" has the right path set for the CLR tool (it should be right, unless your SIMS is installed somewhere other than the C: drive)
Now just open the database to start using it, you'll need your SIMS username and password to login to the database.
To populate your database with data or to refresh the data, there are two pretty self explanatory buttons: "Update Student Data from SIMS .net" & "Update Groups from SIMS .net". The first time you use the database, you'll need to update the groups first so that you can apply a filter when it comes to updating students. I recommend doing this 1 year at a time as a very large report is returned for photographs and it can take a while! There are also two forms set up which act as your reports, they're just there as an example.
The file "default.jpg" is the image that will be used if there is no photograph available for a student, replace it if you want to change that image, Access will automatically scale any image down to fit in the space available.
If anybody does use this, please bare in mind that Access is not secure!
So please don't download all your student info in to it and leave it lying around on a memory stick or anything daft like that :)