I have attached a model of a single matrix with a datalink and a text file to illustrate the problem encountered.
The text file has one line of data which the item matches with the matrix. However, when I do a datalink/update, the item is added to the matrix as a “new” item with a 1 tagged behind (ie Staffa 1). Why does this happen? What should I do so that the data (ie 5) is updated to the existing matrix of the existing item using datalink from a text file? Thanks.
Hello Sally – Thanks for the post:
It looks as though this original Type category item was created by a DataLink from a different source file. Looking “under the hood” can see the original name of the item was ‘Headcount’ and then it was renamed to Staffa. Therefore, when the Staffa item from the new source file is directed towards the type category, it can’t merge with the item because the original name was headcount.
We do this to allow users to change item names in the matrix, without having to change the name of the item in the back end .csv file or database. But it can present some problems if the actual data source column name is changed along with the item name in the matrix being changed.
That said, if you create a new matrix with the data source, as done in the attached model, you can then change the values in the data source and update the DataLink, and the items stay as they are.
We do have an additional plugin you can install that allows you to ‘see behind the scenes’ as to what the original item names are for an item, and change them as needed. If you would like to install and explore this plugin functionality please contact [email:240ag53x]firstname.lastname@example.org[/email:240ag53x].
This is a long answer but I hope you find it helpful.