C / C++ / MFC

6-Sep-06 21:36

Hi all,

I am working on an e-mail client application

I've planned to store every email as *.eml file in the user's appropriate folder (physically created folder like Inbox, Sent Items etc) in HDD
and keeps an *.MDB (CDaodatabase) with fields like
folder, from, to, subject, emlfilepath, emlfilename
So I can query the DB for fast retrieval and when user click/select a mail than open
the eml file and show the mail content on the preview pane

Is this a right way for the e-mail client storage OR any suggestions appreciated

-- modified at 6:06 Wednesday 27th September, 2006

Waldermort6-Sep-06 22:30

Waldermort

6-Sep-06 22:30

Your idea is not very secure. Keeping emails on the HD like that leaves them wide open for people to read. I suggest you implement some sort of encryption. Also, as a user, I would not like individual emails to be stored in this way (even if they are encrypted). It shows people how many emails I have, and roughly when I recieved them, again not very secure.

What I would like though, an encrypted container. Take a look at 'Jetico Bestcrypt'; or a form of password protect filesystem. Either of these would make it easy for you to store .eml files, and keep it secure.

kanitamildasan6-Sep-06 23:52

6-Sep-06 23:52

waldermort, thanks for the point

I’ll lookout for encrypting the mails

If performance concerned, Is it ok to go with MDB/*.eml(encrypted)OR with single custom database file format like outlook express

thanks in advance

Rob Caldecott7-Sep-06 0:17

Rob Caldecott

7-Sep-06 0:17

I have written an email client and I stored files in mbox format - each "folder" consists of a single file, which is plain text and contains all the email messages delimited with "From - date". I maintain a separate binary index file for each "folder" that contains a list of messages and their position in the main mbox file (and other useful information such as the message size, common header fields like To, From, Subject, etc.). This isn't too far away from how Mozilla Thunderbird works.

kanitamildasan7-Sep-06 0:42

7-Sep-06 0:42

thanks robert

Robert Edward Caldecott wrote:
each "folder" consists of a single file, which is plain text and contains all the email messages delimited with "From - date". I maintain a separate binary index file for each "folder" that contains a list of messages and their position in the main mbox file

But we have to write our own parser(non buggy) for the Index and Mail file
I hope SQL queries in MDB gives more customizable(and faster) filters than our own file format

Robert Edward Caldecott wrote:
This isn't too far away from how Mozilla Thunderbird works.

If MDB is not the right way to go Is there any Component/Library which handles the parsing for me ?

thanks again

kanitamildasan7-Sep-06 19:07

saving particular data in txt file [modified]

7-Sep-06 19:07

Is there any MDB data VS (MS)XML data parsing/query/filtering performance review on the net ?

With_problem6-Sep-06 21:34

With_problem

6-Sep-06 21:34

I want to save only three 1)EURUSD,2)USDJPY,3)GBPUSD
market data coming from remote server in a txt file .But in this code all the market data are saved.How to save only paricular data.
I have write a comment line before 'if' statement where i have problem for this.

<br />
void CWartz_newDlg::OnPriceChangeArielapictrl1(LPCTSTR SessionId, LPCTSTR RequestId, short MarketNo, LPCTSTR Market, LPCTSTR Bid, short BidDirection, LPCTSTR Ask, short AskDirection, LPCTSTR High, LPCTSTR Low, short MarketState, LPCTSTR Timestamp) <br />
{<br />
	// TODO: Add your control notification handler code here<br />
<br />
<br />
	sessionid=SessionId;<br />
	CurrentRequestId=RequestId;<br />
	CString MarketSt,a,b,c,d;<br />
<br />
	a.Format("%d",MarketNo);<br />
	b.Format("%c",BidDirection);<br />
	c.Format("%c",AskDirection);<br />
	iMarketNo=MarketNo;<br />
	aMarketNo.Add(MarketNo);<br />
     <br />
	d.Format("%d",MarketState);<br />
<br />
	m_MainEdit=m_MainEdit + "<Price Change>" + SessionId + "\t" + RequestId +"\t"+ a ; <br />
	m_MainEdit=m_MainEdit + "\t"+ Market + "\t" + Bid + "\t" + b + "\t"+ Ask + "\t" +c +"\t"+ High + "\t";<br />
	m_MainEdit=m_MainEdit + Low + "\t" + d +"\t" + Timestamp + "\r\n";<br />
<br />
     UpdateData(FALSE);<br />
	iLineCount=m_EditCtrl.GetLineCount();<br />
	m_EditCtrl.LineScroll(iLineCount);<br />
<br />
          <br />
//  All the market data is saving<br />
// i only want to save EURUSD market data to be saved in txt file not all<br />
           <br />
          	<br />
	if(Market="EURUSD",myfile.Open("EurUsd.txt",CFile.modeCreate | CFile.modeWrite))<br />
	{<br />
      <br />
	LPSTR buf;<br />
	  int i = m_MainEdit.GetLength();<br />
	 buf = m_MainEdit.GetBuffer(i);<br />
	 myfile.Write(buf,i);<br />
	 myfile.Close();<br />
	}<br />
}<br />

And like this way i have to make three txt file:

1)EURUSD.txt
2)USDJPY.txt
3)GBPUSD.txt

Thanks. Pls help me

-- modified at 4:51 Thursday 7th September, 2006

Rinu_Raj6-Sep-06 21:57

Rinu_Raj

6-Sep-06 21:57

Pls use the below code......
CString csMarket = "EURUSD";
if( csMarket == Market )
{
myfile.Open("EurUsd.txt",CFile.modeCreate | CFile.modeWrite));
LPSTR buf;
int i = m_MainEdit.GetLength();
buf = m_MainEdit.GetBuffer(i);
myfile.Write(buf,i);
myfile.Close();
}

With_problem6-Sep-06 22:07

With_problem

6-Sep-06 22:07

Sorry it is also saving all market detail.Do you have any other idea

Hamid_RT6-Sep-06 22:32

Hamid_RT

6-Sep-06 22:32

maybe EURUSD is in all your data

WhiteSky

With_problem6-Sep-06 22:47

With_problem

6-Sep-06 22:47

No it is market name and for these whenever change in data in server side it will come.It is not in all.
I want to make three .txt file

1)EURUSD
2)USDJPY
3)GBPUSD
Thanks

Hamid_RT7-Sep-06 0:47

Hamid_RT

7-Sep-06 0:47

if you run this line if(Market=="EURUSD")
whats happening?did you trace line to line your program?

WhiteSky

David Crow7-Sep-06 4:19

David Crow

7-Sep-06 4:19

WhiteSky wrote:
if you run this line if(Market=="EURUSD")
whats happening?

The condition will never evaluate to TRUE.

"Talent without discipline is like an octopus on roller skates. There's plenty of movement, but you never know if it's going to be forward, backwards, or sideways." - H. Jackson Brown, Jr.

"Judge not by the eye but by the heart." - Native American Proverb

David Crow7-Sep-06 4:17

David Crow

7-Sep-06 4:17

abrakadbra wrote:
Sorry it is also saving all market detail.Do you have any other idea

So have you bothered to set a breakpoint on the if(csMarket == Market) statement to check the value of Market? It may surprise you to find it is always equal to EURUSD.