topic Re: Assistance Needed with Updating Destination Folders in NPrinting Repository after migration in Qlik NPrinting

Assistance Needed with Updating Destination Folders in NPrinting Repository after migration

sreevathsava — Thu, 19 Sep 2024 14:18:58 GMT

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

Re: Assistance Needed with Updating Destination Folders in NPrinting Repository after migration

Frank_S — Wed, 18 Sep 2024 19:25:42 GMT

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

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

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.

Re: Assistance Needed with Updating Destination Folders in NPrinting Repository after migration

sreevathsava — Wed, 18 Sep 2024 20:19:10 GMT

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.

Re: Assistance Needed with Updating Destination Folders in NPrinting Repository after migration

Lech_Miszkiewicz — Thu, 19 Sep 2024 10:00:55 GMT

Hi @sreevathsava

Use this information at your own risk!!!
Make a BACKUP of your repository before making any changes to it
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

Re: Assistance Needed with Updating Destination Folders in NPrinting Repository after migration

sreevathsava — Thu, 19 Sep 2024 13:50:05 GMT

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

Re: Assistance Needed with Updating Destination Folders in NPrinting Repository after migration

Lech_Miszkiewicz — Thu, 19 Sep 2024 14:08:33 GMT

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

Re: Assistance Needed with Updating Destination Folders in NPrinting Repository after migration

sreevathsava — Thu, 19 Sep 2024 14:16:39 GMT

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

I am using

Qlik NPrinting February 2024

Version: 24.4.5.0

Re: Assistance Needed with Updating Destination Folders in NPrinting Repository after migration

sreevathsava — Thu, 19 Sep 2024 14:57:32 GMT

@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

Re: Assistance Needed with Updating Destination Folders in NPrinting Repository after migration

Frank_S — Thu, 19 Sep 2024 15:15:29 GMT

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...

Re: Assistance Needed with Updating Destination Folders in NPrinting Repository after migration

sreevathsava — Thu, 19 Sep 2024 15:20:49 GMT

@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

Re: Assistance Needed with Updating Destination Folders in NPrinting Repository after migration

Lech_Miszkiewicz — Thu, 19 Sep 2024 23:33:17 GMT

Hi @sreevathsava

I did more testing and I just created test path as below:

Then I reloaded my script to load all tables from NPrinting:

LIB CONNECT TO 'NPrinting DB'; Tables: LOAD table_catalog, table_schema, table_name, table_type ; SELECT "table_catalog", "table_schema", "table_name", "table_type", "self_referencing_column_name", "reference_generation", "user_defined_type_catalog", "user_defined_type_schema", "user_defined_type_name", "is_insertable_into", "is_typed", "commit_action" FROM "information_schema"."tables" Where table_schema = 'public'; For each vTable in FieldValueList('table_name') Qualify *; [$(vTable)]: LOAD * ; SELECT * FROM "public"."$(vTable)" ; Next Drop Table Tables; exit script;

And thats the result is below which is exactlky what you want to update as far as I can tell:

The new folder name appears in:

"app_folder" table under "name" field:

So as far as I can tell table "variable" field "value" is where the paths are stored depending on the whay you constracted destinations paths you may need to fiter the name field for apriopriate value.

Since you are saying you are not seeing anything I cannot comment on it cause I am not there with you, but if I was I would build a Qlik Sense app which would read whole reporitory so I coauld easily search through it. All it takes is just to load the script I have attached earlier.

cheers