Solved

Creating New Column within Contact 2 Table

Posted on 2011-03-15
5
716 Views
Last Modified: 2013-11-15
Hi Guys,

I have a requirement to create a new column in the Contact 2 table and usually I do this in goldmine. By doing this process in Goldmine, Im required to get everyone out of Goldmine which is not doable during office hours.

Ive read I can create the column via the SQL manager but Im just wondering when doing it this way, is the process any different from doing within goldmine apart from everyone logging out of goldmine.

Also, when creating the table via the SQL manager and not via goldmine, will this make any differences to the way reports find data in my various tables/columns etc?

And finally, will these cause any problems on the live environment - last thing I want is when I create the table - everyone gets booted out of goldmimne.

Thanks
0
Comment
Question by:daiwhyte
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 12

Accepted Solution

by:
GMGenius earned 250 total points
ID: 35137096
You can add the new field as follows:-

Create the field in GoldMine but "DO NOT REBUILD" - when prompted select No

Add field via SQL Managment studio - make sure you select to correct field type

Log out of GoldMine then log back in
0
 
LVL 11

Assisted Solution

by:stevengraff
stevengraff earned 250 total points
ID: 35137098
Dave, you can do it this way, but you MUST be very careful!!! I have seen systems where otherwise, and it's not pretty, nor easy to fix!

1. Start the field creation process in GoldMine, taking note EXACTLY of field name, type, and size, i.e. UNEWFIELD, Character, 9. Do everything you normally would, up to the point of doing the rebuild. When GoldMine prompts you to rebuild, say No.

2. Next, in SQL, insert the field into your Contact2 table, exactly as you defined it in GoldMine. Then save the table.

3. Log out of GoldMine, the re-log in.

4. You should now be able to place the field on your screen; and no one has had to get out of GoldMine.

The tricky part is probably the data type to use in SQL. When you create a character field in GoldMine, SQL calls it "varchar." The default in SQL is 50, but you must change this to match the size you chose in GoldMine.
0
 

Author Comment

by:daiwhyte
ID: 35137176
Thank you both for coming back so quickly - looks like you are both offering to do the same solution here.

Just to recap,

Im creating a column called timeod as a varchar with 20 characters.

In goldmine, go to custom fields and create a new field
Field name: UTIMEOD
Description: TimeOD
Field Type is: Character
Len is set to 20

Got into SQL manager
Drill down to dbo.Contact2
Right click on columns and select new column
Tyoe into the blank field at the bottom of the Column Name Column UTIMEOD
In data type column, locate the Varchar 50 and select that, then edit the 50 value to 20.
Close the screen and accept the option to save changes.
0
 
LVL 11

Expert Comment

by:stevengraff
ID: 35137250
Yes.

Then you can place the field onto the GoldMine screen.

If you place the field onto the GoldMine screen it may say n/a. No problem, just get out and log back in.
0
 

Author Closing Comment

by:daiwhyte
ID: 35149955
Thank to the both of you, worked a charm.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Query to Add Late Tolerance 10 87
SQL DATE Past due to current wek 4 22
SQL Server for XML PATH giving wrong results. 6 61
What is GIS method of Geometry data type? 6 36
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Salesforce.com is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question