c# - "RPC Server is unavailable" when exporting Outlook contacts to CSV -


i exporting outlook contacts custom form csv specific contacts folder. folder not default location. large folder 7,000 contacts. shared mailbox in office 365, can't use outlook or graph apis because of custom data.

my code below works fine, except after iterating through 200-800 contacts, error: "rpc server unavailable. (exception hresult: 0x800706ba)."

i tried exporting folder .pst , accessing folder on local machine. result same. update: i've been watching outlook.exe in task manager, , steadily increases memory consumption around 300mb before crashing. i've tried same code on laptop running office 2010, , "out of memory" error.

i error whether outlook open or closed, closing outlook during program operation trigger error. outlook either starts (or restarts) following error. i've read number of posts , articles related error, i'm not sure what's going on. appreciated.

update: code has been updated use for loops instead of foreach loops per dmitry streblechenko's suggestion.

using system; using microsoft.office.interop.outlook; using system.text; using system.io; using system.runtime.interopservices;  namespace outlookcontacts {     class program     {         static void main(string[] args)         {             var encoding = encoding.utf8;             string csvpath = @"mycsvpath";             application outlook = new application();             namespace ns = outlook.getnamespace("mapi");             mapifolder sharedcontacts;             string recipientname = "myemail@mydomain";             stringbuilder headerrow = new stringbuilder();             recipient recip = ns.createrecipient(recipientname);             streamwriter writer = new streamwriter(csvpath, false, encoding);              recip.resolve();             if (recip.resolved)             {                 try                 {                     //entryid , storeid of folder                     sharedcontacts =                         ns.getfolderfromid(                             "myentryid",                             "mystoreid"                             );                     items contacts = sharedcontacts.items;                      //writing header row                     contactitem first = contacts.getfirst();                     var properties = first.itemproperties;                     for(int = 0; < properties.count; i++)                     {                         try                         {                             headerrow.append(string.format("\"{0}\",", properties[i].name));                         }                         catch (system.exception ex)                         {                             headerrow.append(string.format("{0},", ex.message));                         }                     }                     headerrow.appendline(environment.newline);                     writetocsv(writer, headerrow);                     console.writeline("header row written;");                     marshal.releasecomobject(properties);                     marshal.releasecomobject(first);                      //writing records                     (int = 1; <= contacts.count; i++)                     {                         object o = contacts[i];                         if (o contactitem)                         {                             contactitem contact = (contactitem)o;                             if (contact != null)                             {                                 console.write(contact.fullname);                                 stringbuilder datarow = new stringbuilder();                                 itemproperties contactprops = contact.itemproperties;                                 (int j = 0; j < contactprops.count; j++)                                 {                                     itemproperty property = contactprops[j];                                      try                                     {                                         if (property.value == null)                                         {                                             string value = "null,";                                             datarow.append(value);                                         }                                         //else if (property.name == "attachments")                                         //{                                         //    //attachment file names                                         //    string attachment = "";                                         //    (int k = 1; k < contact.attachments.count; k++)                                           //    {                                         //            attachment = (string.format("\"{0}\"; ", contact.attachments[k].filename));                                         //            datarow.append(attachment);                                         //    }                                         //    datarow.append(",");                                         //}                                         else                                         {                                             string value = property.value.tostring();                                             value = value.replace("\r\n\r\n\r\n", "\r\n")                                                 .replace("\r\n\r\n", "\r\n")                                                 .replace("\"", "'");                                             value = (string.format("\"{0}\",", value));                                             datarow.append(value);                                         }                                     }                                     catch (system.exception ex)                                     {                                         string value = string.format("{0}: {1},", property.name, ex.message);                                         datarow.append(value);                                     }                                      marshal.releasecomobject(property);                                 }                                 datarow.append(environment.newline);                                 writetocsv(writer, datarow);                                 marshal.releasecomobject(contactprops);                                 marshal.releasecomobject(contact);                             }                             marshal.releasecomobject(o);                             counter++;                             console.writeline(": written " + counter);                         }                     }                 }                 catch (system.exception ex)                 {                     console.writeline(datarow.tostring(), ex.message);                     console.readkey();                 }              }          }          static void writetocsv(streamwriter writer, stringbuilder row)         {             var data = row.tostring();             writer.writeasync(data);         }      } }

looks running out of rpc channels. need avoid using foreach loops (they tend keep collection members referenced until loop exits) , explicitly release com objects done them.

off top of head:

for(int = 1; <= contacts.count; i++) {     obejct o = contacts[i];     contactitem contact = o contactitem;     if (o != null)     {         itemproperties properties = contact.itemproperties;         stringbuilder newline = new stringbuilder();         (int j = 1; j <= properties.count; j++)         {             itemproperty property = properties[j];             var value = "";             if (property.value == null)             {                 value = "null,";                 console.writeline(value);                 newline.append(value);             }             else             {                 value =  property.value.tostring() + ",";                 newline.append(value);             }             marshal.releasecomobject(property);         }         newline.append(environment.newline);         writetocsv(writer, newline);         marshal.releasecomobject(properties);         marshal.releasecomobject(contact);     }     marshal.releasecomobject(o); }

Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more