The Ares seed script has duplicate entries for the same DocumentTypeValues.
The values should be unique. Currently the primary key is only on the document type name field but we do look up value based on Item DocType value so the value should also be unique.
The seed data has the following duplicates:
Word Word
Word .docx Word
Excel Excel
Excel .xlsx Excel
PowerPoint Powerpoint
PowerPoint .pptx Powerpoint
This will need to be corrected in the update script as well. If there is a duplicate value, we can update the value to be the same as the name which is ensured to be unique based on the PK. We should also modify the Items DocType value if the extensions are different between the duplicated values.
1
vote
Genie Shropshire
shared this idea
started
·
AdminDustin Stokes
(Chief Technology Officer @ Atlas Systems, Inc., Atlas Systems, Inc.)
responded
Ares 4.7.0.0