1

I am new to Sequel Pro.

I am trying to import a csv file that has longitude and latitude coordinates, but when the "CSV Import Field Mapping" window shows up, DECIMAL/FLOAT/DOUBLE is not one of the datatypes I can choose in the pulldown menu. The only numeric datatypes I see are INT and BIGINT.

How do I import a file that has decimal numbers and set it as such in Sequel Pro?

Thanks.

Cinji18
  • 619
  • 8
  • 22

1 Answers1

0

I have the same problem with Sequel Pro 1.1.2. This isn't an ideal solution, but I imported my CSV files with TablePlus, which did the job adequately.

It's a free download. ‍♂

To reproduce the problem, click the "Export Data" link on this baseball website. Then import the downloaded CSV in Sequel Pro, selecting the option to create a new table. You'll (presumably) get the result posted in the images linked below, where DECIMAL/FLOAT/DOUBLE is not offered as an option for decimal fields in the downloaded data.

Baseball data to import

Sequel Pro does not offer DECIMAL/FLOAT/DOUBLE for OBP field, among others

double-beep
  • 5,031
  • 17
  • 33
  • 41
Ryan Hughes
  • 1
  • 4