Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I'm glad you like it :)</p> <p>Basically, <code>CHCSVParser</code> <em>only</em> parses CSV files. You give it a path to a CSV file, and it'll give you back a whole bunch of <code>NSStrings</code>. What you do beyond that point is entirely up to you.</p> <p>So let's say you've included a CSV file in your iOS app called "Data.csv". Here's how you'd use <code>CHCSVParser</code> to parse it:</p> <pre><code>NSString *path = [[NSBundle mainBundle] pathForResource:@"Data" ofType:@"csv"]; NSError *error = nil; NSArray *rows = [NSArray arrayWithContentsOfCSVFile:path encoding:NSUTF8StringEncoding error:&amp;error]; if (rows == nil) { //something went wrong; log the error and exit NSLog(@"error parsing file: %@", error); return; } </code></pre> <p>At this point, <code>rows</code> is an array. Each element in <code>rows</code> is itself an array representing a single row in the CSV file. And each element of <em>that</em> array is an <code>NSString</code>.</p> <p>So let's say your CSV file looks like this:</p> <pre><code>Barringer,Arizona,United States,Earth "Chicxulub, Extinction Event Crater",,Mexico,Earth Tycho,,,Moon Lonar,Maharashtra,India,Earth </code></pre> <p>If you run it through the parser, you'll get back the equivalent of this:</p> <pre><code>[NSArray arrayWithObjects: [NSArray arrayWithObjects:@"Barringer",@"Arizona",@"United States",@"Earth",nil], [NSArray arrayWithObjects:@"Chicxulub, Extinction Event Crater",@"",@"Mexico",@"Earth",nil], [NSArray arrayWithObjects:@"Tycho",@"",@"",@"Moon",nil], [NSArray arrayWithObjects:@"Lonar",@"Maharashtra",@"India",@"Earth",nil], nil]; </code></pre> <p>What you do with it then is your business. The CSV parser doesn't know anything about <code>UITableView</code>, so you get to take this data and re-structure it in a way that you're comfortable dealing with and that fits in to your data model.</p> <p>Also, remember that by using <code>CHCSVParser</code>, you agree to abide <a href="https://github.com/davedelong/CHCSVParser/blob/master/LICENSE" rel="noreferrer">the terms under which it is made available</a>. :)</p>
    singulars
    1. This table or related slice is empty.
    1. POBasics Introduction To Using CHCSVParser
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDave DeLong
    1. USDave DeLong
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POBasics Introduction To Using CHCSVParser
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks, Dave, that helps a lot! So where is the best place to implement this method, into my table VC's `viewDidLoad` method? And the API automatically knows that when there is a `,` within two `""`, that that is all one string?
      singulars
      1. PO
      1. USJon
    2. CO@Jon That was a typo that I fixed. Re: best place? Inside a VC is a decent place to put it, I suppose. The best place to put it is something that depends entirely on your app. :)
      singulars
      1. PO
      1. USDave DeLong
    3. COThanks Dave. I tried doing it in ViewDidLoad but it takes forever for the app to open now. Do you have any other sugggestions? It works fine in simulator but on my device it takes like 30 sec for the app to open. I need this data to load the initial tableView.
      singulars
      1. PO
      1. USJon
 

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