Skip to main content

Hello,

I try to instal the Cloud File Storage Migration Tool in our UAT database because we have a storage problem, so the first step it's to instal the "Installing a custom PL/SQL API used by the tool in the source database", so someone can help me step by step how i can do that please ? i follow this documentation : https://docs.ifs.com/techdocs/24r1/030_administration/210_cloud_file_storage/fsmigtool/#logging_options

 

Thank’s

You need to download the tool. It includes an .sql file that is used to install the PL/SQL package in the SOURCE (important!) database.

How much data do you need to move? Did you consider other options?
 


You need to download the tool. It includes an .sql file that is used to install the PL/SQL package in the SOURCE (important!) database.

How much data do you need to move? Did you consider other options?
 

@Mathias Dahl, I have successfully installed everything needed to use the tool.  We are attempting to migrate our shared repo (network folder) to IFS cloud file storage.  I created a comma separated txt file to reference each doc (document.txt).  Is there a specific location that file needs to be?  I put it into the root folder where the tool is located.  I get a very generic error I’m unsure how to fix, see attached.

 


Got past this problem...now I suspect I’m dealing with a certificate problem.  I attempted to import our cert into the keystore, but continue to get the following error:

[2025-07-03 12:07:12] [INFO   ] Cleaning up FileInfoVirtual at cloud... 
[2025-07-03 12:07:12] [WARNING] Error: Unexpected Exception. Check the log for more information. 
[2025-07-03 12:07:12] [WARNING] Error: Error while cleaning up the virtual. Error while getting the token end point. sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
 

Can you give some direction on how to load our cert properly?


Should have waited to post...Here is command you’ll want to use to import your own cert:

.\keytool -import -noprompt -trustcacerts -alias https://<environment-url> -file "<local path to cert>\<yourcert>" -keystore "<Directory of migration tool\java\lib\security\cacerts"

You’ll be prompted for the keystore pw...the default should be changeit


Hi ​@jlandon296

I am planning to do a batch import of documents from a shared folder to IFS cloud file storage.

I tried following the documentation but got stuck on using the command when the file source is a shared folder.

Command:

fsmigtool --docsfromfile DocumentInfo.txt --docsfromfilesource FOLDER --dbconn "what should be the dbconn in this case??" --dbuser "??" --dbpass XXXXXXXXXXXXXXX --cloudurl https://XXXX-cfg.ifs.cloud --cloudclientid IFS_fsmigtool --cloudclientsecret XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX --cloudrealm XXXcfg1 --logmigtable

 

Could you please share the steps you followed for this migration. It would be really helpful.

 

Thank you!


Hi, These are the steps I followed during the migration. I hope this helps. There may be some changes in the latest IFS documentation, so it’s better to refer to the updated document. This migration was done on version 24R1.

 

1. Download the Tool

• First, download the tool Cloud File Storage Migration Tool - Technical Documentation For IFS Cloud

2. Place the Tool on the Target Server

• Copy the downloaded tool to the target server. In this case, it is the upgrade place

management server.

3. Run the PL/SQL API in the Source Database

• Execute the FsMigTool.sql script in the source database to install the PL/SQL API. This

script is located in the database folder.

4. Create an IAM Client

• Create an IAM client in the target application.

• Ensure you have the secret value of the user.

5. Disable the Antivirus Scanner

• Disable the antivirus scanner using the system parameter settings in the application.

6. Prepare the Document List

• Use the --docsfromfile method to transfer the documents.

• Create a comma-separated text file with all the document information that needs to be

transferred. Please refer to this document for the format of the document information

text file.

https://docs.ifs.com/techdocs/24r2/030_administration/210_cloud_file_storage/fsmigtool/#format_of_the_document_information_text_file

Ex: A621,1052662,1,1,ORIGINAL,VIEW,1,L681-1015696-1-1.PDF,XXXXX SERVICES LTD 8002697.pdf,\\xxx-ftp-01\ftp\IFSDOC

A UNC path needs to be created, and the document must be accessible there

7. Run the Query

• Open Command Prompt as Administrator.

• Change the directory to the FsMigTool folder.

• Run the prepared query.

• A log file will be created in the FsMigTool folder.

fsmigtool --docsfromfile doc.txt --docsfromfilesource FOLDER --dbconn

"jdbc:oracle:thin:@//XXX-ORA-DEV:1521/IFSDEV" --dbuser IFSAPP --dbpass

xxxxxxUJxxxx5Ac=mmaa --cloudurl https://XXX-cfg.ifs.cloud --cloudclientid IFS_fsmigtool --

cloudclientsecret XXXXXxxxxxuVOk6rlOc8Y6xk1Fxxxxx --cloudrealm XXXrcfg1 --logmigtable


Hi ​@maheshmuz

Thank you for your response.

We have a set of PDF documents in a shared folder that needs to be attached to corresponding Inventory Parts in IFS Cloud.

In case there are several attachments, importing them manually one by one would be time consuming, so we are looking for a batch import approach.

Is Fs Migration Tool only suitable for environment-to-environment migration? As it requires deploying PLSQL code in source environment.

If the documents are imported into a test environment, would there be a possibility to migrate them to Production? we are on IFS customer managed cloud.

Could you please suggest the best approach to achieve this.

 

Thank You!

 


I'm sorry, I haven't tried the other approach. I only tried deploying the PLSQL code in the source environment. There shouldn’t be any issue migrating the imported document from test to production, but I haven’t tested it myself. I hope someone who has already done this can share their experience.