Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: bursted F95630.xdrpdubblb xml to F95631 record

  1. #1
    Member nkuebelbeck's Avatar
    Join Date
    Mar 2012
    Location
    Minnesota
    Posts
    543

    bursted F95630.xdrpdubblb xml to F95631 record

    F95630.xdrpdubblb contains the compressed xml for the bursted records in F95631. F95631.xorpdxpblb contains the compressed document. Is there anything in F95630.xdrpdubblb that relates the data to a record in the F95631. Is there another tables that relates them directly?
    Best I can tell it's just the order of the bursted xml to the records added to F95631 (sorted by F95631.xoRPDFUSS2 ASC).

    Thanks
    Analyst/Developer
    E1: 9.2 | TR: 9.2.1.4 | JAS: WebLogic | ES: OS400
    DB: DB2 | WebDev Client: Win7Pro (64 bit), VS 2010

  2. #2
    Senior Member
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas
    Posts
    1,560
    Not that I have found - at least for the project I am currently working on. And it makes sense if you think about it. UBE engine is going to output a single XML file, it is BIP that breaks this up into multiple outputs (multiple 631 records). Furthermore it doesn't appear to be sequential. In other words you can't rely on the order of the records in 631 to reflect the breaks in the bursting in the XML file.

    In my case, output is in PDF format and I was able to use XPdfText from http://www.glyphandcog.com/XpdfText.html to read data out of the PDF and sync it with the corresponding burst breaks in the XML file. I have used Glyph and Cog in the past for their XPdfPrint product and it worked great for years. I am using the evaluation version of XPdfText right now and if we decide to move forward with this solution licensing is very reasonable.
    Brian Oster
    Application Development Manager
    E1: 9.0 (TR9.1.5.1) / 9.2 (TR9.2.2.2)
    JAS/BSSV: Weblogic 12.1.2 / Weblogic 12.2
    ES: Win2008 / Win2016
    DB: MSSQL 2014 / 2016
    WebDev Client: Win7Pro / Win10Pro

  3. #3
    Member nkuebelbeck's Avatar
    Join Date
    Mar 2012
    Location
    Minnesota
    Posts
    543
    Thanks for the information.

    What i'm trying to do is to take the BIP output (for a given list of UBE's)and attach it to media object so it's available after being generated(assuming in some batch program). The data I need is in the F95630.xdrpdubblb, but the connection to F95631 was the missing piece. I'm trying to avoid working from the F95631 backwards and avoid using archive option to write output to disk, but I don't think there's a better option.
    Analyst/Developer
    E1: 9.2 | TR: 9.2.1.4 | JAS: WebLogic | ES: OS400
    DB: DB2 | WebDev Client: Win7Pro (64 bit), VS 2010

  4. #4
    Senior Member
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas
    Posts
    1,560
    I would think archiving to disk wouldn't necessarily buy you anything. You will still have to "work backwards" from the report output in 631. In my case it was not as difficult as it sounds. We have one unique document number on the PDF that I extract out with XPdfText and then use that to reference all the other key data elements I need from the XML in 630. It took less code to read data from the PDF than to parse the XML document.
    Brian Oster
    Application Development Manager
    E1: 9.0 (TR9.1.5.1) / 9.2 (TR9.2.2.2)
    JAS/BSSV: Weblogic 12.1.2 / Weblogic 12.2
    ES: Win2008 / Win2016
    DB: MSSQL 2014 / 2016
    WebDev Client: Win7Pro / Win10Pro

  5. #5
    Member nkuebelbeck's Avatar
    Join Date
    Mar 2012
    Location
    Minnesota
    Posts
    543
    Say I archived the BIP output as GT4210.[insertF4210key].pdf. I can parse that and attach it to the correct record(assuming I can figure out how to attach a file to a media object in 9.2). I would never have to concern myself 631.

    Is your project living inside E1 or third party style? Curious where your using the xPdfText library
    Analyst/Developer
    E1: 9.2 | TR: 9.2.1.4 | JAS: WebLogic | ES: OS400
    DB: DB2 | WebDev Client: Win7Pro (64 bit), VS 2010

  6. #6
    Senior Member
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas
    Posts
    1,560
    It's all done within JDE toolset (all in C BSFNs). You simply drop the XPdfText.dll into \system\bin32 and then you can load the dll, get proc addresses, etc. I have a wrapper BSFN that does all the necesary dll loading, init, etc. and returns a struct with all the APIs, much like the vertex APIs are exposed if you are familiar with those so I don't have to re-write all that code for each and every UBE processor. I did the same thing when I used their other product XPdfPrint.

    We are migrating from Transform to BIP for select UBEs (eventually all), but we still have to archive some of the BIP output to Transform Content Center.
    Brian Oster
    Application Development Manager
    E1: 9.0 (TR9.1.5.1) / 9.2 (TR9.2.2.2)
    JAS/BSSV: Weblogic 12.1.2 / Weblogic 12.2
    ES: Win2008 / Win2016
    DB: MSSQL 2014 / 2016
    WebDev Client: Win7Pro / Win10Pro

  7. #7

    Any solution?

    Quote Originally Posted by nkuebelbeck View Post
    Say I archived the BIP output as GT4210.[insertF4210key].pdf. I can parse that and attach it to the correct record(assuming I can figure out how to attach a file to a media object in 9.2). I would never have to concern myself 631.

    Is your project living inside E1 or third party style? Curious where your using the xPdfText library
    Hi nkuebelbeck,

    Did you find any solution to this, i have a similar kind of requirement to attach the BI outputs back to the orders as Media object attachment ?

  8. #8
    Member nkuebelbeck's Avatar
    Join Date
    Mar 2012
    Location
    Minnesota
    Posts
    543
    Quote Originally Posted by sturate View Post
    Hi nkuebelbeck,

    Did you find any solution to this, i have a similar kind of requirement to attach the BI outputs back to the orders as Media object attachment ?
    we ended up using the BI archive option and processing that directory with another UBE that attached the media objects.
    Analyst/Developer
    E1: 9.2 | TR: 9.2.1.4 | JAS: WebLogic | ES: OS400
    DB: DB2 | WebDev Client: Win7Pro (64 bit), VS 2010

  9. #9
    Is it possible for you to attach the code dump for my reference. It will be a great help.Thanks in advance.

  10. #10

    Any solution?

    Quote Originally Posted by nkuebelbeck View Post
    we ended up using the BI archive option and processing that directory with another UBE that attached the media objects.
    Thanks for the response. Any chance you have the dump for that for me to refer. That will be very helpful.

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.