Meta tags:

Headings (most frequently used words):

2013, to, 14, the, wed, dec, in, fireworks, latest, tool, made, export, from, notes, sql, etl, tue, jan, 2014, perfect, desk, quest, update, part, 11, recovering, laptop, after, forgetting, windows, and, bios, password, rockall, design, now, its, 11th, year, fri, nov, using, font, awesome, icons, mon, oct, attachments, taking, it, market, simple, fool, proof, solution, at, what, cost, success, still, domino, future, of, comments, let, get, social, about, this, website, survey, elsewhere, some, demos,

Text of the page (most frequently used words):
the (145), and (57), for (32), you (27), can (23), domino (21), about (21), that (21), this (18), there (17), years (16), from (15), was (15), which (14), search (13), view (13), have (13), are (12), ago (12), then (12), all (11), big (11), test (11), wumrlvwz (11), with (10), any (10), year (10), sql (10), document (9), here (9), now (9), font (9), not (9), use (8), find (8), your (8), work (8), tool (8), #windows (8), comments (7), form (7), like (7), more (7), what (7), had (7), laptop (7), data (7), site (6), other (6), based (6), files (6), awesome (6), but (6), only (6), read (6), 2013 (6), part (6), add (6), fireworks (6), icons (6), step (6), using (6), time (6), hard (6), off (6), bios (6), way (6), notes (6), table (6), rockall (5), name (5), database (5), chart (5), 2012 (5), why (5), long (5), own (5), web (5), perfect (5), desk (5), threads (5), how (5), being (5), just (5), well (5), over (5), out (5), each (5), fields (5), net (4), design (4), jake (4), howlett (4), ajax (4), many (4), file (4), some (4), tue (4), may (4), wed (4), down (4), used (4), lotusscript (4), code (4), always (4), new (4), lotus (4), quest (4), don (4), know (4), working (4), icon (4), map (4), type (4), below (4), where (4), one (4), start (4), install (4), though (4), back (4), however (4), has (4), would (4), could (4), once (4), same (4), been (4), drive (4), password (4), mac (4), between (4), export (4), tables (4), process (4), rss (3), sandbox (3), surveys (3), home (3), download (3), google (3), simple (3), without (3), disk (3), flex (3), mon (3), 2011 (3), interesting (3), when (3), who (3), both (3), right (3), still (3), company (3), called (3), asp (3), things (3), website (3), get (3), update (3), brilliant (3), hope (3), character (3), show (3), made (3), picture (3), define (3), reason (3), point (3), select (3), text (3), them (3), matter (3), much (3), than (3), last (3), people (3), while (3), love (3), boss (3), list (3), showing (3), thought (3), old (3), remove (3), after (3), boot (3), try (3), sell (3), she (3), before (3), monitor (3), moving (3), mouse (3), enough (3), attachments (3), unid (3), field (3), looking (2), group (2), ltd (2), sites (2), blogs (2), top (2), dext (2), take (2), look (2), buttons (2), colour (2), views (2), processing (2), styling (2), html (2), system (2), key (2), proof (2), following (2), demos (2), available (2), archive (2), life (2), aug (2), images (2), choosing (2), oct (2), portrait (2), next (2), done (2), latest (2), development (2), codestore (2), either (2), open (2), need (2), adobe (2), decided (2), future (2), want (2), hey (2), note (2), switch (2), canvas (2), first (2), recently (2), image (2), sometimes (2), quickly (2), dynamics (2), crm (2), product (2), said (2), most (2), turnover (2), mvc (2), sure (2), question (2), those (2), earning (2), lately (2), money (2), ever (2), possible (2), self (2), given (2), growth (2), plot (2), number (2), readers (2), saw (2), say (2), great (2), will (2), answer (2), somebody (2), rule (2), even (2), gone (2), might (2), seem (2), thinking (2), line (2), although (2), hours (2), idea (2), run (2), day (2), worked (2), ready (2), insert (2), hacks (2), did (2), didn (2), able (2), dec (2), video (2), editing (2), versions (2), small (2), keyboard (2), too (2), kind (2), move (2), three (2), watch (2), again (2), recommend (2), synergy (2), dell (2), taking (2), found (2), these (2), row (2), etl (2), ignore (2), etc (2), creates (2), accommodation, kindly, hosted, hosting, smarties, prominic, copyright, 2000, 2026, wishlist, content, contact, gears, demo, sprite, shaded, dojo, dblookup, function, inviewedit, agent, directory, picker, widget, validation, calendar, hierarchy, checkbox, tolerant, wordy, dates, sorting, rating, backup, contents, zip, multiple, typeaheads, xss, accessible, generation, explorer, pdf, templates, downloadable, chock, full, links, apr, mapping, death, tutorial, actionbar, pull, refresh, jul, httpwatch, supports, firefox, selenium, jungledragon, celebrates, 000, wildlife, symphonyonline, sat, sep, lenses, lens, hereby, technique, inception, elsewhere, comment, vote, cares, gets, job, java, whichever, task, maintain, existing, tend, purely, relevant, survey, linked, twitter, host, runs, his, lookout, concentrating, sharepoint, internet, vimeo, videos, github, pins, linkedin, feed, twittter, let, social, darryn, sullivan, blog, entries, goes, source, version, currently, keeps, graphics, scrap, fun, stuck, trying, within, tip, help, they, unicode, limit, creativity, lack, thereof, shown, button, cloud, vector, drawing, app, break, apart, ctrl, shift, their, shape, dragging, corners, points, around, particular, wider, copy, copied, clipboard, press, click, somewhere, paste, resize, wish, program, case, wanted, exclamation, mark, easy, create, fonts, rely, supported, especially, conjunction, bootstrap, easily, elements, whether, remains, term, certainly, feels, got, brighter, lucrative, does, hopefully, write, soon, responsible, changed, whilst, equation, microsoft, everybody, lips, least, stopped, reading, technology, crust, overdoing, moaning, reality, happy, dreamt, won, continue, making, make, hay, sun, shining, employed, means, provide, retirement, greedy, obsessed, crazy, opportunity, capitalise, chances, earn, happened, turn, upside, takings, shot, couple, plummeted, upon, friends, regularly, few, hobbies, enjoyed, must, normally, snap, chance, poor, heart, loneliness, never, imposed, weekend, golden, window, hear, talk, thing, balance, whatever, gotten, luckily, family, cost, success, reluctant, nobody, likes, leave, actual, involved, mystery, suffice, posted, direction, doing, store, past, mainly, luck, put, good, see, bumper, little, office, slash, garage, garden, yesterday, customary, fri, nov, its, 11th, presto, helps, else, partitions, afresh, boots, happening, fails, finding, yourself, wanting, modify, fool, solution, brainwave, tried, lots, complicated, removal, tools, sale, none, nor, stripping, hot, wire, jumpers, cmos, battery, removable, initially, sticking, building, scratch, couldn, change, order, disks, realise, apparently, owner, forgotten, written, worthless, willing, nothing, yes, something, sis, law, loves, bargain, yorkshire, rang, ask, via, her, sister, wife, recover, offered, went, ahead, bought, recovering, forgetting, better, continues, mini, occasional, php, coding, coda, running, various, inside, parallels, virtual, machines, testing, different, until, wasn, attached, square, wall, length, meant, positioning, chair, also, justice, effective, issues, resolved, itself, travel, extremities, screens, magic, seeing, slightest, hint, lag, keep, needlessly, two, happen, almost, recommended, previously, several, times, because, having, daemons, pcs, stupid, glad, sense, aside, adding, brand, amazing, main, difference, shared, win, left, newly, added, u2713h, u2711, samsung, syncmaster, 245b, 676, 800, pixels, glaring, looks, monitors, real, estate, desktop, size, march, going, coming, along, another, updated, interested, migrate, server, rdbms, drop, rockalldesign, com, known, directly, shelf, support, yours, truly, reckon, situations, tailored, doesn, quite, fit, market, special, stores, filename, during, detached, path, stored, associated, matching, initial, configuration, tell, forms, treat, unids, relationships, parent, child, joining, diagram, enhancement, rules, finally, populates, looping, documents, exporting, according, results, builds, primary, related, column, equivalent, resulting, analysed, duplicate, conflicting, types, unnecessary, removed, loop, through, analyse, every, single, target, build, unique, combinations, combination, finds, created, lists, authors, rich, numbers, involves, customers, leaves, behind, assist, best, myself, creating, jan, 2014, menu, welcome, developer, zine,

