PLEASE NOTE: Since we update Flexmonster Pivot with new features biweekly, the information might become outdated. Please check our latest news.

Ian Sadovy

November 22nd, 2016 1 min read

Moving to JSON: converter for old XML reports

Starting from version 2.3 we have moved from XML to new JSON format for saving pivot reports. It means that all inputs and outputs are now in JSON format by default. Despite the fact that all XML reports are still backward compatible, we are receiving numerous questions about an easy way of migrating to the new format.

So, we have decided to create a small utility for helping our customers to convert their XML reports to JSON.

You can try it below or use separate page on our site. Simply insert your XML report in the text box, hit large CONVERT button, and here you are!

XML

→

JSON

</td>
<tr>
<tr>
<td><button class="btn-orange-full" onclick="onConvertClick()">Convert</button></td>
</tr>
</table>
</figure>

$(document).ready(function() {
$.get("https://cdn.flexmonster.com/2.3/reports/report-sample.xml", function(data) {
  $("#fm-xml").text(data);
}, "text");
});
</script>

<p>Source code of the converter is <a href="https://github.com/flexmonster/pivot-xml-report-converter/" target="_blank" rel="noopener">available on GitHub</a>. So, if you have a lot of XML reports, you can use that <strong>JavaScript code to automate conversion</strong> instead of doing it manually.</p><p>Hope it will be useful and don’t forget that you are welcome to post any questions on our <a href="/technical-support/">support forum</a>.</p>        </div>
        <div class="single-post_meta">
            <div class="article-tags">
    <a href="https://www.flexmonster.com/category/blog/web-development/" class="article-tags_item yellow">Web Development</a></div>            <div class="single-post_share socials-list">
                <a href="https://twitter.com/intent/tweet?url=http://www.flexmonster.com/blog/moving-to-json-converter-for-old-xml-reports/" class="icon-tw"></a>
                <a href="http://www.facebook.com/sharer.php?u=http://www.flexmonster.com/blog/moving-to-json-converter-for-old-xml-reports/" class="icon-fb"></a>
                <a href="http://www.linkedin.com/shareArticle?mini=true&url=http://www.flexmonster.com/blog/moving-to-json-converter-for-old-xml-reports/"
                    class="icon-in"></a>
            </div>
        </div>

<div class="blog-widget related-posts">
        <h3 class="blog-widget_title"><strong>Recommended to read:</strong></h3>
        <div class="popular-articles">
                                                            <div class="popular-articles_item">
                        <h6 class="title">
                            <a href="http://www.flexmonster.com/blog/web-development/how-to-manage-date-types-in-flexmonster-video-guide/">How to Manage Date Types in Flexmonster: Video Guide</a>
                        </h6>
                    </div>
                                    <div class="popular-articles_item">
                        <h6 class="title">
                            <a href="http://www.flexmonster.com/blog/web-development/top-tips-from-tech-team-5-videos-to-watch-about-flexmonster/">Top Tips from Tech team: 5 videos to watch about Flexmonster</a>
                        </h6>
                    </div>
                                    <div class="popular-articles_item">
                        <h6 class="title">
                            <a href="http://www.flexmonster.com/blog/understanding-how-to-configure-a-report-in-flexmonster/">Understanding How to Configure a Report in Flexmonster</a>
                        </h6>
                    </div>
                
                                    </div>
    </div>

<div class="blog-widget">
            <h3 class="blog-widget_title"><strong>Other topics:</strong></h3>

<a href="https://www.flexmonster.com/category/blog/data-sources/" class="article-tags_item green">Data Sources</a><a href="https://www.flexmonster.com/category/blog/data-visualization/" class="article-tags_item rose">Data Visualization</a><a href="https://www.flexmonster.com/category/blog/performance/" class="article-tags_item blue">Performance</a><a href="https://www.flexmonster.com/category/blog/reporting/" class="article-tags_item orange">Reporting</a><a href="https://www.flexmonster.com/category/blog/showcases/" class="article-tags_item purple">Showcases</a><a href="https://www.flexmonster.com/category/blog/web-development/" class="article-tags_item yellow">Web Development</a>
</div>
        </div>
        <div class="blog-widget">
            <h3 class="blog-widget_title"><strong>Subscribe to our news:</strong></h3>
            <div>
    <div class="inp-group subscribe-group">
    <input id="email-inp" type="email" class="inp inp-lg" placeholder="Your email" />
    <button id="subscribe-btn" type="submit" class="btn orange form filled no-text">
        Subscribe
        <span class="icon-send" style="margin-left: 10px;"></span>
    </button>
    <div id="subscribe-overlay" class="subscribe-overlay">Thank you for subscribing!</div>
