mervinj82 wrote: ↑Tue Jan 18, 2022 2:55 pm
Guys thanmks for the table. Its much appreciated. So I'm trying to add Mist Echoes so I used (BAC5FF870F6ECEA3: Mist Echoes) in the values section but I keep getting and error saying... the value BAC5FF870F6ECEA3: Mist Echoes could not be parsed. Can anyone tell me what I'm doing wrong here. Thanks
How are you selecting it? Are you selecting directly from the drop-down? Or copy/paste?
CE is weird with its lists - You have to use the actual drop-down to select the option, otherwise it will not accept the value.
If you can provide a bit more of a description or screenshots, might be able to help troubleshoot further.
What I do is copy/paste from the excel, and then click the drop-down so it auto-selects what I've inputted, and then confirm it.
Note that the "Value for CE Drop-Down" has a slight error - its supposed to have a space before and after the colon
i.e. current setup = Hash:InternalName => Hash : InternalName (This threw me off for a while as well)
@SunBeam ^ - might be useful to know. Excel Formula I used: CONCATENATE(A2,CHAR(32),CHAR(58),CHAR(32),B2)
I use CHAR formula in case there is a read error and it can't evaluate (" : ") properly. An Excel habit I've picked up over my career.