csvImport
This operation unzips artifact from csvExport, start import process for all Setup Task CSV Packages to target environment, and waits for completion. The csvImport operation can only be used with a FlexDeploy partial deployment project of type Oracle SaaS FSM.
Artifact contains zero or more zipped Setup Task CSV packages.
Environment/Instance Properties
Property Name | Property Code | Required | Description |
---|---|---|---|
Oracle SaaS FSM Account | FDFSM_CLOUD_ACCOUNT_CODE | No* | Oracle SaaS FSM Account will be required on either the plugin input or environment instance. If a value is set on both then, the plugin input will take precedence. See Special Considerations below for instructions on how to create Oracle SaaS FSM account. |
Oracle SaaS FSM ChromeDriver Path | FDFSM_CHROME_DRIVER_PATH | No* | @since 5.7.0.13 Location of the chromedriver executable. I.E. /usr/local/bin/chromedriver or C:/Users/user/Documents/chromedriver.exe. This is required if See Special Considerations below for instructions on how to download install google chrome and download chromedriver. |
Project Properties
Property Name | Property Code | Required | Description |
---|---|---|---|
Inputs
Input Name | Input Code | Required | Description |
---|---|---|---|
Oracle SaaS FSM Account | FDFSM_INP_CLOUD_ACCOUNT_CODE | No* | Oracle SaaS FSM Account will be required on either the plugin input or environment instance. If a value is set on both then, the plugin input will take precedence. See Special Considerations below for instructions on how to create Oracle SaaS FSM account. |
API Timeout | FDFSM_INP_TIMEOUT | No | Maximum amount of time (seconds) to wait for import process to complete after it is started. Defaults to 900 seconds (15 minutes). |
Compile Fast Formulas | FDFSM_INP_COMPILE_FORMULAS | No | @since 5.7.0.13 Enable compile fast formula after successful import. Applicable to packages containing one more fast formulas. Defaults to true. See special considerations section for additional Chrome browser dependency. |
Compile Formula UI Timeout | FDFSM_INP_COMPILE_FORMULAS_UI_TIMEOUT | No | @since 5.7.0.13 Maximum amount of time (seconds) to wait for Compile Formula payroll flow to complete. Defaults to 300 seconds (5 minutes). |
Save Import Result File | FDFSM_INP_SAVE_IMPORT_RESULT_FILE | No | Saves a comparison result file to the reports directory as a JSON file. The JSON file provides a summary of the comparison process and represents the table shown in the Comparison Details section of the user interface. |
Save Import Report File | FDFSM_INP_SAVE_IMPORT_REPORT_FILE | No | Saves a comparison report file to the reports directory as a Excel file. The excel file provides comparison reports for each of the business objects that were processed. For each business object, a report each for Only in Configuration 1, In Both With Mismatch, and Only In Configuration 2, as applicable is provided. |
Save Import Summary Report File | FDFSM_INP_SAVE_IMPORT_SUMMARY_REPORT_FILE | No | Saves a comparison report file to the reports directory as a Excel file. The excel file provides a summary of the process results, which displays a list of all the processed business objects, and whether their processing completed successfully, or with errors. |
Outputs
Output Name | Description |
---|---|
Artifacts
This operation produces artifacts that will be stored in the artifacts repository.
Endpoint Selection
This operation will select all available endpoints associated to the environment/instance.
Endpoint Execution
This operation will execute on any one of the selected endpoints and will be random in the determination of which one.
Special Considerations
Oracle SaaS FSM Account*
Before using this plugin operation, navigate to Topology → Integrations → Cloud, then create an account with provider OracleFSM for each one of your SaaS environments. This account will store the URL and credentials to make HTTPS requests to your SaaS environment. The account will be reusable by all Oracle SaaS FSM Plugin operations. All fields shown are required.
Compile Fast Formulas - Chrome Browser Dependency
If FDFSM_INP_COMPILE_FORMULAS
is enabled, then FlexDeploy will attempt to compile each fast formula in your package. FlexDeploy implements a double try mechanism for formula compilation. The first try will make use of the Oracle API’s, but the 2nd attempt utilizes the Chrome browser to compile from the Oracle SaaS UI. In the latter case Google Chrome must be installed on the endpoint. If the endpoint is localhost then, Chrome and chromedriver should be installed on the FlexDeploy server. See the below for detailed instructions to install Google Chrome in an Unix environment. Windows install is not covered in the following.
Google Chrome Install
// (Option 1) With yum for RedHat-based Linux Distributions i.e. AlmaLinux, CentOS, Fedora, RedHat, Rocky Linux yum -y install google-chrome-stable_current_x86_64.rpm // If you get cannot open rpm error (Can not load RPM file: google-chrome-stable_current_x86_64.rpm) you can instead just download the rpm itself and then install with the file wget https://dl.google.com/linux/direct/google-chrome-stable_current_x86_64.rpm yum install ./google-chrome-stable_current_*.rpm // If you run into errors you may need to clear the yum cache or update yum yum clean all rm -r /var/cache/yum yum -y update // If you get error like 'Invalid configuration value: failovermethod=priority in /etc/yum.repos.d/nodesource-el8.repo; Configuration: OptionBinding with id "failovermethod" does not exist' // Go to /etc/yum.repos.d/nodesource-el8.repo and comment out the 'failovermethod' entries cat /etc/yum.repos.d/nodesource-el8.repo [nodesource] name=Node.js Packages for Enterprise Linux 8 - $basearch baseurl=https://rpm.nodesource.com/pub_14.x/el/8/$basearch #failovermethod=priority enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/NODESOURCE-GPG-SIGNING-KEY-EL [nodesource-source] name=Node.js for Enterprise Linux 8 - $basearch - Source baseurl=https://rpm.nodesource.com/pub_14.x/el/8/SRPMS #failovermethod=priority enabled=0 gpgkey=file:///etc/pki/rpm-gpg/NODESOURCE-GPG-SIGNING-KEY-EL gpgcheck=1 // (Option 2) With dpkg wget https://dl.google.com/linux/direct/google-chrome-stable_current_amd64.deb sudo dpkg -i google-chrome-stable_current_amd64.deb
Test Google Chrome installation
google-chrome &
Chromedriver Install
Download the chromedriver from ChromeDriver - WebDriver for Chrome - Downloads which is supported for the google chrome version installed on your endpoint. Linux, mac, and windows binaries are available. Where you store the chromedriver executable should be set on target property Oracle SaaS FSM ChromeDriver Path.
wget https://chromedriver.storage.googleapis.com/107.0.5304.62/chromedriver_linux64.zip unzip chromedriver_linux64.zip // Suggest moving the chromedriver somewhere like /usr/local/bin // mv chromedriver /usr/local/bin
- style