Empirisoft Support

    Welcome to Empirisoft Support
Results 1 to 5 of 5

Thread: File not loaded completely (.csv file format)

  1. #1
    Join Date
    Nov 2005
    Posts
    3,320

    File not loaded completely (.csv file format)

    [edited from support email]
    For some reason not all of the data from the last questionnaire is being loaded into the Excel file. When I open the file the computer inform that " File not loaded completely ", and indeed, the last 6 or 7 answers are missing. This happens only to the excel file and not to the txt. The relevant excel and txt files are attached.

  2. #2
    Join Date
    Nov 2005
    Posts
    3,320
    First, be assured that the data are there. If you can not access them then it is likely that your version of Excel is limited to reading in 255 variables. That happens to include all versions of Excel prior to version 2007. You can test this yourself by opening the .csv file in a text editor rather than in Excel. So, how do you access the remaining data if you do not have Excel 2007 or later?

    Some things to try:

    1. Excel v2007 (clever, no?)

    2. Using the SPSS native .SAV data file that ought to be located in your byVariableName data folder. SPSS has no problem with big data files.

    3. With a little effort, you can import the .csv file into SPSS like this:

    Rename the file from .csv to .txt. Then, in SPSS, select:
    Code:
    File > New > Data
    File > Open
    Files of type > Tab-delimited (*.dat,*.txt)
    File name <select your file>
    Predefined format? No
    Delimited? Yes
    Variable names at top? Yes
    First case = Line 2
    Each line represents a case? Yes
    All of the cases? Yes
    Delimiter? Comma (uncheck all others)
    Finish

    Again, if you have any trouble reading in the data, you can always look at the data directly in any text editor. If the file is especially large and difficult to read in its raw form, try a powerful free text editor like PSPad from www.pspad.com.
    Last edited by jarvis24; 05-31-2007 at 06:16 AM.

  3. #3
    Join Date
    Nov 2005
    Posts
    3,320
    Related support email:

    When we go to look at our Excel data file, we are finding that there are not enough columns to contain all of our items/response options. The columns stop at IV in Excel. We would prefer not to have to start another experiment with the subject – we’d like it to be seamless, if possible. Do you know of a solution? We would prefer a solution that would allow it to be a seamless experience for the subject and that would allow us to easily combine the data into a single Excel and/or SPSS file. We tried using the SPSS syntax but only got the variable names to import, not the data itself.
    See above. See also www.empirisoft.com/medialab/help/data.htm

  4. #4
    Join Date
    Jan 2009
    Posts
    3

    File not loaded completely (.csv. file format)

    If you don't have access to Excel v2007 - download OpenOffice 3.1.0 - this is a free open source office-like program. Their spreadsheet program handles larger matrices - I was having the same problem and this worked for me!

    Cheers,
    Shelly

  5. #5
    Join Date
    Aug 2011
    Posts
    3
    Thanks to shelfitz. I don't have Excel v2007, but i have the following question, what os OpenOffice 3.1.0 is running on? or it doesn't make any difference?
    Thanks.
    Last edited by fredd; 06-20-2012 at 08:15 AM.

Similar Threads

  1. 3050 couldn't lock file
    By car in forum MediaLab Older Versions: Troubleshooting
    Replies: 5
    Last Post: 10-19-2006, 11:25 AM
  2. audio file
    By Jessica in forum MediaLab Older Versions: How Do I...
    Replies: 1
    Last Post: 08-17-2006, 05:07 PM
  3. Sound file not playing
    By jarvis24 in forum DirectRT Older Versions: Troubleshooting
    Replies: 5
    Last Post: 06-29-2006, 05:31 AM
  4. Style file settings not being applied
    By jarvis24 in forum DirectRT Older Versions: Troubleshooting
    Replies: 1
    Last Post: 02-21-2006, 06:46 AM
  5. File limits in MediaLab
    By jarvis24 in forum MediaLab Older Versions: How Do I...
    Replies: 1
    Last Post: 11-17-2005, 01:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •