## import from csv with correct number of decimals

User, date | Message |
---|---|

Written by cath
4 years ago
Category: Import/Export 3 posts since Tue, 27 Apr 10 |
Hi, When I import a csv-file into a table in Heidi, a too low number of decimals is imported. In Excel, the value has 10 decimals of which only 2 are displayed. Heidi only takes these two, and not the last 8. Since it is a value that represents the date/time, I do need the other decimals. When all decimals are displayed in the csv-file, all decimals are loaded into Heidi correctly. I tried using decimal (5,10) instead of float (no format specified), but that doesn’t work. Should I better specify the column type somewhere, or is there an elegant way of importing this column correctly without having to adjust all my input files? Thanks, Cathelijne |

Written by ansgar
4 years ago
5010 posts since Fri, 07 Apr 06 |
I guess the Excel export has broken your numbers, but I'm unsure if I understand you right. Please post an extract of your CSV file, so this gets clearer. |

Written by cath
4 years ago
3 posts since Tue, 27 Apr 10 |
Right, found the solution myself by reading the decimal description better :S It should be decimal (15,10) instead of (5,10). Problem solved... :) |

Written by cath
4 years ago
3 posts since Tue, 27 Apr 10 |
Thanks anyway by the way! Oh, and float (15,10) also works for datatype (length/set). |

Please login to leave a reply, or register at first. |