IFS Data Migration Excel Add-in

This document describes how to install the Data Migration Excel Add-in in a computer. For instructions on adding files into the ClickOnce deployment, please refer the Deployment Guide.

Contents

• Prerequisites
• Installation
• Versioning
• Language Limitations
• Security
• Uninstalling

Prerequisites

• Microsoft Office Excel 2010/2013
• Microsoft .NET Framework 4.5.2 or later
• Visual Studio 2010 Tools for Office Runtime

Last two prerequisites will be automatically installed by the installers if not available.

Installation

Data Migration Microsoft Excel Add-in can be installed in multiple ways:

1. Go to IFS Application Server webpage and navigate to the Add-ons page. Click the relevant link and it would automatically download and install the add-in.
2. By manually executing the VSTO setup file.

   ” fndmig\client\officeaddins\fndmigexceladdin\setup.exe”

3. By building the component via IFS Configuration builder and then use IFS Applications Installation Wizard (setup.exe).

   Depending on the version of installed MS Excel, you have to choose "IFS Data Migration Excel Add-In" in section "Installation Components".

   For 32bit MS Excel, you have to choose "IFS Data Migration Excel Add-In (32-bit)”

   For 64bit MS Excel, you have to choose "IFS Data Migration Excel Add-In (64-bit)”

4. By manually running the relevant Microsoft Installer.

   You have to choose MSI package, depending on version of installed MS Excel.

   For 32bit MS Excel, you can install from "fndmig\win32client\IFS Data Migration Excel Add-In (64-bit)\Install\Ifs.Application.Fndmig.ExcelAddinSetup.msi”

   For 64bit MS Excel, you can install from "fndmig\win32client\IFS Data Migration Excel Add-In (32-bit)\Install\Ifs.Application.Fndmig.ExcelAddinSetup.msi”

Versioning

The version of any given Office Add-In will be its Click-Once deployment version where each of the version numbers will have a clear meaning.

Click Once deployment version: M.m.b.r (Major.Minor.Build.Revision)

• Major: Office version (nn) + future use (nnn)
• Minor: Target IFS Applications version (nnn) + target Component version (nn)
• Build: RnD Binary Release number (nnnnn)
• Revision: First number for corrective releases (n) + next two for R&D internal developments (nn) + last two for localizations and customizations (nn)
   

Example: 14000.8020.00001.01500

• 1400.x.x.x  - Microsoft Excel 2010
• x.09020.x.x - IFS Applications 9.0 + FNDMIG version 2.1.0
• x.x.00001.x - Release version 00001
• x.x.x.01500 - R&D Internal build 15

Example: 14000.8020.00001.10800

• 1400.x.x.x  - Microsoft Excel 2010
• x.09020.x.x - IFS Applications 9.0 + FNDMIG version 2.1.0
• x.x.00001.x - Release version 00001
• x.x.x.10800 - Corrective release 1 + R&D Internal build 08

Example: 14000.8020.00001.10800

• 1400.x.x.x  - Microsoft Excel 2010
• x.09020.x.x - IFS Applications 9.0 + FNDMIG version 2.1.0
• x.x.00001.x - Release version 00001
• x.x.x.00803 - Internal build 08 + Customized or Localized Click-Once packaging 03

Language Limitations

The add-in is released only in English language. But additional languages and be added as language files. These language files can either be repackaged to the ClickOnce package or add by the end user. Defining and repackaging translations is described in the Deployment Guide. Add-in login dialog lists out all IFS supported languages but the relevant language file needs to be installed in order to successfully log in.

Security

Permission set "FNDMIG_EXCEL_ADDIN" needs to be granted for an End User to run the add-in. If the permission-set does not exist after installation it should be created manually (Run fndmig\database\fndmig\security_fndmig_excel_addin.ins).

Uninstalling

• Go to installed program list in the control panel
• Select “IFS Data Migration Excel Add-in”, and then click Remove or Uninstall.