Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Bulk Import Users - One Row from Many Rows?
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Bulk Import Users - One Row from Many Rows?
 Login/Join
 
Member
posted
We are in the middle of upgrading from WF8105 (AIX with Oracle DB) to WF8206 (LINUX with Oracle DB) and I want to bulk load my users from 8105 to the 8206 environment. I can get the data I need from the UOA tables but I need all of the different security groups listed in one comma separated row, the bulk loader function only takes one row per user, rejecting subsequent rows with the same ID. I initially thought I could do this using a combination of SUM and ACROSS but I'm not getting the results like the bulk load tool needs.

Would anyone be able to provide a suggestion on how to accomplish this? Someone else has to have run into this already....

Thanks in advance,
Mike
WF 8.1.05 AIX Oracle

This message has been edited. Last edited by: FP Mod Chuck,


Currently WebFocus 8.1.05

 
Posts: 12 | Registered: October 03, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Mike

In the installation guide starting on Page 78 there are step by step instructions to accomplish the upgrade from 8.1.05 to 8.2.06 and it all begins during the actual installation of the product.

If you have questions the best way to get help is to contact your TAM (Technical Account Manager) or techsupport by opening a case.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1664 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Thanks for your reply Chuck, yes we did that and it worked very well for us in our initial 8206 "staging" environment. We also put up a vanilla version, new 8206 install on a new Linux machine. We need to do a phased implementation due to varied needs of our customers. We can CM our groups to the new vanilla 8206 "Dev" machine as needed and wanted to be able to move select groups of users to this machine via the import users in security center, hence the question. Thanks!


Currently WebFocus 8.1.05

 
Posts: 12 | Registered: October 03, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Mike

Gotcha... I have not used this feature but I found two things that may help you.

https://webfocusinfocenter.inf...topics3/02_users.htm

And a case that was open regarding this as well.

https://techsupport.informatio...track/170518074.html


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1664 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Chuck,

Thanks for taking the time and effort to reply once again! I had been using the information in the first link previously to successfully import users. That's the info I was using to get started on this effort. It is very helpful information.

I've gotten the tool to add a user and one group/role; working on getting all of the groups/roles into one string has been the trick.

The second link was a 404 not found for me (?).

Have a great day!
Mike


Currently WebFocus 8.1.05

 
Posts: 12 | Registered: October 03, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
This is what was in that case.

View the current version of active cases.
Status and Action Code Reference

Case History
Case ID: 170518074
Summary: Doc En : WF8201M : security : File layout for 8.2 import users new feature questions
Case Information

Internal Only information appears with a red background.

Account Information
Customer: Hall, David
Title: Project leader
Company: Information Builders Inc
Mobile:
Contact Method: eMail
Customer Rank:


Site: 9999.10 All-in-One Customer Snapshot
Site Company: Information Builders Inc
Address: 2 Penn Plaza New York NY United States 10121-2898
Phone: (212) 330-1775
Email: david_hall@ibi.com
Customer Label:

Case Information
Case Owner: Teatro, Renee
Opened: May 18, 2017
Current Update: March 26, 2019
Status: Closed/Fixed by Programming
Product Group: Client (Architecture/Config)
Major Release: 82
OS Platform: Windows

Initial Group: Premium
Group: Premium
Severity: 3 - Application Issue
Product Area: Client Security
Product Version: 8201M
Site Maintenance
Site OS: ALL
Installed: January 1, 1991
Maintenance: Active Standard

OS Name: Multi-platform - for channels and subs
Renewal Date: December 31, 2999
Project Status
MED Project:
BI Issue: TCM-3509

