Symptom
- We are trying to use the Proxy Import feature but is not working.
- I have downloaded the blank CSV template as provided on the Import Proxy screen.
- No matter what we provide, we receive and error "Bad column in import file :19"
Environment
SAP SuccessFactors HXM Suite
Reproducing the Issue
- Admin Center
- Proxy Import
- Download blank CSV template
- Enter a proxyID as Column A User ID to be proxied as Column B YES in Column C Save as csv.
- Proxy Import
- Import Proxies using the saved file.
Cause
- This issue was caused by the having a comma in one of the Tab names.
- This caused 2 columns to be created in the template instead of one.
- One of the tabs defined in the instance had a comma in the name:
"Performance, Career and 360" Because of the comma, an extra column was created in the template: "Performance", " Career and 360"
Resolution
- Admin Center
- Company Settings
- Text Replacement and do a global change for "Performance, Career" to Performance Career"
- Log out and log back in a new browser window.
You can verify the change by using the Drop Down Menu on the Home Page and see the name has changed. - Go to Proxy Import and download the template - you will see the columns are now correct.
- Update with file with the desired changes.
Note: The Proxy import file needs to have exactly the same column headers as the template downloaded.
See Also
Keywords
Proxy import, bad column, file, Bad column in import file , KBA , bad column , LOD-SF-PLT-PRX , Proxy , Problem
Product
SAP SuccessFactors HXM Suite all versions