topic Re: Import Task for recipient User getting failed in Qlik NPrinting

Import Task for recipient User getting failed

kakaderanjit53 — Wed, 10 May 2017 03:06:03 GMT

Hi Qlik Experts,

I am importing the recipients user task with Filter and groups,It succeed when no. of user upto 3 ,but after updation of excel file of

import recipients with increased number of recipients,the same task getting failed and showing the error,

ERROR message : importing USER : Can not create the new user because their email is already in use.

ERROR message : The import failed due to some invalid entries. No data was saved."

Give me solution for resolving this problem,ASAP;

@lech_miszkiewicz lech_miszkiewicz‌‌,

avinashelite‌,

mto‌,

@ Daniel Jenkins

Thanks and Regards,

RANJIT KAKADE.

Re: Import Task for recipient User getting failed

Lech_Miszkiewicz — Wed, 10 May 2017 04:30:14 GMT

Hi,

this indicates that you have the same email address assigned to multiple users.

Think of e-mail column as of Primary key in recipient table - it cannot have duplicates!!!

that is all said in your log Can not create the new user because their email is already in use.

cheers

Lech

Re: Import Task for recipient User getting failed

kakaderanjit53 — Wed, 10 May 2017 04:36:23 GMT

Hello Lech,

First Thanks for your immediate reply,

FYI, I have been not the same email address assigned to multiple users.

I am just reloading the same task with following actions:

Re: Import Task for recipient User getting failed

Lech_Miszkiewicz — Wed, 10 May 2017 05:16:42 GMT

Are you able to share your recipient file?

did you add manually users to NPrinting console? Are you then trying to update them?

Re: Import Task for recipient User getting failed

kakaderanjit53 — Wed, 10 May 2017 05:37:19 GMT

Hi ,

Yes, I have been added some User manually in the Nprinting Console and trying to update the list of recipients to the specific groups.,But I dont want to delete the existing user to be delete,just want update on the same if already present in the Nprinting Console,even I already tried the same ,For E.g. The User Name "Kamineni Preveen" is already present in the Nprinting console,but after reloading of task its status become "Update", but in the excel file if the number of recipients changed than existing then task getting failed,PFB for Log file when The User Name "Kamineni Preveen" is already present in the Nprinting console,but after reloading of task its status become "Updated and PFA for List of Recipients.,1. existing list

2. Updated List of Recipients.

3. Log file details"

Re: Import Task for recipient User getting failed

kakaderanjit53 — Wed, 10 May 2017 07:50:19 GMT

Hello Guys,

Im waiting for your important reply about my above query.

Re: Import Task for recipient User getting failed

Lech_Miszkiewicz — Wed, 10 May 2017 07:54:15 GMT

I am testing scenarios - will let you know once i am done with it.

I am thinking that only some of user related items can be actualy updated via import - this beeing filters, groups (not sure about the name though).

cheers

Re: Import Task for recipient User getting failed

kakaderanjit53 — Wed, 10 May 2017 11:25:41 GMT

Hello Lech ,

No ,Name also updating after reloading the Import Task, PFB Details for the same:

Re: Import Task for recipient User getting failed

Lech_Miszkiewicz — Thu, 11 May 2017 09:19:36 GMT

how are you going with recipients import?

I am testing it - and it works for me. I do not know what is a problem with your import.

Are there any unusual characters in your file? I had this issue when once i tried to import data with polish characters - load was failing.

cheers

Lech

Re: Import Task for recipient User getting failed

kakaderanjit53 — Fri, 12 May 2017 09:06:20 GMT

Hi Lech,

Kindly find the attached Excelsheet file which contains list of User recipient.,Give me acknowledgement once when you download it,

I have been referred the following weblink article for importing Users Recipients with filters and groups task,

https://help.qlik.com/en-US/nprinting/17.3/Content/Recipients&Users/ImportUsersFiltersGroups/Import-Users-Filters.htm

Re: Import Task for recipient User getting failed

Lech_Miszkiewicz — Fri, 12 May 2017 22:45:04 GMT

Hi - got it - will test on it.

cheers

Re: Import Task for recipient User getting failed

Lech_Miszkiewicz — Fri, 12 May 2017 23:00:07 GMT

Hi Ranjit.

Well - it worked for me. I was able to import whole list without issues. I think you have some legacy stuff there.

I loaded all users without any issues and then re-run imports couple times changing things like time zones, filters etc

Couple things i have noticed:

are you using xls or xlsx (on one of your screenshots you are refering to xls) and attachment you have provided is XLSX
make sure all DOMAIN ACCOUNTS are properly spelled (if you are connected to DOMAIN). I had an issue once with client that NPrinting was checking against AD to see whether such account exists - it was missing a letter and import was failing.
i would suggest to start from 0 - meaning clear all users, import all with file and then play/modify and re-import them again. See how you go.
note that apps, filters (also fields in filters), connections referenced in import file etc.. - they should be all available in NPrinting prior to recipient Import, else import will not work properly.

I am not sure what else we could do.

Works for me - I am running NPrinting 17.3.1

cheers

Lech

Re: Import Task for recipient User getting failed

Lech_Miszkiewicz — Fri, 12 May 2017 23:07:04 GMT

and couple more things.

If you have a user created from NPrinting console you are not able to update such user using task. then you will get error:

Importing filters and recipients for file with path c:\Users\Lech\Desktop\R.xlsx

ERROR message : importing USER : Can not create the new user because their email is already in use.

ERROR message : The import failed due to some invalid entries. No data was saved.

Look at your recipient list - is anyone on this list beeing entered manualy in NPrinting?

------------------------------------------------------------------------------------------------------------------

ps.

when you try to add user which is not recognised in domain:

cheers

Lech

Re: Import Task for recipient User getting failed

kakaderanjit53 — Mon, 15 May 2017 08:57:53 GMT

Hi Lech ,

Thanks alot for your important reply ,let me check now this issue as per your suggestions.

Note: I'm only using excel file with.xls extension for import task,for your reference I have been converted it into

.xlsx file extension.

Re: Import Task for recipient User getting failed

Mon, 15 May 2017 23:02:44 GMT

Couple things i have noticed:

are you using xls or xlsx (on one of your screenshots you are refering to xls) and attachment you have provided is XLSX

make sure all DOMAIN ACCOUNTS are properly spelled (if you are connected to DOMAIN). I had an issue once with client that NPrinting was checking against AD to see whether such account exists - it was missing a letter and import was failing.

i would suggest to start from 0 - meaning clear all users, import all with file and then play/modify and re-import them again. See how you go.

Do the users must exists in the domain? or can it work with another email, without specify domain\user ??

Thanks!

Re: Import Task for recipient User getting failed

Lech_Miszkiewicz — Mon, 15 May 2017 23:16:06 GMT

NO - they do not. They can be existing only with email (for ex.: case when you sending reports/emails to customers)

Domain Account is an optional field - you can leave it blank.

I have actualy found a workaround on how to populate this field with not existing accounts by:

first - importing all users with empty DOMAIN ACCOUNT field
second - updating it with DOMAIN ACCOUNT value - this seems to skip account validation against AD

DOMAIN ACCOUNT is necessary though if you want to publish reports to QlikSense Hub, use SSO for accessig NPrinting NewsStand or NPrinting Admin console.

regards

Lech

Re: Import Task for recipient User getting failed

Mon, 15 May 2017 23:23:36 GMT

Domain Account is an optional field - you can leave it blank.

I have actualy found a workaround on how to populate this field with not existing accounts by:

first - importing all users with empty DOMAIN ACCOUNT field

second - updating it with DOMAIN ACCOUNT value - this seems to skip account validation against AD

Thanksa lot!

Just what do you mean with 'second - updating it', do I let it blank? or which value do I write?

Re: Import Task for recipient User getting failed

Lech_Miszkiewicz — Mon, 15 May 2017 23:32:20 GMT

I have actualy found a workaround on how to populate this field with not existing accounts by:

first - importing all users with empty DOMAIN ACCOUNT field
second - updating it with DOMAIN ACCOUNT value - this seems to skip account validation against AD

Scenario:

If there is user which does not exist in domain and you would try to import from XLS or create such user in NPrinting and also populate value for DOMAIN ACCOUNT field in NPrinting with not existing ivalue in AD it will not allow you to do that when you create a user!

But-when you create a user with blank DOMAIN ACCOUNT field and then re-run import/update task again - you will be able to update DOMAIN ACCOUNT field with any string. Which means that domain account validation happens only on "Create user" action and not on "Update useraction"

I am not sure whether it is a rule or it meant to be like this. It is only my observation.

regards

Lech

Re: Import Task for recipient User getting failed

kakaderanjit53 — Tue, 16 May 2017 03:56:58 GMT

Hi Lech,

As per your suggestion I have been started from 0 - meaning cleared all users, imported all with file and then played/modified and re-imported them again.,and now its working fine.

Re: Import Task for recipient User getting failed

Lech_Miszkiewicz — Tue, 16 May 2017 04:59:39 GMT

great - i am glad i could help - cheers

regards

Lech