Community
Showing results for 
Search instead for 
Do you mean 
Reply

Schema and tables for 10.03

Nickel Super Contributor
Posts: 2,486
Country: USA

Schema and tables for 10.03

Does anyone have this available?  Thanks, Brenda Dixon
Brenda Dixon
ACT! Certified Consultant
Dixon Consulting Solutions
404-405-4116
brenda@dixonconsultingsolutions.com
www.dixonconsultingsolutions.com
www.GoToAssist.com/sb/dixon (FOR SUPPORT)
New Member
Posts: 2
Country: United States

Re: Schema and tables for 10.03

I have been attempting to integrate the ACT! database with a VB.NET application.  I have discovered a simple way to iterate through table fields in ACT! and write the field names to the output window.  Hopefully, the following will help you.

 

Private Sub WriteFields()

Dim cFields As ContactFieldDescriptor() = framework.Contacts.GetContactFieldDescriptors()

Dim cField As ContactFieldDescriptor

Dim cList As ContactList

Try

cList = framework.Contacts.GetContacts(Nothing)

 

Dim i As Integer

 For i = 0 To cFields.Length - 1

cField = cFields.GetValue(i)

Console.WriteLine("TBL_CONTACT: ", cField.ColumnName)

 Next

 Catch ex As Exception

MessageBox.Show(ex.Message.ToString())

End Try

End Sub

 

The same code will work to get the field names from Company if you change Contact to Company.  You will have to log in to the database through code as according to the ACT! SDK before you will be allowed to extract information. 

 

Private framework As New ActFramework()

Private ActServer As String = "ACTServer"  ' Name of the ACT! server

 Private ActDatabase As String = "Act9Demo"  ' Name of the instance of ACT! on the server without file extension

framework.LogOn(UserName, UserPassword, ActServer, ActDatabase)

 

The names of the tables are TBL_CONTACT, TBL_COMPANY, TBL_???

 

Hope this helps some.