I made a new plugin 'Data Map' that helps in preparing Excel sheets during migration. For example in ProductMigration.xls, the Raw Sheet needs to map to the Master Sheet, and the user needs to copy and paste and move columns around. To deal with thousands of records this can be slow and so i made a SynchMaster process to give visibility to the mapping progress and the magic Java code will synch it for you within seconds. The trick is to insert a top row and reference to the same cell in Master sheet.
Note the highlighted cell. They are not typed in, but by placing '=' and then go to the column header that you wish the content to be matched to.
After running this you will see the results magically done at the Master sheet:
Note again in the highlighted cell, I programmatically copied over a reference address. Hope you get the idea.
But before doing that, notice that i could split the Name column to populate the Value column, which was blank before. That is done by using this:
The SplitSymbol was a space.
The plugin is at http://bitbucket.org/red1/org.red1.map
Binary with 2Pack in https://sourceforge.net/projects/red1/f ... Migration/