Hi All

Does anyone know if there is an easy way to export a list of total users along with their Employee ID (from Personal Details Tab under HR)

Many Thanks in Advance
#Reporting/Analytics

------------------------------
steve thompson
FIL Fund Services (Bermuda) Limited
------------------------------

Steve,
I am using the Genesys CLI (gv.exe, from windows, please see "https://developer.genesys.cloud/blog/2021-06-01-cli-with-powershell/" for tool description)

for getting the "user list" in the CSV format, I am using the command: 
(gc.exe users list -i --pageSize 5000 -a --expand="authorization" | ConvertFrom-Json) | Select-Object name,id,state,acdAutoAnswer,department,email,division | ConvertTo-CSV >.\list.csv
from MS PowerShell

------------------------------
Best regards,

Yvgeni Liberman
ITNAV-Pro Ltd.
------------------------------

Original Message:
Sent: 06-14-2022 07:32
From: steve thompson
Subject: Exporting a list of Names and Employee ID

Hi All

Does anyone know if there is an easy way to export a list of total users along with their Employee ID (from Personal Details Tab under HR)

Many Thanks in Advance
#Reporting/Analytics

------------------------------
steve thompson
FIL Fund Services (Bermuda) Limited
------------------------------

Thank you for posting this.  We have been struggling to get this data out of Genesys as well.  The only way I could do it was using the API's but I had to run the API's multiple times because of the record limits so this is a huge help.  

I do have one more question if you are able to help.  I need to pull the agents employeeId when I pull the list of users.  I was able to update your command to get the info, but it pulls in other fields as well and really all I want is the employeeID.  Is it possible to pull just a sub-item and not the whole object?  

This is the command I used: 
(gc.exe users list -i --pageSize 5000 -a --expand="employerInfo" | ConvertFrom-Json) | Select-Object name,id,state,acdAutoAnswer,department,email,employerInfo | ConvertTo-CSV >.\list1.csv

That pulls back anything in the employerInfo object.  I just want the employeeId field listed under employerInfo.  

Thanks!

------------------------------
Jason Lorden
Independent Health Association, Inc.
------------------------------

Original Message:
Sent: 06-15-2022 02:27
From: Yvgeni Liberman
Subject: Exporting a list of Names and Employee ID

Steve,
I am using the Genesys CLI (gv.exe, from windows, please see "https://developer.genesys.cloud/blog/2021-06-01-cli-with-powershell/" for tool description)

for getting the "user list" in the CSV format, I am using the command:
(gc.exe users list -i --pageSize 5000 -a --expand="authorization" | ConvertFrom-Json) | Select-Object name,id,state,acdAutoAnswer,department,email,division | ConvertTo-CSV >.\list.csv
from MS PowerShell

------------------------------
Best regards,

Yvgeni Liberman
ITNAV-Pro Ltd.

Original Message:
Sent: 06-14-2022 07:32
From: steve thompson
Subject: Exporting a list of Names and Employee ID

Hi All

Does anyone know if there is an easy way to export a list of total users along with their Employee ID (from Personal Details Tab under HR)

Many Thanks in Advance
#Reporting/Analytics

------------------------------
steve thompson
FIL Fund Services (Bermuda) Limited
------------------------------

Hello Jason,
I am not sure that I understand Your question.
You are getting the CSV file that You can "import" to the Excel and/or any DB, after this, You can do any manipulations that You want.

------------------------------
Best regards,

Yvgeni Liberman
ITNAV-Pro Ltd.
------------------------------

Original Message:
Sent: 06-16-2022 09:29
From: Jason Lorden
Subject: Exporting a list of Names and Employee ID

Thank you for posting this.  We have been struggling to get this data out of Genesys as well.  The only way I could do it was using the API's but I had to run the API's multiple times because of the record limits so this is a huge help.

I do have one more question if you are able to help.  I need to pull the agents employeeId when I pull the list of users.  I was able to update your command to get the info, but it pulls in other fields as well and really all I want is the employeeID.  Is it possible to pull just a sub-item and not the whole object?

This is the command I used:
(gc.exe users list -i --pageSize 5000 -a --expand="employerInfo" | ConvertFrom-Json) | Select-Object name,id,state,acdAutoAnswer,department,email,employerInfo | ConvertTo-CSV >.\list1.csv

That pulls back anything in the employerInfo object.  I just want the employeeId field listed under employerInfo.

