SAP Knowledge Base Article - Public

2328644 - Analytics user bulk upload ignores leading zeroes in SF User ID


When uploading users using the Bulk User Load template, leading zeroes (e.g. 0615, 000392572) are lost from the SF User ID and therefore the user does not link with its BizX counterpart.


Excel will not retain leading zeroes in a file if the cell is formatted as a Number.  It chooses this as the default format if a cell contains only digits (and optionally a decimal point).


Highlight the column in the bulk user load template file which contains the leading zeroes, right click and select "Format cells".  Select the Text option.

Afterwards, re-complete the form to ensure the leading zeroes are present, then save the file and upload into Analytics as normal.


ORD, zeros, Online Report Designer , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem


SAP SuccessFactors HCM Core 1605 ; SAP SuccessFactors Workforce Analytics all versions