Question

Excel Data Migration install issue

  • 31 January 2022
  • 6 replies
  • 266 views
C
Rank
Userlevel 3
Badge +9

Hi,

 

We use 21R2 on IFS Cloud and try to use Excel Data Miogration.

I downloaded Excel DataMigr Manifest from IFS but when I try to import it in Excel  I have a certificat error.

Do you an idea about this ?

 

Regards,

 

Christophe

ARCWIDE FRANCE / IFS Project Manager
This topic has been closed for comments

6 replies

Himasha Abeywickrama
Rank
Userlevel 7
Badge +18

Hi @Christophe BUSSI,

 

Are you trying to import the manifest file to Excel desktop app or web app?

https://www.linkedin.com/in/himashaabeywickrama
C
Rank
Userlevel 3
Badge +9

Hi @Himasha Abeywickrama ,

On Excel desktop app.

For information, on this same Excel, I have business reporter installed.

ARCWIDE FRANCE / IFS Project Manager
C
Rank
Userlevel 3
Badge +9

Hi @Himasha Abeywickrama 

 

is it necessary to install somethning else before the manifest ?

 

Reagrds,

 

Christophe

ARCWIDE FRANCE / IFS Project Manager
C
Rank
Userlevel 3
Badge +9

Hi @Himasha Abeywickrama ,

 

I found using Excel Web App.

  1. Open Microsoft Office on the web.
  2. Choose Excel and open a workbook.
  3. Go to Insert > Office Add-ins.
  4. In the Office Add-ins dialog, click Upload My Add-in.
  5. In the Upload Add-in dialog, click Browse and locate your add-in manifest file.
  6. Click Upload. The MicroStrategy for Office add-in appears in the ribbon.

Regards,

Christophe

ARCWIDE FRANCE / IFS Project Manager
Himasha Abeywickrama
Rank
Userlevel 7
Badge +18

Hi @Christophe BUSSI,

Tried importing the manifest file to excel desktop app but i’m not finding an option to import it. Not sure if its the excel version that i’m running. However, i was able to import it successfully to the web app and everything works fine. 

https://www.linkedin.com/in/himashaabeywickrama
Jens
Rank
Userlevel 4
Badge +8

This is a possible solution for installing the IFS Data Migration Excel-AddIn in the desktop app of Excel in 21R2. It only works with Excel 365 at the moment. Excel 2016/2019 are not working at the moment (you can install it in the same way but if you press the logon button nothing happens).

1. In IFS Cloud go to Solution Manager -> Data Management -> Data Migration -> Excel Migration -> Generate Manifest
2. Enter a file name, e.g. IFS Excel AddIn - 21.2.0.2 - CFG, and press Generate
3. Save the file to a local Folder, e.g. C:\IFSAddIn
4. Mark the folder C:\IFSAddIn and RMB Properties
5. Go to tab Sharing and press Share
6. Select your name/user and press Share
7. Press Done, note the Network Path(!), e.g. \\DEVICENAME\IFSAddIn and then Close
8. Open Excel, choose a new Blank Workbook
9. Go to Options
10. Choose Trust Center
11. Select Trust Center Settings..
12. Select Trusted Add-in Catalogs
13. Add your shared folder to the Catalog Url. E.g. file://DEVICENAME/IFSAddIn (the slashes are now the other way around)
14. Tick on Show in Menu, OK, OK
15. Close Excel and open it again
16. Choose a new Blank Workbook
17. Go to Insert in the menu
18. Choose My Add-ins
19. Select tab Shared Folder
20. Now you should see you file, e.g. IFS Excel AddIn - 21.2.0.2 - CFG.xml
21. Select and add it
22. Close Excel and open it again
23. Choose a new Blank Workbook
24. Now you should see your IFS Excel Add-in in the menu in the right corner

Thank you to Martina Kern for the support.

Terms & ConditionsCookie settings