seadinnovations

Design - Develop - Integrate - Extend

SugarCRM Target List Data Pump

SugarCRM Target List Data Pump is a small utility for creating sugarcrm targets lists from a set of contacts contained in a Microsoft Excel file.

The problem

You have an installation of sugarCRM and you have exported a group contacts in order to proceed with a mail merge or create some subsets of contacts.
You do that because you can work faster with excel spreadsheets than the sugarCRM environment.
But now you have to update sugarCRM with the lists produced.

The solution

1.Run this simple utility
2.Go to operations/CRM connection Settings and set your MySQL connection settings for your sugarCRM Installation

p2 

3.Select File/Select Excel of user the right icon of the excel input box

p3

4.Press "Open" button and if you have the right connection settings the excel file entries will be shown on the "Excel Data" grid.

5.Input the "filter fields" criteria 

p4

You can select up to 4 fields from sugarCRM and match them with an Excel column number :

p5 

6.Select the desired Target List from the dropdown list with the available targets lists of your sugarCRM installation.

7.Press start and the system will go through all the Excel rows and try to match the criteria given in order to find the sugarCRM rows and add them to the selected Target List.
If for example, you have selected as "Excel Column" :2,3 and "CRM fields": first_name,last_name the system will search for contacts the have first_name the value in column 2 and last_name the value in column 3. 

The utility adds the record found in the given target list, only if there is only one record with the given criteria.
If there are no rows found or there are more than one matching the criteria then you get a warning in the "results log" to the bottom of the form and the row is ignored.

p6

You can save this log when the check ends using the "Save Results" button.
The file created is a ; delimited text file you can easily import to Excel again.

SEAD HUB Outlook Plugin

Outlook1SEAD Hub Outlook Plugin

Microsoft Outlook Plugin to archive your email's in the SEAD HUB 

Read More..

SEAD HUB Microsoft Office Plugin

WordAddInSEAD Hub Microsoft Office Plugin

Microsoft Office Plugin for automatic archiving Documents to the SEAD HUB 

 

Read More...

Web development

upmWeb Development

Take a Look at our latest Web projects

 

Read More...