The prefered method of importing into MSSQL is to let extractusers do it
for you. The fixed width columns aren't used when the insert is done
automatically.
I'll add a quoted text qualifier to eliminate the import problem.
Chris
----------------------------------------------
Original Message
From: "Craig Gittens"<[EMAIL PROTECTED]>
Subject: [IMail Forum] MSSQL7 and extractusers.exe
Date: Wed, 21 Mar 2001 11:50:52 -0400
>Guys,
>
>I had a problem with extractusers.exe and sql. I did the extract and then
>imported the users into MSSQL7 using MS DTS wizard on the fixed space text
>file. I thought it worked quite well until I couldn't log into web
messaging
>because it would crash and in Imail Admin, the user list would come up, but
>no attributes like FULLNAME or mail address. As well, if I clicked on a
user
>and then clicked on the Info Manager tab, Imail would close itself (sound
>familiar?)
>
>I noticed there were spaces after the values in the varchar fields, to
solve
>all these problems I trimmed the field columns with this: (note I am not
>that good with SQL, I only started using it yesterday)
>
>UPDATE tablename set fieldname = rtrim(fieldname)
>
>You have to do it for all the varchar fields.
>
>I am not sure if you need to do this if you use the extractusers to enter
it
>into the database at the same time. Hope this helps somebody save some
time!
>
>Craig.
>
>
>Please visit http://www.ipswitch.com/support/mailing-lists.html
>to be removed from this list.
>
>An Archive of this list is available at:
>http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
>
_____________________________________________
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
