Extracting information form Isams for fundraising database

[junz]

Hi,

 

I work at a school that has a foundation set up to raise money for the school. the foundation is crucial to help with the costs of the school such as staff costs.

 

We have been told that is they are fundamental to the running of the school we are allowed to share certain information with them.

 

At the moment we provide them an Excel spreadsheet each year with the name of student, year he or she is in and primary contact name and details.

 

Each Time a parent changes their email or contact we have to provide update them as well as when when new students start/leave,

 

Is there a way for me to extract only the above data using something like groupcall into a front end database so information is upto data and when students leave that data is removed.

 

Any help with this would be much appreciated.

[Katy]

Groupcall Xporter can extract data from iSAMS using the API (we used to use it to feed data into Groupcall Messenger), but no idea on if you could then put that into another database.

[TechMonkey]

You could direct access the DB from Excel and extract data. Is your DB hosted or on site?

Could you not give them a very locked down user to ISAMS and show them how to export?

[junz]

The foundation currently just uses an Excel Spreadsheet.

 

I would like to extract to a database.

 

I will ask Isams on Monday but I do not think it is possible to refine to where you can only access Name of student, year he or she is in and primary contact name and details.

[KK20]

if the isams is locally hosted then you can script SQL to do what you want. If it isnt then you will need to shell out for isams API. The API cannot have SQL attached to it, you simply make an API, choose what access and there you go, it would be up to your "endpoint" to sanitise.

 

Isams API can create standard REST API calls, you can script this in a scheduled task if you want to create CSVs etc

[KK20]

if the isams is locally hosted then you can script SQL to do what you want. If it isnt then you will need to shell out for isams API. The API cannot have SQL attached to it, you simply make an API, choose what access and there you go, it would be up to your "endpoint" to sanitise. as far as I am aware, groupcall xporter is just a broker, it moves data from one place to another - I dont think you can "query" the data, however I could be wrong as ive never worked with creating calls to groupcall, ive only ever installed it as part of other applications.

 

Isams API can create standard REST API calls, you can script this in a scheduled task if you want to create CSVs etc

 

However, at about £600 per year, the API isnt cheap and if you only use it for this job then it is an expensive proposition. You can export CSVs from isams directly (export pupil details) with a few click, you can then mangle these in excel for a single job. Come what may you will need to sanitise the data externally anyway.

Edited April 23, 2018 by KK20