search

magicbug / Cloudlog

Web based amateur radio logging application built using PHP & MySQL supports general station logging tasks from HF to Microwave with supporting applications to support CAT control.
http://www.cloudlog.co.uk
MIT License
460 stars 190 forks source link

QSL Request CSV contains unicode characters which MS Excel/MS Word doesn't like! #2453

Closed m1geo closed 1 year ago

m1geo commented 1 year ago

The Export to CSV button generates CSV that includes "Ø" characters which aren't correctly handled by Microsoft Excel/Word for using in mail merges.

image

I know that Word does support these, but it gets broken when opened. Not sure if you can add some metadata or make this an option during the export.

image

Looking at the same QSOs in the ADIF shows a standard ASCII "0" character:

image

Just in case there is a way to make this import work better :)

Thanks for the great work, George, M1GEO. sk sk.

phl0 commented 1 year ago

Fix proposed in https://github.com/magicbug/Cloudlog/pull/2454.

magicbug commented 1 year ago

Looks a good fix to me, merged into the dev branch

magicbug commented 1 year ago

This code is now in the master branch so @m1geo should be able to use and test it easily.