How to remove the Customer Experience Improvement Program (CEIP) task from Microsoft Dynamics GP


INTRODUCTION


This article describes how to remove the Customer Experience Improvement Program (CEIP) task from the Reminders window in Microsoft Dynamics GP.

More Information


The CEIP task appears after you install Microsoft Dynamics GP. CEIP collects information about how a customer uses Microsoft products and about any problems that customers experience.

For more information about CEIP, visit the following Microsoft Web site:To remove the CEIP task, use one of the following methods.

Method 1

Follow these steps for each Microsoft Dynamics GP user:
  1. Start Microsoft Dynamics GP.
  2. On the View menu, click Reminders.
  3. In the Reminders window, click the CEIP task, and then click Task on the Open menu.
  4. In the Task window, click Name.
  5. In the Customer Experience Improvement Program window, select an option, and then click OK.
  6. In the Task window, click Completed in the Status list, and then click Save.

Method 2

  1. Open Microsoft SQL Query Analyzer or SQL Server Management Studio.
  2. To delete the CEIP reminder, run the following script.
    delete from DYNAMICS..SY01403 where LinkTo = 2 and CmdID = 269 and CmdFormID = 1568 and CmdDictID = 0
  3. To select all users not to participate in the CEIP program, run the following script.
    USE DYNAMICS
    set nocount on
    declare @Userid char(15)
    declare cCEIP cursor for
    select A.USERID
    from SY01400 A left join SY01402 B on A.USERID = B.USERID and B.syDefaultType = 48
    where B.USERID is null or B.SYUSERDFSTR not like '1:%'
    open cCEIP
    while 1 = 1
    begin
    fetch next from cCEIP into @Userid
    if @@FETCH_STATUS <> 0 begin
    close cCEIP
    deallocate cCEIP
    break
    end

    if exists (select syDefaultType from DYNAMICS.dbo.SY01402 where USERID = @Userid and syDefaultType = 48)
    begin
    print 'adjusting ' + @Userid
    update DYNAMICS.dbo.SY01402
    set SYUSERDFSTR = '1:'
    where USERID = @Userid and syDefaultType = 48
    end
    else begin
    print 'adding ' + @Userid
    insert DYNAMICS.dbo.SY01402 ( USERID, syDefaultType, SYUSERDFSTR )
    values ( @Userid, 48 , '1:' )
    end
    end /* while */
    set nocount off