Solved

Export User Accounts in Apps9

  • 10 February 2021
  • 2 replies
  • 305 views

Userlevel 1
Badge +3

Can you export IFS user accounts using IEE in Apps 9? If not, have you done this using SQL script?

 

I know you can batch-create users based on the imported xml/txt file, but can you export existing accounts to a file?

 

Mateusz Klos
Ahead ERP Consulting Inc.
 

icon

Best answer by Viranga Ruwanpathirana 12 May 2021, 09:00

View original

This topic has been closed for comments

2 replies

Userlevel 5
Badge +11

Hi @mateuszklos,

 

If you are ok to get the list from Oracle user's window, that is possible to export them using output channels. But unfortunately this is not allowed in normal users page.

 

Anyway you can use data migration or standard SQL scripts to export directly from the database tables. For data migration information, refer to our documentation - https://docs.ifs.com/techdocs/Foundation1/040_administration/260_data_management/050_data_migration/default.htm

 

Best Regards.

Userlevel 7
Badge +15

Hi @mateuszklos ,

You can follow the below steps to export the users.
 

  1. Select the Output and then select Custom Export

 

  1. Select the file type you need to generate the output file and then select OK.
  1. You can select either selected rows and all rows as you require.
     



    Hope this helps your resolve your issue :relaxed:

    Best Regards,
    Thanushi