Multiple tabs in excel when export

[svisveswaraiya]

Hi,

When we export data, is it possible to dynamically split rows and add them in multiple tabs? Eg: if there are total of 5 lakh rows, I wanted to split them 1 lakh rows in 1st tab and from 100001 to 2lakh rows in 2nd tab and likewise. Is it possible to achieve this use case in ThingWorx?

Thanks in advance,

Shalini V.

[PEHOWE]

@svisvswarai,

The CSV file is defined to be a single Tab in an Excel file. There is no support for multiple tabs in the CSV file. The process you create to export the data from your instance can perform the export multiple times. Each export will create a different CSV file. These files can then be imported into different tabs in excel.

[svisveswaraiya]

Hi @PEHOWE ,

Thanks for your response. 

Could you please guide me how to export multiple times by splitting of data? The user will be clicking the export once and based on rows, can the files be exported multiple times?

[PEHOWE]

@svisveswaraiya,

There are multiple options on how to export information out of ThingWorx as a CSV file. There is the Data Export widget which takes a Infotable, and Export File name and creates a file which contains the information in the InfoTable. This approach can only export a single file.

For a more complex export into multiple files you can load the "ThingWorx CSV Parser" extension which adds a group of functions. This extension can be downloaded from the same site as ThingWorx was downloaded. One of these functions is WriteCSVFile.

WriteCSVFile

Write a CSV File from an Infotable Data Type Source to a specified ThingWorx Repository 

•Below is the Snipet of the Service with Parameters Explanations:

var params = {
  data: undefined /* INFOTABLE */,
  path: undefined /* STRING */,
  fileRepository: undefined /* THINGNAME */,
  withHeader: undefined /* BOOLEAN */
};

// no return
Resources["CSVParserFunctions"].WriteCSVFile(params);

-data = The infotable source of Data to be used as a content for the CSV file
-path = the name of the CSV File that would be created
-fileRepository = The ThingWorx File Repository in which the CSV File will be stored
-withHeader = has a value of true or false to specify whether the CSV File would have a header as first line and which would be based on the Fields of the Infotable Datashape    

If you add the CSV Parser Extension, then you can write a service which builds the info table which represents a single tab in your desired file and export the file. The script can then move on to create the additional files which are required for your design.

The other option would be to create your own custom extension which opens up other possible solutions.

HTH

Pehowe

[svisveswaraiya]

Hi @PEHOWE,

We can iterate the set of rows that needs to be downloaded as you suggested. But should we click the button every time to download multiple files or add a refresh button or it auto downloads? 

Thanks in advance,

Shalini V.

[PEHOWE · Accepted solution]

@svisveswaraiya,

If you take the approach of loading the ThingWorx CSV Parser Extension, you can write your own service. Having the extension loaded will allow you to create a Service on a Thing. This service can be designed to meet your needs. 

From our conversation I would guess that you have an InfoTable which contains all the information you wish to export. The service would need to have some type of loop to work through the information and create a sub infotable which can then be passed to:

Resources["CSVParserFunctions"].WriteCSVFile(params);
 

This will create a file for that sub table. You will then need to loop and perform the next segment. 

Because you have created a unique service to generate the number of files you need. then the service can be activated by a single button push.

HTH

Pehowe

[svisveswaraiya]

Thanks a lot for helping out @PEHOWE.