question

yuan zhang avatar image
0 Likes"
yuan zhang asked Benjamin W2 commented

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!

FlexSim 19.2.4
characterexporting 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
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Benjamin W2 avatar image Benjamin W2 commented ·

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

0 Likes 0 ·

1 Answer

Phil BoBo avatar image
1 Like"
Phil BoBo answered yuan zhang commented

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
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

yuan zhang avatar image yuan zhang commented ·

I'll relay it to our users.

Thanks a lot, Phil.

0 Likes 0 ·