February 18, 2019

Randomization In Informatica Cloud (IDMC)

Problem Description Customers/Users face issues in picking multiple CSV files with having the same base name from a directory and generates multiple Excel file for each CSV file. The Excel files need to be generated based upon either percentage of available filtered records or exact number of records and maximum records allowed in a single excel file. The filtration of records is based upon the specific column and its specific value.
February 18, 2019

CSV Splitting In Informatica cloud platform (IICS)

Problem Description Customers/Users face issues in splitting a CSV file into multiple CSV based upon some specific column and its specific value of that column. Challenges to User/Developer In IICS, above mentioned problem can be solved through Java Transformation. The CSV file needs to be split into multiple CSV files. Move the original CSV file to other location.
February 18, 2019

Excel to CSV using SFTP In IICS

Problem Description Customers/Users face issues with loading Excel files from SFTP remote server to local machine and convert the excel file to CSV file in mapping on IICS. Challenges to User/Developer In IICS, above-mentioned problem can be solved through Java Transformation. The Excel file needs to be transferred to the local machine (where the secure agent is installed). The locally available Excel file needs to be converted to CSV file. Move the original Excel file which we got from SFTP remote server to other location.
January 21, 2019

How To Case Comments in Case Object Without The Public Checkbox in Salesforce?

Problem Description: Salesforce users/customers have an issue with Case Comments(Internal comments) as it shows up for all users. Challenges to User/Developer: A workaround is to create a custom object which replicates the behavior of the standard Case Comments object.
January 21, 2019

Challenges on Multi Select While Reporting in Salesforce!

Problem Description: Salesforce doesn’t allow users to create a report based on an individual multi-picklist field or group the reports based on individual multi picklist. Challenges to User/Developer : A workaround for this is to create a custom object which holds the multi-picklist values of the object you are trying to build a report on.
January 21, 2019

Unable To Set a Record Type in Salesforce Object in Salesforce Community

Problem Description : Salesforce users/customers have issues with seeing record types in community page. Solution : If all the page layouts and permissions are assigned correctly and yet there is no record type shown in the community. Then, contact the Salesforce customer support and make sure it is enabled from their end.
January 21, 2019

Changing Case Owner Assignment Email Template in Salesforce

Problem Description : Salesforce customer/users receive the standard/default email every time a case is assigned to him/her. The template cannot be modified as the user will not have access to that email template. Challenges to User/Developer : A workaround for this is to create a brand new workflow with a custom email template.
January 21, 2019

Salesforce – How to Prevent Auto-Reply for an Email to case in Salesforce ?

Problem Description : Salesforce customers/users have issues adding email to the activity tab and customizing the email to send new mail every time. Challenges to User/Developer : Enable Email-to-Case and then create a custom email action