Forum OpenACS Q&A: Re: Using the API for shell scripts

Collapse
Posted by Caroline Meeks on
Hi Agustin,

I am in the process of transfering a slightly smaller amount of data from a legacy system to a dotLRN1.0 postgres system. I am working from a excel export of the data so I am useing CSV. I created almost 5000 users from a CSV and the web interface in a couple hours. The trick for me was running Jeff's object__new performance improvements.

For Sloan we transfered data from a legacy ACES database on the same box Tracy wrote scripts that connected to both databases, extracting the data from the old database then running the tcl APIs to import the data into dotLRN. AISEC expanded and refined these scripts.

If you want to connect up to two running databases see this thread: https://openacs.org/forums/message-view?message_id=32476

If you want to extract your old data as CSV and upload it contact me, I'm doing that this week.