[jira] Created: (OFBIZ-1810) Implement the sample code for conversion of spreadsheet data to entity engine data

[Nicolas Malin (Jira)]

Implement the sample code for conversion of spreadsheet data to entity engine data
----------------------------------------------------------------------------------

                 Key: OFBIZ-1810
                 URL: https://issues.apache.org/jira/browse/OFBIZ-1810
             Project: OFBiz
          Issue Type: New Feature
          Components: specialpurpose/assetmaint
            Reporter: Pranay Pandey
            Priority: Minor


Implement sample code for performing the operation of conversion of data from a spreadsheet data to a entity engine data by using poi api.




--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

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

Pranay Pandey updated OFBIZ-1810:
---------------------------------

    Attachment: Spreadsheet_To_Database.patch

Here is the sample code for performing this operation using poi api and also preparing a document for the guidance. Tomorrow the document will be uploaded as well, it will guide better in using this sample code.
The code is having comments which are explanatory and understandable.
Presently the code is in the assetmaint under special purpose.

The spreadsheet is also attached. Put this file in your OfbizHomeDirectory/spreadsheet and don't forget to import the data for scheduling the job. The data is in the file ScheduleUploadJob.xml.

> Implement the sample code for conversion of spreadsheet data to entity engine data
> ----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-1810
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1810
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: specialpurpose/assetmaint
>            Reporter: Pranay Pandey
>            Priority: Minor
>         Attachments: Spreadsheet_To_Database.patch
>
>
> Implement sample code for performing the operation of conversion of data from a spreadsheet data to a entity engine data by using poi api.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-1810?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12600832#action_12600832 ]

pranaypa edited comment on OFBIZ-1810 at 5/29/08 9:50 AM:
---------------------------------------------------------------

Here is the sample code for performing this operation using poi api and also preparing a document for the guidance. Tomorrow the document will be uploaded as well, it will guide better in using this sample code.
The code is having comments which are explanatory and understandable.
Presently the code is in the assetmaint under special purpose.

The spreadsheet is also attached. Put this file in your OfbizHomeDirectory/spreadsheet and don't forget to import the data for scheduling the job. The data is in the file ScheduleUploadJob.xml.

--
Thanks & Regards,
Pranay Pandey
           &
Chirag Manocha



      was (Author: pranaypa):
    Here is the sample code for performing this operation using poi api and also preparing a document for the guidance. Tomorrow the document will be uploaded as well, it will guide better in using this sample code.
The code is having comments which are explanatory and understandable.
Presently the code is in the assetmaint under special purpose.

The spreadsheet is also attached. Put this file in your OfbizHomeDirectory/spreadsheet and don't forget to import the data for scheduling the job. The data is in the file ScheduleUploadJob.xml.




 

> Implement the sample code for conversion of spreadsheet data to entity engine data
> ----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-1810
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1810
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: specialpurpose/assetmaint
>            Reporter: Pranay Pandey
>            Priority: Minor
>         Attachments: Spreadsheet_To_Database.patch
>
>
> Implement sample code for performing the operation of conversion of data from a spreadsheet data to a entity engine data by using poi api.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

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

Pranay Pandey updated OFBIZ-1810:
---------------------------------

    Attachment: inventory_by_item_detail.xls.gz

This is spreadsheet data file on which the operations are being performed.

> Implement the sample code for conversion of spreadsheet data to entity engine data
> ----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-1810
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1810
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: specialpurpose/assetmaint
>            Reporter: Pranay Pandey
>            Priority: Minor
>         Attachments: inventory_by_item_detail.xls.gz, Spreadsheet_To_Database.patch
>
>
> Implement sample code for performing the operation of conversion of data from a spreadsheet data to a entity engine data by using poi api.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

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

Pranay Pandey updated OFBIZ-1810:
---------------------------------

    Attachment: poi_sampleCode_steps.pdf

This is the documentation which is having steps to be performed.

Thanks & Regards
--
Pranay Pandey
           &
Chirag Manocha

> Implement the sample code for conversion of spreadsheet data to entity engine data
> ----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-1810
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1810
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: specialpurpose/assetmaint
>            Reporter: Pranay Pandey
>            Priority: Minor
>         Attachments: inventory_by_item_detail.xls.gz, poi_sampleCode_steps.pdf, Spreadsheet_To_Database.patch
>
>
> Implement sample code for performing the operation of conversion of data from a spreadsheet data to a entity engine data by using poi api.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

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

Ashish Vijaywargiya reassigned OFBIZ-1810:
------------------------------------------

    Assignee: Ashish Vijaywargiya

> Implement the sample code for conversion of spreadsheet data to entity engine data
> ----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-1810
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1810
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: specialpurpose/assetmaint
>            Reporter: Pranay Pandey
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>         Attachments: inventory_by_item_detail.xls.gz, poi_sampleCode_steps.pdf, Spreadsheet_To_Database.patch
>
>
> Implement sample code for performing the operation of conversion of data from a spreadsheet data to a entity engine data by using poi api.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

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

Ashish Vijaywargiya closed OFBIZ-1810.
--------------------------------------

    Resolution: Fixed

Pranay and Chirag thanks for your patch.
Its now in trunk rev # 663581.

--
Ashish Vijaywargiya

> Implement the sample code for conversion of spreadsheet data to entity engine data
> ----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-1810
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1810
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: specialpurpose/assetmaint
>            Reporter: Pranay Pandey
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>         Attachments: inventory_by_item_detail.xls.gz, poi_sampleCode_steps.pdf, Spreadsheet_To_Database.patch
>
>
> Implement sample code for performing the operation of conversion of data from a spreadsheet data to a entity engine data by using poi api.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.