Forum OpenACS Q&A: Batch Synch with SQL

Collapse
1: Batch Synch with SQL
Posted by Nima Mazloumi on 01/19/04 05:49 PM
Hello friends,

is there a way to do the initial upload of all users via sql directly. The batch synch job takes very long and crashed two times so far.

How would an insert statement for a single user look like?

Greetings,
Nima

Collapse
2: Re: Batch Synch with SQL (response to 1)
Posted by Jade Rubick on 01/19/04 08:10 PM
There is a way to do it. Look at api-doc, in the pl/sql functions, and I think there is a Tcl script that calls it. Try grep -r in the packages directory.
Collapse
3: Re: Batch Synch with SQL (response to 1)
Posted by Lars Pind on 01/20/04 03:53 PM
Why/how did the batch sync job crash?

The thing that takes time is not reading the file, it's creating the users. So doing the insert statements directly isn't going to be any faster.

/Lars

Collapse
4: Re: Batch Synch with SQL (response to 1)
Posted by Nima Mazloumi on 01/20/04 05:13 PM
Sorry Lars, I messed it up with the replies...here is my reply to your question:

https://openacs.org/forums/message-view?message_id=157301