How can I export/ import multiple USER PROFILES in one(1) action.

Let me know if you could fnd a  way to export into one file...

The only way we were able to do it for our current migration was exporting the nodes and values from the database. Then write a script to import them….probably want to break it up into manageable chunks.

Thank you for your response. 

At the end, ….. I did it one-by-one 🙁.

Regards,

Bram.

It doesn't help you, ​@BvT, I know, but IFS25R1 has the same issue.

As far as I know it’s locked in core code and it can be unlocked after what you are able to export multiple user profiles at once. Of course it creates dedicated file per profile but at least export is easy because importing must be done precisely user by user :(

Exporting can be done using this Quick Report SQL statement:

select * FROM CLIENT_PROFILE_NODE_FULL

You can import this using Excel to manipulate the export making it into an xml, but I don’t think it imports at a user level, you can import sections into users profiles (eg. bookmarks and table view layouts) which I have been successful at doing.

I have the instructions on how to do this, but they are a bit long. Essentially, you create an xml table, but don’t include these fields: state, OBJ_VERSION, PROFILE_ID, PROFILE_NAME and OWNER as elements.

I was able to write a script to export and import profiles in bulk from the back end. In a nutshell, I called client_profile_handling_svc.do_export_profile_action to generate the profile nodes, then client_profile_node_api.generate_xml_data_for_node to get a blob. From there, you have a couple of options, but I converted it to a clob and wrote it to an xml file with dbms_xslprocessor.clob2file. To import, I did the reverse and read the file into an xmltype and passed that to client_profile_node_api.import_xml_data.