Page 1 of 1

Import Utility is not reading worksheets for Excel upload

Posted: 11 Apr 2022, 12:02
by ben.ralph.nmc
Hi

I'm trying to do my first upload to Essential OS but the Import Utility is not reading the worksheets in the Excel file.

I have downloaded the XML (Excel) file from the Launchpad Export page and made edits to the business domains and business capabilities tabs. I've configured the Import Utility and successfully tested the connection to my Essential Viewer. When I create a new import activity the worksheets from the Excel file are not being displayed in the Select Worksheets' section. What am I doing wrong?

Thanks for your help.

Re: Import Utility is not reading worksheets for Excel upload

Posted: 12 Apr 2022, 21:17
by JohnM
Can I just check, are you saving the XML file as an Excel before you upload it to the import utility?

Re: Import Utility is not reading worksheets for Excel upload

Posted: 13 Apr 2022, 05:32
by ben.ralph.nmc
Hi John, yes I'm saving the file as Excel (.xlsx) file for the upload.

Re: Import Utility is not reading worksheets for Excel upload

Posted: 18 Apr 2022, 10:25
by ben.ralph.nmc
Hi John

I've diagnosed the issue. I needed to upload the import specification.

Re: Import Utility is not reading worksheets for Excel upload

Posted: 25 Jul 2022, 05:10
by dhaya.karuthedathu
Hi,

A newbie here can you please advise how you got the import specification file.
I am trying to get excel or XML import from the initial data load and I cant seem to figure out from where I can get the excel or XML import specification file.
I am using the essential_baseline_v6.15 and trying to make sure the import works before i deal with actual data

Thanks in advance.

Re: Import Utility is not reading worksheets for Excel upload

Posted: 27 Jul 2022, 16:26
by JohnM
Hi,

Just request Launchpad to import the Excel, register here https://enterprise-architecture.org/ess ... nchpad.php and the team will send you a pack.

John