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
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 bulkImportWide character in print at \\localhost\D$\customerScript\bulkImport\download_contacts.pl line 12." is on the first line.
binmode STDOUT, ":encoding(ASCII)"; near the top of the PERL script.#!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;
[#751000] Error while loading employee import file causing new custodians to not be imported into eDP.