Error about creating Excel reports

[jan_blaha]

I looked more at the detail, and it seems that your template has lost the reference to the "xlsx template".
The v3 during the startup process automatically migration and converts the old xlsxTemplate entities to assets.
https://jsreport.net/learn/v3-migration-guide#xlsxtemplates
Maybe there was some error during this. You should be able to manually edit the template and add the xlsx template reference.

It would be great if you email me your original v2 data in export. I would love to take a look at why the migration didn't process it correctly.

[Genhan]

Hi @jan_blaha,

Downgrading Node to 14 resolved this issue, but we do need to update them in the near future

I will try your suggestion about linking xlsx templates manually. I think that it might resolve the issue - since I tried the same report in the playground and it works: https://playground.jsreport.net/w/anon/8iI_gl82 .

Sure. Where should I drop the original v2 data?

Thank you,
Genhan

[Genhan]

Hi @jan_blaha ,

I upgraded to v3 again and captured the v3 template folder structure in the following screenshot:

The v2 structure in the xlsxTemplates folder is like:

Those ***.xlsx folders were created by the migration process.

Thank you,
Genhan

[Genhan]

Hi @jan_blaha , do you have a guide about how to add the xlsx template reference manually? I copied xlsx templates (e.g. PublicPrjXlsxTpl) into the assets folder manually - but it did not work.

[jan_blaha]

The reference to the excel template is set in the template properties.

If it's possible, please send me the v2 data to jan.blaha@jsreport.net

[Genhan]

Thank you, @jan_blaha. I emailed you the v2 data zip. Let me know if you received it.

Best,
Genhan

[jan_blaha]

I apologize for the delay. I found the email but the attachment was removed by some email servers on the way.
Could you please zip the attachment and send it again to these two email addresses? Thank you

jan.blaha@jsreport.net
jan.blaha@hotmail.com

[Genhan]

@jan_blaha , I shared the zipped data folder in Dropbox with you. Let me know if you received the share link.

Thank you,
Genhan

[jan_blaha]

Thank you, I received your data.

I analyzed the migration of data there and it looks fine.
The problem is that the data already includes a flag that data were migrated so it doesn't run again.
Please remove file data/settings and start jsreport v3 again. It should migrate properly the xlsx templates to assets and fill the references for you.

[Genhan]

Thank you so much, @jan_blaha! Removing data/setting resolved the issue.