Skip to main content

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

Hi Bas, 

Marty here from Pigment Product Support. 

We received your Support request regarding your Excel connector issue. We’ll continue our conversation in that ticket. 

Cheers,
Marty


Reply