Migration doesn't transfer 'reportermap' wizzzard configurations

[Nicklas Nordborg]

From the mailing list by Pawel Sztromwasser: ​http://www.mail-archive.com/basedb-users@lists.sourceforge.net/msg00962.html

The wizzard transfer works like this (when comes to mapping):

1. it parses mapping string from Base1 database using regular expression looking for (key:value) pairs separated by comma. Example part of a mapping string:

_r_block:1,_r_x:\"Column"\,_r_y:\"Row"\,reporterId:\"Probe_ID"\, 

2. it puts the (key,value) pairs into HashMap
3. and uses this map when configuring import plugin. When getting those values, it looks for certain keys ('numCol' and 'numRow' are among them, explicitly coded around lines 130 and 140 in WizzzardTransfer.java). When there is no value in HashMap it returns null, so null is passed to plugin configuration. Then it complains:

10:58:47,690 DEBUG WizzzardTransfer:281 - Setting parameter values 
for a reportermap-FormatType
10:58:47,690 DEBUG WizzzardTransfer:314 - 
net.sf.basedb.core.InvalidUseOfNullException: Invalid use of null.
The 'columnColumnMapping' value cannot be set to null.
10:58:47,690 DEBUG WizzzardTransfer:314 - 
net.sf.basedb.core.InvalidUseOfNullException: Invalid use of null.
The 'rowColumnMapping' value cannot be set to null.
10:58:47,690  WARN WizzzardTransfer:321 - The wizzard 
[11:Agilent test map format w/o block] could not be transfered

[Nicklas Nordborg]

BASE 1 seems to define three column mappings for this importer that are important in this case. Here is the list and the corresponding plug-in parameters for the BASE 2 importer

• _r_block --> blockColumnMapping
• _r_x --> columnColumnMapping
• _r_y --> rowColumnMapping

As for the other importers, all reporter column mappings except for the 'reporterId' should be ignored. Meta grid X/Y column mappings that are available in BASE 2 didn't exist in BASE 1 and should also be ignored.

[Nicklas Nordborg]

There is also a problem with complex column mappings. BASE 2 no longer accepts complex mappings by default. The parameter "complexExpressions" must be set to "allow".

[Nicklas Nordborg]

(In [4036]) Fixes #851: Migration doesn't transfer 'reportermap' wizzzard configurations