ALIPO Posted April 12, 2021 Posted April 12, 2021 Can the bulk upload .csv be used to 'Update' existing records without creating duplicates or only used to 'Upload' new records?
Guest Mary Posted April 12, 2021 Posted April 12, 2021 Hi @ALIPO could you please clarify what you mean by bulk upload .csv? What records are you trying to update - users, assets?
ALIPO Posted April 12, 2021 Author Posted April 12, 2021 29 minutes ago, Mary said: Hi @ALIPO could you please clarify what you mean by bulk upload .csv? What records are you trying to update - users, assets? I am looking to upload a .csv template to update Assets. Situation is that we have dozens of Assets that need to be marked as being disposed and I believe that the Manage Assets Bulk Upload function can do this, and as long as we verify on Serial Number no duplicates will be created. Initially I thought the function was for 'NEW' only but then remembered the VERIFICATION option I tried uploading my a test .csv but that failed The reason made no sense to me other than a database error occurred. Andrew
Guest Mary Posted April 12, 2021 Posted April 12, 2021 @ALIPOyou need https://wiki.hornbill.com/index.php?title=CSV_Asset_Import to update asset records via csv. The reason in the screenshot above states it cannot AddRecord because the record already exists.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now