Solved

Inserting into Goldmine

Posted on 2001-08-29
19
807 Views
Last Modified: 2013-12-24
In one of my application pages I have a registration form, and I want to set it up so that when the form is submitted and email is sent and the information is imported directly into Goldmine. Does anybody have an idea of how to do this???
0
Comment
Question by:the_kid
  • 11
  • 4
  • 2
  • +2
19 Comments
 
LVL 14

Expert Comment

by:SBennett
ID: 6441678
You will have to set up a native driver to the database with coldfusion administrator. then just use <cfquery> and SQL to updatde the goldmine database



These may be of help:

ftp://www.goldmine.com/downloads/public/manuals/GM-API.pdf

ftp://www.goldmine.com/downloads/public/manuals/dbaseexp.pdf

0
 
LVL 14

Expert Comment

by:SBennett
ID: 6441696
As for the form sending an email, on the action page use the <cfmail> tag to send the email.

here's an example of the use of <cfmail>



<CFIF IsDefined("form.mailto")>
    <CFMAIL TO="#form.mailto#"
            FROM="#form.mailFrom#"
            SUBJECT="#form.subject#">
            #form.body#
    </CFMAIL>
</CFIF>
<P>
<FORM ACTION="cfmail.cfm" METHOD="POST">
TO:         <INPUT TYPE="Text" NAME="MailTo">
FROM:        <INPUT TYPE="Text" NAME="MailFrom">
SUBJECT:    <INPUT TYPE="Text" NAME="Subject">
<hr>
MESSAGE BODY:
<TEXTAREA NAME="Body" COLS="40" ROWS="5" WRAP="VIRTUAL"></TEXTAREA>

</FORM>  


-Scott
0
 

Author Comment

by:the_kid
ID: 6441718
No,

When the email is sent the data will automatically be imported into the database. What I have right now is something like this:

<cfmail

to="'{$GM-WebImport$}' <execed@duke.edu >"
from="execed-info@fuqua.duke.edu"
subject="Content-Type: application/x-gm-impdata\n ">
[Instructions]
DupCheck=Email


OnDupAttachTrack=Registration
SaveThis=Registration

[Data]
Company=#form.company_name#

etc...
0
 
LVL 14

Expert Comment

by:SBennett
ID: 6441791
Cold fusion will not send an email like this because it validates the email address first and this is an incorrect format. email addresses should be in the following format "Person@MailServer.Extention" the special characters and spaces in your to address will cause coldfusion to place the spool file in the Undelivr folder.
0
 
LVL 14

Expert Comment

by:SBennett
ID: 6441807
Eliminate the space int this part of your address and it should work:


<execed@duke.edu >

Should be

<execed@duke.edu>
0
 

Author Comment

by:the_kid
ID: 6441824
The email part works fine, it just isn't importing into Goldmine properly...
0
 
LVL 14

Expert Comment

by:SBennett
ID: 6442126
The following example shows and import instruction file wich contains all possible instructions.

[Instructions]
DupCheck1=Contact
DupCheck2=UserDef05
DupCheck3=cs1
OnNewSendEmail=JON, NEW, Prospect requesting information
OnDupSendEmail=AMI,,Repeated request...
OnNewAttachTrack=Web Lead
OnDupAttachTrack=100067,JON
Run=c:\goldmine\webimp.exe
SaveThis=Web import file
;ImportData=0
Password=Verify

[Data]
Company=GoldMine Software Corp.
Contact=Jon Ferrara
Phone1=310/454-6800
Address1=17383 Sunset Blvd.
City=Pacific Palisades
State=CA
Zip=90272
Source=Web Page
email=jferrara@goldminesw.com

[ContSupp]
cs1_RecType=P
cs1_Contact=Serial Number
cs1_ContSupRef=10001001
cs1_Address1=This is a test...
cs2_RecType=C
cs2_Contact=John Doe
cs2_Title=Beta Program Manager



------------------------------------------------------
For more info on this you can download the following PDF:

ftp://www.goldmine.com/public/manuals/Gm4-ref.pdf

The information you will want to look at is on pages 465-471 (448-454 if you go by the page numbers written on the document).

-Scott
0
 
LVL 14

Expert Comment

by:SBennett
ID: 6446756
if you are still having trouble then I can help you better if you can show me the syntax you are using to create the email from the <cfmail> tag to the </cfmail> tag. but basically Your goal is to create an email whose end result is syntatically equivalent to the example I gave in my last comment. Another thing to check is the password you are using is correct(if you are requireing a password). Have you seen the emails that the code you are using is producing?

-Scott
0
 
LVL 14

Expert Comment

by:SBennett
ID: 6446796
another link you can check out is:

http://kbase.goldmine.com/cgi-bin/om_isapi.dll?softpage=default

Enter "Internet Preferences", or "Emial", or the like as the keyword.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 1

Expert Comment

by:snakehollywood
ID: 6466708
Sending an e-mail cannot automatically update a database. You must insert the records into the database yourself using the CFQUERY tag.

<cfquery datasource="mydsn">
insert into mytable (list of columns)
values(
field1 = #value1#,
field2 = #value2,
etc}
</cfquery>

0
 
LVL 14

Expert Comment

by:SBennett
ID: 6471695
Snakehollywood,

With the Goldmine product, you can write a script within an e-mail that automatically updates the database with a new contacts information. Goldmine can be set up to check an email account for emails where the "To" field has the following trigger name: "'{$GM-WebImport$}' <EmailAddress@Server.com>". what the_kid is having trouble with is dynamically generating that emial properly.

Regards,
Scott
0
 

Author Comment

by:the_kid
ID: 6639568
I ended up have to buy a custom tag cfx_mail2. None of the suggestions worked, and I have solved the problem on my own.
0
 

Expert Comment

by:whatemail
ID: 6812559
SBennett,

I think that you should have gotten some points or something for your assistance here.  A great deal of effort was put into and i think all the relevant info is there in some form or another.

Thanks for contributing to EE.

an appreciative yet less knowledge learner,
Paul.
0
 
LVL 14

Accepted Solution

by:
SBennett earned 300 total points
ID: 6813609
I appreciate that Paul,

While I believe I answered his original question correctly, I think the problem The_Kid was having wasn't what he originaly thought. I am asuming that since he had to purchase the cfx_mail2 tag the problem was more do do with the SMTP mail headers that get automaticaly generated when using the cfmail tag. Perhaps these were causing errors with goldmine. I guess the most important thing is that his problem was solved. Although it would be nice if he would give more details as to exactly what the problem ended up being and why the cfx_mail2 tag solved it. This way anyone searching through PAQs who has the same problem will be able to find the solution without having to spend their question points.

Thanks,
Scott
0
 

Author Comment

by:the_kid
ID: 6813620
Sorry...can't give details as to exactly what the problem was as I'm not quite sure. All I know is that CFX_MAIL2 fixed it, so if anybody has to do the same thing buy this tag...
0
 
LVL 14

Expert Comment

by:SBennett
ID: 6813638
The main difference between cfmail and cfx_mail2 is the ability to create custom mail headers and to remove the "X-Mailer: Allaire Cold Fusion" mail header generated by CFMAIL, which can cause the email to be stoped by certain SPAM filters.

I think that the most likely problem is that Goldmine doesn't like the "X-Mailer: Allaire Cold Fusion" header, and therefore doesn't process the request.

cfx_mail2 is available at

http://www.fuseware.com

Regards,
Scott
0
 
LVL 7

Expert Comment

by:Kurt4949
ID: 20700028
sBennett, I think the real problem is that Goldmine either needs {$GM-WebImport$} in the TO line like the kid wanted or Goldmine requires a special Content-Type.  Neither of these will work with ColdFusion which I find very annoying.

From the Goldmine Help File:
Importing Contacts with WebImporting
GoldMine's Internet e-mail reader identifies data retrieved from the WebImport Gateway. GoldMine looks at the header of every e-mail message for special handling instructions.
The following example shows the special header information:

Content-Type: application/x-gm-impdata

When an e-mail message containing WebImport information is retrieved, GoldMine automatically handles the message. Alternatively, an incoming message can trigger the WebImport with the following To: line entry:

{$GM-WebImport$}

0
 
LVL 7

Expert Comment

by:Kurt4949
ID: 20700051
Actually it is possible now.  Construct the To line like this:

to="{$GM-WEBIMPORT$} <kurt@somewhere.com>"
0
 
LVL 14

Expert Comment

by:SBennett
ID: 20700092
Kurt,

Not sure if you noticed, but this question is over 6 years old? There are probably a ton of things different with whatever the current version of GoldMine is, and there have been a ton of changes to ColdFusion since this question was answered as well. I personally have never used goldmine, but I vaguely remember reading a lot about it when I answered this question. In current versions of ColdFusion you can use the cfmailparam tag to set the content-type to whatever you need, and you can use the mailerid attribute in the cfmail tag to control the x-mailer header as well. The CFX_Mail2 tag is probably no longer necessary.

http://livedocs.adobe.com/coldfusion/8/htmldocs/index.html

-Scott
0

Featured Post

Superior storage. Superior surveillance.

WD Purple drives are built for 24/7, always-on, high-definition security systems. With support for up to 8 hard drives and 32 cameras, WD Purple drives are optimized for surveillance.

Join & Write a Comment

Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

758 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now