Text of the page (random words):
welcome to codestore jake howlett s web developer e zine lotus domino flex asp net mvc and more menu home blogs surveys sandbox search a tool i made to export from notes to sql etl tue 14 jan 2014 as i watch all my customers leaves notes domino behind all i can do is try and assist as best i can as part of this process i ve found myself creating a notes to sql export tool the tool is notes based and involves the following three part process step 1 loop through and analyse every single document in the target database and build a list of all unique combinations of form field data type for each combination it finds a notes document is created which lists the form name the field name and the type of data text authors rich text numbers etc the resulting list is then analysed and any duplicate fields conflicting data types or unnecessary fields are removed step 2 taking the results of step 1 it then builds the sql tables using the document s unid as the table s primary key for each form it creates a table of the same name for each field related to that form it creates a column in the sql table with the equivalent data type step 3 finally step 3 populates the sql tables with data by once again looping all documents in the database and exporting each document to a new row in sql according to the map of form fields we ve decided on once it s done we can then go in to sql and define relationships between parent child document by joining the tables in a database diagram although as an enhancement to the tool it could be a part of the export process that we define these rules as part of the initial configuration of the tool you can tell it which forms to ignore which fields ignore which fields to always treat as unids etc once the data is in sql then you can do the t and l of the etl process attachments for attachments there s a special table called files which stores the unid and filename of any files found during the export these files are detached to disk and the path to them stored in the files table for any given row of any of the sql tables you can find the associated attachments by looking in the files table for a matching unid taking it to market i ve always known i need a product to sell could this be it it s some way off being ready to sell directly off the shelf however with some support from yours truly i reckon it could be used in most situations or tailored to work where it doesn t quite fit if you re interested in using the tool to migrate data from lotus notes to sql server or any other rdbms system then drop me a line on jake howlett rockalldesign com there are 27 comments in 14 threads read add the perfect desk quest 2013 update part 2 wed 11 dec 2013 back in march i updated you all on how my on going quest for the perfect desk was coming along here now is another update question can you ever have too many monitors or enough real estate desktop size answer no here s how my desk looks now from left to right there s a newly added dell u2713h showing os x a dell u2711 and a samsung syncmaster 245b both showing the same windows 7 pc all in there are 9 676 800 pixels glaring back at me aside from adding a brand new monitor which by the way is amazing and i can t recommend it enough the main difference is that there is only one keyboard and mouse which shared between win and mac using synergy km synergy is brilliant and again i can t recommend it enough it s been recommended to me on here previously several times why oh why i didn t try it out before i don t know well i do it s because i don t like the idea of having to run daemons on my pcs which is a stupid reason and i m so glad i saw sense it s like a kind of magic seeing your mouse move from windows to mac without even the slightest hint of a lag for the first day or so i d just keep needlessly moving between the two just to watch it happen after a while it s almost possible to start thinking of them both as the same pc the mouse itself has to move about 3 to travel between the extremities of all three screens i use the mac mini for video editing the occasional php coding coda 2 and for running various versions of windows inside parallels virtual machines for testing sites in different versions of ie until now using the mac wasn t great the monitor was small and attached square to the wall to use for any length of time meant moving one keyboard out the way moving over the other and re positioning my chair the old monitor was also too small to do os x justice or for any kind of effective video editing all those issues have now been resolved is it my perfect desk though no but it s way way way better than before not perfect though the quest continues there are 6 comments in 5 threads read add recovering a laptop after forgetting windows and bios password wed 4 dec 2013 my sis in law loves a bargain she s from yorkshire and recently rang to ask me via her sister my wife if i d be able to recover a laptop she d been offered before she went ahead and bought it apparently the owner of the laptop had forgotten the windows password and had written the laptop off as worthless so was willing to sell for next to nothing i said yes i d able to do something with it what i didn t realise was that it might have a bios password which it did initially i d thought it would be as simple as sticking in a windows install cd and building from scratch however without the bios password i couldn t change the boot order of the disks to get it to boot from cd i tried google and there s lots of complicated hacks out there as well as bios removal tools for sale none of the hacks worked for me nor did stripping the laptop down to hot wire jumpers or remove the cmos battery which was un removable then i had a brainwave the simple fool proof solution if you find yourself wanting to boot from cd on a laptop or pc for that matter where you can t modify the bios try this remove the hard drive insert the windows install cd start the laptop hope that bios fails over to the cd after not finding a hard drive if it boots from the cd while that s happening quickly re insert the hard drive by the time windows is ready to install the hard drive will be there remove the old disk partitions and start afresh hey presto worked for me hope it helps somebody else there are 7 comments in 2 threads read add rockall design now in its 11th year fri 1 nov 2013 rockall design ltd the little company i run from the office slash garage in my garden was 10 years old yesterday it s customary on this day each year that i plot a chart of turnover growth over the years so here it is as you can see it s been a bumper year last year i put down what at the time i thought was a good year to long hours and hard work but mainly luck this year is much the same although if i thought i was doing long hours back then i had no idea what was in store this past year i was reluctant to show the chart as it may seem like i m showing off and nobody likes a show off note however that i leave the actual number involved a mystery suffice to say i would have posted the chart no matter which direction the line would have gone this year at what cost success i hear people talk about this thing called a work life balance whatever that might be it s gotten to the point for me now where all i seem to do is work not only that but when i m not working it s work that i m thinking about and i find it hard to switch off luckily i love what i do but there are other things i love my family being top of that list i used to have a self imposed rule of not working at the weekend lately even that golden rule has gone out the window people sometimes say to me i d love to work from home or it must be great being your own boss at which point i normally snap up the chance to poor my heart out about the loneliness and how you re never your own boss you will always have a boss and answer to somebody once upon a time i had a group of friends i saw regularly and had a few hobbies i enjoyed then there s this website what happened there well if you turn my company growth chart upside down it could just as well be a plot of the number of readers this site has had over the years as my takings have shot up over the last couple of years the readers of this site have plummeted i m overdoing it on the moaning though in reality i m happy with how things are i m earning more money than i ever dreamt possible i know it won t can t continue and i m making sure i make as much hay as i can while the sun s shining being self employed means i have to provide for my own retirement i m not greedy or obsessed by money but it would be crazy for me not to take the opportunity to capitalise on any chances i m given to earn still domino i m sure the question on everybody s lips well at least on those of the people who ve not stopped reading the site is what technology is earning your crust just lately this time last year i said it was lotus domino that was responsible for most of rockall s turnover this year however the picture has changed and whilst domino is still in the equation it s now microsoft dynamics crm and asp net mvc that i m working with whether dynamics crm remains in the picture long term or not i don t know it certainly feels like it s got a brighter more lucrative future for it than domino does it s an interesting product and hopefully i ll find time to write about it here soon right back to work so much to do there are 16 comments in 14 threads read add using font awesome icons in fireworks mon 14 oct 2013 the font based web icons from font awesome is brilliant especially when used in conjunction with bootstrap you can quickly and easily add any one of the icons to your html buttons or many other elements for that matter like so sometimes though you can t use web fonts either you can t rely on them being supported or for some other reason you just want to use an image file that was the case for me recently and i wanted an image file of an exclamation mark here s how easy it was using font awesome and adobe fireworks to create images based on font icons first step is to download and install the font awesome font to your pc then open the character map program and select the font awesome font as below in there you can view select and copy any one of the icons with it copied to the clipboard you can then switch to fireworks start a new canvas select the text tool or press t click on the canvas somewhere and paste in the icon you can then resize and re colour as you wish as below note that fireworks is a vector based drawing app and you can break apart ctrl shift p the icons so that you can re define their shape by dragging corners and points around like below where for no particular reason i ve made the point wider the only limit is your creativity or lack thereof as shown here hey look i made a download button with a picture of a cloud in it if you get stuck trying to find the icon you want from within character map then here s a tip that may help find the icon on the website and on there they show you the unicode code which you can type in to character map to find the icon as below have fun future of fireworks fireworks is brilliant why of why adobe have decided to scrap it i don t know i only hope it either goes open source or the version i currently own keeps working for as long as i have need of a graphics tool there are 4 comments in 2 threads read add more blog entries are available in the archive latest comments darryn sullivan on the perfect desk quest 2013 update part 2 about 5 years ago wumrlvwz on the big domino view search test about 6 years ago wumrlvwz on the big domino view search test about 6 years ago wumrlvwz on the big domino view search test about 6 years ago wumrlvwz on the big domino view search test about 6 years ago wumrlvwz on the big domino view search test about 6 years ago wumrlvwz on the big domino view search test about 6 years ago wumrlvwz on the big domino view search test about 6 years ago wumrlvwz on the big domino view search test about 6 years ago wumrlvwz on the big domino view search test about 6 years ago wumrlvwz on the big domino view search test about 6 years ago wumrlvwz on the big domino view search test about 6 years ago let s get social me on twittter me on google rss feed for this site me on linkedin my pins my code on github my vimeo videos about this website codestore is all about web development concentrating on lotus domino asp net flex sharepoint and all things internet your host is jake howlett who runs his own web development company called rockall design and is always on the lookout for new and interesting work to do you can find me on twitter and on linked in read more about this site latest survey is lotusscript still relevant i tend to code purely in lotusscript 37 i now only maintain existing lotusscript code 9 i use both choosing whichever is right for the task 27 i used to use lotusscript but now only use java 8 who cares as long as it gets the job done 17 comment or vote here elsewhere we hereby name this portrait technique portrait inception next tue 02 oct 2012 choosing lenses when to use which lens and why sat 22 sep 2012 symphonyonline co uk wed 22 aug 2012 jungledragon celebrates 5 000 awesome wildlife images tue 07 aug 2012 httpwatch 8 4 supports firefox 14 and selenium mon 30 jul 2012 pull down to refresh wed 25 may 2011 tutorial styling the actionbar tue 17 may 2011 interesting chart mapping the life death and mon 18 apr 2011 more links are available in the archive some demos dext is a downloadable domino database chock full of the following demos and more pdf files based on templates flex document explorer file generation without disk i o accessible ajax surveys xss proof form multiple key typeaheads backup database contents to zip file document rating system document sorting with ajax wordy dates tolerant html processing checkbox styling many to many document hierarchy calendar like views form validation domino directory name picker widget inviewedit view processing agent ajax dblookup function simple dojo ajax colour shaded views sprite based buttons google gears demo to download dext take a look in the sandbox top home blogs surveys sandbox search about contact other sites rss content rss comments my wishlist copyright 2000 2026 jake howlett of rockall design ltd this site is kindly hosted by prominic net domino hosting smarties looking for group accommodation in the uk