Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-1810

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

        Details

        • Type: New Feature
        • Status: Closed
        • Priority: Minor
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: assetmaint
        • 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. Text File
            Spreadsheet_To_Database.patch
            14 kB
            pranaypa
          2. GZip Archive
            inventory_by_item_detail.xls.gz
            4 kB
            pranaypa
          3. PDF File
            poi_sampleCode_steps.pdf
            292 kB
            pranaypa

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            pandeypranay 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
            pandeypranay 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
            Hide
            Permalink
            pandeypranay Pranay Pandey added a comment - - edited

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

            Show
            pandeypranay Pranay Pandey added a comment - - edited This is spreadsheet data file on which the operations are being performed.
            Hide
            Permalink
            pandeypranay Pranay Pandey added a comment - - edited

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

            Thanks & Regards
            –
            Pranay Pandey
            &
            Chirag Manocha

            Show
            pandeypranay Pranay Pandey added a comment - - edited This is the documentation which is having steps to be performed. Thanks & Regards – Pranay Pandey & Chirag Manocha
            Hide
            Permalink
            toashishvijay Ashish Vijaywargiya added a comment -

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

            –
            Ashish Vijaywargiya

            Show
            toashishvijay Ashish Vijaywargiya added a comment - Pranay and Chirag thanks for your patch. Its now in trunk rev # 663581. – Ashish Vijaywargiya

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Development