Dear Gretl users, when importing the attached csv file on windows 7 64bit (German localization) into gretl, it says that the first element in variable 1 (female) is empty. But it is not. See also below the Gretl console output.

Hi sven, thanks for your efforts. Sorry for not putting the Gretl version. It is gretl-1.9.14-64 A bit more background knowledge: I became aware of this issue only when I gave Gretl assignments to my students. I generated CSV-files like the one I posted earlier with R and I suppose the encoding is UTF8. Some of my students then had other results than I had with R or Gretl. Then I figured out with one studente that the CSV file was not imported correctly as I described earlier (I dont know which windows version he had). I went to my virtual machine with Windows 7 64 Bit and Gretl 1.9.14-64 and I could replicate the problem. I suppose my students have the same gretl version because I told them to download the latest release. Could it be possible that the source of the problem is the encoding? If so, which encoding do you recommend such that there is no issue on any platform (in particular both Mac and Windows?) I have over 150 students and it would be very important for me to resolve this issue. Many thanks in advance, Dominik On 12/21/2013 03:07 PM, Sven Schreiber wrote: > > > Am 21.12.2013 13:55, schrieb Dominik Menno: >> Dear Gretl users, >> >> when importing the attached csv file on windows 7 64bit (German >> localization) into gretl, it says that the first element in variable 1 >> (female) is empty. But it is not. See also below the Gretl console output. >> > > Cannot reproduce this on 32-bit Windows / German. Which gretl version? > > cheers, > sven > > _______________________________________________ > Gretl-users mailing list > Gretl-users(a)lists.wfu.edu > http://lists.wfu.edu/mailman/listinfo/gretl-users >

Am 23.12.2013 20:57, schrieb Dominik Menno: > Dear Gretl users, > > sorry for bothering you. I found it out myself; I guess it is an issue > of portability between operation systems (in particular Linux to > windows) and with file encoding/line endings of text files. That's actually what I had thought first, but... > > Here in particular, it was the file ending of the csv-files that caused > the problem. I now generate the CSV file so that it has the windows file > ending (encoding is now ASCII/CRLF), see attached file. your earlier file also had the Windows line endings (CRLF), so it seemed that that was not the issue.

In any case, I was under the impression that gretl would import/accept text files regardless of the platform-specific line endings. (not 100% sure though)

So there may still be something there, perhaps also specific to the experimental 64-bit version of gretl on Win that you're using apparently.

Could you try the precise file you sent to the list first (re-grab it from the message attachment) if it really works?

Hi Sven and Allin, thanks for your help. The original file I attached to the first mail had the unix type of line ending (is this plain??). So I did as you suggested and the error remains under windows 64bit. Here is the gretl output: parsing E:\CollegeDistOrigin.csv... using delimiter ',' longest line: 100 characters first field: 'female' number of columns = 14 number of variables: 14 number of non-blank lines: 342 scanning for variable names... line: female,black,hispanic,bytest,dadcoll,momcoll,ownhome,urban,cue80,stwmfg80,dist,tuition,ed,incomehi scanning for row labels and data... the cell for variable 1, obs 1 is empty: treating as missing value treating these as undated data Again, as I said if I generate the CSV file with CRLF file ending, the error disappears under Windows. I can import the file both under windows and under Linux without error message.

Dear Gretl users, when importing the attached csv file on windows 7 64bit (German localization) into gretl, it says that the first element in variable 1 (female) is empty. But it is not. See also below the Gretl console output. When importing into Gretl under Linux (ubuntu 12.04 64bit), everything works fine, the file is imported without problems. Does anybody know why this behavior might occur? Thank you and Best, Dominik Here is the Gretl console output: gretl console: type 'help' for a list of commands ? open C:\Users\dmenno\Downloads\CollegeDist.csv parsing C:\Users\dmenno\Downloads\CollegeDist.csv... using delimiter ',' longest line: 100 characters first field: 'female' number of columns = 14 number of variables: 14 number of non-blank lines: 342 scanning for variable names... line: female,black,hispanic,bytest,dadcoll,momcoll,ownhome,urban,cue80,stwmfg80,dist,tuition,ed,incomehi scanning for row labels and data... the cell for variable 1, obs 1 is empty: treating as missing value treating these as undated data _______________________________________________ Gretl-users mailing list Gretl-users(a)lists.wfu.edu http://lists.wfu.edu/mailman/listinfo/gretl-users