Weird Question with Email

[JoeShmoe]

LOL, well I'm sorry. I used to doze off in the classes that were for C++ and C Sharp.


Nerd faces

[Blackcrow64]

Originally Posted by JoeShmoe

LOL, well I'm sorry. I used to doze off in the classes that were for C++ and C Sharp.


Nerd faces

Sounds like pure jealousy to me. lol...

I used to doze off too, but that's because they went so slow and made it so boring. It isn't brain surgery. lol...

Actually, it has been so long since I've done any of that now that I would probably have a hard time with the coding...

I need to get back in shape on that stuff and see if I can't get a job doing it, cause it was simple...

[david-b]

Databases are easy. I don't use Access or anything when it comes to that. Good old command prompt editors FTW, such as Putty. Also most web server providers offer a mySQL manager of some sort which is more visually pleasing. It's more fun to me to sit there and type out something like this:

Originally Posted by The Dave

CREATE TABLE `signs` (
`id` int(11) NOT NULL auto_increment,
`rep` varchar(255) NOT NULL default '',
`signs` int(11) default NULL,
`text` varchar(255) NOT NULL default '',
`qty` int(11) default NULL,
PRIMARY KEY (`id`)
);

My Programming Web Databases class was so hard when I took it. I had no interest in it and couldn't stay focused. My teacher came from Silicon Valley and got BORED there so he came to Chicago to start a new life. He died last semester I ended up getting mono that semester I took it and missed 3 weeks. Then over spring break, taught myself everything and for the final wrote a shopping cart website. Now I do this for a living.

I really don't do C++ programming anymore... switched over to all web-based programming. C++ changes so often with different framework, .NET, and all that other stuff.

And it's not just archiving. It's pulling specific data from the email. Here's an example or an everyday sign request.

Originally Posted by Budweiser Sales Rep

Dave;
10 2x3
1 3x10
50 Table Tent

Bud Family Bud Bowl Template
"Join us here for the BIG GAME
$13 Bud Light Buckets (5 bottles)"

So when this email is sent, it goes into an inbox of mine. When it gets there, this program or whatever goes in and picks out the info. 10 2x3, 1 3x10, and 50 Table Tents Get stored in one field of the table, the template in another, and the text in another. Again, needs to be automatic as soon as the request is received. On my side, I would have an alert that comes up saying new request and I get to see it being displayed from the database itself.

[JoeShmoe]

I get it now, well sounds pretty interesting.

[Thor06]

Nice!! Very good Dave, glad you got 'er worked out.

[david-b]

Originally Posted by Thor06

Nice!! Very good Dave, glad you got 'er worked out.

Uh haven't done anything yet bud. Still working on theory. And I'm waiting to get settled in before I start coding. Sometimes I like sitting down and writing code for hours all night. When it rains it pours lol.

[JoeShmoe]

LOL, i knew you would get dustin on that. Owned!

How many lines do you think you will need to write?

[david-b]

Originally Posted by JoeShmoe

LOL, i knew you would get dustin on that. Owned!

How many lines do you think you will need to write?

Lines of code? For the whole site or just for this specific part? Probably a good solid couple thousand. That's why like I said, when I get into it, I get really into it. I'm working on my personal site so I can start showing off some work and all and that's going to be quite a bit also.

[david-b]

Ah sent an email to myself and manual searched for it and look what I got
http://davidbonolo.com/xml/

Only thing is, email looks like

Originally Posted by Me Sending Crap to Myself

<email>
<to>Dave Bonolo</to>
<from>Sales Rep</from>
<subject>Sign request 1</subject>
<sign1>5 2x3, Bud Light temp, "$2 bottles everyday"</sign1>
<sign2>5 2x3, Bud Light temp, "$1 bottles every Wednesday, $5 Pitchers"</sign2>
</email>

Which means the reps would have to add each field (or make a template like above) to every email. I'm sure they would love that. lol.

[JoeShmoe]

Originally Posted by david-b

Which means the reps would have to add each field (or make a template like above) to every email. I'm sure they would love that. lol.

I'm usre they wold love that Dave. Take an extra couple minutes to fill it out. Well, a template that you made up might work better than having them make their own, IMO.