In Kinetic browser, when I export a grid to excel, the Service Call Number has commas, even though the grid shows that it should not

Kinetic ERP
1

Hello,

Getting a bit frustrated with Kinetic ‘Export to Excel’.

I have a dashboard that contains the service call number.

When I export to excel, it adds a comma to it. EX: 8,222 instead of 8222.

It shows fine in the BAQ where the formatting is: >>>>>9

It shows fine in the dashboard grid.

How do I get it to export without adding the comma?

I tried converting the field to text and that fixed the comma issue.

Unfortunately, it caused the field to no longer be right clickable to send you directly to service call.

My only choices at this point:

  • INT field that shows commas on export to excel
  • nVarChar field where right click doesn’t work.

Is there another option that fixes both issues?

Any help on this is appreciated.

2

So I tried to replicate this and I can’t. When I remove the comma from an int field in a BAQ the comma is not included in my excel export. I didn’t even have to save my BAQ for the change to work. Perhaps there is an issue with Excel and how it interprets values?

If yours continues to be an issue, you could do both of your suggestions. Leave the Int field and add the text version of it. The text version of the field can be used in your Excel export, and the int version of the field can be used for your dashboards or whatever context menu needs you have.
Good luck!

EDIT Upon further testing I couldnt get the comma to show up in my excel export at all. So now I think it must be an Excel setting…

3

Curious if you have the same data settings as I do in Excel:

Capture23dwdsd
Capture23dwdsd882×705 94.9 KB

I don’t think it will help, but it is worth a look.

4

My version of excel has not been changed from default. It is excel 365.

Did you test on that or an older version?

Also, just to confirm, you didn’t just do a copy all and paste into excel, did you?

I use the three vertical dots, click ‘Export to exel’, and then save it to open.

Did you do the FSCallHd_CallNum?

5

I dont have that field available as we don’t use that feature. Perhaps it is an issue with that specific table. I did export to Excel with the three dots in the BAQ editor. I also tried the Export Selected Rows to Excel. I have Excel 365 on my desktop, not in the browser. I can’t ever get my export to include the commas! Gotta love that Epicor consistency!
season 6 legs GIF