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
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
Hi
Are you trying to import the manifest file to Excel desktop app or web app?
Hi
On Excel desktop app.
For information, on this same Excel, I have business reporter installed.
Hi
is it necessary to install somethning else before the manifest ?
Reagrds,
Christophe
Hi
I found using Excel Web App.
Regards,
Christophe
Hi
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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.