</div>

let subscriptionType = $(this).data('type');
            if (!subscriptionType) subscriptionType = 'subscribe_trial';

if (isValid) {
                $("#subscribe-btn").attr("disabled", "");
                fmTrackEvent({
                    type: subscriptionType,
                    email: email
                }, function(res, err) {
                    console.log(res);
                    if (!err) {
                        $("#subscribe-overlay").css("display", "flex");
                    } else {
                        $("#subscribe-btn").removeAttr("disabled");
                    }
                })
            }
        });

</main>

<footer class="mainfooter  ">
    <div class="container-xl">
        <div class="mainfooter-left">
            <div class="mainfooter-menu">
                <h3>Demos</h3>
                <ul class="foot-nav">
                    <li><a href="/demos/js/pivot-table/">Pivot Table demo</a></li>
                    <li><a href="/demos/js/connect-msas/">Connect to MS Analysis Services</a></li>
                    <li><a href="/demos/js/one-million-rows/">One million rows</a></li>
                    <li><a href="/demos/js/loading-json-and-csv-file/">Load JSON and CSV files</a></li>
                    <li><a href="/demos/js/pivot-charts/">Pivot charts</a></li>
                </ul>
            </div>
            <div class="mainfooter-menu">
                <h3>Pricing</h3>
                <ul class="foot-nav">
                    <li><a href="/pivot-table-editions-and-pricing/">Choose your license</a></li>
                    <li><a href="/scl-pricing/">Single Corporate License</a></li>
                    <li><a href="/saas-pricing/">SaaS</a></li>
                    <li><a href="/oem-pricing/">OEM</a></li>
                    <li><a href="/unlimited-perpetual-distribution-pricing/">Unlimited Distribution</a></li>
                    <li><a href="/rockstar-support/">Rockstar Support</a></li>
                    <li><a href="/support-options/">Support options</a></li>
                    <li><a href="/resellers/">Global resellers</a></li>
                </ul>
            </div>
            <div class="mainfooter-menu">
                <h3>Support</h3>
                <ul class="foot-nav">
                    <li><a href="/technical-support/">Technical support</a></li>
                    <li><a href="/doc/">Documentation</a></li>
                    <li><a href="/api/">API reference</a></li>
                    <li><a href="/user-interface/">User interface</a></li>
                    <li><a href="/technical-specifications/">Technical specifications</a></li>
                    <li><a href="/release-notes/">Release notes</a></li>
                    <li><a href="/client-info/">Client information</a></li>
                    <li><a href="/faq/">FAQ</a></li>
                </ul>
            </div>
            <div class="mainfooter-menu">
                <h3>Company</h3>
                <ul class="foot-nav">
                    <li><a href="/about/">About</a></li>
                    <li><a href="/contact/">Contact us</a></li>
                    <li><a href="/blog/">Blog</a></li>
                    <li><a href="/software-license-agreement/">License agreement</a></li>
                    <li><a href="/privacy-policy/">Privacy policy</a></li>
                    <li><a class="cky-banner-element">Manage cookies</a></li>
                </ul>
            </div>

</div>
        <div class="mainfooter-right">
            <div class="mainfooter-copy">
                <a href="https://www.flexmonster.com/" class="logo-foot" title="Flexmonster"><img loading="lazy" style="width: 232; height: 44" src="/base/assets/img/svg/logo.svg" alt=""></a>
                <p class="copy">
                    © 2024 Flexmonster<br>All Rights Reserved.
                </p>
            </div>
            <div class="mainfooter-contacts">
                <div class="contact-link">
                    Contact us on Skype:<br>
                    <a href="skype:flexmonster.help?chat">flexmonster.help</a>
                </div>
                <div class="socials-list">
                    <a href="https://youtube.com/user/FlexMonsterPivot" class="icon-yt" target="_blank" rel="noopener" title="Flexmonster's YouTube account"></a>
                    <a href="https://twitter.com/flexmonster" class="icon-tw" target="_blank" rel="noopener" title="Flexmonster's Twitter account"></a>
                    <a href="https://github.com/flexmonster" class="icon-git" target="_blank" rel="noopener" title="Flexmonster's GitHub account"></a>
                    <a href="https://linkedin.com/company/flexmonster/" class="icon-in" target="_blank" rel="noopener" title="Flexmonster's LinkedIn account"></a>
                </div>
            </div>
        </div>
    </div>
</footer>

</body>

</html>

Changes to Flexmonster Software License Agreement

Moving to JSON: converter for old XML reports

XML

JSON