jd-edwards

Data Selection – Literal Import List of Values Tool – JDE 9.1.5 | JDE 9.2

Update 24th Oct 2015: Data selection import tool is now available for Google Chrome as well. I’ve released the extension on Chrome Webstore. Following is the URL for the same: https://chrome.google.com/webstore/detail/jde-data-selection-import/njpneibpplcgghbjcbfhcdcfigjnaaha. Please click here to download the guide for installing in offline mode. Also download JDE Data Selection Import Tool chrome extension file, which will be required to carry out offline installation. Offline installations are generally required on systems where access to chrome webstore is forbidden.

 

As were are aware that JDE doesn’t allow us to mass add list of values in data selection, I have written this small addon which takes care of the problem.

Following is the guide to install the tool and get it running:

Step 1. Save following files on your hard drive

ImportValueList.htm

JDEDataSelectionImportTool9.1.5.abc

Rename .abc file to .bat before/after saving.

For e.g. in directory E:\NIMISH\JDEImport

Make a note of the directory path you are storing your files in.

Data Selection Literal Import List of Values Tool - JDE 9.1.5 - 1

Step 2. Edit JDEDataSelectionImport9.1.5.bat

Right click on the file and click on Edit.

Replace the directory path, E:\NIMISH\JDEImport with the path noted down earlier.

Data Selection Literal Import List of Values Tool - JDE 9.1.5 - 2

 

Step 3. Run JDEDataSelectionImport9.1.5.bat

Run the file JDEDataSelectionImport9.1.5.bat

This will create an entry in registry which will enable you to launch the tool in Internet Explorer.

 

Step 4. Turn off Protected Mode in Internet Explorer

If protected mode is turned on, it will block the script.

To turn off protect mode, go to Internet Options > Security Tab

Uncheck Enable Protected Mode for Internet, Local Intranet and Trusted Sites:

Data Selection Literal Import List of Values Tool - JDE 9.1.5 - 3

Step 5. Restart Internet Explorer

In order for the menu to reflect, close all instances of Internet Explorer and open again.

 

Step 6. Right click in the header menu on Data Selection page.

Data Selection Literal Import List of Values Tool - JDE 9.1.5 - 4

NOTE: It is necessary to launch the tool by right clicking in the header part of the page (as shown above) and clicking on “JDE Data Selection Import – 9.1.5”

Step 7. Fill the list of values and click on Add.

Data Selection Literal Import List of Values Tool - JDE 9.1.5 - 5

Step 8. Wait for the values to be added then click OK

Data Selection Literal Import List of Values Tool - JDE 9.1.5 - 6

Step 9. Voila! Your Data Selection has been imported successfully.

P.S.  If you find any bugs in the tool or if you have any suggestions/feedback about the same, feel free to contact me using the contact page or drop a comment using the form below.

8 thoughts on “Data Selection – Literal Import List of Values Tool – JDE 9.1.5 | JDE 9.2”

  1. Hi,

    Nothing happens when I click. I did the same as the pictures show in Chrome App Store. Do you know what it can be?

    -Win7
    -PopUps Alowed
    -No AddBlock
    -Chrome

    1. Hi Tarcio

      Please check if you are on the “list of values” tab.

      Next make sure you have run the batch file and the path mentioned in the file points to a valid location. If the path mentioned in .bat file is incorrect, pop up won’t launch. Correct the path and it should work fine.

      Thanks & Regards

      Nimish Prabhu

  2. Hi,

    Nothing happens when I click. I did the same as the pictures show in Chrome App Store. Do you know what it can be?

    -Win7 can you guide me in this……please

  3. This works fine,

    But if the user wants to utilize this option in any new machine/in their own machine they do have to do installation of these htm & bat files & the required setups????

    These steps has to be repeated once before we start with batch execution for bulk data in any machine????

  4. Hey,

    This rules.

    Stumbled upon it today when the client was in a pinch. Had to bulk reprint a ton of work orders. Used this to copy and paste ~1000 work orders into the reprint program.

    Good stuff mate.

    Patrick

  5. Hi,
    I am getting the below internet page error after adding the values to your page and clicking the add line.
    Webpage error details

    User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0)
    Timestamp: Thu, 14 Apr 2016 09:33:56 UTC

    Message: ‘iObj.JDE.RID.value’ is null or not an object
    Line: 1
    Char: 878
    Code: 0
    URI: https://172.16.2.37/jde/E1Menu.maf?RENDER_MAFLET=E1Menu&jdeowpBackButtonProtect=PROTECTED

    Can you help me out pl.

Leave a Reply

Your email address will not be published. Required fields are marked *