asked on April 25, 2019
Example CSV
"Month","Category","Revenue"
"","","$708,785.00"
"January","Condiments","$5,737.50"
"January","Breakfast Cereals","$2,370.00"
"January","Confectionery","$3,687.50"
"January","Soups","$1,080.00"
"January","Confectionery","$4,477.50"
"January","breakfast Cereals","$1,580.00"
"January","BAKERY","$2,625.00"
"January","Bakery","$1,312.50"
"January","Fruit Preserves","$2,962.50"
In the same column we have "BAKERY" and "Bakery". After importing this into Flexmonster all instances of "bakery" found in the column will now be displayed as "BAKERY"
Is this expected behavior?
⋅ April 26, 2019
Hello, Christopher,
Thank you for your question.
We would like to confirm that this is the expected behavior.
When two same values are detected differing from one another only by case, then out of both values Flexmonster chooses the one which was encountered first.
So, in your case, "BAKERY" was encountered first, hence all other values of "bakery", "Bakery", "BAKERY",.... will be grouped under "BAKERY".
Please let us know if you have further questions.
Best Regards,
Vera
⋅ April 26, 2019
Thanks for the response Vera, is there anyway we can maintain case sensitivity? We have a case where IDs do maintain the case sensitivity and thus are different.
⋅ April 29, 2019
Yup, this is very important in cases where unique identifiers expect uniqueness based on casing, we've seen this with output from Salesforce. Can you provide some sort of property like 'enforceCasing=true'
⋅ April 30, 2019
Hello, Christopher, Patrick,
Thank you for your reply.
Our team will further investigate if this feature can be added and we will notify you about the results on the 21st of May.
Please let us know if you have any further questions.
Best Regards,
Vera
⋅ May 21, 2019
Hello, Christopher, Patrick,
We would like to inform you that our team has looked into your request and is currently working on adding an option to maintain case sensitivity.
The feature will be available in the minor release with the ETA 3rd of June.
Please let us know if you have any further questions.
Best Regards,
Vera
⋅ May 21, 2019
Thanks Vera! That's great news, let's us integrate with a wide variety of systems that would've been very difficult previously.
⋅ June 4, 2019
Hello, Christopher, Patrick,
We are glad to announce that a new property caseSensitiveMembers was added to distinguish members with different cases.
This is available in the 2.7.7 version of Flexmonster
You are welcome to update the component
Please let us know if everything works fine.
We are looking forward to hearing from you.
Best Regards,
Vera
⋅ June 5, 2019
Hello, Christopher, Patrick,
We would like to add that caseSensitiveMembers needs to be specified in the options the following way:
options: {
caseSensitiveMembers: true
}
Here is a JSFiddle example for illustration.
The caseSensitiveMembers parameter works the same way for CSV.
Please let us know if everything works.
We are looking forward to hearing from you.
Best Regards,
Vera
⋅ June 5, 2019
Great! We'll take a look at adding this to our application