Skip to main content
Anybody out there familiar with an application called "Prelude"? I've got an end user out there who's migrating to Prophet ( Profit? ) 21 who is having trouble extracting the data they need. The developer modified and locked down Prelude, passworded everything, removed any source, then died taking all knowledge with him. It would be nice to know stuff like "blah blah is the invoice file, blah blah is the customer file..." etc.

------------------------------
Brian S. Cram
Principal Technical Support Engineer
Rocket Software
------------------------------
Anybody out there familiar with an application called "Prelude"? I've got an end user out there who's migrating to Prophet ( Profit? ) 21 who is having trouble extracting the data they need. The developer modified and locked down Prelude, passworded everything, removed any source, then died taking all knowledge with him. It would be nice to know stuff like "blah blah is the invoice file, blah blah is the customer file..." etc.

------------------------------
Brian S. Cram
Principal Technical Support Engineer
Rocket Software
------------------------------
Would Epicor be philanthropic enough to offer support services gratis?

------------------------------
[Doc] [Ruckel]
[IT Guy]
[Southwest Traders]
[Temecula] [CA] [USA][Doc]
------------------------------
Anybody out there familiar with an application called "Prelude"? I've got an end user out there who's migrating to Prophet ( Profit? ) 21 who is having trouble extracting the data they need. The developer modified and locked down Prelude, passworded everything, removed any source, then died taking all knowledge with him. It would be nice to know stuff like "blah blah is the invoice file, blah blah is the customer file..." etc.

------------------------------
Brian S. Cram
Principal Technical Support Engineer
Rocket Software
------------------------------
In a situation like this, I would certainly not trust the end user.  Sounds more like an issue where they fired the developer and refused to pay them.

There should be an active license with Epicor, if this is indeed their product Prelude, and they could be contacted directly to work with the end user.

------------------------------
Will Johnson
Systems Analyst
Rocket Forum Shared Account
------------------------------
In a situation like this, I would certainly not trust the end user.  Sounds more like an issue where they fired the developer and refused to pay them.

There should be an active license with Epicor, if this is indeed their product Prelude, and they could be contacted directly to work with the end user.

------------------------------
Will Johnson
Systems Analyst
Rocket Forum Shared Account
------------------------------
Yeah, it's actually Epicor that started this inquiry. The now deceased developer did a lot to secure the system and didn't leave any passwords in his will, so they're stuck. I've got a few people lined up to help, so I think we're good.

------------------------------
Brian S. Cram
Principal Technical Support Engineer
Rocket Software
------------------------------
Yeah, it's actually Epicor that started this inquiry. The now deceased developer did a lot to secure the system and didn't leave any passwords in his will, so they're stuck. I've got a few people lined up to help, so I think we're good.

------------------------------
Brian S. Cram
Principal Technical Support Engineer
Rocket Software
------------------------------
Once upon a time, there was a product called "Unbasic" which one could use to produce source code (less comments) from compiled Pick Basic code.
I don't know if it still exists or is supported.  It seems to me that this would be the cure to this problem.  Use of such a product without permission of the copyright holder of the product being "decompiled" could possibly result in civil or criminal liability, so caution is encouraged.

------------------------------
Keith Grill
President
DBMS Inc
Shreveport LA US
------------------------------
Once upon a time, there was a product called "Unbasic" which one could use to produce source code (less comments) from compiled Pick Basic code.
I don't know if it still exists or is supported.  It seems to me that this would be the cure to this problem.  Use of such a product without permission of the copyright holder of the product being "decompiled" could possibly result in civil or criminal liability, so caution is encouraged.

------------------------------
Keith Grill
President
DBMS Inc
Shreveport LA US
------------------------------
You're right.  Although UNBASIC only worked on R83 code, and Universe/Unidata doesn't use that type of coding.


------------------------------
Will Johnson
Systems Analyst
Rocket Forum Shared Account
------------------------------
Once upon a time, there was a product called "Unbasic" which one could use to produce source code (less comments) from compiled Pick Basic code.
I don't know if it still exists or is supported.  It seems to me that this would be the cure to this problem.  Use of such a product without permission of the copyright holder of the product being "decompiled" could possibly result in civil or criminal liability, so caution is encouraged.

------------------------------
Keith Grill
President
DBMS Inc
Shreveport LA US
------------------------------
Yeah, David Andresen's product. Haven't used that since the '90's. Wouldn't recommend that anyway. Just need a Prelude resource that can tell us what file is what.

------------------------------
Brian S. Cram
Principal Technical Support Engineer
Rocket Software
------------------------------
Once upon a time, there was a product called "Unbasic" which one could use to produce source code (less comments) from compiled Pick Basic code.
I don't know if it still exists or is supported.  It seems to me that this would be the cure to this problem.  Use of such a product without permission of the copyright holder of the product being "decompiled" could possibly result in civil or criminal liability, so caution is encouraged.

------------------------------
Keith Grill
President
DBMS Inc
Shreveport LA US
------------------------------

Hi,

maybe the DECOMPILE command, decatalog object first, or use the Debug !, trace, break, get file and variable names, there's a couple of User Exits Brian could drag up, when using debug and the !command to give a complete list of variables and their values including filenames, look at the records being written and deduce their attributes, et al. Another UE at ! Command gives select list contents to deduce ids. Files, DL/IDs, contents. 

Big assumption is that the source was compiled with the map correct options (MX


Beware of Unbasic in a UK or French system - check the source first, there was a version I wrote in late 70's for April fools day, The proper one worked fine though on CMC and Microdata/MDIS/Reality.

Merry



------------------------------
Merry Player
Pick Multivalue Person since CMC (1978) /Microdata/McD/Northgate and onwards Reality/Zebra/Mentor/Ultimate/Universe/Unidata into Pick, Pick AP, and so on up until 2021 on mvBase/D3 - so far ....
Isle of Wight England
------------------------------
Terms & ConditionsAccessibility statement