If you want to remove data from a field you can enter <Blank> instead of data. The import will blank the data out of the specified field for you. If you just leave the field blank, the import will skip that field and not change the data that exists in that field.
If you try to import data into a text field and that data is longer than what the text field can accept, your data will be imported but the excess data will be truncated. For example, the Number/Address field is limited to 200 characters. If you try to import text that exceeds 200 characters, the excess characters will get cut off.
The import logic for the Creation of a New Location Type requires that no Contact Information exists for the Location Type and Contact Type specified, if the specified Location Type and Contact Type already has an address an Error is caused for that row. Import logic for the Update of an Existing Location Type and Contact Type is that that Location Type must already exist, if the specified Location Type does not exist an Error is caused, if more than one address exists for the specified Location Type an error is caused.
This import cannot be “undone”. Once the import creates and/or updates the data, there is no way to auto-magically reverse what you just did.
If you are interested in utilizing this feature, please contact EQUUS for a copy of our Employee & Assignment Import File Template and Field/Column Definitions.