Hello,
I'm experiencing some issues with pushing data to Pigment from Excel. I have a simple dimension list (800+ items with about 4 dimension properties) that I would like to periodically update from Excel.
I exported the current dimension list to .csv and used that .csv to setup an import configuration in Pigment. Then I pasted the .csv in Excel and updated the 4 dimension properties. I then named the data range in Excel but when I try to configure a push connection it doesn't recognize the named cells (“no names defined”).
Also, when I try to input the cell ranges manually (A1 → G800) and then push the data to the dimension block in Pigment, the import fails (headers are not found...).
Any help is appreciated. Thanks!
Bas