KB Home \| Advanced Search \| News \| Ask Question
ProSoft Knowledge Base

Can I use Excel to create or edit CSV files for QuickServers or SlotServers?

Article Number: 592 | Rating: Unrated | Last Updated: Tue, Nov 3, 2015 at 6:34 PM

Yes, with some caveats. We have had customers report that Excel on an Apple OS created a CSV format which FieldServer products could not load. There also appear to be some special circumstances, such as when you tab, where Excel even in Windows will add quotation marks or other invisible characters which will cause the names fields to be treated differently than intended by FieldServer products. Excel will also frequently add extra commas, however, FieldServer's csv parser has been built to try to ignore these so they are usually not an issue. If you are concerned that Excel may be causing issues, we strongly recommend opening your CSV file in note pad, or a similar text editor, that should reveal any extra characters Excel may have added that you did not intend which you can then manually remove. You will want to be sure, however, to save your file with the csv extension and not txt.

Custom Fields

Attachments (0)

There are no attachments for this article.

Comments

There are no comments for this article. Be the first to post a comment.

What do the QuickServer LEDs indicate?

Viewed 1 times since Thu, Jul 17, 2014

How many Client and Server connections does the QuickServer’s Modbus TCP/IP driver support?

Viewed 1 times since Tue, Nov 3, 2015

How does field server modbus driver handle floats

Viewed 1 times since Mon, Aug 10, 2015

What steps should I take to diagnose a Fieldserver product?

Viewed 1 times since Wed, Aug 20, 2014