Fronter / SIMs Integration

[jdoyle]

Is anyone else havign problems with the integration between SIMs and Fronter?

 

It used to be that new students/staff used to be created by the daily scheduled task on the SIMs server. Ditto any timetable changes for staff/students would be automatically updated overnight.

 

This no longer appears to be the case for us. The support desk at Fronter suggested doing a Full Export on a regular basis. Great but I'm paying for an automated option.

[Edu-IT]

In your scheduled tasks when does it say it last ran, any errors?

[jdoyle]

it still runs everynight; no errors recorded.

[Edu-IT]

In SIMS there is a report for data out for the VLE. Does this contain anything worthwhile?

[timbo343]

Yep, we looked at that and thought, lets go to SIMS Learning Gateway.

 

The fronter version is very basic and no one would tell us how much to would be.

[jdoyle]

In SIMS there is a report for data out for the VLE. Does this contain anything worthwhile?

 

there is? How do you view this?

[Face-Man]

Do you have admin right for you Fronter building ?

 

if so you can go to admin -> tools -> import configuration -> click on the import

 

it should give you a URL about half way down "URL to use with the export web service:" if you copy and past that into a browser (why it is not a link !!) this will give you the date and time of the last import.

 

It also let you see the percentage changes that raise suspicion with the data.

 

I suspect that as the data is incremental and so if fronter misses one update that data is not resent hence the need for a full export

[jdoyle]

Do you have admin right for you Fronter building ?

 

if so you can go to admin -> tools -> import configuration -> click on the import

 

it should give you a URL about half way down "URL to use with the export web service:" if you copy and past that into a browser (why it is not a link !!) this will give you the date and time of the last import.

 

It also let you see the percentage changes that raise suspicion with the data.

 

I suspect that as the data is incremental and so if fronter misses one update that data is not resent hence the need for a full export

 

sorry, I thought it was a report in SIMs. I know about this link and used it when putting in my support request to Fronter last month - it was reporting "Not Available" under Dataset. Prior to this, I've only needed to do Full Export's at the start of the year; it's now looking like I have to do a Full Export for every change in SIMs.

[Edu-IT]

sorry, I thought it was a report in SIMs. I know about this link and used it when putting in my support request to Fronter last month - it was reporting "Not Available" under Dataset. Prior to this, I've only needed to do Full Export's at the start of the year; it's now looking like I have to do a Full Export for every change in SIMs.

There is data in SIMS too for the export. I can't remember the exact menu it's under but what you need to be looking for is DATA OUT then VLE. I can tell you more next week when I am in the office.

[Fronter]

The support desk at Fronter suggested doing a Full Export on a regular basis. Great but I'm paying for an automated option.

 

Hi, just so your aware you can send daily full exports if you wish automatically by adding /F to the scheduled task command line. If you require assistance in setting this up please feel free to call the help desk who will be happy to guide you through this.

 

Kind Regards

 

Fronter

[jdoyle]

Hi, just so your aware you can send daily full exports if you wish automatically by adding /F to the scheduled task command line. If you require assistance in setting this up please feel free to call the help desk who will be happy to guide you through this.

 

Kind Regards

 

Fronter

 

I'd rather have the incremental updates working which is why I raised a support request with Fronter initially.

[Dino]

I am also having problems with the export...however it is a data issue and cannot find a desription of the error to rectify:

 

Violation of PRIMARY KEY constraint 'PK__#vle_person_reco__0FE6CAB3'. Cannot insert duplicate key in object 'dbo.#vle_person_records'.The statement has been terminated.

 

We had a message similar to this before and it turned out to be duplicate phone numbers in students data, that resolved i ran the vle export again and got the above error, i would asssume there is other duplicate data somewhere else in some records? Any ideas with this?

[Fronter]

Hi Dino,

I would suggest logging a call with your local Sims support as it is usually due to an invalid entry in a user record and as a result the export does not complete (as you stated). Sims should be able to search the database and identify the issue in the data and resolve it.

 

Kind Regards

 

Fronter

[Dino]

Thanks for your reply Fronter

 

i have been going through this with our SIMS LA support guys, they have said i should look through the Capita knowledgebase (which i couldnt find!)to try and find a fix as they were unsure, i would assume it will take quite some time for them to sift through all our data trying to find duplicate entries etc.

[creese]

Thanks for your reply Fronter

 

i have been going through this with our SIMS LA support guys, they have said i should look through the Capita knowledgebase (which i couldnt find!)to try and find a fix as they were unsure, i would assume it will take quite some time for them to sift through all our data trying to find duplicate entries etc.

 

SupportNet is on a go slow at the moment, up and down like a yo-yo so looking in the Knowledgebase is near impossible. But if you can get onto it look for Web Support - Solution Search.

[Fronter]

Thanks for your reply Fronter

 

i have been going through this with our SIMS LA support guys, they have said i should look through the Capita knowledgebase (which i couldnt find!)to try and find a fix as they were unsure, i would assume it will take quite some time for them to sift through all our data trying to find duplicate entries etc.

 

Your very welcome,

I believe that its possible for capita to run a script on the data set which identifies the cause of the problem and where in the database the entry is located. This is usually how the problem is resolved.

 

Kind Regards

 

Fronter