[
https://issues.apache.org/jira/browse/OFBIZ-5116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
winster t jose updated OFBIZ-5116:
----------------------------------
Affects Version/s: (was: Release Branch 11.04)
SVN trunk
the same patch is applicable for trunk. Currently in trunk, creating a product fails.
[java] Message: SQL Exception while executing the following:INSERT INTO PRODUCT_KEYWORD_NEW (PRODUCT_ID, KEYWORD, KEYWORD_TYPE_ID, RELEVANCY_WEIGHT, STATUS_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz`.`PRODUCT_KEYWORD_NEW`, CONSTRAINT `PROD_KWD_TYPE` FOREIGN KEY (`KEYWORD_TYPE_ID`) REFERENCES `ENUMERATION` (`ENUM_ID`)))
(I have a clean database with ProductTypeData.xml loaded)
So I could not test it over there.
> Bulk creation of products via excel upload and product image content via zip file upload
> ----------------------------------------------------------------------------------------
>
> Key: OFBIZ-5116
> URL:
https://issues.apache.org/jira/browse/OFBIZ-5116> Project: OFBiz
> Issue Type: New Feature
> Components: product
> Affects Versions: SVN trunk
> Environment: OS : Ubuntu 12.04
> Database : mysql
> Reporter: winster t jose
> Priority: Minor
> Labels: excel, productid, zip
> Attachments: OFBIZ-5116.patch, products.xls, test1.zip
>
>
> Users can use this feature to create a number of products and associated images in a single stretch.
> The excel sheet is used for storing product information and the zip file should contain images for each product.
> Spreadsheet parsing service for the creation of products had already been implemented as part of productImportFromSpreadsheet. But for that to happen, excel sheet has to be kept in a location somewhere inside server. But I have made it more flexible by allowing user to upload an excel sheet.
> The next part is uploading images for each product. User has to create a folder which contains image file for each product which has been mentioned in excel. The name of image file should be product id. When a zip file is uploaded, it will be extracted in server and each image will be stored in respective image sever path.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Locked
