Converting XBRL file to PDF - evaluation text is not getting removed and most of the data has been ignored into target file

Aspose.Finance Product Family
1

private static void AsposeFun()
{
var sourceDir = “C:\Project\XBRL\”;
var outputDir = “C:\Project\XBRL\”;
// Load XBRL document
XbrlDocument document = new XbrlDocument(sourceDir + @“CONF-ATO-IITR-SRP-004_Prefill_Response_03.xml”);

        Aspose.Finance.License license = new Aspose.Finance.License();
        license.SetLicense("Aspose.Financefor.NET.lic");
        
        // Set save options
        Aspose.Finance.Xbrl.SaveOptions saveOptions = new Aspose.Finance.Xbrl.SaveOptions();
        saveOptions.SaveFormat = Aspose.Finance.Xbrl.SaveFormat.XLSX;

        // Save XBRL as XLSX in File Stream
        FileStream fs = new FileStream("sample_out_1.xlsx", FileMode.Create);
        document.Save(fs, saveOptions);

        // Open an Excel file
        Workbook workbook = new Workbook(fs);
        workbook.Save(outputDir + "Aspose_sample_output_1.pdf");

}

2

@rachit.patel,

I have reviewed your sample code segment. Since you are converting an XBRL file to PDF in two steps using the Aspose.Finance (XBRL to XLSX) and Aspose.Cells (XLSX to PDF) APIs, you will also need to use and set an Aspose.Cells license in the code at the beginning of your program for the task. Please obtain and use an Aspose.Cells license file, and then set it in the code (refer to the documentation on licensing for your reference). This should resolve any issues. Let us know if you encounter any further problems.

3

Hi Amjad,

Thanks for quick response.

Is there a way to convert the XBRL to PDF directly without Aspose.Cells? I just want to use the Aspose.Finance API only but couldn’t find the code.

Can you help in this?

image001.png (1.04 KB)

4

@rachit.patel,

We are sorry but currently Aspose.Finance does not support rendering XBRL to PDF directly, so you have to use both Aspose.Finance and Aspose.Cells APIs for the task.

Moreover, we will evaluate your requested feature (XBRL to PDF rendering using Aspose.Finance). 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): FINANCENET-331

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.

5

Hi Amjad,

We don’t mind buying and using both license as far as it generates the desired output.

After setting up license for Cells, the evaluation text has been removed but the main issue still exist. It is not converting all the data from source file. I have attached source and output file for your reference. It is very crucial for us to convert all the data if we have to go ahead with Aspose. Can you please advise on this?

.Net Code :

var sourceDir = “C:\Project\XBRL\”;

var outputDir = “C:\Project\XBRL\”;

// Load XBRL document

XbrlDocument document = new XbrlDocument(sourceDir + @“CONF-ATO-IITR-SRP-004_Prefill_Response_03.xml”);

Aspose.Finance.License license = new Aspose.Finance.License();

license.SetLicense(“Aspose.Financefor.NET.lic”);

Aspose.Cells.License lic = new Aspose.Cells.License();

lic.SetLicense(“Aspose.Cellsfor.NET.lic”);

// Set save options

Aspose.Finance.Xbrl.SaveOptions saveOptions = new Aspose.Finance.Xbrl.SaveOptions();

saveOptions.SaveFormat = Aspose.Finance.Xbrl.SaveFormat.XLSX;

// Save XBRL as XLSX in File Stream

FileStream fs = new FileStream(“sample_out_2.xlsx”, FileMode.Create);

document.Save(fs, saveOptions);

// Open an Excel file

Workbook workbook = new Workbook(fs);

workbook.Save(outputDir + “Aspose_sample_output_2.pdf”);

image001.png (1.04 KB)

Aspose_sample_output_2.pdf (43.5 KB)

(Attachment CONF-ATO-IITR-SRP-004_Prefill_Response_03.xml is missing)

6

CONF-ATO-IITR-SRP-004_Prefill_Response_03.zip (1.6 KB)

7

@rachit.patel,

Thanks for the sample files.

I did test your scenario/case using your sample XBRL file and sample code snippet. I found some data is clipped in the output XLSX by Aspose.Finance and hence the output PDF by Aspose.Cells has some data missing as well. I have attached the output XLSX file by Aspose.Finance for your reference. We request you to kindly share an Excel file with your expected results (which should have all the data intact), you may create such a file in MS Excel manually. We will then evaluate and may log a ticket for it into our database for investigation and resolution.
sample_out_2.zip (7.3 KB)

8

Hi Amjad,

Please ignore the previous xsd file I sent, that was the wrong one.

Please refer the correct attached file in this email for you reference. Apology for inconvenience.

image001.png (1.04 KB)

(Attachment ato.iitr.0010.2023.prefill.response.01.00.report.xsd is missing)

