BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Storing emails Goto page 1, 2, 3, 4  Next          BorlandTalk.com Forum Index -> Delphi Non-Technical View previous topic :: View next topic   Author Message Andrea Raimondi Guest Posted: Thu Jul 29, 2004 2:45 pm    Post subject: Storing emails Hello, I am writing an email client, well, it's a client - a bit more than email, but that's what I am facing right now - and I was wondering what format should I store retrieved emails in. I'm leaning towards this solution: I will store my emails into a Firebird database, built up with folder tables and everything, and then export them in XML when needed. Thing is, I wouldn't want to have to deal with plain text files, since they're unhandy especially under latest windows versions( on 2K, a 1K email takes up too much space ). I would then add a feature allowing for attachments be selected and compressed into a single ZIP file - which comes in handy. Comments? Insights? TIA, Andrew Back to top Xavier Pacheco Guest Posted: Thu Jul 29, 2004 3:13 pm    Post subject: Re: Storing emails Andrew, I use outlook because functionally it's awesome. What I hate about it is the way everything is a proprietary format. I use folders extensively and I would like to be able to simply have an email client that sat on top of the folder structure I have within Windows. I am reconsidering Thunderbird (tried it once), but I'm going to have to keep Outlook around for about 10 years since my life is contiained in it. . My thoughts. -- Xavier Pacheco President, Consultant Xapware Technologies Inc www.xapware.com --- Author - Delphi for .NET Developer's Guide http://www.amazon.com/exec/obidos/ASIN/0672324431/ Back to top Xavier Pacheco Guest Posted: Thu Jul 29, 2004 3:14 pm    Post subject: Re: Storing emails I really need to install the spell checker for my copy of Xananews. -- Xavier Pacheco President, Consultant Xapware Technologies Inc www.xapware.com --- Author - Delphi for .NET Developer's Guide http://www.amazon.com/exec/obidos/ASIN/0672324431/ Back to top Andrea Raimondi Guest Posted: Thu Jul 29, 2004 3:26 pm    Post subject: Re: Storing emails Xavier Pacheco wrote: Quote: Andrew, Hi Xavier :-) Quote: I use outlook because functionally it's awesome. What I hate about it is the way everything is a proprietary format. I use folders extensively and I would like to be able to simply have an email client that sat on top of the folder structure I have within Windows. Uhm... are you saying something like this? MAILFOLDER MAILFOLDERFROM MAILFOLDERFROMANDREARAIMONDI( collects all mails you received from me ) MAILFOLDERFROMALESSANDROFEDERICI( collects all mails you received from Alef ) MAILFOLDERFROMANDREARAIMONDIREPLIES( collects all mails you sent me in response ) Is this what you mean? Quote: I am reconsidering Thunderbird (tried it once), but I'm going to have to keep Outlook around for about 10 years since my life is contiained in it. . :-) Quote: My thoughts. Well appreciated :-) Andrew Back to top Xavier Pacheco Guest Posted: Thu Jul 29, 2004 3:31 pm    Post subject: Re: Storing emails I mean something like this: XMail XMailANDREARAIMONDI - all mails from you XMailALESSANDROFEDERICI - all from alex which get deleted automatically XapwareActiveFocus XapwareActiveFocusCustomers XapwareClients XapwareClientsClient1 XapwareClientsClient2 Xapware See, the problem is in outlook, I get an email with an attachment that I'd like to keep. Now, to try to manage the size of that !@#%^!^! .pst file, I have to create a copy of my folder structure in outlook to some directory on my hard drive. Then I have to put the attachment there and delete it from the email. However, I've not lost the reference. It's a mess in my opinion. If an email could just be file that could internally mainain a reference to other files (attachments, contacts, etc), if MS Outlook could do this it would be everything I need. Man, I hate that !@#%!@#%@# .pst file. !@#%!@^#%! Delphi would be a great tool to write something in (keep on topic here). -- Xavier Pacheco President, Consultant Xapware Technologies Inc www.xapware.com --- Author - Delphi for .NET Developer's Guide http://www.amazon.com/exec/obidos/ASIN/0672324431/ Back to top Xavier Pacheco Guest Posted: Thu Jul 29, 2004 3:34 pm    Post subject: Re: Storing emails Also, if email were NOT stored in some internal !@#$%^! database or !@#!Q!@ proprietary file, I could search through them using ZTreeWin my favorite windows GUI. - x -- Xavier Pacheco President, Consultant Xapware Technologies Inc www.xapware.com --- Author - Delphi for .NET Developer's Guide http://www.amazon.com/exec/obidos/ASIN/0672324431/ Back to top Leonel Guest Posted: Thu Jul 29, 2004 3:41 pm    Post subject: Re: Storing emails Xavier Pacheco wrote: Quote: I am reconsidering Thunderbird (tried it once), but I'm going to have to keep Outlook around for about 10 years since my life is contiained in it. . My emails were imported from Outlook Express by Mozilla very well. Not sure how Firefox handles Outlook, though. -- Leonel http://www.techtips.com.br Back to top eshipman Guest Posted: Thu Jul 29, 2004 3:48 pm    Post subject: Re: Storing emails In article <41090d22 (AT) newsgroups (DOT) borland.com>, [email]rainaple (AT) tin (DOT) it[/email] says... Quote: Hello, I am writing an email client, well, it's a client - a bit more than email, but that's what I am facing right now - and I was wondering what format should I store retrieved emails in. SNIP Think very seriously about Structured Storage instead. Back to top Leonel Guest Posted: Thu Jul 29, 2004 3:51 pm    Post subject: Re: Storing emails Andrea Raimondi wrote: Quote: I am writing an email client, well, it's a client - a bit more than email, but that's what I am facing right now - and I was wondering what format should I store retrieved emails in. There's a standart format to store emails in. Comes from UNIX, and it's called mbox, IIRC. -- Leonel http://www.techtips.com.br Back to top G. Allen Casteran Guest Posted: Thu Jul 29, 2004 4:19 pm    Post subject: Re: Storing emails In article <41091860$1 (AT) newsgroups (DOT) borland.com>, [email]xavier (AT) _nospam_xapware (DOT) com[/email] says... Quote: I mean something like this: XMail XMailANDREARAIMONDI - all mails from you XMailALESSANDROFEDERICI - all from alex which get deleted automatically ROFL. Poor Alex. I'll bet he wishes Peck was back here to be our whipping boy again! Allen. Back to top dsiders Guest Posted: Thu Jul 29, 2004 4:20 pm    Post subject: Re: Storing emails Quote: what I am facing right now - and I was wondering what format should I store retrieved emails in. There's a standart format to store emails in. Comes from UNIX, and it's called mbox, IIRC. There are many: mbox, mbx, pst, dbx, mh, ms, etc. You might want to look at maildir format, too. Back to top G. Allen Casteran Guest Posted: Thu Jul 29, 2004 4:22 pm    Post subject: Re: Storing emails In article <41091cea (AT) newsgroups (DOT) borland.com>, togniolli. @.techtips.com.br says... Quote: Andrea Raimondi wrote: I am writing an email client, well, it's a client - a bit more than email, but that's what I am facing right now - and I was wondering what format should I store retrieved emails in. There's a standart format to store emails in. Comes from UNIX, and it's called mbox, IIRC. There is no need to use the mbox format unless one needs R/W compat with sendmail. From a Win client standpoint anything would work. As Xavier pointed out the main problem is being able to quickly locate messages and attachments without bloating the PST file or Exchange server. We have pondered this same concept for some time now, since so many sites are finding that Exchange crash probability increases exponentially with the size of the Exchange DB. Allen. Back to top Andrea Raimondi Guest Posted: Thu Jul 29, 2004 4:36 pm    Post subject: Re: Storing emails G. Allen Casteran wrote: Quote: As Xavier pointed out the main problem is being able to quickly locate messages and attachments without bloating the PST file or Exchange server. Hi, I mailed Xavier privately with an idea which may solve this elegantly and in a very powerful way. I'm waiting for an answer and when the thing is going to be developed( I already found the bits I was missing, I guess ), I'll come back here explaining what I thought. Quote: Allen. Andrew Back to top Andrea Raimondi Guest Posted: Thu Jul 29, 2004 5:41 pm    Post subject: Re: Storing emails Leonel wrote: Quote: There's a standart format to store emails in. Comes from UNIX, and it's called mbox, IIRC. Hi Leonel, While I'm generally favourable to standards, I really beleive that their use should always be evaluated on a per-standard basis. The one you're referring to is just *a bit* old( 1982 ) and Unix has rarely been used in the past for the kind of messages I beleive are now being sent back and forth the Internet. With Linux coming over, I guess there will be( or should be ) an update of such standard. Anyway, I prolly found a good method for this stuff, I'm investigating... Andrew Back to top Xavier Pacheco Guest Posted: Thu Jul 29, 2004 6:46 pm    Post subject: Re: Storing emails Ok, so I have to admit that I know diddly about email format and so forth. But, this thread got me looking into email formats a bit, only enough to confuse me to no end. So, I see that there's mbox and mdir formats. But most of what I read refers email servers. What the heck do I care about email servers? All I want is to download an my pop email and that my client stores it as plain text format on my HD. Ideally, if I create an email folder structure in my email client, I'd like that this structure is exactly the same on my HD and that email are stored as such. Anybody know of such a beast? -- x -- Xavier Pacheco President, Consultant Xapware Technologies Inc www.xapware.com --- Author - Delphi for .NET Developer's Guide http://www.amazon.com/exec/obidos/ASIN/0672324431/ Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Non-Technical All times are GMT Goto page 1, 2, 3, 4  Next Page 1 of 4   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.