IMPORTANT: If you are importing new data into the system you must ensure the id column is empty.
If there is an id the importer will assign that id to the data being imported. If that id has already been used by the system it will replace the data already at that location, if it has not already been used you will get an error when the system try's to write to that location in the future.