Date: Tue, 4 Apr 2006 15:24:41 -0400
Reply-To: "Roberts, Michael" <robertsm@ahca.myflorida.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Roberts, Michael" <robertsm@ahca.myflorida.com>
Subject: Re: problem with SAVE TRANSLATE
Content-Type: text/plain; charset="us-ascii"
You could try saving the data in dbf format and then import it using
SQL. If have problems saving the data, it is likely that data in one
field or more, are inconsistent. This type of error will cause you to
have the problems you are describing.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
RD
Sent: Tuesday, April 04, 2006 2:31 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: problem with SAVE TRANSLATE
Hi again,
First of all thank you for your answers.
Second: the error show that the 39 case is where it drops, because I've
erased case 35 to try to see a partern.
I don't see any ' in the data, and the error says that I have an error
around ''.
I was using a sax script to export data to XML format, and then import
it with java in MySQL, but because the script is putting everything into
memory, it is very slow and unusable with large data files (30k+ cases).
Any other way I can get data out of the spss to xml or any other usable
format?
Thank you,
Catalin Acatrinei
--- Michael Healy <healym@earthlink.net> wrote:
> Hi, I've also seen this message using MySQL. I think it's a bug
> related to the '/replace' option. You could try working around this
> problem by adding /SQL statements in which you drop the table then
> rebuild the table and then add your data to the new table using the
> /append option. For what it's worth though, I found that after fixing
> this problem, SAVE TRANSLATE /type = ODBC was unusable for large
> datasets as rows were inserted at a rate of about 100/2 sacs.
> Mike
>
> > From: RD <acatram@yahoo.com>
> > Reply-To: RD <acatram@yahoo.com>
> > Newsgroups: bit.listserv.spssx-l
> > Date: Tue, 4 Apr 2006 03:55:14 -0700
> > To: SPSSX-L@LISTSERV.UGA.EDU
> > Subject: problem with SAVE TRANSLATE
> >
> > Hi all,
> >
> > I want to export from SPSS14 to MySQL; I am using
> the
> > MySQL odbc, and works for the first 34 cases; The command is like:
> >
> > SAVE TRANSLATE
> > /TYPE=ODBC
> >
> /connect='DSN=LocalSource;UID=user;PWD=password'
> > /table="table1"
> > /unselect=retain
> > /replace
> > /map.
> >
> > However, at case #35, it dies with the following
> > message:
> > ---------------------
> >> Error # 6491. Text: Case #39 has been dropped Insert record failed
> >> This command not executed.
> >
> >> [MySQL][ODBC 3.51 Driver][mysqld-5.0.19-nt]You
> have
> > an error in your SQL
> >> syntax; check the manual that corresponds to your
> > MySQL server version for the
> >> right syntax to use near '' at line 1
> > C
> >
> >
> >
> >
> >> Error # 6487
> >> Write request failed - couldn't write any data.
> >
> >
> >> Error # 6452
> >> An error occurred while the output file was being
> > written.
> > ------------------------
> >
> > Can anybody point me to the right direction on how
> to
> > solve this? Or where/how I can see more detailed
> log
> > information?
> >
> > If I erase case # 35, then it goes up to #39,
> where it
> > dies again. I look at the data and I see no reason
> why
> > this is happening.
> >
> > Thank you.
> >
> > Best regards,
> > Catalin V. Acatrinei
> >
> >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
