Genesys Cloud CX

 View Only
Discussion Thread View
  • 1.  Exporting a list of Names and Employee ID

    Posted 11 days ago
    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
    ------------------------------


  • 2.  RE: Exporting a list of Names and Employee ID

    Posted 11 days ago
    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.
    ------------------------------



  • 3.  RE: Exporting a list of Names and Employee ID

    Posted 9 days ago
    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.
    ------------------------------



  • 4.  RE: Exporting a list of Names and Employee ID

    Posted 7 days ago
    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.
    ------------------------------



  • 5.  RE: Exporting a list of Names and Employee ID

    Posted 5 days ago
    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.
    ------------------------------



  • 6.  RE: Exporting a list of Names and Employee ID

    Top 25 Contributor
    Posted 6 days ago
    Something like this should do the trick

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

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



  • 7.  RE: Exporting a list of Names and Employee ID

    Posted 5 days ago
    Thank you!  This is exactly what I needed.

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