[Technical] Schedule an export from cases?

[Chris Hopkinson]

I have a another question on Cases 21 that I would like to solve. At
Bairnsdale SC we have setup a couple of export queries that sends Cases 21
data to text files. The text files are then used by various other programs
(such as timetabling and attendance systems).

I am looking for a way to automate the export from cases21. Is there any way
that we can schedule this to happen once a day?

Regards
Chris Hopkinson
TSSP, Bairnsdale SC

-----Original Message-----
From: tech-bounces at edulists.com.au [mailto:tech-bounces at edulists.com.au] On
Behalf Of Con Zymaris
Sent: Thursday, 2 March 2006 1:13 PM
To: Technical Discussion in Schools Mailing List
Cc: edulists.com.au IS; edulists.com.au Off Topic
Subject: Re: [Technical] Export from CASES SQL contains CR/LF within
fields.Can't find unique end of record.

On Thu, Mar 02, 2006 at 01:02:34PM +1100, Stephen Digby wrote:
> Can't seem to write  an SQL query in CASES that generates a unique 
> string start or end of record marker.
> Can't import CASES export because so many fields allow CR/LF within
fields.
> Any ideas ? suggestions ?

What tool are you using for bulk record import?

Cheers,

Con Zymaris

- CEO, Cybersource Pty. Ltd.
- Director, Open Source Industry Australia, Limited.
- Convenor, Open Source Victoria (A Government-funded industry cluster.)

-- 
___________________________________________________________________________
Con Zymaris <conz at cyber.com.au> Level 4, 10 Queen St, Melbourne, Australia 
Cybersource: Australia's Leading Linux and Open Source Solutions Company 
Web: http://www.cyber.com.au/  Phone: 03 9621 2377   Fax: 03 9621 2477


_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
Technical Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority
and
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers
Association Inc




Important - 
This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training.