Databases
StackOverflow2013
Postsdbo
POCHCSVParser returns nil Array for valid filePath & valid csv file
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCHCSVParser returns nil Array for valid filePath & valid csv file
    primarykey
    data
    text
    <p>I am trying to parse a .csv file with approximately 30K lines. The following was mycode:</p> <pre><code>NSString *pathToGameLibrary = [[NSBundle mainBundle] pathForResource:@"GameLibrarySample" ofType:@"csv"]; NSArray *gameLibraryData = [NSArray arrayWithContentsOfCSVFile:pathToGameLibrary]; </code></pre> <p>At the end of this execution, gameLibraryData is nil.</p> <p>I can confirm that both the path and the csv file are valid because the following code spits out 30,000 lines of data to the console:</p> <pre><code>NSString *pathToGameLibrary = [[NSBundle mainBundle] pathForResource:@"GameLibrarySample" ofType:@"csv"]; NSString *fileString = [NSString stringWithContentsOfFile:pathToGameLibrary encoding:NSUTF8StringEncoding error:nil]; NSLog(@"%@", fileString); </code></pre> <p>Because this code does not work, I assume that the failure has to do with the length of the csv file. In an <a href="https://stackoverflow.com/questions/4636428/load-remote-csv-into-chcsvparser">earlier question</a>, CHCSV's author Dave DeLong suggests that:</p> <blockquote> <p>"If this is a very big file, then you'll want to alloc/init a CHCSVParser with the path to the local copy of the CSV file."</p> </blockquote> <p>So...I've tried to follow what <a href="https://stackoverflow.com/questions/4636428/load-remote-csv-into-chcsvparser">the original poster</a> attempted with this code:</p> <pre><code>NSString *pathToGameLibrary = [[NSBundle mainBundle] pathForResource:@"GameLibrarySample" ofType:@"csv"]; CHCSVParser *file = [[CHCSVParser alloc] initWithContentsOfCSVFile:pathToGameLibrary]; [file setDelegate:self]; </code></pre> <p>At which point the method callbacks which enable retrieval of data are:</p> <pre><code>- (void)parserDidBeginDocument:(CHCSVParser *)parser; - (void)parserDidEndDocument:(CHCSVParser *)parser; - (void)parser:(CHCSVParser *)parser didBeginLine:(NSUInteger)recordNumber; - (void)parser:(CHCSVParser *)parser didEndLine:(NSUInteger)recordNumber; - (void)parser:(CHCSVParser *)parser didReadField:(NSString *)field atIndex:(NSInteger)fieldIndex; - (void)parser:(CHCSVParser *)parser didReadComment:(NSString *)comment; - (void)parser:(CHCSVParser *)parser didFailWithError:(NSError *)error; </code></pre> <p>Thanks to yonosoytu for le assistance.</p> <p>On Topic Post-Edit Question: So what counts as a "very big file" anyway? At which point is it prudent to use delegation over the simple 'arrayWithContentsofCSVFile'?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USOneManBand
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COThe method name is just `setDelegate:`.
      singulars
      1. POCHCSVParser returns nil Array for valid filePath & valid csv file
      1. USyonosoytu
    2. COWell shucks, that's sort of embarrassing...thanks yono!
      singulars
      1. POCHCSVParser returns nil Array for valid filePath & valid csv file
      1. USOneManBand
    3. COI guess I"ll update the question with code that works..
      singulars
      1. POCHCSVParser returns nil Array for valid filePath & valid csv file
      1. USOneManBand
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload