Community
Showing results for 
Search instead for 
Do you mean 
Reply

Field names for act database tables.

New Member
Posts: 2
Country: USA

Field names for act database tables.

Hi All,

 

I am new to sage act and i am porting my old data in sage. i am adding contacts, company and history. I am adding new company like this,

 

ActFramework framework = new ActFramework();
framework.LogOn("admin", "xxxxxxxxxxx", "xx.xxx.xxx.xx", "Sage_database");

Act.Framework.Companies.CompanyManager mgr = framework.Companies;
Act.Framework.Companies.Company comp = mgr.CreateCompany();
comp.Name = "MyCompany";
comp.Fields["TBL_COMPANY.NAME", true] = "Microsoft";
comp.Fields["TBL_COMPANY.BUSINESS_CITY", true] = "USA";
comp.Update();

 

I have one question here that where can i find all the field names for company, history and contact. (e.g. "TBL_COMPANY.NAM", "TBL_COMPANY.BUSINESS_CITY" )

 

Thanks,

 

Tuned Listener
Posts: 21
Country: Germany

Re: Field names for act database tables.

New Member
Posts: 2
Country: USA

Re: Field names for act database tables.

hi,

 

Thanks for your help. That helped me alot.

 

One more question, i am using act 2013. i am unable to add comany record manager programatically. Here is my code and i get the following error:

 

Error: Invalid name format: MANAGEUSERID_NAME
Parameter name: realName

 

comp.Fields["TBL_COMPANY.BUSINESS_CITY", true] = "USA";
comp.Fields["MANAGEUSERID_NAME"] = "Nick";
comp.Fields["WEBADDRESS", true] = "www.alachisoft.com";

 

Thanks

Tuned Listener
Posts: 21
Country: Germany

Re: Field names for act database tables.

MANAGEUSERID_NAME  is  Read-Only