iWay Issue:
Research Notes
Explanation
WebFOCUS Security I am working with several users who are asking questions about the new 8.2 feature to upload users. The 8.2 new features document states: New Users Bulk Load You can now import a .csv file to create new WebFOCUS users in bulk. This can be quicker and more efficient than individually creating multiple users with the New User dialog box from the Security Center. 170518074_1.png This opens the Import Users dialog box, where you can browse to locate the.csv file containing multiple users. 82snf.pdf attached. An example of the csv file is provided in the retail_Samles CM package Note the following: 170518074_2.png The contents look like: 170518074_3.png The security and admin manual has the layout as follows (page 317) The import file must contain the following columns: user name, password, description, email address, user status, and groups, The questions I have are the following: 1) Are the fields all necessary (for example if you do not want to put in a password, do you leave it blank or with two commas) It appears the password is plain text. Would an encrypted password from the UOA_Users table work? This example of 7 users has two groups on one line 2) Are there any rules like one user per line, Or can one have one line for each group So could you enter a list of users in one group then later include users for another group. Will the repeated users be overwritten or will the 2nd group just be added. This information is lacking in the new features guide 3) Are users the only thing that are added. If there is a group membership to a group that does not yet exist, does the group get create, or is it just passed over
Reproduction
IRNing per Product Division (BMN) and ASM (DRH) comments below: ASM (DRH) talked to the Product Division (BMN) He thinks there needs to be a JIRA to note that the document information on the layout is missing. It is not found anywhere. He was not aware of that.
Workaround
na
Case Notes
By: Hall, David
Severity: 3 - Application Issue
Type: General Comments

Date: Thursday, May 18 2017
Status: Open / Unassigned
Published: Y

Time: 04:22 PM
Support Group: Premium


I am working with several users who are asking questions about the new 8.2 feature to upload users

the 8.2 new features document states:



This is also available in the PDF.

An example of the csv file is provided in the retail_Samles CM package

Note the following:





The contents look like:



I have uploaded a copy of the file to this case.

The security and admin manual has the layout as follows (page 317)



The import file must contain the following columns: user name, password, description, email address, user status, and groups,



The questions I have are the following:



Are the fields all necessary (for example if you do not want to put in a password, do you leave it blank or with two commas)

It appears the password is plain text. Would an encrypted password from the UOA_Users table work?

This example of 7 users has two groups on one line

Are there any rules like one user per line,

Or can one have one line for each group

So could you enter a list of users in one group

then later include users for another group. Will the repeated users be overwritten or will the 2nd group just be added.

This information is lacking in the new features guide

Are users the only thing that are added. If there is a group membership to a group that does not yet exist, does the group get create, or is it just passed over















By: Muller, Fred
Severity: 3 - Application Issue
Type: General Comments

Date: Thursday, May 18 2017
Status: Research / General Research Required
Published: N

Time: 04:56 PM
Support Group: Premium


Pulling into my queue.

By: Muller, Fred
Severity: 3 - Application Issue
Type: General Comments

Date: Thursday, May 18 2017
Status: Research / General Research Required
Published: N

Time: 05:17 PM
Support Group: Premium


INTERNAL: Email sent to the Product Division (BMN).

By: Muller, Fred
Severity: 3 - Application Issue
Type: General Comments

Date: Wednesday, May 24 2017
Status: Research / General Research Required
Published: Y

Time: 03:04 PM
Support Group: Premium


Update:

Hi David,

Below are the Product Division responses:

1) Are the fields all necessary (for example if you do not want to put in a password, do you leave it blank or with two
commas)
It appears the password is plain text. Would an encrypted password from the UOA_Users table work?
This example of 7 users has two groups on one line

Response:
Not sure what they are asking. The password in this file is clear text, that is true.
When inserted in to the DB, it is hashed.
If you are using External Authentication, the password does not matter, and yes
you can put in a blank.

2) Are there any rules like one user per line,
Or can one have one line for each group
So could you enter a list of users in one group
then later include users for another group. Will the repeated users be overwritten or will the 2nd group just be added.
This information is lacking in the new features guide

Response:
Need to read the entire feature, page 317 of attached.

3) Are users the only thing that are added. If there is a group membership to a group that does not yet exist,
does the group get create, or is it just passed over

Response:
This one is for you to try to see what happens if the group does not exist.

Please let me know.

Thanks, Fred.

Status:
RR

By: Hall, David
Severity: 3 - Application Issue
Type: General Comments

Date: Wednesday, May 24 2017
Status: Research / General Research Required
Published: Y

Time: 04:38 PM
Support Group: Premium


Was there supposed to be an uploaded file

Page 317 of what manual?

THe security manual?



By: Muller, Fred
Severity: 3 - Application Issue
Type: General Comments

Date: Wednesday, May 24 2017
Status: Research / General Research Required
Published: Y

Time: 07:19 PM
Support Group: Premium


Attached.

By: Muller, Fred
Severity: 3 - Application Issue
Type: General Comments

Date: Tuesday, May 30 2017
Status: Research / General Research Required
Published: N

Time: 06:08 PM
Support Group: Premium


Update:
See comments below.
Status:
RR



By: Muller, Fred
Severity: 3 - Application Issue
Type: General Comments

Date: Friday, June 2 2017
Status: Research / General Research Required
Published: N

Time: 06:58 PM
Support Group: Premium


Update:
See comments below.
Status:
RR

By: Muller, Fred
Severity: 3 - Application Issue
Type: General Comments

Date: Thursday, June 8 2017
Status: Customer Researching / Customer to Test
Published: N

Time: 02:38 PM
Support Group: Premium


Update:
See comments below.
Status:
CT

By: Muller, Fred
Severity: 3 - Application Issue
Type: General Comments

Date: Thursday, June 15 2017
Status: Customer Researching / Customer to Test
Published: Y

Time: 03:29 PM
Support Group: Premium


Update:

Hi David,

I am just following up on this issue. Please let me know if there is
anything else needed or if the case can be closed.

Thanks, Fred.

Status:
CT

By: Hall, David
Severity: 3 - Application Issue
Type: Email

Date: Thursday, June 15 2017
Status: Research / General Research Required
Published: Y

Time: 04:30 PM
Support Group: Premium

cc: "Muller, Fred"
I talked to Ben Naphtali at Summit.
He thinks there needs to be a JIRA to note that the document information on the layout is missing.
It is not found anywhere.
He was not aware of that.
Can we generate a JIRA for a doc enhancement?
David Hall | Premium Account Support Manager| InfoResponse Premium Support Services | Information Builders, Inc.
Office: 212-330-1775 |Mobile 850-445-0141| email: David_Hall@ibi.com | Customer Support Hotline 800.736.6130
By: Muller, Fred
Severity: 3 - Application Issue
Type: General Comments

Date: Thursday, June 15 2017
Status: Research / General Research Required
Published: N

Time: 06:09 PM
Support Group: Premium


IRNing.

By: Service, IR Live
Severity: 3 - Application Issue
Type: N/A

Date: Thursday, June 15 2017
Status: Research / General Research Required
Published: N

Time: 06:14 PM
Support Group: Premium



Hottrack created TCM-3509:
-----------------------------

Summary: Doc En : WF8201M : security : File layout for 8.2 imp=
ort users new feature questions
Key: TCM-3509
URL: http://bipgjira:8080/browse/TCM-3509
Project: Technical Content Management
Issue Type: Story
Components: Release PDF
Reporter: Muller, Fred
Assignee: Naphtali, Ben
By: Service, IR Live
Severity: 3 - Application Issue
Type: N/A

Date: Thursday, June 15 2017
Status: Research / General Research Required
Published: N

Time: 06:18 PM
Support Group: Premium



Muller, Fred updated TCM-3509:
------------------------------

Attachment: 170518074_1.png
170518074_2.png
170518074_3.png
retail_samples_users.csv
By: Service, IR Live
Severity: 3 - Application Issue
Type: N/A

Date: Friday, June 16 2017
Status: Research / General Research Required
Published: N

Time: 09:59 AM
Support Group: Premium



Naphtali, Ben updated TCM-3509:
-------------------------------

Content Type: Impacts Technical Content (was: Not Yet Identified)
Publish: Yes (was: Not Set)
By: Service, IR Live
Severity: 3 - Application Issue
Type: N/A

Date: Friday, June 16 2017
Status: Research / General Research Required
Published: N

Time: 09:59 AM
Support Group: Premium



Naphtali, Ben updated TCM-3509:
-------------------------------

Content Release Target: 8202
By: Service, IR Live
Severity: 3 - Application Issue
Type: N/A

Date: Friday, June 16 2017
Status: Research / General Research Required
Published: N

Time: 09:59 AM
Support Group: Premium



Naphtali, Ben updated TCM-3509:
-------------------------------

Assignee: Galloway, Robert (was: Naphtali, Ben)
By: Service, IR Live
Severity: 3 - Application Issue
Type: N/A

Date: Friday, June 16 2017
Status: Research / General Research Required
Published: N

Time: 06:28 PM
Support Group: Premium



Galloway, Robert reassigned TCM-3509:
-------------------------------------

