Data import: same values being added multiple times to values list
I have noticed that during a lot of the imports that I perform that values that are exactly the same as those included in a values list are being re-added with a (#) beside them, in most cases this isn't too bad, but after importing a large volume of data recently I have over 200 extra items added per list.
This is especially frustrating because as you may know I would then have to go through all records change values before I can do a bulk delete, and with a large number of records this is very time comsuming
I have double checked to make sure that values are exactly the same as those that are already included in the values list and that no spaces exist where there should not be. Does anyone have any other suggestions to prevent this from happening? I did not noticed any options during the import that prevents this but I may be overlooking something.
As always I appriciate the time taken to read and respond. Thank you,
Archer v5.4 P1
Not seen this behaviour but understand your frustration as I have inadvertantly created extra values when running imports as admin.
I would look at the import file with a text editor to make absolutely sure excel isn't doing anything weird with the field values. Are you sysadmin when running the import? If so you could create a user who doesn't have rights to add values to the values list and try the import when logged in as that user.
Have had this happen many times with imports and due to packaging. For imports the most effective way I have found to validate import data is to use vlookup in excel to compare import data to values in list. Get the exact values in list using export list option.
Cleaning up after this from imort and after packaging can be time consuming.
I would suggest that you really inspect the data from your import. 99% of the time I see this, I find that the incoming data is not very clean and may contain extra spaces at the front or end of the value.