Automatic Keyword Creation for Windows Live Add On Update

Started out smoothly. I got to work on it during my lunch hour. As I said before if you think of suggestions I would love to hear them.
 
I am not going to use MS Word for a dictionary at this point. Rather I am unsing an online dictionary. If I should choose to move to another source it will be fine as I will have the logic down.
 
Basically I am going to refer you to a past blog entry and show you the keywords it would have generated and then the keywords it did not choose to generate, either cause the words were too short, not a noun or were numbers.
 
Right now this is just the logic. We will work on the gui and options later.
 
The text contained in the entry:
 
Fix: Jet can get the datatype wrong with Excel as data source using vb.net
Good Morning. I cannot believe what happened on "The Shield" last night. All of Mackey’s talk about loyalty and family went straight down the tubes when his butt was on the line. Is there anyone left routing for this bastard? I think for a lot of us, it is like we want to see justice served and see this guy go down in flames. it’s a car wreck and we can’t turn away. Next week is a 90 minute episode and believe you me I will be taping this one.
Anyway, I really struggled with this. When connecting to an excel spreadsheet the Jet Engine "fixes" the datatypes with reference to a scan of some rows and then produces NULLS when subsequent values in that column do not conform to that fixed datatype: specifically text in number columns. This is what I came up with and I have attached the spreadsheet. I hope you never have to deal with this problem.  Don’t forget to change the path for the attached spreadsheet. Make it a great day!
 
End of entry…… 
 
Keywords That Would Have Been Generated (at this point):
 
Jet,data,source,net,Morning,Shield,night,loyalty,family,line,bastard,lot,
justice,car,wreck,week,minute,episode,one,spreadsheet,Engine,
reference,column,text,number,hope,deal,problem,path
 
Words It Ignored listed with the type of word the dictionary said it was. One word, I have got to find a way to have the logic include was "Excel" as that was critical to it. But not bad for a start. It thought "Excel" as in being good at something not the program.
 

Fix verb

can verb

get verb

wrong adj

with prep

Excel verb

Good adj

cannot verb

believe verb

what adj

last adj

All adj

talk verb

about prep

and abbreviation

straight adj

down adverb

when adverb

his adj

butt verb

there adverb

anyone pronoun

left adj

for prep

this pronoun

think verb

for prep

like adj

want verb

see verb

and abbreviation

see verb

this pronoun

guy abbreviation

down adverb

and abbreviation

can verb

turn verb

away adverb

Next adj

and abbreviation

believe verb

you pronoun

will auxiliary verb

this pronoun

Anyway conj

really adverb

with prep

this pronoun

When adverb

excel verb

with prep

scan verb

some adj

and abbreviation

then adverb

when adverb

subsequent adj

that adj

not adverb

conform verb

that adj

fixed adj

This pronoun

what adj

came verb

with prep

and abbreviation

have verb

attached adj

you pronoun

never adverb

have verb

with prep

this pronoun

forget verb

change verb

for prep

attached adj

Make verb

great adj

 
 

Advertisements
  1. #1 by Michael on November 22, 2008 - 7:42 am

    Pretty neat. Thanks for sharing! I look forward to seeing more.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: