louisphicc
Member
Hello,
I would need some advice on this one.
We have a use case for pricing were the users have a large CSV file containing pricing schedules to map in JDE.
They are currently doing it manually with the P4072 application, navigating between forms and copy-pasting the data.
In Orchestrator, I have managed to create the following pieces of the puzzle:
- a Connexion and a Connector to read the CSV file sitting on a FTP server
- a Form Requests to navigate through the different forms, to add one line of data and to process it
- an Orchestration to link the previous two with an iteration over each lines in the source file.
- another Orchestration that reads the output of the first one and sends an email with the error description (if any) or a success message.
I ran this orchestration for about 5000 lines and it took nearly an hour to process (withour error).
The manual process remains faster, but at least the user can do something else while the Orchestration is running...
I am a little disapointed how slow the Orchestrator is.
Any ideas to make it faster?
I would need some advice on this one.
We have a use case for pricing were the users have a large CSV file containing pricing schedules to map in JDE.
They are currently doing it manually with the P4072 application, navigating between forms and copy-pasting the data.
In Orchestrator, I have managed to create the following pieces of the puzzle:
- a Connexion and a Connector to read the CSV file sitting on a FTP server
- a Form Requests to navigate through the different forms, to add one line of data and to process it
- an Orchestration to link the previous two with an iteration over each lines in the source file.
- another Orchestration that reads the output of the first one and sends an email with the error description (if any) or a success message.
I ran this orchestration for about 5000 lines and it took nearly an hour to process (withour error).
The manual process remains faster, but at least the user can do something else while the Orchestration is running...
I am a little disapointed how slow the Orchestrator is.
Any ideas to make it faster?