#4 Support HTML and Image content from PSCONTDEFN table [Patch]

[wsx22]

I'm using this project to get people code from PeopleSoft 8.44 environment.
I've found that HTML and Image people code content is not saved during ProcessToFile work.
This content is store in PSCONTDEFN table (CONTTYPE = 1 is Image (binary format), CONTTYPE = 4 is HTML (text format))
I've add code to support this content.
Added code can be turned on by flags getContentHtml and getContentImage in DecodePC.properties file.
( true / false values. Now, by default, turned off)
Patch was tested only with PeopleSoft 8.44 environment.

[Erik H]

Thanks!

I've patched and committed the code. Unfortunately, I can't test it myself
because I no longer have access to any PeopleSoft systems.

I'm going to put a new .zip file (1.0_RC1) on SourceForge. Please test and
let me know if everything works. If it's okay, I'm going to clean up the
documentation a bit and turn it into v1.0 - probably the last version I'll
be committing...

Erik

On Wed, May 4, 2016 at 8:39 AM, wsx22 wsx22@users.sf.net wrote:

---

• [feature-requests:#4]
  https://sourceforge.net/p/decodepcode/feature-requests/4/ Support HTML
  and Image content from PSCONTDEFN table [Patch]*

Status: open
Group: Next Release (example)
Labels: HTML Image PSCONTDEFN
Created: Wed May 04, 2016 12:39 PM UTC by wsx22
Last Updated: Wed May 04, 2016 12:39 PM UTC
Owner: nobody
Attachments:

• DecodePCODE_PSCONTDEFN-support.patch
  https://sourceforge.net/p/decodepcode/feature-requests/4/attachment/DecodePCODE_PSCONTDEFN-support.patch
  (20.7 kB; application/octet-stream)

I'm using this project to get people code from PeopleSoft 8.44 environment.
I've found that HTML and Image people code content is not saved during
ProcessToFile work.
This content is store in PSCONTDEFN table (CONTTYPE = 1 is Image (binary
format), CONTTYPE = 4 is HTML (text format))
I've add code to support this content.
Added code can be turned on by flags getContentHtml and getContentImage in
DecodePC.properties file.
( true / false values. Now, by default, turned off)
Patch was tested only with PeopleSoft 8.44 environment.

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/decodepcode/feature-requests/4/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

[Jonathan Rehm]

I suspect it's because this is a 8.44 environment, but in our 8.54 environment, this doesn't work. PSCONTDEFN doesn't have CONTDATA, the PSCONTENT record does. And PSCONTENT has a SEQNUM field that's used to join the data back together. Locally I have things partially working with 8.54 (not sure when the record structure change happened, though Doc ID 637140.1 makes me think it happened with 8.45) but it would require some additional work to re-combine objects that are split across sequence numbers.

Of course, that would break things for 8.44 (the version OP is using).

[Erik H]

I'd like to help develop a solution for all Tools versions but now that I've left the PeopleSoft world, I can't do any testing.

At this point, I can only hope that the two of you (and/or other users) can work out a solution. Let me know if you need to be granted access to publish your code.

[wsx22]

I've wrote next patch, based on available documentation.
It works on 8.44 and schould work on 8.45 and newer too (database convention is detected automatically)

DecodePCODE_PSCONTDEFN-support_v2.patch
- Add PSCONTDEFNLANG support (fetch different content files per locales)
- Add support for versions 8.45 and newer (moded tables PSCONTDEFN, PSCONTDEFNLANG and added tables PSCONTENT, PSCONTENTLANG)

@Erik H could you build new version with patch so @Jonathan can test it.

PS. There is broken encoding after rev 99 https://sourceforge.net/p/decodepcode/code/99/tree//trunk/src/decodepcode/compares/ExtractPeopleCodeFromCompareReport.java?diff=51a508242718464e57ac1c6e:98

[Erik H]

Thanks wsx22.
I've patched the code and published version RC2. Please test.

[Jonathan Rehm]

I just tried the patch and it worked for some of our HTML objects but not others (2/6 in one project failed). I'll try to take some time to debug the issue in the coming weeks.

On a completely different note, how open would you guys be to switching to git instead of subversion? I've not used subversion except with this project, so I don't know how it works, but it seems like it's not possible to maintain one's own fork of the repository.