Hi all,
Until now, our migration process consisted of:
1. Using an existing LSMB 1.2 to 1.5 or Sql-Ledger 2.8 or 3.0 database
2. Applying a specific migration script, with various fix
possibilities using specific forms
3. Obtaining a dataset that can be pushed into the latest LedgerSMB
schema or failing completely.
During the last week, Erik and I have been working on adding different
edit, update, insert, cancel and override possibilities for the
migration forms, in order to ease migration and try to prevent returning
the user to his old application to fix data.
Now, some of those fixing forms are specific to each migration but some
are more general and should probably fit better in a new sanitization
step, to be inserted between steps 2 and 3 above.
This would
* benefit all previous versions
* prevent entering bad data in the database for which we do or not
have means to fix
* provide a diagnostic of the database to the owner. Such report could
also be generated on demand through the admin application.
* allow for more complex checks than was is strictly required by
migration.
This is a change from the actual process for which your input would be
welcomed.
Yves
