SQL import to tblAuthor issue
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=12731
Printed Date: 11 April 2026 at 2:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL import to tblAuthor issue
Posted By: confused2xover
Subject: SQL import to tblAuthor issue
Date Posted: 27 November 2004 at 3:57pm
|
I seem to be having all kinds of issues using SQL 2000 DTS and
importing my current user table into the forum table. I have had
to create many additional columns in my table to match the Author Table
in the forum. I have answered all of it's issues so far and created columns with the appropriate information and formatting, etc. However, currently it 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 that has two levels, per company and per user in each company, so our tables are several and all reference each other. Each user is assigned an identifier randomly generated via VBScript. I tried to use these unique identifiers as the column to import into the "User_code" column, but the SQL DTS still tells me that the "User_code" column allows only unique identifiers.  I
have tried everything I could, worn the search feature in these forums
out searching for information, and still I cannot figure out how to
import my current users into the forum.I did find where I could disable the encryption which was nice if I was manually entering these, but I do not have the time to enter each one of my members now or in the future, so I have to figure out how to import them from another various sets of SQL tables and set up a way for 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 a unique "User_code" or auto-generate one so this will import? |
Replies:
Posted By: dj air
Date 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. |
Posted By: confused2xover
Date 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 random set of numbers as it imports the other columns and see if this eliminates 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, |
Posted By: dj air
Date Posted: 28 November 2004 at 12:20pm
|
the value just has to be different , so you can have 425834853Username2 and dfsskdfks4=zsssd |
Posted By: confused2xover
Date 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....
|