Assistance Needed with Updating Destination Folders in NPrinting Repository after migration

[sreevathsava]

Hello Experts,

We’ve recently migrated our Qlik NPrinting environment and need to update approximately 600 destination folder paths. Only the server1 name in the path needs to be changed (e.g., from (\\server1\folder1\folder2\folder3) to (\\server2\folder3\folder6\folder9), while the rest of the path remains the same.

I’m currently using pgAdmin 4 but am unable to locate the specific table in the NPrinting Repository where I can make this update.

If there’s a more efficient approach to accomplish this, or if you have any insights on where this change should be made, I’d greatly appreciate your guidance.

Thank you in advance!

Sree

[Frank_S]

Please avoid directly modifying the NP database at any time as this will likely damage your deployment.

If you want to have a better method of managing your destination folders going forward you may wish to use the following approach.

Another solution may be to use qlik variables in the future to make folder management more flexible.

• Use "set" command to create a folder variable path in the load script. Reload the NP connection after adding/updating the filepath variable ie: 'c:\nprinting;\' in this example.

• Create a variable folder location destination. select the variable set in the load script and save the destination ie Salesdemo_filepath

1. Go to the publish task/destinations to add your new folder variable path to the task

1. Run the task

This way in the future if the folder path needs to change, you simply update the load script with the new path and reload the NP connection.

This will require initial setup pain but long term ease of folder management gain.

Others here may also have other ideas but again, you should not ever manually modify the NP database if you wish to avoid damaging your NP deployment.

Kind regards.

[sreevathsava]

Thank you @Frank_S taking the time to explain this. I’ll definitely follow this approach moving forward.

Do you or anyone else know how to update existing destination folder paths efficiently? My last resort is manually editing the file paths, but with 600 of them, I’d like to avoid that if possible. Ideally, if there’s a way to simply change "server1" to "server2" across all paths, that would be perfect.

[Lech_Miszkiewicz]

Hi @sreevathsava 

1. Use this information at your own risk!!!
2. Make a BACKUP of your repository before making any changes to it
3. Paths are stored in:
   1. Table called "variable"
   2. Where field "name" = Custom path'
   3. The actual values are in field = "value"

The "variable" table is a table of many different attributes which are stored including also variables from Qlik Sense or QlikView so you have to be careful not to make changes accidently to other attributes.

cheers

[sreevathsava]

Thank you for responding @Lech_Miszkiewicz, but I did not find the destination folder paths in the variable table. In the variable table, the column "name" has variables (ex: vCurrentMonth, vMaxDate) and the column "value" has just NULLs in it. 

I don't see any paths in the table like "\\server1\Share\SourceDocuments\ADMINISTRATOR\Reporting_Upload\Reporting\UploadProcessing"

Please advice.

Thanks,

Sree

[Lech_Miszkiewicz]

Sorry @sreevathsava 

what version of nprinting we are talking about? You gave us misleading info about version 16 which obviously is incorrect so lets get the facts straight. 
i may need to do more tests tomorrow to check it again as the info i gave you was based on my testing so far. I wonder if there are any other tables i missed when searching for my folder paths. 
cheers

[sreevathsava]

@Lech_Miszkiewicz, I'm sorry, its my bad. 

I am using 

Qlik NPrinting February 2024

Version: 24.4.5.0

[sreevathsava]

@Lech_Miszkiewicz,

It is the backup of Qlik NPrinting February 2021 Version: 21.0.0.0 which I restored in Qlik NPrinting February 2024 Version: 24.4.5.0 

[Frank_S]

You cannot backup an old NPrinting database to a new NPrinting server.

This will NOT work as tables are not the same.

How to BackUp and Restore Qlik NPrinting Repositor... - Qlik Community - 1715863

You need to be very careful how you proceed. 

I suggest you work with a trusted partner or Qlik Professional services to assist you and avoid any catastrophic damage to your environment (Contact your Qlik Account manager who can arrange this but keep in mind, these are paid services).

Kind regards...

[sreevathsava]

@Frank_S @Lech_Miszkiewicz,

I'm sorry again, I should've mentioned this clearly in my previous comment, I restored the repository in the same version of Qlik NPrinting February 2021 Version: 21.0.0.0 on a new server and then did incremental version upgrades and took their respective repository backups and finally stopped at Qlik NPrinting February 2024 Version: 24.4.5.0.

Please let me know if I missed anything.

Thank you