We are now back into ACS big time over here and are trying to get the ecommerce module configured and working. First problem is the bulk upload of products. I keep getting SQL insert errors - specifically, the postgres log says
ERROR: ExecAppend: Fail to add null value in not null atribute product_id
And in the browser window...
FAILURE! SQL: insert into ec_products (creation_date, available_date,
dirname, last_modified, last_modifying user, modfied_ip_adress)
values(sysdate(), sysdate(), '', sysdate(), 4,'192.168.10.150')
The CSV file was generated by Excel to test the system with. I tried loading the CSV from a windows box, and it spat out the file 'Cannot read file'. I created a sample csv file with VI, and it too was rejected.
I have played around with the format of the CSV file, tried inserting '''s around the values, etc., all to no avail. Does anyone have any ideas?
Ps I'm using the latest ACS (which is excellent btw!!!), the lastest postgres, and the latest AOLserver.
thanx
grant
