Data export is interrupted when a special character '&' is encountered

Question

question

yuan zhang asked Apr 20, '20 Benjamin W2 commented May 18, '20

Data export is interrupted when a special character '&' is encountered

Hi All,

One of our users had a problem that exporting global table data to MES (using a web interface).

Because the data in the cell has an '&' character, the export breaks and pops up an error:"JSON parameter format is wrong and an unterminated string is passed in."

Then they delete the character '&' , export is normal.We also tested exporting data with such special characters to Excel ,.it seems to be fine. But it really can't be displayed properly in a global table.

How to solve this problem?

Is there a similar situation with any other characters other than '&'?

Many thanks!

Software Version:

FlexSim 19.2.4

character exporting data

image00104-20-09-24-22.png (10.1 KiB)

image00204-20-09-24-22.png (5.4 KiB)

qq截图20200420095540.jpg (4.3 KiB)

qq截图20200420095509.jpg (3.9 KiB)

· 1

Benjamin W2 commented · May 18, 2020 at 05:25 PM

Hi @yuan zhang, was phil.bobo's answer helpful? If so, please click the red "Accept" button on their answer!

0 ·

Answer 1 · 2020-04-22T12:54:49Z

Phil BoBo answered Apr 22, '20 yuan zhang commented Apr 23, '20

What does "exporting global table data to MES (using a web interface)" mean exactly?

What are you doing to export the data? What commands are you using? What's generating the JSON data?

Ampersands are special characters in URLs, XML, and HTML. Whatever you are doing to export the data; you probably need to account for that.

This doesn't sound like a FlexSim problem. It sounds like a problem with the user's code that is doing the export or the MES import code.

The table view in FlexSim has always displayed ampersands that way. The ampersand is used to define access keys (mnemonics) on menu items. The Windows API command that the table uses to draw text also displays mnemonics this way. It is just a visual display bug that isn't going to affect your export at all; the stored data still has an ampersand in it. I can fix the display bug for the next bugfix release.

· 1

yuan zhang commented · Apr 23, 2020 at 12:46 AM

I'll relay it to our users.

Thanks a lot, Phil.

0 ·

question