https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 14:52:39 +0000 Sun, 28 Nov 2004 15:35:52 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=12731 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/sql-import-to-tblauthor-issue_topic12731_post70513.html#70513 Author: confused2xover
Subject: 12731
Posted: 28 November 2004 at 3:35pm

Thank you, I was able to import successfully! Now I am off to bigger and better things............   Lot's more to do and oh so little time....]]> Sun, 28 Nov 2004 15:35:52 +0000 https://forums.webwiz.net/sql-import-to-tblauthor-issue_topic12731_post70513.html#70513 https://forums.webwiz.net/sql-import-to-tblauthor-issue_topic12731_post70495.html#70495 Author: dj air
Subject: 12731
Posted: 28 November 2004 at 12:20pm

the value just has to be different ,

so you can have 425834853Username2 and dfsskdfks4=zsssd
]]> Sun, 28 Nov 2004 12:20:26 +0000 https://forums.webwiz.net/sql-import-to-tblauthor-issue_topic12731_post70495.html#70495 https://forums.webwiz.net/sql-import-to-tblauthor-issue_topic12731_post70494.html#70494 Author: confused2xover
Subject: 12731
Posted: 28 November 2004 at 12:17pm

Thank you so much for the reply and the great forum here.

Sounds like a plan, I'll giver it a try and make it generate a randomset of numbers as it imports the other columns and see if thiseliminates my issues.

Just as long as they are unique I should be fine?  Nothing fancy or certain string format required?

Thanks again.
Keep up the great work,
]]> Sun, 28 Nov 2004 12:17:55 +0000 https://forums.webwiz.net/sql-import-to-tblauthor-issue_topic12731_post70494.html#70494 https://forums.webwiz.net/sql-import-to-tblauthor-issue_topic12731_post70475.html#70475 Author: dj air
Subject: 12731
Posted: 28 November 2004 at 9:20am

you haven't got auto number or anything that is Plujs 1 or something..

you might be able ot do a random generator to enter codes for each user. as it doesn't have to be spacific.
]]> Sun, 28 Nov 2004 09:20:29 +0000 https://forums.webwiz.net/sql-import-to-tblauthor-issue_topic12731_post70475.html#70475 https://forums.webwiz.net/sql-import-to-tblauthor-issue_topic12731_post70447.html#70447 Author: confused2xover
Subject: 12731
Posted: 27 November 2004 at 3:57pm

I seem to be having all kinds of issues using SQL 2000 DTS andimporting my current user table into the forum table.  I have hadto create many additional columns in my table to match the Author Tablein the forum.

I have answered all of it's issues so far and created columns with theappropriate information and formatting, etc.  However, currentlyit is telling me that "User_code" column must be unique identifiers.

When my users sign up for my online service we have a portal site thathas two levels, per company and per user in each company, so our tablesare several and all reference each other.

Each user is assigned an identifier randomly generated viaVBScript.  I tried to use these unique identifiers as the columnto import into the "User_code" column, but the SQL DTS still tells methat the "User_code" column allows only unique identifiers.

Ihave tried everything I could, worn the search feature in these forumsout searching for information, and still I cannot figure out how toimport my current users into the forum.

I did find where I could disable the encryption which was nice if I wasmanually entering these, but I do not have the time to enter each oneof my members now or in the future, so I have to figure out how toimport them from another various sets of SQL tables and set up a wayfor the system to import each time I get new users.

I am by no means a SQL wiz, so please be easy.

Any ideas on how I can make this work? How do I bypass the need for aunique "User_code" or auto-generate one so this will import?
]]> Sat, 27 Nov 2004 15:57:06 +0000 https://forums.webwiz.net/sql-import-to-tblauthor-issue_topic12731_post70447.html#70447