Page 2 of 2 FirstFirst 1 2
Results 11 to 16 of 16

Thread: Dump JDE File Structure into Excel???

  1. #11

    Re: Dump JDE File Structure into Excel???

    can't believe that tool really works!! kudos to tpw_nz or Trevor who developed this tool.

    i ran it for a table on both 7333 and 8.12 and the results are amazing.

    will run this for a couple more and will confirm to you guys if it really works!!! i will also attach the link to that tool - it is simply great!!!

    got to run now... more later.

    thanks for refering me to this post #

    best rgds
    sheeba
    Thanks,
    Sheeba.

    - E1 9.0 ,TR 8.98.4.2 , SQL 2008 R2 , IE 11
    - have worked on B7322, XE Release B7333, B7334 (as400/sql 2005 Win 2003); E1 8.12(Oracle 10g OAS 10.0.1.2)

  2. #12
    Member
    Join Date
    Nov 2000
    Location
    Denver, Colorado
    Posts
    574

    Re: Dump JDE File Structure into Excel???

    Ok,

    I feel really stupid. How do you go to post #109162?

    Ben again,

  3. #13
    Senior Member peterbruce's Avatar
    Join Date
    Jan 2004
    Location
    NSW Australia
    Posts
    1,892

    Re: Dump JDE File Structure into Excel???

    Ben,

    Go to the JDEList search page and enter the post number in the post number field and click submit.
    Thanks, Peter

    "Give a person a fish, feed them for a day, teach them how to fish, feed them for a lifetime."

    E9.1 TR9.1.2.1, Enterprise Server: Sun, Database Server: Sun, Oracle DB: 11g, Weblogic.
    Create!form 7

  4. #14
    Senior Member Alex_Pastuhov's Avatar
    Join Date
    Jul 2001
    Location
    Australia
    Posts
    1,648

    Re: Dump JDE File Structure into Excel???

    You can also look at our OneAssist software. Our site URL is in my signature. The trial version is free.
    Regards,
    Alexander Pastuhov
    http://www.everestsoftint.com/

  5. #15
    Senior Member Sebastian Sajaroff's Avatar
    Join Date
    Mar 2005
    Location
    Montreal (QC) Canada
    Posts
    1,179

    Re: Dump JDE File Structure into Excel???

    Hi,

    DBLOOK is for UDB/DB2, not for DB2/400; both are IBM
    database products but are not the same!
    Sebastian Sajaroff
    CNC - B7321 to E900

  6. #16

    Re: Dump JDE File Structure into Excel???

    thanks Sebastian. gotcha!

    You all are THE best!!! i finally got what i was looking for for so long (ever since our upgrade started) - pls check this out for the tool that can dump JDE file structures into Excel (i tried Xe 7333 and 8.12 as well) - and works great!!!

    http://www.geocities.com/tpw_nz/

    we have some 40 odd JDE files they use to report off using a third party software. And since the layouts from 7333 has drastically changed in 8.12 - it was really important for me to find this out to simplify our work.

    thankyou one and all for helping me out.

    FYI... Here is what Oracle got back with (just so you know another workaround) :

    ISSUE:
    Is it possible to export the specifications of a table to Excel. I would like a spreadsheet that includes the data item, alias, type, size and description information.

    SOLUTION:
    Within the EnterpriseOne toolset, the functionality is not available to Export table design information to Excel. The only option available for output of the table information is to print the table information from within Table Design Aid. There are several enhancement SARs in the system requesting this ability, but currently the functionality is not available.

    As a workaround, create a custom report over the tables that contain the desired table information and then export the report to CSV. For example, the F98711 Central Objects table column contains all the Data Dictionary alias names for the columns in each table. This can be filtered by the TDOBNM column which contains the table name. Once the data dictionary alias is determined, the information regarding the data item type and size can be retrieved from the F9210 Data Field Specifications table. The description of the data item can be retrieved from the F9203 Data Item Alpha Descriptions table. Both of these data items store the data dictionary alias name in the FRDTAI column. Finally, index information for the table can be retrieved from the F98713 Primary Index Detail table. This table contains a record for each index and each column within the index.

    This type of report would take advanced knowledge of the EnterpriseOne report writer including the ability to use event rules to perform such functions as Table I/O and business functions. However, once a report was created, it could then be exported to CSV and subsequently opened in Excel.

    thanks very much again.
    sheeba
    Thanks,
    Sheeba.

    - E1 9.0 ,TR 8.98.4.2 , SQL 2008 R2 , IE 11
    - have worked on B7322, XE Release B7333, B7334 (as400/sql 2005 Win 2003); E1 8.12(Oracle 10g OAS 10.0.1.2)

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Download Enterprise One 9.0 File Structure into text or excel
    By Gunawan in forum JD Edwards® EnterpriseOne Developers
    Replies: 3
    Last Post: 08-04-2010, 01:00 AM
  2. Print out file structure from JDE
    By JdeBlues in forum JD Edwards® World™
    Replies: 4
    Last Post: 10-29-2008, 07:07 AM
  3. Report Interconnect Data Structure Header File
    By anishshetty in forum JD Edwards® EnterpriseOne Developers
    Replies: 5
    Last Post: 05-01-2007, 03:02 AM
  4. PDF file structure
    By AussieGuy in forum JD Edwards® EnterpriseOne
    Replies: 1
    Last Post: 09-25-2003, 02:54 AM
  5. Flat File Dump on Citrix Servers
    By jcockrill in forum JD Edwards® EnterpriseOne Applications
    Replies: 0
    Last Post: 02-06-2003, 05:44 PM

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, Oracle or Peoplesoft.