使用 CHCSVParser 通过邮件编辑器将核心数据导出到 csv(作者:Dave DeLong)

2023-12-12

我正在使用 CHCSVParser(由 Dave DeLong 编写)通过邮件编辑器将核心数据导出到 csv 中,但问题是它采用的是核心数据表名称而不是行值。

另外,我希望它们按特定顺序排列,例如“下水道号”、“人孔 1”、“人孔 2”

这是我正在使用的编码:

//从核心数据中取出数据

NSManagedObjectContext *moc = [self managedObjectContext];
NSEntityDescription *entityDescription = [NSEntityDescription
                                          entityForName:@"Input_Details" inManagedObjectContext:moc];
NSFetchRequest *request = [[NSFetchRequest alloc] init];


request.predicate = [NSPredicate predicateWithFormat:@"rs_Input_project.name = %@", self.projectObject.name];


[request setEntity:entityDescription];
request.resultType = NSDictionaryResultType;

NSSortDescriptor *sortDescriptor = [[NSSortDescriptor alloc] initWithKey:@"sewer_No" ascending:YES];
[request setSortDescriptors:@[sortDescriptor]];

NSError *error;

NSArray *fetchedObjects = [moc executeFetchRequest:request error:&error];



 //creating a csv CHCSVWriter
NSOutputStream *output = [NSOutputStream outputStreamToMemory];
CHCSVWriter *writer = [[CHCSVWriter alloc] initWithOutputStream:output encoding:NSUTF8StringEncoding delimiter:','];

for (id object in fetchedObjects)
{
    if ([object conformsToProtocol:@protocol(NSFastEnumeration)])
    {
        [writer writeLineOfFields:object];

    }
}

[writer closeStream];


NSData *buffer = [output propertyForKey:NSStreamDataWrittenToMemoryStreamKey];

NSString *string = [[NSString alloc] initWithData:buffer encoding:NSUTF8StringEncoding];

NSLog(@"Length of Buffer:%d Error:%@",[buffer length],[error localizedDescription]);

if ( [MFMailComposeViewController canSendMail] )
{


    MFMailComposeViewController *mailComposer = [[MFMailComposeViewController alloc] init];
    mailComposer.mailComposeDelegate = self;

    NSData *myData = [string dataUsingEncoding:NSUTF8StringEncoding];
    NSLog(@"myData csv:%@",myData);
     NSLog(@"string csv:%@",string);

// Fill out the email body text
    NSString *emailBody = @"Sewer_Output";
    [mailComposer setMessageBody:emailBody isHTML:NO];

    //attaching the data and naming it Sewer_Output
    [mailComposer addAttachmentData:myData  mimeType:@"text/cvs" fileName:@"Sewer_Output.csv"];

[self presentModalViewController:mailComposer animated:YES];
}

//creating a csv CHCSVWriter
NSOutputStream *output = [NSOutputStream outputStreamToMemory];
CHCSVWriter *writer = [[CHCSVWriter alloc] initWithOutputStream:output encoding:NSUTF8StringEncoding delimiter:','];
//wrting header name for csv file
[writer writeField:@"Line No"];
[writer writeField:@"Sewer No"];
[writer writeField:@"Manhole Up"];
[writer writeField:@"Manhole Down"];

[writer finishLine];



for (NSManagedObject *object in fetchedObjects)
{
    //getting the data from core data


    int line_no = [[object valueForKey:@"line_no"] intValue];
    int sewer_No = [[object valueForKey:@"sewer_No"] intValue];
    NSString *mh_Up=[object valueForKey:@"mh_Up"];
    NSString *mh_down=[object valueForKey:@"mh_down"];

        //writing that data to writer for csv file

        [writer writeField:[NSString stringWithFormat:@"%i",line_no]];
        [writer writeField:[NSString stringWithFormat:@"%i",sewer_No]];
        [writer writeField:[NSString stringWithFormat:@"%@",mh_Up]];
        [writer writeField:[NSString stringWithFormat:@"%@",mh_down]];

        [writer finishLine]; //finishing the writing of first row

}

[writer closeStream];


NSData *buffer = [output propertyForKey:NSStreamDataWrittenToMemoryStreamKey];

NSString *string = [[NSString alloc] initWithData:buffer encoding:NSUTF8StringEncoding];
//NSLog(@"string = %@",string);

Thanks

本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)

使用 CHCSVParser 通过邮件编辑器将核心数据导出到 csv(作者:Dave DeLong) 的相关文章

随机推荐