Hi all, does anyone have experience in doing archiving in Baan IV with Oracle 7.3 in the back end? Where can I get more information about archiving, please help..........

sasa

Do you have an account at www.support.baan.com?

Since some days you can access the Baan user docs there. A search for "Archiving" should deliver at least one result - I definitely know there is a standard document on archiving.

Uli

:( Unfortuntely we don't have support anymore.....

TriNET has a Baan IV Archiving Workshop which is intended to educate you on the issues on archiving and help you develop a project plan and then you decide if you want to execute the project yourself or whether you need additional consulting assistance. We have recently done this workshop for a Baan IV account using Oracle 7.3
Email me if you would like additional information.

I have done it once, Baan IVc4 / Oracle / aix. We used a whitpaper from Baan that described the technical and functional approach and the Luminux Archive Indicator report (I do think you can get this report from Baan).
An exampel of the report can be found at:
http://www.baanboard.com/baanboard/showthread.php?s=&threadid=6663&perpage=15&display=&pagenumber=1

If you want the whitepaper, send me your e-mail adress, and I'll send it to you.

We didn't have any problems at all when we did the archive job. We followed the approach in the whitepaper, and the result was excellent.

sturla.farnes@baanaid.com

Sturla, do you have to purchase any more modules for the archiving process? Thank you.

sasa

Standard Baan archiving means copying data from your production company to another company (the archive company). The main purpouse of this is to reduce table size which will increase system performance and maintainability (eg. you are faster in creating test environments then).

This archiving is part of Baan. No other software has to be bought, however, if you have modified software components you should check if the standard archiving routines will do or if you have to modify the archiving routines also (e.g. to archive additional tables).

For any other "archiving" - like storing data as "printout" on CD-Roms, microfilm..., Document Management Systems, whatever, additional Software (like a DMS, an interface) or services (like microfilming) will be required of course.

The Luminux/Baan Support Eye Tool mentioned is additional software that will help you analyze your system configuration. It doesn't do any archiving by it's own.

Uli

Some Baan Archiving Informations

http://www.dotcom-resources.com/news.htm

Juergen

Two questions ?

1 Does Baan have any limits on filesizes beyond which it wont function?

2 Having archived at say 4b2 and now on 4c4 what are the options to be able to review the data archived under 4b2 ?

Does Baan provide special programs for "upgrading" the archived data to 4c4 ?

Yes we are doing couple of Baan archiving projects. Let me know if you need something specific. Thanks.

maxdixit@yahoo.com

Frank,
the file size should be limited only by the database you use (if the database has a limit).

However, there is a semantic limit: You can run out of number: eg. you only have 999999 sales oder numbers. So you will have to archive if you produce many orders a day.

As long as 4b data is archived within another Baan company it may be converted the same way as you converted your operational data to c4.

Many thanks Ulrich !

With respect to sales /purchase order range I was told that on reaching 999999 it is possible to reset 3 digit code to 001 again as the previous record of 001 had a timestamp in the index with uniquly identified it . Is this correct ? but not the best practice ?

Also on the conversion of archive data from 4b to 4c I take it then that the Baan programs take into account tables that have been dropped during the original archiving process and do not "complain" about them when the archive data is upgraded.
Being sceptical , has someone proved this ?

Regards

The reseting of the number because of the time stamp is ok for warehouse order numbers series but not things like purchase orders /sales orders/ production orders these need to archived.

Check Baan document U7046AUS which you can download from www.support.baan.com

Originally posted by sasa888
Hi all, does anyone have experience in doing archiving in Baan IV with Oracle 7.3 in the back end? Where can I get more information about archiving, please help..........

sasa

please take a look at www.cofiba.de. Cofiba is a german consulting company and made a lot of work around archiving.

The main features are:

automatic initialisation for archive company
extensions for sales and purchase
export nearly every archived data to ascii and delete

The implmentation of archiving is very disapointing. Is there not a way to setup archiving rules for sessions and then run a batch process on a monthly basis to archive data based on the rules.

sasa888,

you can find information about archiving on my website.

I'm using an archive planning tool that checks the data on a system and automatically generates an archive plan and other information needed for archiving. I'm convinced it delivers the most efficient approach to archiving currently available.

Please find examples on www.maxsc.com. The tool did run on Baan 5 and Baan 4 systems and I've received very positive feedback from all clients who used it. I also offer all necessary add-on sessions for Baan 4 and Baan 5. Please find a list on the same website. You're welcome to contact me if you have any questions.

Karin Espelage