import: file type issue on Mac OS Sierra

Started by richardh9935, 04 November 2016, 05:08:56

Previous topic - Next topic
A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

richardh9935

I have created a CSV file delimited by semi-colons and using double-quote marks for each field.  It is named with a .CSV extension.  However, when attempting to import, I cannot select the appropriate file.   I used the "choose file" button and my local file system appeared.  I navigated to the appropriate folder, but the CSV file was not selectable.  It was grey.

If I changed the file name extension to .TXT, the file became selectable.  However, the IMPORT procedure reported an error:
Error
The file must have the '.csv' extension

How can I overcome this?

richard.

A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

federica

Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
Informatizzati [url="https://informatizzati.org"]https://informatizzati.org[/url]
Stacca la spina [url="https://disconnessi.org"]https://disconnessi.org[/url]

richardh9935

Sorry, my mistake.

Mac OS File Manager has a filter called "modified file" which I didn't know had been turned On.  Once I turned that filter off, I could select the .csv file properly.


richard.

richardh9935

The anomaly was between (Safari) and (Chrome).  One view of the file uploader showed an extra option which enabled me to select the relevant file.

In the end, I retreated to creating multiple SQL INPUT INTO files.

(Could you please close this issue.)

A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9