STEARsoft
School
Teachers'
Electronic
Attendance
Register
software
Home page
Download
Tutorials
Support
Forum
Forum thread: Timetable data
| Jake Alston 28 October 2010 17:24 |
Hi, I am just experimenting with STEARsoft, to see whether it is what we are looking for. It looks really promising, but no timetable data is coming through to the teacher accounts. I think this may fixable by editing the Class Accessibility Tags. When I navigate there, all the fields are grayed out, so not editable. I am importing data with ODBC from an Access 2010 Database, and cannot see a way of importing this sort of information. Thanks, Jake |
| Marcus Butler (STEARsoft) 29 October 2010 03:49 |
Hi Jake, Using ODBC is the optimal way to use STEARsoft and what you describe should all be possible. Have you followed the fuller example ofHow to dynamically import data from an existing school database in the tutorials section found in the main STEARsoft website? It's important to import the period and day information via ODBC in the administrator section, and to import the teacher accounts rather than manually create them. The class accessibility tags are not relevant to getting the ODBC import working. If you let me know at which stage on the tutorial things don't work as expected I shall try and help with more detail. Yours, Marcus |
| Jake Alston 29 October 2010 09:45 |
Marcus, Thanks for the quick reply. I followed the fuller example all the way through, creating the required tables from scratch, and importing the teachers accounts. I also imported the days, and periods as well. Really, it is just as soon as I log in as a teacher, it just says you have no classes. If I click timetable, the periods of the day are there at the top, it is just all blank. I have followed all the instructions. Jake |
| Marcus Butler (STEARsoft) 29 October 2010 14:09 |
Hi Jake, A few questions that will help me determine where the problem might be: In the teacher account, did you click the 'Import data (ODBC)' option on the left panel? (does this option exist in fact?). Has it imported any classes (they'd appear below the timetable). Has it imported any students (click the all students option on the left panel). If it's done all these things and it comes up with the 'importing please wait...' screen without any error messages on doing the 'import data', then it's worth looking a bit deeper as follows: The most likely issue is with importing times and dates over ODBC. Unfortunately the standards for this particular bit of the standard are not very standard. In the administrator section where you set up the ODBC fields there should be options to set the date format. You could play around here with trial and error, but might make faster progress by checking the error log to see if there's any useful message appearing there. The error log is found in the administrator section. If you need more detail from the error log, you can increase the logging threshold. But beware! Ensure you put it back down if you increase it. If you go over 100+ you start getting almost a complete transcript of comms which can slow things possibly in a terminal way if the log file gets huge. To adjust this threshold go tothe STEAR admin program (installed under the Start menu of windows, not part of the web interface). Let me know your answers and how you get on. Yours, Marcus |
| Jake Alston 30 October 2010 10:33 |
Marcus, OK, problem is now completely different. Have you done something to my account, because all the timetable and class information has imported, but no student info.... In answer to your questions, there is no Import Data (ODBC) on the right in the teacher account, but there is a Update Data (ODBC). I have clicked this many times. I don't really get what you are saying about the dates. I can't see any dates think within the ODBC area, but just under that, the is something. It gives me two options UK and US. I have been putting UK format in my database, and it says UK here, so I think that is fine. I have put up the log, but nothing is being logged. Any ideas? Jake PS. The account has become an active account which it was not before. |
| Marcus Butler (STEARsoft) 30 October 2010 21:15 |
Dear Jake, Sorry. I'm actually away at the moment so was trying to answer from memory using a mobile device. I've now got access to a computer with STEARsoft to hopefully give more accurate information. - Yes, I meant the 'Update Data (ODBC)' option. - Re the dates. Sorry, I think this is not relevant (I was remembering an issue in the past which has since been resolved properly) - I have not altered your account in any way, and this couldn't affect things anyway, so this shouldn't be relevant here. Why it has suddenly got a bit further may as much be to do with the Access Database side of things. I've occasionally needed to close Access to get all my changes there suitably saved. It sounds a little odd otherwise. - Re log files. Again, sorry - it wasn't quite as straight forward as I remembered. The default is to do no logging. To start logging, open the 'stear Administrator' program that is installed under the start menu and set a log files directory and set priorities to be up to 100. Stop and restart the server (also on this screen) to ensure this change is picked up. At this high level (100), you will see a log of all the ODBC communication so should hopefully pick up an indication to any problems. In particular, log the 'Update Data (ODBC)' process. Stop and Restart the server to force starting a new log file at any point. Opening the log file as a spreadsheet will allow you to filter on priority if it's big. - You could delete and re-import the teacher account, but this is a bit hit-and-miss and would only resolve unexpected situations where a teacher account has not picked up the central day and period details. It sounds like it's very close to working. Hopefully the log files will direct further effort efficiently (and be potentially useful to know about for any oddities in the future). Do let me know how you get on. Yours, Marcus |
| Jake Alston 03 November 2010 17:20 |
Marcus, Sorry not to get back to you sooner. I am having real trouble with the installation of Microsoft Office Professional Plus 2010 after the beta - nightmare. This means that the ODBC links are down so there is not much new to report. Just a thought I had though, the database file type was a .accdb. Would this affect anything? I will keep you posted when I have installed properly, Jake |
| Marcus Butler (STEARsoft) 03 November 2010 18:08 |
Hi Jake, I'm back on UK time :) I was in Canada last week. The .accdb thing crossed my mind too given you're using a more recent version of office than we've tested with. I did a mini test with .accdb files last week and it worked for me (though, I had to be careful to leave things in a sensible state to be saved in access). If you're concerned, you could always do a 'Save As' and save as the old .mdb format, but ODBC hides all the differences, so it should make no difference and I can't see this being necessary. The other option, if you haven't already got all your data in Access, and you've having problems with Access would be to use Microsoft's SQL Server Express. It's free and the last version I used for testing STEARsoft was pretty good. I believe one of our school deployments uses this rather than Access. Just Google "SQL Server Express" and the top result is probably what you want. Obviously, just get back to me when you've got a bit further. Yours, Marcus. |
| simran sandhu 23 September 2013 19:05 |
I HONESTLY CARNRT FIND THE PROGRAMME WHAT DO YOU DO AFTER YOU HAVE SET EVERYTHING UP |
| Marcus Butler (STEARsoft) 23 September 2013 19:50 |
Dear Simran, Thank you for your post. So I can help you more effectively could you please tell me a little more: Are you using the iPhone or Windows version of STEARsoft? And what have you set up; if it's hard to describe, tell me one or two items that you have set up. Yours, Marcus |
Please login to contribute to this thread.