0

I need the ability pull in a column from a spreadsheet more than once.  The column is a numeric field and I want to bring it into an entity twice.  Once column “A” will be a string result, while column “B” will be an integer result.  Yes the same value, but used in two different ways in a data grid.  I want to be able to provide the ability to search/filter on the string “A” so that the input of “20” through “Contains” could result in the final results: 20 120 200 201 207 220 420 720 1020   Then I want to use “B” to sort so that following store sort in numeric order versus text order: Standard Numeric Ordering 1 2 3 6 8 10 11 23 26 27 30 33 36 40 41 45 51 52   Sorted as if text not numbers 1 10 100 2 23 26 27 3 30 33 36 40 41 45 51 52 6 8   So I’ve set my template up like this: I get the error stack trace: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: replication.ReplicationSettings$MendixReplicationRuntimeException: This column alias: 0 already exists in this configuration | VERSION: Mx5_20161013 at com.mendix.basis.component.InternalCoreBase.execute(InternalCoreBase.java:383) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: replication.ReplicationSettings$MendixReplicationRuntimeException: This column alias: 0 already exists in this configuration | VERSION: Mx5_20161013 at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:155) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: replication.ReplicationSettings$MendixReplicationRuntimeException: This column alias: 0 already exists in this configuration | VERSION: Mx5_20161013 at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36) Caused by: com.mendix.core.CoreException: replication.ReplicationSettings$MendixReplicationRuntimeException: This column alias: 0 already exists in this configuration | VERSION: Mx5_20161013 at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:129) Caused by: replication.ReplicationSettings$MendixReplicationRuntimeException: This column alias: 0 already exists in this configuration | VERSION: Mx5_20161013 at replication.ReplicationSettings.addMappingForAttribute(ReplicationSettings.java:579) at excelimporter.reader.readers.replication.ExcelReplicationSettings.addColumnMapping(ExcelReplicationSettings.java:19) at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:281) at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:120) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:54) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:25) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:54) at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:146) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:151) at com.mendix.basis.component.InternalCoreBase.execute(InternalCoreBase.java:379) at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:53) at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:201) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:54) at com.mendix.basis.actionmanagement.DefaultActionMonitor$.$anonfun$run$1(CustomMonitoredAction.scala:18) at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.basis.actionmanagement.IMonitoredAction.monitor(IMonitoredAction.scala:49) at com.mendix.basis.actionmanagement.IMonitoredAction.monitor$(IMonitoredAction.scala:25) at com.mendix.basis.actionmanagement.CustomMonitoredAction.monitor(CustomMonitoredAction.scala:22) at com.mendix.basis.actionmanagement.DefaultActionMonitor$.run(CustomMonitoredAction.scala:18) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.runMonitoredAction(CoreActionHandlerImpl.scala:60) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:47) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:54) at com.mendix.basis.actionmanagement.ActionManager.$anonfun$execute$1(ActionManager.scala:106) at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:658) at scala.util.Success.$anonfun$map$1(Try.scala:255) at scala.util.Success.map(Try.scala:213) at scala.concurrent.Future.$anonfun$map$1(Future.scala:292) at scala.concurrent.impl.Promise.liftedTree1$1(Promise.scala:33) at scala.concurrent.impl.Promise.$anonfun$transform$1(Promise.scala:33) at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:64) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:834)   It doesn’t appear to let me do the column twice.  What shall I do? FYI, I’m using 8.2.2. Regards,  Keith

asked 2019-10-23

2 answers