Scheduled Bulk Custodian Import Fails with error "[#751000] Error while loading employee import file".

book

Article ID: 100053727

calendar_today

Updated On:

Description

Error Message

From Job Log Report:
08/11/2022 16:49:00 Running the bulk load import job...
08/11/2022 16:49:00 Executing script file: \\localhost\D$\customerScript\bulkImport\download_contacts.pl
08/11/2022 16:49:03 Completed script execution process.
08/11/2022 16:49:03 Loading employees...
08/11/2022 16:49:03 Initializing employee attributes mapping
08/11/2022 16:49:03 Adding 0 custom attributes to employee attribute mapping
08/11/2022 16:49:03 generated output file name D:\CW\V101\scratch\temp\esadb_eDP_App1\dataStore_evidence_repo_aesamjwruu_89341294\Employees-1660250943966.csv
08/11/2022 16:49:03 getting headers
08/11/2022 16:49:03 Returning headers [Wide character in print at \\localhost\D$\customerScript\bulkImport\download_contacts.pl line 12.]
08/11/2022 16:49:03 [#751000] Error while loading employee import file

Cause

The PERL script being executed is using the print function to print data out for eDP import function to collect and encounters a wide character within the data causing perl to display a warning similar to the following prior to the data:
Wide character in print at \\localhost\D$\customerScript\bulkImport\download_contacts.pl line 12.

This then becomes the first line of the created csv file making the file invalid .csv format and therefore cannot be imported.  The first line must contain the column names.  This can be seen by going to the folder where the script is located and the files being created will have file names of bulkImport_.  For example bulkImport08112022_164900.csv.  Open the file and see if similar message of "Wide character in print at \\localhost\D$\customerScript\bulkImport\download_contacts.pl line 12." is on the first line.

Resolution

  1. Modify the PERL script to force ASCII encoding by adding the line binmode STDOUT, ":encoding(ASCII)"; near the top of the PERL script.
  2. Save the script.
  3. Run the scheduled Bulk Custodian Import job again
    Below is an example PERL script with the added line:

    #!C:\PERL\perl\bin\perl.exe
    use strict;
    use warnings;
    use LWP::Simple;

    binmode STDOUT, ":encoding(ASCII)";

    sub main
    {
        my $url = 'http://edp-app1.edp.lab/esa/public/clearwell_import.csv';
        my $data = get($url);
        print $data;
    }

    main();
    exit 0;

Issue/Introduction

The scheduled bulk custodian import job fails with error [#751000] Error while loading employee import file causing new custodians to not be imported into eDP.

Additional Information

JIRA: CFT-4832