search

Logiqx / wsw-tech

Technical tasks relating to Weymouth Speed Week
0 stars 0 forks source link

CSV Export from web site - Phone numbers #59

Closed nickjpovey closed 1 year ago

nickjpovey commented 1 year ago

Just logging something to watch.

When opening the CSV file Excel assumes the phone number is a number and strips off leading zeros and "+" from +44 and turns it into something to the power 11, it seems to do this per number as a number with a space e.g. 01342 825392 converts OK. Setting the cells after import doesn't help. Libre Office is easier as you can set that field to text rather than standard in the import interface and then everything is good. I expect Excel has the same - somewhere.....

P.S. I felt that it is appropriate for you to have phone numbers and email addresses of the competitors as you could well have good reason to contact them during the event.

nickjpovey commented 1 year ago

Phone numbers excluded from download.

If you need to contact a competitor then the front end edit option (only available to us) will show this data.