Query not working in process, works from gui

ckacoroski · Post by **ckacoroski** » Tue Jun 26, 2007 8:04 pm

Hi,

I have process to import students from an external table. For the initial import I used:

Find ExtStudent where ExtStudent.EndDate is Undefined
UpdateStudent <-- process to update each student found

Problem is that this grabbed all students. When I run the exact same query from the GUI (e.g. Search Objects->New Query), I get the expected behavior. I can run the opposite from within the GUI to get all the accounts I did not want to import:

Find ExtStudent where ExtStudent.EndDate is defined

Any ideas on how to get this query to work in a process.

BTW, I have 50000 students total of which 20000 are active and need to be imported.

cheers,

ski

aware_support · Post by **aware_support** » Wed Jun 27, 2007 1:21 am

Very strange. The code that works from the GUI and from the process should be identical. Are you sure you are getting all students? Can you try some other condition in the process and check if it is being picked up?

ckacoroski · Post by **ckacoroski** » Wed Jun 27, 2007 7:02 pm

I must have been doing something wrong yesterday. Everything worked today. I ran it in test mode with the default logging settings (minimal, log to console). All 20K students were created ok using 520MB of ram. The web browser crashed during the process so I had to cancel the process after it completed. Got the correct number of changelogs and everything.