- (void) fillLanguages {
    NSString *path = [[NSBundle mainBundle] pathForResource:@"langue" ofType:@"csv"];
    NSString * zStr =
    [NSString stringWithContentsOfFile:path
                              encoding:NSASCIIStringEncoding
                                 error:NULL];

    NSLog(@"zStr=%@", zStr);
    NSLog(@"path=%@", path);
    // extract the data line by line
    NSArray * zAryOfLines = [zStr componentsSeparatedByString:@"n"];
    if([zAryOfLines count] == 0) {
        NSLog(@"zAryOfLines count = 0");
        return;
    }

    for (NSString * zStrLine in zAryOfLines) {
        @autoreleasepool {
            NSLog(@"zStrLine=%@", zStrLine);
            NSArray *lines = [zStrLine componentsSeparatedByString:@";"];
            NSString *name = [lines objectAtIndex:0];
            [self insertLanguage:name];
        }
    }
}

- (void)insertLanguage:(NSString*)name {
    Language *language = [NSEntityDescription
                          insertNewObjectForEntityForName:@"Language"
                          inManagedObjectContext:_managedObjectContext];
    language.languageName = name;
    language.languageGrammar = [NSString stringWithFormat:@"Grammaire + %@", name];

    // inserting the words of this language
    [self insertLanguageWords:language];

    [_managedObjectContext refreshObject:language mergeChanges:YES];

}

- (void)insertLanguageWords:(Language *)language {
    NSString *lower = [[NSString stringWithString:language.languageName] lowercaseString];
    NSString *fileName = [NSString stringWithFormat:@"teere_%@", lower];

    NSString *path = [[NSBundle mainBundle] pathForResource:fileName ofType:@"csv"];
    NSString * zStr =
    [NSString stringWithContentsOfFile:path
                              encoding:NSASCIIStringEncoding
                                 error:NULL];

    NSLog(@"zStr=%@", zStr);
    NSLog(@"path=%@", path);
    // extract the data line by line
    NSArray * zAryOfLines = [zStr componentsSeparatedByString:@"n"];
    if([zAryOfLines count] == 0) {
        NSLog(@"zAryOfLines count = 0");
        return;
    }

    for (NSString * zStrLine in zAryOfLines) {
        @autoreleasepool {
            NSLog(@"zStrLine=%@", zStrLine);
            NSArray *lines = [zStrLine componentsSeparatedByString:@";"];
            Word *word = [NSEntityDescription
                          insertNewObjectForEntityForName:@"Word"
                          inManagedObjectContext:_managedObjectContext];
            if([lines count] > 1) {
                word.value = [lines objectAtIndex:0];
                word.frenchValue = [lines objectAtIndex:1];
            }
            else {
                word.value = @"n/a";
                word.frenchValue = @"n/a";
            }
            [language addWordsObject:word];

            [_managedObjectContext refreshObject:word mergeChanges:YES];
        }

    }
}