[jira] [Updated] (OFBIZ-5116) Bulk creation of products via excel upload and product image content via zip file upload

["winster t jose (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OFBIZ-5116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

winster t jose updated OFBIZ-5116:
----------------------------------

    Attachment: OFBIZ-5116.patch

There are 7 new files.
1. applications/product/src/org/ofbiz/product/spreadsheetimport/ImportZipHelper.java
2. applications/product/src/org/ofbiz/product/spreadsheetimport/ImportZipServices.java
3. framework/webtools/widget/ImportScreens.xml
4. framework/webtools/webapp/webtools/import/importimages.ftl
5. framework/webtools/webapp/webtools/import/importspreadsheet.ftl
6. framework/webtools/webapp/webtools/js/BulkImport.js
7. framework/webtools/webapp/webtools/WEB-INF/actions/bulkimport/BulkImport.groovy


There are 6 files updated.
1. applications/product/src/org/ofbiz/product/spreadsheetimport/ImportProductHelper.java
2. applications/product/src/org/ofbiz/product/spreadsheetimport/ImportProductServices.java
3. applications/product/config/catalog.properties
4. framework/webtools/widget/Menus.xml
5. framework/webtools/config/WebtoolsUiLabels.xml
6. framework/webtools/webapp/webtools/WEB-INF/controller.xml
                
> 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: Release Branch 11.04
>         Environment: OS : Ubuntu 12.04
> Database : mysql
>            Reporter: winster t jose
>            Priority: Minor
>              Labels: excel, productid, zip
>         Attachments: OFBIZ-5116.patch
>
>
> 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