Home › Discussions › Questions & Answers › API for Mass Import of Excel4apps Reports Wand

API for Mass Import of Excel4apps Reports Wand

Avatar photoCustomer Questions & Answers 5 replies

We need to programmatically migrate reports originally defined for Excel4apps Reports Wand, which are registered as concurrent programs. Which API is used?

5 replies

  • Support Enginatics

    The migration of Excel4apps Reports Wand concurrent programs uses the same API as BI Publisher imports: the PLSQL procedure **`xxen_api.import_concurrent_program`**.

  • Avatar photoCustomer

    So, I pass the application short name and the concurrent program name?

  • Support Enginatics

    Correct. You specify the `p_application_short_name` and `p_concurrent_program_name`. There are example scripts like `mass_import_excel4apps_reports.sql` available for scripted mass migration.

  • Avatar photoCustomer

    Is there an output parameter for the resulting Blitz Report ID?

  • Support Enginatics

    Yes, the API includes `x_report_id` and `x_message` output parameters to confirm the result of the import.

  • You must be logged in to reply to this post.