Btw Sumit, Enumeration table has entries starting with KWT%. On 1 Jan 2013 17:38, "winster t jose (JIRA)" <j...@apache.org> wrote:
> > [ > https://issues.apache.org/jira/browse/OFBIZ-5116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13541627#comment-13541627] > > winster t jose commented on OFBIZ-5116: > --------------------------------------- > > Then it is not an issue. Locally, I disabled the eca > "indexProductKeywords" and created a product and it worked correctly. And I > tested my "bulk import" changes. That also worked. That means, I am missing > some data in my database which causes the keyword table to throw exception. > > I think, you can go ahead with checking my changes. > > > 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 >