Is anybody interested in my programs that use Lawson API's to clean out files? I have 2 versions, one of which is index-moderated and uses 8.x API's to delete records by range; the other of which does it "the old-fashioned way". With a bit of rejiggering, these can be used for specialized data dumps, custom deletion, or other such speciality stuff.

Each program does more than 1 file at a time. They also include reports on how many records are currently in the file. Running them in "N" mode (No delete) will give a quick count of all of the records in those files.

The incentive for these programs were custom systems that I wrote, which needed data to be cleaned out and then reloaded. Loading via importdb is easy, and dumping via rngdump or rngdbdump is easy. But removing all or some records in a file is not. Although I could go in and use SQL Server tools, I wanted something that was more "generic Lawson" and which could also be turned over to users when necessary. Thus these programs were created.

I'd be very interested, Milo! Feel free to e-mail me, or if you're posting it here on LawsonTalk, please give me a head's up - my old eyes aren't what they used to be....

Thanks - Stephanie

Me too, please.

THANKS for sharing. ;-D :bow:

I would like these as well

Thanks

We would be interested too.

Brenda

Absolutely - thanks so much!

Sorry, there's a slight delay while I'm rewriting the 2 programs for clarity.

Developed and tested on
App Version 8.0.3.9
Env Version 8.0.3 SP6
OS/Version Windows 2003

System Requirements / Pre-requisites
MT555 Requires 8.0.x minimum
MT556 May work in 7.2.x level

Description
There are times when users must purge files on a regular basis. These are 2 programs which provide templates for screens which allow users to delete files themselves. Each program allows purging more than one file at a time, and reports full count information – how many records to start, how many purged, how many remaining. They can be run in “safe” mode (purge = “N”) to give just a record count.Program MT555 is a template for purging files using a key range. This is very fast, but may not delete all data, depending on how the records are populated. Program MT556 is a template for purging files the slow and old-fashioned way, one record at a time. This method also allows for adding conditional logic, reporting, and archiving.

Installation Instructions
These programs are intentionally not working as they stand. You must modify them for your own purposes. Follow the instructions in comment lines within each program. You can add more sections to purge more files if you wish. (MT556 was originally a program to purge 7 files at one time.)

Release Notes
This is the initial release – V 1.00, September 5, 2006. Written by Milo Tsukroff, copyright released. Portions of each program are derived from Lawson-developed code.