Re: [Activewarehouse-discuss] problems using bulk_import (to mysql on win xp)

2008-02-15 Thread Paul Cortens
are you using the Ruby MySQL gem or the native gem? I had the exact same error when using the Ruby gem. Paul On Feb 15, 2008 3:52 PM, Jesper Rønn-Jensen [EMAIL PROTECTED] wrote: Hi there I have been trying for days to get bulk import working with Activewarehouse-ETL Here is my rule in

Re: [Activewarehouse-discuss] problems using bulk_import (to mysql on win xp)

2008-02-15 Thread Marty Haught
Hi Jesper, My understanding is that this is an issue with how ActiveRecord works with MySQL. I believe there was a change in how MySQL did bulk update and that ActiveRecord's way of calling this no longer works. Sorry, I don't have more technical information on the issue. Our work around has

[Activewarehouse-discuss] problems using bulk_import (to mysql on win xp)

2008-02-15 Thread Jesper Rønn-Jensen
Hi there I have been trying for days to get bulk import working with Activewarehouse-ETL Here is my rule in employees.ctl: post_process :bulk_import, { :file = 'output/employees.out.txt', :columns = EMPLOYEE_COLS, :truncate = true, :field_separator = ',', :field_enclosure =

[Activewarehouse-discuss] Fwd: problems using bulk_import (to mysql on win xp)

2008-02-15 Thread Marty Haught
-- Forwarded message -- From: Chris Williams [EMAIL PROTECTED] Date: Fri, Feb 15, 2008 at 5:09 PM Subject: Re: [Activewarehouse-discuss] problems using bulk_import (to mysql on win xp) To: Marty Haught [EMAIL PROTECTED] I just did a gem list on my windows box and this is what it