Symptom
System throws the error: "IOException happened when importing data from zip." when trying to import data via Live Profile Import job, that runs in the back-end.
Image/Data in this KBA is from SAP internal systems,sample data or demo systems.Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors Employee Profile
Reproducing the Issue
- Set up and run a Live Profile Import job in Provisioning;
- See that it fails with the following error: "IOException happened when importing data from zip.":
Cause
This error can be caused by several reasons, such as:
- There is a subfolder inside the zip file;
- There is no .csv file inside the zip, only attachments;
- The Excel file containing the background data was saved as ".xls" or ".xlsx" format, instead of ".csv";
- The Excel file containing the background data, or one of the attachment files, contains special, non-ASCII characters in the name or content, which is not supported for live profile import.
Resolution
- According to KBA 2218874, no subfolders are allowed in the zip file. So, in order to fix that, please make sure the files (.csv and attachments) are zipped by following the steps below:
- Put the .csv and the attachments together;
- Select them;
- Zip them (the correct option might vary according to system's configuration and available application);
- See the .zip file will be available;
- With no subfolder:
- Put the .csv and the attachments together;
- Please make sure the .csv file that contains the background data is also in the zip file;
- Please make sure the Excel that contains the background data is saved as "Comma delimited": ".csv". No other extensions are allowed;
- Please make sure all attachment files are named with ASCII characters, special characters are not supported for live profile import.
See Also
2218874 - Upload of attachments to Employee Profile - SAP Employee Profile
Keywords
IOException happened when importing data from zip, Error, Message, Issue, Live Profile Import, Attachment, Import, Job, Provisioning, Failed, SFTP, Subfolder , KBA , LOD-SF-EP-JOB , Scheduled jobs , LOD-SF-EP-BGD , Background Elements , Problem
Product
Attachments
Pasted image.png |
Pasted image.png |
Pasted image.png |
Pasted image.png |
Pasted image.png |