Omatic Cloud
402 results found
-
OC Transformations in Alphabetical Order
Transformations are not currently in alphabetical order but it would be helpful to reorder those so they are in alphabetical order.
1 vote -
LO Groups to Mobile Commons
It would be helpful to have a LO Groups to Mobile Commons formula. Currently, there is no filtering available when ingesting data from LO.
0 votes -
Participant guests in Classy
Would like to see the ability to import guests associated with a participant in Classy to RE NXT event record.
6 votes -
Enable File-to-File Transformation & Export in Omatic Cloud
Currently, Omatic Cloud only allows transformations when importing data into Raiser’s Edge or other connected systems. However, it would be extremely beneficial to have a file-to-file processing option. This would allow users to:
Upload a spreadsheet, apply transformations, and export the transformed data as a new file (CSV, Excel, etc.).
Use Omatic’s powerful transformation tools without requiring integration with an external database.
Improve data cleaning and preparation workflows for reporting, imports, and other external processes.
This feature would save time and expand Omatic Cloud’s usability beyond direct imports. Please consider adding this functionality in a future update!5 votes -
Ability to map to Mailing ID and Finder Number on gift record
These fields aren't available through the Blackbaud API, but we have numerous queries and reports that rely on them, dating back to when we first started using RE. We use the Mailing ID field to track the platform through which a gift was made, and the Finder Number field to identify constituents from acquisition mailing finder files. If we can't map to these fields in Omatic Cloud, it will require significant changes to our existing workflows. Currently, I'm adding this data to gift records with a Blackbaud import after importing through IOM+, which is not an efficient process.
6 votes -
Skip Days for Scheduling (Allow for weekday only)
Currently, you can only select daily or weekly. I think it would be beneficial to have it only run on Weekdays. That way records don't pile up over the weekend and risk duplicate records from showing up if multiple changes happened. This has happened when people submit multiple surveys or they have multiple scheduled gifts. And there is no way from the interface to tell which record is the latest.
9 votes -
Partial string 'Replace' transformation
It was a sad day when I realized that there wasn't a Transformation for address abbreviation standardization like there is in IOM (https://support.omaticsoftware.com/s/article/RegularExpressionDictionaryforAddressAbbreviations) and sadder still when I learned that I couldn't create a transformation of my own. While the 'Replace' transformation will IDENTIFY a field value containing a qualifying text string just fine, it will also replace the ENTIRE field value (not just the identified text string) with whatever replacement value you designate. Thought you could use a transformation for common address standardizations like replacing "Street" with "St"? Think again, because the way it exists now will…
16 votes -
Security
In RE we have very granular security. It would be great if Omatic could link to RE security roles? That way you can accurately see who ran the import/changed the records (last updates by in RE) instead of who connected omatic to RE environment.
** Or a little more granularity within the Omatic user settings would be great! Example the option for data processors to not have the ‘add’ or ‘send’ button, only match/override(link)/delete and move to ready would be very helpful, so that someone with higher security can review & send.3 votes -
Ability to Filter on Refunded Gifts in EveryAction
Currently, our EveryAction API ingests on modified date and that brings in refunded gifts. Those refunded gifts do not have any indication that they are refunded and resemble true gifts. Request is for some filter on refunded gift or the inclusion of Refund/Adjustment information fields.
1 vote -
Ability to Access Emma Sent Email Date
It would be helpful to have the Emma "sent date" for the Email Campaign Activity formula type. We can technically access this through including the "sent" activity in the filtering, however, that adds high record volume that is uncessary and could cause ingestion/processing issues down the line.
1 vote -
Update Transaction Schedule when Recurring Gift Payments are imported into RENXT batch
Gifts for payments to recurring gifts can be linked at time of import into RENXT batch. The gif shows up in the list of transactions and the amount Received is updated, but the Next transaction due: is not. This causes problems with our reminder process. The transaction schedule needs to be incremented as well.
3 votes -
Add the functionality to map 'Class Notes Status' in the Notes field section
The 'Class Notes Status' field is used in RE Database view. We are unable to use Omatic Cloud to import class notes because this field isn't mapped.
3 votes -
Add the "Class Notes Status" field to the Notes field section
Add the "Class Notes Status" field to the Notes field section
1 vote -
Import Processing
I'm just learning Omatic Cloud and a big reservation I have about import processing is that I wish the job would not start processing the second you upload a file. I'd really like to be able to hit 'run' when I am ready for it to do so. There will be times when I upload a file and realize at the last second that I forgot to do something or will realize I've grabbed the wrong file. I just wish there would be the opportunity to say 'are you sure' before it starts running.
1 vote -
Ability to "deactivate" user without deleting in Omatic Cloud
If a user needs to go on extended leave but should not have access to Omatic Cloud, the only current option is to delete their record (and possible history associated with the record). It would be helpful to have the option to temporarily deactivate a non temporary user.
0 votes -
Duplicate data checks between columns
It would be helpful to have the ability to compare fields in different columns to each other, to check for duplicate values. For example, when we're working with files that contain more than one address, email, phone etc. while being able to either blank out the value if its a duplicate of another field, or keep it if it isn't.
5 votes -
Match search on existing relationships within record
It would be helpful to match on existing relationships that already exist on a record vs the entire database. For example, if there are duplicates of a non constituent organization relationship, it wouldn't be reasonably possible to narrow down which value was the existing relationship without opening up all the records to review first. Use case - schools, company relationships.
0 votes -
Sort Data Differences in Buckets with Mailchimp Connector
It would be great if we could sort the different Mailchimp connector buckets in a formula by data differences so that they are sorted to the top of the list or bottom depending on preferences. ie. purple highlights at the top or bottom of the list.
1 vote -
Pulling in Mailchimp actions from previous Campaigns sent in previous months, not just current month.
I've noticed that after a mailchimp campaign has been sent, if donor clicks on a link or opens the mailchimp email many weeks or months after it was initially sent, that data does not pull into NXT. It would be great if there was a way to ensure that all mailchimp actions (sent, open, click, unsubscribe, abuse) are pulled into NXT regardless if it's from the current month's mailchimp campaign or an older one.
1 vote -
Add text fields to facilitate documentation of formula configuration background
For each group heading in an ImportOmatic+ formula (in the mapping section of its definition), add text fields to allow the addition of notes by the creators/managers of the formula. This would improve the product by providing a mechanism for documentation directly within the formula. Information that could be included could be explanations of why certain configuration decisions were made, idiosyncrasies and deficiencies expected in the data, where to find current mappings/value lists from data source systems, and other considerations etc.
13 votes
- Don't see your idea?