Final file missing when converting html to excel using On Premise

rajatdpw · September 13, 2023, 10:07am

I am making below axios call for on Premise approach:

let data = new FormData();
        let randomStr = Math.random().toString(36).slice(2, 8);
        let outputFileName=`output-${randomStr}.xlsx`;
        let outputDatafolder = 'htmlToExcelFilesData';
        let outputFilePath = outputDatafolder + '/' + outputFileName;
        data.append('file', htmlStream);
        let accessToken = await getAsposeAccessToken();
let configuration = {
            method: 'put',
            url: config.getConfig('ASPOSE_BASE_URL') + '/v3.0/cells/convert?format=XLSX&outPath=' + outputFilePath + '&checkExcelRestriction=true&streamFormat=html',
            headers: {
                'accept': 'multipart/form-data',
                'authorization': 'Bearer '+ accessToken,
                'Content-Type': 'multipart/form-data',
                'x-aspose-client': 'Containerize.Swagger',
                ...data.getHeaders()
            },
            data: data
        }

I am getting below successful response:

{
  FileInfo: {
    Name: 'output-09ov32.xlsx',
    Size: 9255,
    Folder: 'htmlToExcelFilesData'
  },
  Code: 200,
  Status: 'OK'
}

But I am not able to find converted file in my azure storage account file share. I am not able to find it in my mounted folder in pod as well.

Please also note that I am already using aspose on Premise for conversion of excel to pdf and was getting converted files in azure file share. So ideally, this converted file should also be present in that file share right?

wangtao · September 14, 2023, 4:55am

@rajatdpw,

According to the code you provided, we conducted a simulated test using C# and found the corresponding file in Aspose Cloud storage.

Please take a moment to check your Aspose Cloud storage to see if you can locate it. Additionally, kindly provide your account email. We will search the system logs for further relevant information.

rajatdpw · September 14, 2023, 6:00am

Hi @wangtao Please find email id:

jayakrishna_alwar[at]dpworld.com

Please note that I checked my storage account where cloud api is storing converted files, as well as file share which is mounted for on premise approach. I wasn’t able to find the file. Also, Can you kindly share how are you calling on premise api, like I can use it for reference.

Also, please share if any configuration is required to be set.

wangtao · September 14, 2023, 6:30am

@rajatdpw,

We do not find data with your provided email. Please check your provided email.

rajatdpw · September 14, 2023, 6:53am

Please use jayakrishna.alwar[at]dpworld.com

Sorry for the confusion

wangtao · September 14, 2023, 7:00am

@rajatdpw,

Okay, we got the log data and we will go to check.

wangtao · September 15, 2023, 6:48am

@rajatdpw,

Please refer to the following code. and try to use Aspose.Cells Cloud SDK for Node to test the conversion case.

const clientId = process.env.CellsCloudClientId;
const clientSecret = process.env.CellsCloudClientSecret;
const ApiURL = process.env.CellsCloudApiBaseUrl;
const localPath = “TestData/”;
var fs = require(‘fs’);
var path = require(‘path’);
var assert = require(‘assert’);
describe(‘Conversion test’, function() {

  this. Timeout(200000);
const cellsApi = new api.CellsApi(clientId, clientSecret,"v3.0",ApiURL);
describe('convert html to xlsx test', function(){
  it("should call PutConvertWorkbook successfully" , function(){
    var remoteFolder = "htmlToExcelFilesData/"
    var localName = "ToxXlsx.html"
    var remoteName = "output-fje5tj.xlsx"
    var format = "html"
    var mapFiles = {};           
    mapFiles[localName]= fs.createReadStream(localPath  +localName) ;
    var request = new model.PutConvertWorkbookRequest();
    request.file =  mapFiles;
    request. Format = "xlsx";
    request.streamFormat =  format;
    request.outPath = remoteFolder + remoteName;
    return cellsApi.putConvertWorkbook(request).then((result) => {
        expect(result.response.statusCode).to. Equal(200);
    });
  });
});

});

