Page 4 of 5 FirstFirst ... 2 3 4 5 LastLast
Results 31 to 40 of 46

Thread: JDE Object Browser 1.3

  1. #31
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,153
    Hi Craig,

    I've noticed an issue with your browser tool. I think it's related to a bare bone record with NULL in certain columns.

    If there are records created outside of E1, the record may have a lot of NULL columns.
    If records are create through E1, the record seems to have very few or zero NULL columns.

    If I use your viewer to browse a table I can only see certain records (non NULL) that were created by E1

    However......
    If I use UTB I can see any record I wish. Both NULL and non NULL records.
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR 9.1.5.3 Unix

  2. #32
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    848
    Hi John,

    I can't seem to replicate this. You mention that you can only see "certain" records. Is there something about them that is different than the hidden ones? Are you using a filter on a column?

    Craig
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.3 iSeries
    E1 9.0 8.98.4.2 Wintel SQL 2008

  3. #33
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,153
    Hi Craig,

    To replicate this try inserting a record into a table using SQL. Bare bones. Insert into F0101 and just map the AN8 and ALKY = TEST for example.
    Then create a record in P01012 using ALKY = TEST and then use your browser leaving everything open. No filters entered

    If it's anything like here, you'll only see the P01012 entered record....until you use a field to filter.

    Strange things is....if your E1 record created an AN8 = 5112345 (for example) and then you typed AN8 = 5112345 in the browser, you'd see it
    But like I said, if you leave the search open and click find, you don't see it

    Only difference I can see is one is full of nulls, the other inserted by E1 isn't

    I'll post them below now. (bold = key)

    Won't work
    (null) (null) (null) 00728 12345678 CB 1 1 (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null)

    Will work
    900057639 00728 104888 SU 0 0 H 0 850 I850JWGEN 112265 R 0 SEABNOHDD 00 0 0 0 0 0 0 1969-12-31 00:00:00 0 0 1969-12-31 00:00:00 0 0 1969-12-31 00:00:00 SS 10071 0 0 0 0 1969-12-31 00:00:00 0 82W476185001 riordino Gen8 7211221825 SAPR01 CZ680517284 FGICUS CLCGAE 0 0 0 EBI EBI EBI 112265 145649 1969-12-31 00:00:00
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR 9.1.5.3 Unix

  4. #34
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    848
    Still can't get this to happen in how you explain. Any chance a numeric column being inserted by the external SQL has a value greater than the DD definition? For example 8898989898 in AN8 will display as 999999999 since it runs through a JDE formatting routine.

    thanks
    Craig
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.3 iSeries
    E1 9.0 8.98.4.2 Wintel SQL 2008

  5. #35
    New Member
    Join Date
    Jan 2017
    Location
    Toronto, ON
    Posts
    2
    Hi Craig,

    Thanks a lot for such very useful tool, appreciate your dedication and efforts.

    I have quick question, while opening the table using the tool's data browser, is there a way to export the record to csv without listing all of the records ?

    Thanks a million again
    Ahmad

  6. #36
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    848
    Hi Ahmad,

    Appreciate the kind words. I'm not sure I understand what you're asking, but if you just want to export the table layout (columns, not records), open the table in the main tool (not data browser) and export. Let me know if I'm not understanding.

    Craig
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.3 iSeries
    E1 9.0 8.98.4.2 Wintel SQL 2008

  7. #37
    New Member
    Join Date
    Jan 2017
    Location
    Toronto, ON
    Posts
    2
    Hi Craig, Thanks for for your reply.

    my question was about exporting table's data.

    for example if i have a table of 15000 records and i want to export the entire records to excel .. do i have to press (fetch) and wait for the entire 15000 records to be fetched then press (export Grid) .. or is there a way to export them without waiting to fetch all of them ...

    hope that explains my question

    thanks,
    Ahmad

  8. #38
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    848
    Ahmad,

    Yes, at this point the export is directly from the grid. I will look to create a direct table export feature for all rows. I'm sure we'll have to support multiple documents based on the possible # of rows and what Excel supports.

    thanks for the feedback,
    Craig
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.3 iSeries
    E1 9.0 8.98.4.2 Wintel SQL 2008

  9. #39
    New Member MCCInet's Avatar
    Join Date
    Jun 2002
    Location
    Ontario, Canada
    Posts
    40
    Is there a way to export menu details to a spreadsheet?
    Steve
    EnterpriseOne 9.0

  10. #40
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,153
    Hi Craig,

    A wish for your rather useful Explore References function.

    Is there any way to export this info to a spreadsheet? Or is there any way to fully nest ALL the calls rather than clicking Explore each time to drill down.

    Thanks

    John
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR 9.1.5.3 Unix

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Object Browser
    By craig_welton in forum Developer / Programmer
    Replies: 11
    Last Post: 08-21-2017, 08:29 AM
  2. Replies: 5
    Last Post: 12-13-2011, 01:18 PM
  3. JDE Object Browser 1.2
    By craig_welton in forum Developer / Programmer
    Replies: 0
    Last Post: 07-28-2011, 10:20 AM
  4. JDE Object Browser 1.1
    By craig_welton in forum Developer / Programmer
    Replies: 10
    Last Post: 04-07-2011, 08:58 AM
  5. JDE Object Browser Beta
    By craig_welton in forum Developer / Programmer
    Replies: 8
    Last Post: 11-24-2009, 05:34 AM

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.