OFBiz
  1. OFBiz
  2. OFBIZ-1810

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

    Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None

      Description

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

      1. poi_sampleCode_steps.pdf
        292 kB
        Pranay Pandey
      2. inventory_by_item_detail.xls.gz
        4 kB
        Pranay Pandey
      3. Spreadsheet_To_Database.patch
        14 kB
        Pranay Pandey

        Activity

        Gavin made changes -
        Workflow jira [ 12432123 ] OFbiz Workflow [ 12505704 ]
        Ashish Pareek committed 781926 (2 files)
        Reviews: none

        Wrong location was specified for this service.
        Minor fix in code to return error and success message.

        I will create the "How To" docs for this in next few hours on the OFBiz confluence.
        As the present document is present in OFBIZ-1810.

        Ashish Vijaywargiya made changes -
        Status Open [ 1 ] Closed [ 6 ]
        Resolution Fixed [ 1 ]
        Hide
        Ashish Vijaywargiya added a comment -

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


        Ashish Vijaywargiya

        Show
        Ashish Vijaywargiya added a comment - Pranay and Chirag thanks for your patch. Its now in trunk rev # 663581. – Ashish Vijaywargiya
        Ashish Pareek committed 663581 (6 files)
        Reviews: none

        Applied patch from JIRA issue # OFBIZ-1810.
        This additional feature will help the Developer to get the idea of
        usage of POI api with the Ofbiz.

        Please take the attached pdf file from JIRA issue for the references for now.
        Pranay & Chirag please upload the document on Ofbiz Confluence whenever you get a chance.

        This addition looks really good to me and didn't see any comment from community so I am committing it and further enhancement can be done later on.

        Thanks Pranay Pandey and Chirag Manocha for working on this.

        Ashish Vijaywargiya made changes -
        Assignee Ashish Vijaywargiya [ toashishvijay ]
        Pranay Pandey made changes -
        Attachment poi_sampleCode_steps.pdf [ 12383077 ]
        Hide
        Pranay Pandey added a comment -

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

        Thanks & Regards

        Pranay Pandey
        &
        Chirag Manocha

        Show
        Pranay Pandey added a comment - This is the documentation which is having steps to be performed. Thanks & Regards – Pranay Pandey & Chirag Manocha
        Pranay Pandey made changes -
        Attachment inventory_by_item_detail.xls.gz [ 12383033 ]
        Hide
        Pranay Pandey added a comment -

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

        Show
        Pranay Pandey added a comment - This is spreadsheet data file on which the operations are being performed.
        Pranay Pandey made changes -
        Field Original Value New Value
        Attachment Spreadsheet_To_Database.patch [ 12383031 ]
        Hide
        Pranay Pandey added a comment - - edited

        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

        Show
        Pranay Pandey added a comment - - edited 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
        Pranay Pandey created issue -

          People

          • Assignee:
            Ashish Vijaywargiya
            Reporter:
            Pranay Pandey
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development