2414239 - Proxy Import - Bad Column in import file :19

SAP Knowledge Base Article - Public

2414239 - Proxy Import - Bad Column in import file :19

Symptom

We are trying to use the Proxy Import feature.  We've 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

HCM BizX

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 that file

Cause

This issue was caused by the customer having a comma in one of the Tab names.  This caused 2 columns to be created in the template instead of one.

Resolution

One of the tabs defined in the instance had a comma in the name:

"Performance, Career and 360"  Because of that comma, an extra column was created in the template showing as column T " Career and 360",

Go into the 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 check the drop down  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.

Keywords

KBA , bad column , LOD-SF-PLT , Foundational Capabilities & Tools , Problem

Product

SAP SuccessFactors HCM Core 1611