Answers.Body: <p>This is very difficult to answer without sample data.  Your data may contain carriage returns, or not escape quotation marks properly.  However, if you can't safely share the data, here are some troubleshooting steps:</p>
  
  <ul>
  <li>Try uploading to a demo server (demo.civicrm.org) to ensure you're seeing the same problem.</li>
  <li>Most likely, some lines work and some don't.  Take just the first three lines.  Which import, which don't?  Is there any change from adding/removing lines?  What do the lines that don't import have in common?</li>
  <li>Most importantly - view the data in a regular text editor, not just a spreadsheet app.  The spreadsheet app may be hiding some irregularity that's obvious when viewing the data in a text editor.</li>
  </ul>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-28T17:25:56.703Z
Answers.Text: Shouldn't each record be a separate line?  When I changed the file extension from "csv" to "txt" and opened it with notepad, it appeared to be a continuous block of text without apparent separate lines.  Invisible encoding?  csv files were exported as text from MS Access.  Edit: Sorry, my mistake.  I hit word wrap and the ends of lines became observable.
Answers.UserDisplayName: JohnHj
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-29T13:29:23.803Z
Answers.Text: Yes, each record should be a separate line.  I should have been clearer - there may be carriage returns in the data itself.  For instance, if you're importing a "Notes" field, someone may have put a carriage return in the notes.  Also - notepad does some naughty things that hides the true nature of your data.  I recommend installing Notepad++ to view your data as a text file!
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-26T04:50:03.600Z
Answers.LastActivityDate: 2016-02-26T04:50:03.600Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I have a contacts.csv file with 4330 records.  On importing, CiviCRM reports that the file has 1866 records.  Separating the file into three files yields proportionately similar results.  Why the miscount?</p>
  
Tags: <import>
Title: ignored import file lines
ThreadText: # ignored import file lines
  
  (Asked by: username_0 on 2016-02-26)
  
  I have a contacts.csv file with 4330 records. On importing, CiviCRM reports that the file has 1866 records. Separating the file into three files yields proportionately similar results. Why the miscount?
  
  **Tags:** import
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-02-26. Score: 3
  
  This is very difficult to answer without sample data. Your data may contain carriage returns, or not escape quotation marks properly. However, if you can't safely share the data, here are some troubleshooting steps:
  
  * Try uploading to a demo server (demo.civicrm.org) to ensure you're seeing the same problem.
  * Most likely, some lines work and some don't. Take just the first three lines. Which import, which don't? Is there any change from adding/removing lines? What do the lines that don't import have in common?
  * Most importantly - view the data in a regular text editor, not just a spreadsheet app. The spreadsheet app may be hiding some irregularity that's obvious when viewing the data in a text editor.
  
  > **Comments:**
  > **username_0**: Shouldn't each record be a separate line?  When I changed the file extension from "csv" to "txt" and opened it with notepad, it appeared to be a continuous block of text without apparent separate lines.  Invisible encoding?  csv files were exported as text from MS Access.  Edit: Sorry, my mistake.  I hit word wrap and the ends of lines became observable.  
  > **username_1**: Yes, each record should be a separate line.  I should have been clearer - there may be carriage returns in the data itself.  For instance, if you're importing a "Notes" field, someone may have put a carriage return in the notes.  Also - notepad does some naughty things that hides the true nature of your data.  I recommend installing Notepad++ to view your data as a text file!  
  
  ---
  
  