Assignee: Naphtali, Ben (was: Galloway, Robert)
By: Service, IR Live
Severity: 3 - Application Issue
Type: N/A

Date: Monday, June 19 2017
Status: Research / General Research Required
Published: N

Time: 10:19 AM
Support Group: Premium



Naphtali, Ben reassigned TCM-3509:
----------------------------------

Assignee: Galloway, Robert (was: Naphtali, Ben)

Confirmed.
By: Service, IR Live
Severity: 3 - Application Issue
Type: N/A

Date: Monday, June 19 2017
Status: Research / General Research Required
Published: N

Time: 01:07 PM
Support Group: Premium



Galloway, Robert updated TCM-3509:
----------------------------------

Labels: SECADMIN (was: )
By: Muller, Fred
Severity: 3 - Application Issue
Type: General Comments

Date: Thursday, June 22 2017
Status: Product Division / In Product Management
Published: N

Time: 11:39 AM
Support Group: Premium


FTPM

By: Service, IR Live
Severity: 3 - Application Issue
Type: N/A

Date: Tuesday, June 27 2017
Status: Product Division / In Product Management
Published: N

Time: 04:42 PM
Support Group: Premium



Galloway, Robert updated TCM-3509:
----------------------------------

Sprint: TCM Release Content Sprint 32
By: Service, IR Live
Severity: 3 - Application Issue
Type: N/A

Date: Tuesday, June 27 2017
Status: Product Division / In Product Management
Published: N

Time: 04:42 PM
Support Group: Premium



Work on TCM-3509 started by Galloway, Robert.
By: Service, IR Live
Severity: 3 - Application Issue
Type: N/A

Date: Tuesday, June 27 2017
Status: Product Division / In Product Management
Published: N

Time: 07:41 PM
Support Group: Premium



Galloway, Robert updated TCM-3509:
----------------------------------

Attachment: TCM-3509_wfsec.pdf
By: Service, IR Live
Severity: 3 - Application Issue
Type: N/A

Date: Tuesday, June 27 2017
Status: Product Division / In Product Management
Published: N

Time: 07:43 PM
Support Group: Premium



Galloway, Robert updated TCM-3509:
----------------------------------

Attachment: TCM-3509_wfsec.pdf
By: Service, IR Live
Severity: 3 - Application Issue
Type: N/A

Date: Tuesday, June 27 2017
Status: Product Division / In Product Management
Published: N

Time: 07:43 PM
Support Group: Premium



Galloway, Robert updated TCM-3509:
----------------------------------

Attachment: (was: TCM-3509_wfsec.pdf)
By: Service, IR Live
Severity: 3 - Application Issue
Type: N/A

Date: Tuesday, June 27 2017
Status: Product Division / In Product Management
Published: N

Time: 07:43 PM
Support Group: Premium



Galloway, Robert reassigned TCM-3509:
-------------------------------------

Assignee: Naphtali, Ben (was: Galloway, Robert)
By: Service, IR Live
Severity: 3 - Application Issue
Type: N/A

Date: Wednesday, June 28 2017
Status: Product Division / In Product Management
Published: N

Time: 11:44 AM
Support Group: Premium



Naphtali, Ben reassigned TCM-3509:
----------------------------------

Assignee: Galloway, Robert (was: Naphtali, Ben)

Page 325 examples have a few issues.
1) the first one, uses a username of testgrp, and an e-mail of testadv@doma=
in.com
This example should be better example

The second example needs to have double quotes around Getting Started Basic=
User
But again, this example can also be improved upon as far as the name and de=
scription.

As an example, but see if you have better ideas.
adv1,pass1,=E2=80=B3Getting Started, Advanced 1=E2=80=B3,adv1@domain.com,AC=
TIVE,Getting_Started/AdvancedUsers
By: Service, IR Live
Severity: 3 - Application Issue
Type: N/A

Date: Friday, June 30 2017
Status: Product Division / In Product Management
Published: N

Time: 01


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1664 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Thanks to help from my IBI Site Tech Rep, Rich Desrosiers, I was able to use Restful services to obtain this information in the format I needed. Much appreciated Rich, you rock!


Currently WebFocus 8.1.05

 
Posts: 12 | Registered: October 03, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Bulk Import Users - One Row from Many Rows?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.