Normal
0
false
false
false
EN-US
X-NONE
X-NONE
MicrosoftInternetExplorer4
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"Times New Roman";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;}
Hello!
I am trying to use Inaport 7.0 to add a group member to an
existing group in Goldmine 8.5.
FYI My excel data includes company (our unique identifier), contact name, and last name (for
Sort), and email address (for Ref).
Under “Add Fields”, I have the following:
PaddedPID == ltrimpad(#PID,
9, "0")
AcctNo == dbexecsql("T",
"SELECT accountno FROM contact1 WHERE company = '" & #PaddedPID
& "'") And this part works fine. Target Table is _contact1 and I am matching on a single
existing record with SQL match “Select Accountno from contact1 where
accountno
= ‘#acctno”. This works great.
Under “Change Data” I put Evaluation Expression as
addtogrp (“SanAntonioGroup”,”BURKE”, “TRUE”,’#Sort,
#Ref)
But I’m not sure where this function should actually
go; it’s not working as it is.
Can you help me so that I can get the addtogrp() function to work? I reviewed the forum posts, which helped me get this far... Thank you.
Blessings,
Sue