What is an External ID and why is it important?
An External ID is an employee ID that is given to your employees within your organization.
If you would like to make changes to the information on a current employee (role, team, etc) the system will recognize the user according to their email address.
If not sure if your organization is already using external IDs on Impraise, you can use the Export feature to check.
If your organization is using external IDs then each upload should have them included. If no external IDs are provided on the new user data file, the new users will be assigned an automated Impraise external ID.
To have an external ID changed on Impraise, please contact firstname.lastname@example.org.
What is a CSV file?
In computing, a comma-separated values (CSV) file is a delimited text file that uses a comma to separate values. CSV files store tabular data (numbers and text) in plain text. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format.
Based on the regional settings of the computer you are working on, the values in your CSV might be separated with semicolons (;) instead of commas (,).
Impraise will not process CSVs delimited with semicolons or any delimiters other than commas.
Here is how to check whether your CSV is delimited with commas or other characters
If you are located in Europe, it is likely that the computer you are working on is set to separate values (groupings) using semicolons (;) and decimals with commas (,).
If you are located in the US, most likely the settings state that values (groupings) are separated by commas and decimal numbers - by full stops (.)
To check these settings on a Windows PC:
- click the Windows logo, the bottom left corner;
- go to Settings;
- type “Region” in the search bar and click “Region Settings”;
- in the “Related settings”, click “Additional data, time & regional settings”;
- go to “Region”;
- go to “Additional settings” ;
- look for “Decimal symbol” and “Digit grouping symbol”:
- set “Decimal symbol” to full-stop (.);
- set “Digit grouping symbol” to comma (,)
- click OK
To check these settings on a Mac:
- call Spotlight by holding cmd & pressing the space bar;
- type “Preferences”;
- go to “Language & Region”;
go to “Advanced”;
select comma (,) for Grouping & full-stop (.) for Decimal.