The following figure shows the running structure:

And you can check your Cloud API run details with Fiddler.

rajatdpw · September 15, 2023, 7:03am

Hi @wangtao. We are leveraging on Premise approach for file conversion. Cloud api is anyways working but there is latency issue. Which is why we are using aspose.cells docker image.

wangtao · September 15, 2023, 7:10am

@rajatdpw,
Thank you for choosing Aspose.Cells, and you can also refer to Aspose.Cells Cloud Docker.

rajatdpw · September 15, 2023, 7:14am

@wangtao We have been already using on Premise approach (using cells docker image) for excel to pdf conversion. That is working fine, like we are getting converted files in azure file share, which is mounted in pv-yaml file.

The main issue while converting html to excel is, i am getting a successfull message as shown above in first message, but file is not present in location.I was wondering if you could kindly help something in this regard. Thank you for your support so far

wangtao · September 15, 2023, 9:14am

@rajatdpw,

From your code parameters and response, the file should be in the "htmlToExcelFilesData“ folder of the Aspose Cloud default storage space.

rajatdpw · September 15, 2023, 9:22am

Yes. Ideally it should be. Can you confirm like if I am getting below response, does that mean file conversion has happened?

    {
  FileInfo: {
    Name: 'output-09ov32.xlsx',
    Size: 9255,
    Folder: 'htmlToExcelFilesData'
  },
  Code: 200,
  Status: 'OK'
}

Because, If you see my request body in first message, I am sending data as htmlStream in form data as:

let data = new FormData();
data.append('file', htmlStream);

I even tried with, data.append(‘document’, htmlStream) and I got same response. I am not sure how the api is behaving in both the cases. can you confirm?

wangtao · September 16, 2023, 1:29pm

@rajatdpw,

In theory, if you receive the above response, it indicates that the file conversion was successful.
There are two ways we can parse the FormData data you added, and typically, we determine the input file type based on the query parameter “streamFormat.”

rajatdpw · September 18, 2023, 8:04am

Hi @wangtao. Considering I am getting a correct response but file is not present at expected location, I think problem is that I am not giving storageName in query params as shown in the swagger UI:

image.jpg (339.8 KB)

Can you please help me, like as per our last discussion in this chat: link , I am giving storageName as ‘First Storage’.

Rest is all same like there is a json file at mounted path with same configuration. Can you please let me know if anything needs to be done here.

PS: I tried by giving storageName as ‘File Storage’ , still no luck

wangtao · September 18, 2023, 2:12pm

@rajatdpw,

This is a strange issue.
I will create a ticket number for it. And I’ll simulate the way you mentioned handling problem occurrences.
I wish I could reproduce this issue.

wangtao · September 18, 2023, 2:13pm

@rajatdpw
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSCLOUD-12348

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

rajatdpw · September 22, 2023, 9:58am

Hi @wangtao. Waiting for your response if you were able to replicate the said issue.

rajatdpw · September 25, 2023, 2:26am

Thank you for your reply. Can you please elaborate like which two documents you are referring to and what are you processing exactly? Since I get a 200 ok response, main issue which I believe is to check how storageName is being set and if any configuration is required for same. Please feel free to discuss if you find anything.

wangtao · September 25, 2023, 6:17am

@rajatdpw,

I’ll use Aspose.Cells Cloud API reference to demonstrate the conversion process, so please check the differences with yours.

First check whether the default storage space is normal.
Input conversion parameters, the parameter of the Storage name uses the default value.
Check the executed result.
Check output file.

rajatdpw · September 26, 2023, 5:34am

Hi @wangtao. Thank you so much for brief explanation. Actually I believe you have shared steps for using cloud api. The same is working for me as I had mentioned earlier.

The problem we are facing is with on Premise approach i.e, we are using docker image of aspose cells and running these apis locally. For that we have mounted the destination folder as I mentioned in above comment. If possible, I request you to kindly try with the on premise approach.