Skip to main content
Question

Excel Data Migration tool - Multiple environments (IFS Cloud)


NovPeterR
Sidekick (Partner)
Forum|alt.badge.img+6

Does anyone know if it is possible to use the Excel Plugin to access multiple data bases?

I have a customer who want to be able to update both test and Prod.
Not both at the same time, but be able to switch between the two.

 

4 replies

Forum|alt.badge.img+10
  • Hero (Partner)
  • 186 replies
  • November 20, 2022

To me it looks like you can add two excell addins to an Office environment. 
You can create an excell file for the TEST env and another one for the PROD env.

(Note that you have to download the manifest for both environments then, TEST and PROD)

Then you can just copy paste the data from one excell file to another.

Note that you cannot export Excell migration jobs so you have to recreate the job in the PROD env

and grant the needed access to the excell migration projection. 


NovPeterR
Sidekick (Partner)
Forum|alt.badge.img+6
  • Author
  • Sidekick (Partner)
  • 27 replies
  • November 23, 2022
kvbe wrote:

To me it looks like you can add two excell addins to an Office environment. 
You can create an excell file for the TEST env and another one for the PROD env.

(Note that you have to download the manifest for both environments then, TEST and PROD)

Then you can just copy paste the data from one excell file to another.

Note that you cannot export Excell migration jobs so you have to recreate the job in the PROD env

and grant the needed access to the excell migration projection. 

Thanks,

While waiting for this answer I found out the above myself too.
But, it is possible to export/import. You just need to grant your user access to the FNDMIG_EXPORT and FNDMIG_IMPORT jobs.

And another thing that I also found out. Both jobs (test and prod) will have the same name in Excel so it is difficult to tell one from the other.
Before you add the Add-In into Excel you can edit the XML file and rename the add-in label that is visible in Excel.


Forum|alt.badge.img+10
  • Hero (Partner)
  • 186 replies
  • November 30, 2022

Thats a very good suggestion! 

That should actually  be a feature request. That the Excel migration tool should be named with an indication for the platform you are on.


NovPeterR
Sidekick (Partner)
Forum|alt.badge.img+6
  • Author
  • Sidekick (Partner)
  • 27 replies
  • November 30, 2022

Agree to that.
Just add a field in the ‘Generate Excel manifest’ where user can give the plug in a unique name that will be visible in Excel.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings