DarkSithBob

Hi, i work for an LA that delivers regualr periodic reconciliation files to schools but we do not support the schools SIMS/FMS installs (this is handled by a support company of the schools choice) Since the new financial year we have had users reporting duplicate entries in FMS after an import of the files sent. I have checked the files we generate & send out and have found no duplicates within the file & therefore suspect that the users are importing the reconciliation files twice or more. has anyone had this issue (especially recently) and is this possible? I assumed (i know i shouldnt!) that capita's FMS module would recognise the file (name, time stamp etc...) and issue a warning like "hang on -you've already imported this file!" and error out. Im i wrong in assuming this and can anyone point me in the direction of any instructions that i can send out to schools to remove these entries (at the minute its to advise a complete restore of the DB which is a bit of a pain for both the users, the 3rd party support companies and the LA) Also, is there a log of what files have been imported into FMS and when so we can see if a user has indeed imported the same file multiple times? Thanks Gavin.

The PDF's from capita included on the Autumn 2009 CD are useful (also the FMS Installation) however they do not mention the following setup steps: Edit config.nt -> files=254 Environment variable -> LANID = nn Borland Database Engine configuration -> system - max file handles = 121 and -> driver - paradox - net dir change from c: to S:\sims These have been done by previous technical support people at our authority and it's just stuck with us. does anyone know if these still need to be changed or is this just legacy stuff now? We want to minimise the amount of work that needs to be done on each workstation as we roll them out now. Thanks in advance, Bob

hi, is there any way to redirect to this type of file, for example if i copy the contents and modify it to my c:\program....\connect.ini file it works ok. however if i copy this connect.ini file to the s:\sims folder and create a c:\program....\connect.ini file to redirect to s:\sims, the drop down list fails and i can only login to the first DB listed!!! i have a requirement for a terminal server so i cannot rewrite files on the c:\ drive and the drop down list seems to have an issue with more than 10-12 entries. Thanks, Gav

We are currently in the process of implementing a centrally hosted SIMS & FMS system for multiple schools in our authority and i am interested of any suggestions of how others perform backups for SIMS, FMS and DOCSTORAGE data. we are using 2 servers, one SQL server 2005 that hosts SIMS & FMS SQL database which we are intending to use the SQL maintainence tasks to perform a FULL backup for each DB to a .bak file which then gets backed up using Legato. the second server is used purely for the DOCSTORAGE server - is it neccesary to stop the service and then perform a backup using the legato client and then restart the service when finished? what do others use and can anyone recomend a better/different way? Regards, Gavin