[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Sheflug] Can open office help?



david wrote:
> Dear all
>
> A school I do some work for has hit a problem with SIMS (their school
> management system). Previous versions allowed teachers to export data in
> a variety of formats, including csv and excel 2000. The latest version
> only works (according to Capita who produce it) with Excel 2003. They've
> been warning about the upgrade needed for a year now. When the data is
> exported Excel's now fired up automatically and the data appears in a
> spreadsheet. The data exported is still only a single table so we can't
> see any reason why the option to export as csv is no longer there. It's
> a bit inconvenient for me as well as I was using the csv file to get the
> pupils, teachers and classes into moodle. The network manager's looked
> for a temporary excel file on the hard drive but can't find one, and the
> error that comes up on the machines with Office 2000 is something like
> 'The application couldn't be found' - sorry I didn't jot down the exact
> message. Can anyone suggest a way in which OO (or another open source
> solution) might help? 
>
> Thanks
>
> David Willington
>
>
> _______________________________________________
>         Sheffield Linux User's Group
>   http://wwww.sheflug.org.uk/mailfaq.html
>  GNU - The choice of a complete generation
>
>
>   
What format are the sims databases in?
Are they encrypted?

If they are not encrypted, you could try sql and odbc to extract the 
required info to the required format.

If they are in VFP format (unlikely) I have already written stuff to 
extact info

-- 
Fernite of Sheffield Ltd
Fernite Works
Coleford Road
Sheffield
S9 5NJ
Registered No: 3133576 England




_______________________________________________
        Sheffield Linux User's Group
  http://wwww.sheflug.org.uk/mailfaq.html
 GNU - The choice of a complete generation