Results 1 to 6 of 6

Thread: Extract information of JD Edwards on Excel file

  1. #1

    Extract information of JD Edwards on Excel file

    I want to extract some information from Accounts payable ( JD Edwards) in an Excel file is it possible
    If yes how ?
    please advice
    regards


  2. #2
    New Member
    Join Date
    May 2008
    Posts
    15

    Re: Extract information of JD Edwards on Excel file

    I'm aware or 2 basic ways.

    The first is, within oneworld, right click and export a selection from the grid
    The second way, is to use ODBC, you will need database password to do this, since it does not use the jde security.
    From excel, Click Data-> Import Export Data ->New Data base Query - select your odbc.

    Now a few notes is you are not familiar with ODBC, then don't use it, there are some danger.

    Also there are a few tools out there that might help you, try downloading OW INFO, I think the demo lets you open 1 table so you can see how it works.

    hope that helps
    Jane

  3. #3
    New Member
    Join Date
    Dec 2008
    Posts
    1

    Re: Extract information of JD Edwards on Excel file

    The first is, within oneworld, right click and export a selection from the grid and select that u want to open in exell and then click ok .

  4. #4

    Re: Extract information of JD Edwards on Excel file

    Thanks for your suggestion
    can you help me how i can use ODBC because i am not aware
    after all that step it is asking for new query
    how can i aproceed further while working in citrix

  5. #5
    New Member ChelseaGirl's Avatar
    Join Date
    Feb 2005
    Location
    Oxford
    Posts
    13

    Re: Extract information of JD Edwards on Excel file

    To export to Excel from OneWorld in a Citrix session, you need Excel (office) installed on the Citrix server.

  6. #6

    Re: Extract information of JD Edwards on Excel file

    do you? can't you just export in csv format to client installed xls?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.