Flexmonster Software License Agreement (“Agreement”) has been significantly revised and is effective as of September 30, 2024.
The following modifications were made:
The modified version of Flexmonster Software License Agreement is available here.
Downloading, installing, and/or continuing to use Flexmonster Software after September 30, 2024, constitutes Licensee’s acceptance of the terms and conditions of the modified version of Flexmonster Software License Agreement. If Licensee does not agree to any of these terms and conditions, they must cease using Flexmonster Software and must not download, install, use, access, or continue to access Flexmonster Software. By continuing to use Flexmonster Software or renewing the license under License Model or Maintenance after the effective date of any modifications to Agreement, Licensee accepts and agrees to be bound by the terms and conditions of the modified Agreement.
In the previous article, we described how to connect the pivot table to the CSV data source. To gain even better performance while working with CSV datasets, use Flexmonster Data Server — a special server developed by Flexmonster. This server aggregates your data and then passes it to Flexmonster Pivot in a ready-to-show format.
Flexmonster Data Server has the following advantages:
npm install -g flexmonster-cli
Now follow the steps below to connect to CSV using the Data Server.
Get the Data Server with the flexmonster add fds command:
flexmonster add fds -r
This command installs and runs the Data Server as a Windows/Unix service. Besides, the command installs Flexmonster Admin Panel — a graphical user interface for the Data Server.
The Data Server's files can be found in the flexmonster-data-server/
folder in your working directory.
There are also alternative ways to install the Data Server:
Now let's create a new index for the file with your data.
Open Flexmonster Admin Panel and go to Indexes > Add New Index. Then, fill in the following fields:
CSV
.,
separates СSV fields.3,14
. Default value: .
.1.000
(one thousand). Default value: ,
.0
, which means the Data Server will not reload the data.Your configurations should look similar to the following:
When the index configuration is complete, click Create. The index will be automatically added to your index pool.
Note By default, the Data Server resolves data types for all fields automatically. If you need to set data types for some fields manually, edit your index and configure the Mapping for it.
If Flexmonster is not yet embedded, set up an empty component in your webpage:
Complete the Integrating Flexmonster guide. Your code should look similar to the following example:
let pivot = new Flexmonster({ container: "pivotContainer", componentFolder: "node_modules/flexmonster/", toolbar: true });
Complete the Integration with React guide. Your code should look similar to the following example:
<FlexmonsterReact.Pivot toolbar={true} />
Complete the Integration with Angular guide. Your code should look similar to the following example:
<fm-pivot [toolbar]="true"> </fm-pivot>
Complete the Integration with Vue guide. Your code should look similar to the following example:
<Pivot toolbar />
On the client side, the report should be configured as follows:
let pivot = new Flexmonster({ container: "pivotContainer", componentFolder: "node_modules/flexmonster/", toolbar: true, report: { dataSource: { type: "api", url: "http://localhost:9500", index: "index-csv" } } });
Note The index
must match the name of the index defined in step 3 (e.g., "index-csv"
).
When Flexmonster Pivot requests the data, Flexmonster Data Server sends the response and then caches it. In case the component sends the same request once again, the server responds with the data from its cache. The Data Server clears the cache when restarted.
The Data Server’s cache has a memory limit. When the cache does not have enough memory for a new response, the Data Server server deletes one of the previously cached responses.
Note You can manage the cache size via the Cache size limit configuration.
You may be interested in the following articles: