× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: RE: Creating a Test Company based on Live Company Files
  • From: "Duncan, Helen (MacGas)" <DuncanH2@xxxxxx>
  • Date: Mon, 18 Dec 2000 11:51:11 -0000

Instead of using test companies on the same files as the live data, we have
created a duplicate set of files prefixed TST instead of OSL.  We have set
up 2 different test environments: TSP (production test environment - which
mimics live environment) and TSD (development test environment which
contains changes & fixes for testing).  We have set up separate user
profiles to access the test environments and we have written programs to
populate the test files with cut down copies of the live files using CPYF.
Care needs to be taken that there is no activity on the live system when the
test system is re-generated - otherwise the invoice & order numbers get out
of sync.

This was quite labour-intensive to set up, but it works well.

Helen 

> ----------
> From:         plynch@sunflowermfg.com[SMTP:plynch@sunflowermfg.com]
> Reply To:     JBAUSERS-L@midrange.com
> Sent:         14 December 2000 20:50
> To:   JBAUSERS-L@midrange.com
> Subject:      Creating a Test Company based on Live Company Files
> 
> Sunflower needs to syncronize the test environment with the live
> environment on a weekly basis.
> This need is extremely critical right now because we're testing SP3 for
> 3.5.2b.
> 
> Does anyone out there have, or know of, a utility that performs this task
> cleanly?
> 
> Currently we have a program that runs a series of SQL statements that does
> most of the job but it is not clean enough or reliable enough to permit a
> full blown test. Part of the issue is the fact that not all files prefix
> their company number fields with "CONO". During the copy we convert the
> live company number to a different test company number so users are fully
> aware when they are in the test environment.
> 
> We'd like to run the live and test side as close to parallel as possible
> to
> facilitate efficient testing of this, and subsequent, service packs.
> Having
> a reliable utility for this would really cut down on some of the pain of
> uplifting.
> 
> Patricia Lynch
> Sunflower Mfg. Co., Inc.
> AS/400 Applications Mgr.
> 
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: doug333@aol.com.
> +---
> 
+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.