9

@rachit.patel,

We could not find the resource files in your previous post/mail. Could you please zip the resource files again and attach the zipped archive here in this thread? We will check your issue soon.

10

Hi Amjad

Rachit is currently on leave and has asked me to attach the zip file again.

Please let me know if you are still not seeing the file.

Kind regards

image001.png (538 Bytes)

image002.png (606 Bytes)

image003.png (518 Bytes)

image004.png (702 Bytes)

image001.png (1.04 KB)

ato.iitr.0010.2023.prefill.response.01.00.report.zip (30.8 KB)

11

@rachit.patel,

I checked and found you only provided XSD (XML Schema File). We also need the following:

  1. XBRL file
  2. XLSX file with your expected results in first step, you may manually create such such a file in MS Excel.

Once we receive the above mentioned files, we will start investigating your issue and may log a ticket for it.

12

Hi Amjad

Please find attached the XBRL file and schema file. I believe we had previously provided a PDF document highlighting the data in the input file that we are trying to convert, and they are all missing.

I currently don’t have in XLSX of my expected results. Once you are able to confirm that the highlighted data can be extracted from the XBRL with schema file applied, this will assist us to provide you with what output to expect.

Kind regards

Angelo Yeung

Business Analyst

RSM Australia Pty Ltd

Level 27, 120 Collins Street Melbourne VIC 3000

PO Box 248, Collins Street West VIC 8007

DL: +61 (0) 3 9286 8000 | F: +61 (0) 3 9286 8199

E: Angelo.Yeung@rsm.com.au | W: www.rsm.com.au

(Attachment CONF-ATO-IITR-SRP-004_Prefill_Response_03 1.xml is missing)

CONF-ATO-IITR-SRP-004_Prefill_Response_03.xml [highlighted].pdf (4.51 MB)

13

You have again provided PDF file and not XBRL/xml file in your reply, see the screenshot for your reference.
sc_shot1.png (77.1 KB)

Please zip XBRL and schema file and attach it here. We will download your attachment and then evaluate your issue using your files.

14

Hi Amjad

The XBRL was attached to the previous email but the webmail client may have blocked it. However, it is my understanding that Rachit had provided this to you in an earlier email. I had also zipped the schema file and sent it to you last week.

Please see attached zip file containing the XBRL/XML and schema files.

Kind regards

Angelo Yeung

Business Analyst

RSM Australia Pty Ltd

Level 27, 120 Collins Street Melbourne VIC 3000

PO Box 248, Collins Street West VIC 8007

DL: +61 (0) 3 9286 8000 | F: +61 (0) 3 9286 8199

E: Angelo.Yeung@rsm.com.au | W: www.rsm.com.au

Aspose.zip (32.4 KB)

15

We did evaluate your issue in details. We tested your scenario/case using your sample XBRL file and noticed that some data is missing in the output XLSX file from XBRL via Aspose.Fianance for .NET.

We require thorough evaluation of the issue. 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): FINANCENET-333

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.

16

Hi Amjad

I came across 4 other files which I think could be useful for building the report. Please see attached zip.

Kind regards

Angelo Yeung

Business Analyst

RSM Australia Pty Ltd

Level 27, 120 Collins Street Melbourne VIC 3000

PO Box 248, Collins Street West VIC 8007

DL: +61 (0) 3 9286 8000 | F: +61 (0) 3 9286 8199

E: Angelo.Yeung@rsm.com.au | W: www.rsm.com.au

files.zip (121 KB)

17

@Angelo_Yeung,

Thanks for providing more XBRL files.

I have attached the archive with your existing ticket “FINANCENET-333” into our database. We will evaluate all your files (you provided) while fixing the issue.

Once we have an update on your issue(s), we will update you.

18

Hi Amjad

Thanks for the update. The zip file I provided in my previous email are linkbases. Hopefully it will provide some additional information in relation to relationships and presentation.

Kind regards

Angelo

RSM Australia practices via the legal entities RSM Australia Pty Ltd and RSM Australia Partners. Further information can be found here.

Liability limited by a scheme approved under Professional Standards legislation.

19

@Angelo_Yeung,

Sure, let us evaluate your issue in details. Once we have any information available, we will update you.

20

Hi Amjad

Thank you. It’s an XBRL reporting for Australian : Tax file number. I hope that helps.

Kind regards

Angelo Yeung

Business Analyst

RSM Australia Pty Ltd

Level 27, 120 Collins Street Melbourne VIC 3000

PO Box 248, Collins Street West VIC 8007

DL: +61 (0) 3 9286 8000 | F: +61 (0) 3 9286 8199

E: Angelo.Yeung@rsm.com.au | W: www.rsm.com.au

image001.png (1.04 KB)