G/L report writer

[coffeepot]

I'm a new support person to Ellipse. The accountants have been using the G/L report writer to create a number of reports in the test environment. When asked how to transfer these 'reports' to the production environment, we were told to recreate them. Does 'something' exist that could help us?

Thanks

 

[Calator]

Can you describe what the accountants have created, what are the components that need to be migrated, and your version of Ellipse or MIMS.

If for instance that were records from MSF010 table code 'GL', then there could be several ways to migrate them but it may depend on the version you're running. Eg in MIMS 4.1 we have explored following options:
- copy and paste screen by screen from one instance of GUI into the other with MSO010; this may be a tedious manual procedure but still more productive than recreating record by record. The users themselves can do that if shown how.
- write custom RDL to extract MSF010 table to fixed column format flat file and custom batch program to upload from extract file. The extraction step may use MSR010.RDL as a template and the upload MSL010.CBL.
- write custom RDL to extract same to csv format file and write a GUI script to upload to MIMS
- extract with any other tool eg sqlplus for upload to MIMS
Above solutions apart from 1st one require to write some software but once you have done that, you will find it useful in many other instances when table records need to be migrated from one instance to another.

In Ellipse you may have more suitable options to extract and upload records.

 

[coffeepot]

We're running version 5.2.3.2 I've noticed a number of tables referencing the info entered, tables MSF96A, MSF96B, MSF96C, etc. Before I start writing the SQL I wanted to be sure 1) something isn't already available, and 2) I name all the tables. The links between some tables is obviously less so for others.

 

[Calator]

The tables you mentioned do not exist in our version 4.1. It appears you need help from Ellipse specialists. I'm sorry I cannot assist further.