Annulleret

Goldmine integration

This is a potential new client that does a lot of Goldmine integration. Goldmine is an off-the-shelf product like [url removed, login to view] that manages leads/sales/customers for a sales force.

So the Goldmine front end is accessing a SQL 2000 backend; this project will involve building triggers (though these are not SQL triggers, they are things like send an email out when certain things happen).

So here is the project description below, \

Project Description

Generate 5 triggers against GoldMine database table set.

Customer environment - Goldmine 7.5/7.6 MSSQL 2000

Remote access to test system for development provided (mirrored environment - but SQL2005)

Remote access to customer system provided once tests are complete.

Create triggering procedures to handle New member calling patterns;

All calendar record durations = 15 mins.

o Trigger 1 - When a prospect becomes a Member then schedule a series of calls**

On Update ONLY [url removed, login to view] - If [url removed, login to view] = 'M' then

a: schedule a "New Member Welcome" call -- Cal.Userid=[url removed, login to view], Cal.Ondate=Getdate()+1

b: schedule a "New Member 90 day call" -- Cal.Userid=[url removed, login to view], Cal.Ondate=Getdate()+90

c: schedule a "New Member 180 day call" -- Cal.Userid=[url removed, login to view], Cal.Ondate=Getdate()+180

o Trigger 2 - Schedule Pre-Renewal member reminder call for MOR**

On Insert, Update [url removed, login to view]

a: schedule a "Pre-Renewal Member call" -- Cal.Userid=[url removed, login to view], Cal.Ondate=[url removed, login to view](note: this is a varchar field)-45days

o Trigger 3 - When a history of a Membership renewal is put in, get the MOR to call to touch bases re: renewal**

On Insert to ContHist - If [url removed, login to view] like '%Dues-Renewal:%' then

a: schedule a "Member Renewed call" -- Cal.Userid=[url removed, login to view], Cal.Ondate=[url removed, login to view]+1(ensure it is weekday)

o Trigger 4 - When a user enters a result code of DNR (Did not Reach) in a history, send an email.

On Insert to ContHist - If (Conthist.ref="New Member Welcome Call 1" and [url removed, login to view] = 'DNR')

a: send an email from [url removed, login to view] to (the primary member email adderss) [url removed, login to view] where (cs.rectype='P' and cs.contact='Email Address' and [url removed, login to view] like '1%'); Email template is "Welcome to the Group"

Færdigheder: AJAX, Javascript, Linux, PHP, Script Installering

Se mere: user tests, update email template, php remote development, group o, customer email template, calendar code development php, goldmine create group, p sql, sql integration, shelf, salesforce sql, salesforce test, salesforce project, salesforce integration, salesforce development, sales force, mor, integration test, call schedule, c1, php calendar reminder, create sales system table, access 2000 sales template, email potential customer, mssql remote access

Om arbejdsgiveren:
( 82 bedømmelser ) karachi, Pakistan

Projekt-ID: #943864

2 freelancere byder i gennemsnit $625 for dette job

PinkCrow

I can help you with a linux backgroud process or deamon process that handles those triggers.

$500 USD in 5 dage
(137 bedømmelser)
6.6
shuiwatermizu

please see pm

$750 USD in 10 dage
(97 bedømmelser)
6.4