🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Settings saved with version 2.7 doesn't work with version 2.8

Answered
Martin Torres asked on May 6, 2021

Hello,

We have some report settings that were saved using version 2.7 of Flexmonster. We updated to 2.8.32 to use the custom data source feature. With this version, we can save and apply settings correctly, but those settings that were saved using 2.7 are not taking any effect. When we select those settings, it should take and select the fields automatically but the popup to select fields is prompted instead.  
I’ve followed the migration guide and deleted the availableAggregations field. Also tried setting the “version” field to 2.8.32. Neither of these things worked. There is no error showing in console. 

Is there any field or configuration that can be causing this problem? 
I’ve attach a JSON file with an example of non working setting set.
Thanks in advance. Best regards

6 answers

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster May 10, 2021

Hi Martin,
 
Thank you for posting your question.
 
Are you using the Flexmonster Data Server, or have you developed your own custom data source API implementation? 
 
Also, would it be possible for you to send us a dummy data set with which the issue is reproducible? This would allow us to test it on our side and check whether the report is valid for the given data.
 
Looking forward to your response.
 
Best regards,
Mykhailo

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster May 17, 2021

Martin,
 
Hope you’re doing well!
 
We were wondering if your inquiry is still relevant, or have you managed to solve the mentioned issue?
 
We’d be happy to hear from you.
 
Best regards,
Mykhailo

Public
Martin Torres May 24, 2021

Hello Mykhailo,

Sorry for the delay. I couldn’t manage to publish a demo with dummy data source, because I don’t have access to the backend server and it is protected by IP. However I found the cause of this problem. 

We have a solution working with CSV files and testing an alternative solution with custom data sources, using Flexmonster Data Server. For the CSV we were using prefixes to specify the data type of the columns. So all the previous saved settings have the column names without prefixes. But when we use the same CSVs with the custom data source, those fields are displaying with prefixes, making settings not to match and producing this situation. 

If we decide to migrate definetely to custom data source, we will use the mapping object instead of prefixes. But for this proof of concept we need both working simoultaneously. Is there any way to make CSV with prefixes work with a custom data source API? 

Thank you so much

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster May 26, 2021

Hi Martin,
 
Thank you for your response!
 
Currently, Flexmonster Data Server does not support the CSV format with prefixes.
 
That being said, we’d suggest feeding different CSVs to the Data Server and the pivot table directly – one with prefixes and one without.
 
Would this be possible in your situation?
 
Regards,
Mykhailo

Public
Martin Torres May 26, 2021

Hi Mykhailo 

Yes, I think it is the only option we have. We’ll go with this solution. Thank you so much for your help !!

Regards

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster May 26, 2021

Martin,
 
Glad to hear this works for you!
 
Feel free to reach out if you have any other questions we can help you with.
 
Regards,
Mykhailo

Please login or Register to Submit Answer