Omatic Cloud
418 results found
-
Additional Date Format Option
I recently came across the KB article How to Map a Batch Number Using Transformations Where None Are Provided and realized that this would help us cleanup some of our post import process. However, as I was going through the steps I found that none of the existing date formats match what we need. It would be very helpful to us if there was an option to format a date as MMDDYYYY. There is already a format of YYYYMMDD, so it seems like this should be an easy option to provide.
1 vote -
Translate RENXT Query Field IDs
When using a Raisers Edge Query as the formula source, to add a Custom Code Translation we can't easily determine the field name to use.
For example, in the Available Source Fields it'll show
"name": "13579",
instead of
"name": "address.addressline1"1 vote -
Add Org Relationships Second Time
When importing organizational relationships, the organization relationship may exist already with an end date. We would like to add an additional org relationship with a current start date. Currently, it is matching to the existing organizational relationship and erroring out because "start date cannot be before end date".
Therefore, we must manually add the relationship if the relationship already exists. Example, we want to upload a new employee to our database but they were a former employee 20 years ago and that org relationship is recorded as a former org relationship on their record to our university. Therefore, I cannot…
3 votes -
Allow sort by "match reasons" in Needs Review grid
Allow sorting by “Match Reasons” in the Needs Review grid so users can quickly prioritize and process potential matches more efficiently. Let me know if I am missing something that already exists. Thank you.
1 vote -
Add Write-In Field to the GiveCampus Gift Connector
We'd like to have the "write-in" column for a fund added to the GiveCampus / Omatic gift connector so that we can access that information in the gift import.
1 vote -
Check-In Information from GoFundMe Pro LIVE
Add check-in information from GoFundMe Pro live to the omatic cloud dataflow so we can sync event attendance with our CRM software (in this case, virtuous).
Wouldn't it be great to use digital check in and have it sync with your attendance information in your CRM instead of having to upload a file after every event.
1 vote -
Recurring Gift Card Token
Ability to import BBPS card tokens
https://developer.sky.blackbaud.com/api#api=gft-gifts&operation=AddGiftsToBatch
1 vote -
matching gift pledges
Omatic Cloud needs the ability to enter matching gift pledges and matching gift pledge payments. Currently the feature is only available with Importomatic and with database view sunsetting in the near feature we need to have more functionability.
2 votes -
Support for line break character (/n)
Right now we can add line breaks through Concatenation, but there isnt a simple way to force a line break in some more complex situations.
We use this particularly for notepad text, where we want to summarise a few cells of data into a single notepad, e.g.
'Signed up for Email Newsletter on the website. /n
First Name Provided: Alex /n
Surname Provided: Bishop-Thorpe /n
Email address provided: alex.bishop-thorpe@'Importimatic supported '/n' as a line break character, but this isnt supported by Omatic Cloud. Instead it just renders the text '/n'. If we use the line break as the separator…
5 votes -
Custom Routing to send some rows onto another Formula
Sometimes it's necessary (or more convenient) to achieve our desired outcome by taking one file and running two different Formula across it.
A common example would be files that have a mix of Individual and Organisation records. One Formula for the Individual import, and another formula to do the Organisation import - the Organisation import would add and link the individual as a Contact against that Organisation. Fancy.
Right now custom routing lets us skip some rows, having the Formula ignore them. This let's us have our two import formulas, one for Individuals and one for Organisations.
But it would…
6 votes -
Add Tax Receipt Number
Could you include the Tax Receipt Number field in the mapping? The gift transactions I import into RENXT come from an external system that has already generated the tax receipts.
1 vote -
The ability to exclude records before transformation
It would be great to be able to have a formula skip a record based on specific criteria before transformation and matching happens. For example, we have lists that contain thousands of people that get scored by a wealth screening service. We only want to import the records that have a score of 52 or higher. This is sort of like the custom routing rules that happen after all the records have been matched/transformed. But having this ability before processing skips having to deal with exceptions for records that ultimately won't go into the CRM and saving us time.
3 votes -
MailChimp SMS into RENXT
Have MailChimp SMS data recorded in RENXT using the connector in the same way the Email data is.
3 votes -
Increase number of search scenarios
Increase number of allowed search scenarios until Match Settings / Contact Match Search to more than five. Our use case is to match on ID (primary), then Name, Personal Email, Work Email, Alt Email, and Mailing Address.
6 votesHi Hannah - Thanks for your idea. One thing you may not be aware of is that with Salesforce if your object has more than 1 email address field then you can choose each of those email address fields when you create an Email or Name and Email match scenario. Thus instead of creating a match scenario for each of your email address fields in Salesforce you can create one match scenario and choose all of your email fields in that single match scenario. There is an implied OR between each of the email addresses when performing the search.
For example, suppose I have 3 email address fields (per your description) in Salesforce: Work Email, Personal Email and Alt Email. Suppose my incoming email address is steve@myorgname.org. I then add an Email match scenario and choose each of those email address fields in my match scenario. When Omatic Cloud attempts to match on email address the query…
-
Ability to delete bio2 end dates
I need to be able to remove end dates from the bio2 codes. We use them to show what projects a constituent participates in.. If they sign up again after a lapse, we need to be able to remove the end date that is there.
1 vote -
Transformations: Completely delete/remove data field
I would like to see that one of the transformations have the ability to completely delete/remove that field. One of the examples that I have come across is for consistuency codes. We use them if someone is giving at a certain amount annually. But if they are not at that level anymore, we need to delete the code. But I can see this being used for attributes or duplicate pieces of contact information.
5 votes -
Fuzzy Organization Name Matching
Currently, Omatic Cloud does not support fuzzy name matching for organizations. Organizations can only be matched on name exactly. In this case, if you were to try and import employment data, minor variations in organization name will force you to manually match with existing organizations or you will end up with multiple duplicate organizations within your database. Fuzzy organisation name matching would make this process much simpler and streamlined.
22 votes -
Add individual system Record ID as a match option when importing a Relationship
Expand the matching logic for Relationships to include the Constituent System record ID . The constituent system record ID is unique across RE and is assigned to a record once added in RE. This data point will allow the import for Relationship records to use an alias/alias type and constituent system record IDs to get an exact match and will prevent duplicate/reciprocal relationships to be added in RENXT. Currently ImportOmatc will match on an Alias ID and will not create additional relationships if it exists.
Currently in OmaticCloud, matching on alias id/type will result in unwanted/duplicate relationships added to RENXT.…
3 votes -
Import of Fund Relationships
There is currently no functionality to import new Fund Relationships or update existing ones via import. We would like to track scholarship recipients directly on the fund itself. Providing this functionality would allow us to import the students receiving aid, making your solution even more valuable than it already is.
Thank you!16 votes -
Add Suffix as a field for matching.
We bring in many alumni or students who have parents who match on first, last, address, etc. and we would like to use Suffix as a matching or autopick field.
1 vote
- Don't see your idea?