Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
punitpopli
Specialist
Specialist

Unable to import users using excel

Hi Experts,

I am unable to import users using as excel when am trying yo update the filters associated with a user (using "Update filters if modified" property in import task).

getting an error as - Importing FILTER with name 'EU'. ERROR: The filter 'EU' is invalid because the app 'Sales Demo' does not exist.

Though I don't have a filter named as EU in the list, still am getting aforementioned error.

Any help or suggestion on this would be really helpful.

I have used the same recepient.xlsx file available under Example.zip in help section, link for reference - https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/Examples/Examples.htm

 

thanks in advance

Labels (3)
2 Solutions

Accepted Solutions
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Well - if you used the example file then that exact file has that filter in it. Have you reviewed all sheets from the template as all of them are very important and need to be properly configured.

Lech_Miszkiewicz_0-1677660234335.png

Go to "Filters" sheets and remove unwanted records or create those which you want to create/import. The same applies to "Groups" sheet in that excel. 

Note that those sheets are there for reason as they are related to columns in your user Sheet!

Lech_Miszkiewicz_1-1677660490956.png

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

Ruggero_Piccoli
Support
Support

Hi,

If a filter already exists you must use its exact name. The same if you create it in the Filters worksheet.

Then you have to check the options:

  • Create filters if not present
  • Update filters if modified
  • Remove filters not present in newest import sources
  • Replace existing filter fields

Based on your needs.

All details are explained at https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/DeployingQVNprinting/Import-Users-Fi...

Note that Import task can be run in Test Mode and after you can download a text file with related erros.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

5 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Well - if you used the example file then that exact file has that filter in it. Have you reviewed all sheets from the template as all of them are very important and need to be properly configured.

Lech_Miszkiewicz_0-1677660234335.png

Go to "Filters" sheets and remove unwanted records or create those which you want to create/import. The same applies to "Groups" sheet in that excel. 

Note that those sheets are there for reason as they are related to columns in your user Sheet!

Lech_Miszkiewicz_1-1677660490956.png

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Ruggero_Piccoli
Support
Support

Hi,

You could also use Excel searching feature to find all occurrences of "EU" in your file and delete them.

The structure of the Excel file must be the one in the samples file but sheets can be empty. For example, if you do not need to create new groups keep the related worksheet empty.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
punitpopli
Specialist
Specialist
Author

My Bad , didn't realize other sheets might be causing the issue. Thank you for your quick response.

This helps

 

Also, when am adding filter names in the User spreadsheet the filters are not getting assign to a user. May I know if there is a specific option (s) which needs to be selected while importing details from spreadsheet?

 

Ruggero_Piccoli
Support
Support

Hi,

If a filter already exists you must use its exact name. The same if you create it in the Filters worksheet.

Then you have to check the options:

  • Create filters if not present
  • Update filters if modified
  • Remove filters not present in newest import sources
  • Replace existing filter fields

Based on your needs.

All details are explained at https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/DeployingQVNprinting/Import-Users-Fi...

Note that Import task can be run in Test Mode and after you can download a text file with related erros.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Frank_S
Support
Support

Regarding filters:

Using the import tool

cc @punitpopli 

kind regards...

 

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!