Thanks!

------------------------------
Jason Lorden
Independent Health Association, Inc.

Original Message:
Sent: 06-15-2022 02:27
From: Yvgeni Liberman
Subject: Exporting a list of Names and Employee ID

Steve,
I am using the Genesys CLI (gv.exe, from windows, please see "https://developer.genesys.cloud/blog/2021-06-01-cli-with-powershell/" for tool description)

for getting the "user list" in the CSV format, I am using the command:
(gc.exe users list -i --pageSize 5000 -a --expand="authorization" | ConvertFrom-Json) | Select-Object name,id,state,acdAutoAnswer,department,email,division | ConvertTo-CSV >.\list.csv
from MS PowerShell

------------------------------
Best regards,

Yvgeni Liberman
ITNAV-Pro Ltd.

Original Message:
Sent: 06-14-2022 07:32
From: steve thompson
Subject: Exporting a list of Names and Employee ID

Hi All

Does anyone know if there is an easy way to export a list of total users along with their Employee ID (from Personal Details Tab under HR)

Many Thanks in Advance
#Reporting/Analytics

------------------------------
steve thompson
FIL Fund Services (Bermuda) Limited
------------------------------

Hi Yvgeni, 

I was looking to just pull a single value from the employerInfo section and not have to manually manipulate the data after the export.  What Anton posted is what I was looking for.  

Thanks again!

------------------------------
Jason Lorden
Independent Health Association, Inc.
------------------------------

Original Message:
Sent: 06-19-2022 02:19
From: Yvgeni Liberman
Subject: Exporting a list of Names and Employee ID

Hello Jason,
I am not sure that I understand Your question.
You are getting the CSV file that You can "import" to the Excel and/or any DB, after this, You can do any manipulations that You want.

------------------------------
Best regards,

Yvgeni Liberman
ITNAV-Pro Ltd.

Original Message:
Sent: 06-16-2022 09:29
From: Jason Lorden
Subject: Exporting a list of Names and Employee ID

Thank you for posting this.  We have been struggling to get this data out of Genesys as well.  The only way I could do it was using the API's but I had to run the API's multiple times because of the record limits so this is a huge help.

I do have one more question if you are able to help.  I need to pull the agents employeeId when I pull the list of users.  I was able to update your command to get the info, but it pulls in other fields as well and really all I want is the employeeID.  Is it possible to pull just a sub-item and not the whole object?

This is the command I used:
(gc.exe users list -i --pageSize 5000 -a --expand="employerInfo" | ConvertFrom-Json) | Select-Object name,id,state,acdAutoAnswer,department,email,employerInfo | ConvertTo-CSV >.\list1.csv

That pulls back anything in the employerInfo object.  I just want the employeeId field listed under employerInfo.

Thanks!

------------------------------
Jason Lorden
Independent Health Association, Inc.

Original Message:
Sent: 06-15-2022 02:27
From: Yvgeni Liberman
Subject: Exporting a list of Names and Employee ID

Steve,
I am using the Genesys CLI (gv.exe, from windows, please see "https://developer.genesys.cloud/blog/2021-06-01-cli-with-powershell/" for tool description)

for getting the "user list" in the CSV format, I am using the command:
(gc.exe users list -i --pageSize 5000 -a --expand="authorization" | ConvertFrom-Json) | Select-Object name,id,state,acdAutoAnswer,department,email,division | ConvertTo-CSV >.\list.csv
from MS PowerShell

------------------------------
Best regards,

Yvgeni Liberman
ITNAV-Pro Ltd.

Original Message:
Sent: 06-14-2022 07:32
From: steve thompson
Subject: Exporting a list of Names and Employee ID

Hi All

Does anyone know if there is an easy way to export a list of total users along with their Employee ID (from Personal Details Tab under HR)

Many Thanks in Advance
#Reporting/Analytics

------------------------------
steve thompson
FIL Fund Services (Bermuda) Limited
------------------------------

Something like this should do the trick

(gc.exe users list -a --expand="employerInfo" | ConvertFrom-Json) | Select-Object {$_.employerInfo.employeeId}

------------------------------
Anton Vroon
------------------------------

Original Message:
Sent: 06-16-2022 09:29
From: Jason Lorden
Subject: Exporting a list of Names and Employee ID

Thank you for posting this.  We have been struggling to get this data out of Genesys as well.  The only way I could do it was using the API's but I had to run the API's multiple times because of the record limits so this is a huge help.

I do have one more question if you are able to help.  I need to pull the agents employeeId when I pull the list of users.  I was able to update your command to get the info, but it pulls in other fields as well and really all I want is the employeeID.  Is it possible to pull just a sub-item and not the whole object?

This is the command I used:
(gc.exe users list -i --pageSize 5000 -a --expand="employerInfo" | ConvertFrom-Json) | Select-Object name,id,state,acdAutoAnswer,department,email,employerInfo | ConvertTo-CSV >.\list1.csv

That pulls back anything in the employerInfo object.  I just want the employeeId field listed under employerInfo.

Thanks!

------------------------------
Jason Lorden
Independent Health Association, Inc.

Original Message:
Sent: 06-15-2022 02:27
From: Yvgeni Liberman
Subject: Exporting a list of Names and Employee ID

Steve,
I am using the Genesys CLI (gv.exe, from windows, please see "https://developer.genesys.cloud/blog/2021-06-01-cli-with-powershell/" for tool description)

for getting the "user list" in the CSV format, I am using the command:
(gc.exe users list -i --pageSize 5000 -a --expand="authorization" | ConvertFrom-Json) | Select-Object name,id,state,acdAutoAnswer,department,email,division | ConvertTo-CSV >.\list.csv
from MS PowerShell

------------------------------
Best regards,

Yvgeni Liberman
ITNAV-Pro Ltd.

Original Message:
Sent: 06-14-2022 07:32
From: steve thompson
Subject: Exporting a list of Names and Employee ID

Hi All

Does anyone know if there is an easy way to export a list of total users along with their Employee ID (from Personal Details Tab under HR)

Many Thanks in Advance
#Reporting/Analytics

------------------------------
steve thompson
FIL Fund Services (Bermuda) Limited
------------------------------

Thank you!  This is exactly what I needed.

------------------------------
Jason Lorden
Independent Health Association, Inc.
------------------------------

Original Message:
Sent: 06-19-2022 17:31
From: Anton Vroon
Subject: Exporting a list of Names and Employee ID

Something like this should do the trick

(gc.exe users list -a --expand="employerInfo" | ConvertFrom-Json) | Select-Object {$_.employerInfo.employeeId}

------------------------------
Anton Vroon

Original Message:
Sent: 06-16-2022 09:29
From: Jason Lorden
Subject: Exporting a list of Names and Employee ID

Thank you for posting this.  We have been struggling to get this data out of Genesys as well.  The only way I could do it was using the API's but I had to run the API's multiple times because of the record limits so this is a huge help.

I do have one more question if you are able to help.  I need to pull the agents employeeId when I pull the list of users.  I was able to update your command to get the info, but it pulls in other fields as well and really all I want is the employeeID.  Is it possible to pull just a sub-item and not the whole object?

This is the command I used:
(gc.exe users list -i --pageSize 5000 -a --expand="employerInfo" | ConvertFrom-Json) | Select-Object name,id,state,acdAutoAnswer,department,email,employerInfo | ConvertTo-CSV >.\list1.csv

That pulls back anything in the employerInfo object.  I just want the employeeId field listed under employerInfo.

Thanks!

------------------------------
Jason Lorden
Independent Health Association, Inc.

Original Message:
Sent: 06-15-2022 02:27
From: Yvgeni Liberman
Subject: Exporting a list of Names and Employee ID

Steve,
I am using the Genesys CLI (gv.exe, from windows, please see "https://developer.genesys.cloud/blog/2021-06-01-cli-with-powershell/" for tool description)

for getting the "user list" in the CSV format, I am using the command:
(gc.exe users list -i --pageSize 5000 -a --expand="authorization" | ConvertFrom-Json) | Select-Object name,id,state,acdAutoAnswer,department,email,division | ConvertTo-CSV >.\list.csv
from MS PowerShell

------------------------------
Best regards,

Yvgeni Liberman
ITNAV-Pro Ltd.

Original Message:
Sent: 06-14-2022 07:32
From: steve thompson
Subject: Exporting a list of Names and Employee ID

Hi All

Does anyone know if there is an easy way to export a list of total users along with their Employee ID (from Personal Details Tab under HR)

Many Thanks in Advance
#Reporting/Analytics

------------------------------
steve thompson
FIL Fund Services (Bermuda) Limited
------------------------------