-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `intel145_apps`
--

-- --------------------------------------------------------

--
-- Table structure for table `tips`
--

CREATE TABLE `tips` (
  `id` int(11) NOT NULL,
  `title` varchar(64) NOT NULL,
  `cat` varchar(64) DEFAULT 'cat',
  `subCat` varchar(64) DEFAULT 'subCat',
  `descr` text NOT NULL,
  `comments` varchar(512) DEFAULT NULL,
  `links` varchar(256) DEFAULT NULL,
  `tags` varchar(128) NOT NULL,
  `moreInfo` varchar(512) DEFAULT NULL,
  `attachments` varchar(128) DEFAULT NULL,
  `tipCreate` timestamp NOT NULL DEFAULT current_timestamp(),
  `tipMod` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tips`
--

INSERT INTO `tips` (`id`, `title`, `cat`, `subCat`, `descr`, `comments`, `links`, `tags`, `moreInfo`, `attachments`, `tipCreate`, `tipMod`) VALUES
(212, 'mysql definition for dates created and updated', '', '', 'CREATE TABLE `tips` (   `id` int(11) NOT NULL,   `title` varchar(64) NOT NULL,   `cat` varchar(64) DEFAULT \'cat\',   `subCat` var', 'ALTER TABLE `tips` MODIFY COLUMN `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, MODIFY COLUMN `updated_at` TIMESTAMP', 'link1', 'mysql,', 'update work', '', '2025-06-26 20:28:46', '2025-06-26 20:33:16'),
(3, 'mySql csv to sql', 'mySql', 'todo', 'Convert CSV to SQL Table ', 'Comments: Does this work (', 'https://convertcsv.com/csv-to-sql.htm', 'mysql, csv', 'MoreInfo', 'attachment', '2025-06-25 21:22:00', '2025-11-19 15:54:00'),
(207, 'New Record', 'Cat', 'Sub', 'Description', 'Comment updated but updated_at not updating', 'https://www.att.com', 'tag, test, ', 'What is moreinfo for', 'what are att', '2025-06-26 19:39:05', '2025-06-26 19:39:05'),
(6, 'vim', 'cat', 'subCat', 'Select HTML Block of Tags', 'How select block of matching tags', 'Place the cursor on the tag.<br> Enter visual mode by pressing v.<br> Select the outer tag block by pressing v + a + t <br>or <k', 'tipsVim.html', 'https://stackoverflow.com/questions/6270396/navigating-html-tags-in-vim', 'MoreInfo', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(9, 'test attachment', 'test', '', 'Try out to view attachment', 'Comments are here', '', 'sample,test', '', '~/lbin/tipsAttachments/20190323170202.html', '2025-06-25 21:22:37', '2025-11-07 05:39:00'),
(10, 'UI Interface increase font contrast text for accessibility', 'ui', '', 'UI Interface increase font contrast text for accessibility', 'desc', 'Add from shell', 'n', 'https://www.rwjbh.org/events/register/thank-you/?signup=d67bc2886e8761f5cb57fc7819676104f497798926bc006aac7eb712ec8b51298d3ad95a', 'MOREINFO', '2025-06-25 21:22:37', '2025-11-04 13:02:00'),
(11, 'Wawa Background colors', 'todo', '', 'Wawa Background colors', 'Use these colors for backgrounds', 'Add from shell', 'n', 'https://wawa.kobie.com/pages/UnsubscribeComplete.aspx', 'MOREINFO', '2025-06-25 21:22:37', '2025-11-04 13:02:00'),
(12, 'Toll Brothers Kitchn Planner', 'kitchen', '', 'Toll Brothers Kitchn Planner', 'Great Kitchen planner for cabinets layout colors', 'Try it out', 'kitchen', 'https://www.tollbrothers.com/luxury-homes-for-sale/North-Carolina/Toll-Brothers-at-Weddington/Executive-Collection', '', '2025-06-25 21:22:37', '2025-11-04 13:03:00'),
(259, 'AI Rules', 'msvc', 'todo', 'gallery/oldCoPilot/ai.txt - music\r\n./gallery/resize/ai.txt - resize/rules\r\n./airplay20251023/docsO/requirements.txt ./gallery/oldCoPilot/ai.txt ./galler\r\n  2 ./airPlay/docsO/requirements.txt', '', '', 'ai, requirements', '', '', '2025-11-04 13:15:00', '2025-11-04 13:36:00'),
(14, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Bike Ride Mapping', 'Great tool to create bike maps', 'rickbeachlbi', 'n', 'https://ridewithgps.com/routes/new', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(15, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Famous Demo for building slideshow', 'Beta Software', 'Remove famous from macbook.sierra', 'n', 'https://api.famous.co/api/a/7hrxwh/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(16, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Get TinyMCE Colors for ui blue grey', 'Make green the orange colors', 'Image is in: /Users/rbutare/Documents/Screenshots/tinyMceColors.jpg', '/Users/rbutare//lbin/tipsAttachments//20190330175815.html', 'https://www.tiny.cloud/get-tiny/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(17, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'UI I Like', 'I like the blue black rounded corners on edge', 'blues and good fonts', 'n', 'https://www.roomkey.com/hotels/1b7VGiG4T04s6Rl05g9krVMw/compare?brand=152&checkIn=2019-04-02&checkOut=2019-04-03&currency=USD&de', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(18, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Memory Test', 'Dr Apter Princeton Medical Institute', 'Free Memory Test study Vicki found in Star Ledger 609-921-6050', 'n', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(19, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Email Tabs open in Firefox', 'Send Email or put in clipboard all links of tabs that are open', '', 'n', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(20, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Websites Down Detector', 'Check if websites are having problems reported', '', 'n', 'https://downdetector.com/status/facebook-messenger', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(21, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Speed Test Internet', 'Check Speed test', '', 'n', 'https://www.speedtest.net/,http://speedtest.xfinity.com/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(22, 'subsub', 'cat', 'sub', 'Test 2 Links and Attachment', 'desc', 'NOT WORKING ON SECOND ATTACHMENT Test Record with attachment 2 links 2 tags', '/Users/rbutare//lbin/tipsAttachments//20190403082625.html', '/Users/rbutare//lbin/tipsAttachments//link1.html, link2', 'moreinfo', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(23, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'One Note Stickies off Iphone', 'Can\'t find stickies in Onenote app must go online to get them', '', 'n', 'https://www.onenote.com/stickynotes#', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(24, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Southern Pines Pinehurst House $650', '15 Masters Ridge Place Southern Pines, NC 28387', '15 Masters Ridge Place', 'Southern Pines, NC 28387', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(25, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Console tricks', '', 'Try these tricks/tips console.log debug  ', '/Users/rbutare//lbin/tipsAttachments//20190406082618.html', 'https://areknawo.com/getting-creative-with-the-console-api/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(26, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Where are my ios/IPhone photos backed up to?', 'google, iCloud, microsoft', 'find photos how to move to macbook', 'n', 'https://iphonephotographyschool.com/how-to-transfer-photos-from-iphone-to-mac/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(27, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'How to move photos from IPhone to macbook', 'use iPhoto app or image capture on macbook', '', 'n', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(28, 'SUBSUBCAT', 'CAT', 'SUBCAT', 't', 'd', 'c', 'n', 'l', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(29, 'free', 'images', 'photos', 'Images for Web - no cost, copyright, attributions', 'Get free images for web use commercial/personal', '', 'n', 'https://www.pexels.com/', 'Free Stock I', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(30, 'SubSubCat', 'Cat', 'SubCat', 'Title', 'Description', 'Comments', 'Attachments', 'Links', 'MoreInfo', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(31, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'UrlEncoder', 'encode url information', '', 'n', 'https://www.urlencoder.org/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(32, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Compress images jpg', 'Compress smaller files', 'online compressor', 'n', 'https://compressjpeg.com/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(33, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Disability Menu Tools', 'Contrast text size', 'nice features', 'n', 'https://www.shouselaw.com/first-time-dui.html', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(34, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Reset Video 2nd Monitor Display', 'External Monitor not working', 'not sure works', 'n', 'https://www.youtube.com/watch?v=kaCZ-AqqIoA', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(35, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'New Mac USER video', 'beginner macos 45min', 'ttp://bit.ly/TechTalkPDFGuides', 'n', 'https://www.youtube.com/watch?v=_7wmVxUCzs0', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(36, 'Vision Loss - Glacoma', 'medical', '', 'Glacoma Vision Loss', 'Good Article on Vision loss dr questions', '', 'eyes,vision', 'https://www.visionaware.org/info/your-eye-condition/glaucoma/patients-guide-to-living-with-glaucoma/125', 'MOREINFO', '2025-06-25 21:22:37', '2025-11-04 12:34:00'),
(37, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Simulation of vision problems', 'shows all types of vision loss video', '', 'n', 'https://www.visionaware.org/info/your-eye-condition/eye-health/vision-simulation-video/125', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(38, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Contrast Sensitivity', 'How I am seeing greys in white spaces - lisa sheds bathroom granite', '', 'n', 'https://www.aoa.org/Documents/optometric-staff/Articles/Contrast-Sensitivity.pdf', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(39, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Good Search for McLendon Hills', 'All available properties', '', 'n', 'https://www.zillow.com/homes/for_sale/?utm_source=email&utm_medium=email&utm_campaign=emo-dailysavedsearch&rtoken=30ee04ca-639e-', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(40, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Animated Css Effects', 'Nice Css animations for spinner bubbles buttons', '', 'n', 'https://emilkowalski.github.io/css-effects-snippets/?ref=producthunt', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(41, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Weather info', 'weather, sunrise sunset temps', '', 'n', 'https://www.willyweather.com/nc/moore-county/west-end.html', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(42, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Lots Mclendon Hills', 'lots beth\'s point', '', 'n', 'https://www.realtor.com/realestateandhomes-detail/211-Beth-Pt_West-End_NC_27376_M63520-52544#photo0', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(43, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'All Homes McLendon Hills', 'houses and lots', '', '', 'https://www.realtor.com/realestateandhomes-search/McLendon-Hills_West-End_NC', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(44, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Next Billion Dollar Investments', 'investment future', 'read later', 'n', 'https://www.forbes.com/sites/amyfeldman/2019/07/16/next-billion-dollar-startups-2019/?utm_source=newsletter&utm_medium=email&utm', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(45, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Houses Sold/ForSale In Mclendon Hills', 'All Home Listings Mclendon Hills', 'All Homes on Market', 'n', 'https://www.zillow.com/homes/for_sale/2_p/?utm_source=email&utm_medium=email&utm_campaign=emo-dailysavedsearch&rtoken=f5339eb8-2', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(46, 'SUBSUBCAT', 'CAT', 'SUBCAT', '27376 Real Estate Lookup - West End', 'Find all homes for sale in West End Area in NC', '', 'n', 'https://www.realtor.com/realestateandhomes-search/27376/price-300000-800000/sby-6', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(47, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Send Large Files', 'Transfer large files', 'Files to 2.5gb', '', 'https://send.firefox.com', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(48, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Search for Starred Emails', 'Search for Starred : zillow: in:starred NOT STARRED: zillow: -in:starred', 'not starred: zillow: -in:starred', 'n', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(49, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Input Shortcuts for Mac Typinator', 'Typinator good application for shortcut typing', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(50, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'SambaNova NLP and AI Company', 'SambaNova company AI competing with MSFT and GOOGLE on AI parameters', 'watch for investment opportunity', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(51, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Keynote Smaller Size', 'Go to the File menu and select Reduce File Size. ...', 'Use to reduce size of file and images', 'n', 'https://www.techwalla.com/articles/how-to-reduce-keynote-file-size', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(52, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Gimp Convert to Black and White', 'Colors->Colorize->Color Pick Grey Duplicate the original image (Shft+Cmd+D) and right-click on the copy. Select  Image -> Mode -', '', 'n', 'https://www.gimp.org/tutorials/Color2BW/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(53, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Imovie Short cut keys', 'Make a range i key to start o key to end; to play range not sure ? r key to create range ; cmd->b to split / to play range', '', '', 'https://www.idownloadblog.com/2020/01/16/imovie-keyboard-shortcuts-hotkeys-mac/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(54, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Brew Update', 'How to update Brew - application or all installed brew software', 'Brew update updates brew and brew upgrade updates brewed software. If you want to keep your software up to date I’d recommend ru', 'n', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(55, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Get Version of Brew Software Installed', 'How to determine what software is installed by brew and version: brew list --versions', '', 'n', 'https://devhints.io/homebrew', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(56, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Brew Commands', 'check version: brew update wget; Update wget: brew upgrade wget; what is outdated - needs update: brew outdated', '', 'n', 'https://devhints.io/homebrew', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(57, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Brew Cask', 'Use Cask to install some applications: brew cask install inkscape; brew cask list - to list applications installed by cask', 'not sure what brew cask is', 'n', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(58, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Du command replacement', 'Visual size du command replacement', '', 'N', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(59, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Top Replacement for Processes', 'Htop - new replacement for top command', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(60, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Json command like sed, awk jq', 'Unix command for json to format output like sed awk', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(61, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Applications added with homebrew/brew', 'Install applications brew install ncu', '', 'N', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(62, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'OBDII Diagnostics for Car', 'OBDII device for car from bafx products to read check engine codes', 'Use the softare OBD Fusion / car scanner from App store - I think I bought this', 'n', 'https://bafxpro.com/products/wifi-obdii-reader-scanner-for-ios-devices', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(63, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Smartthings Hub Developer Portal New', 'New Portal for smartthings', '', 'n', 'https://smartthings.developer.samsung.com/docs/index.html', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(64, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'smartthings Login', 'Login use samsung login', '', 'n', 'https://account.smartthings.com/login#showLoginForm', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(65, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Gmail Text Expander', 'Quick shortcuts to expand shortcuts to special gmail searches', 'gmtd, gmwk, gmmo -- gmalert -- gmapps -- gmbank -- gmhouse -- gmjunk -- gmstores -- gmail2 -- gmunread -- gmtry -- gmhome -- mkr', 'n', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(66, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'zSh - startup files', '.profile = .zshrc alis = ~/custom-alias env settings= .zshenv .zlogin = login shell .zlogout - what runs on exit', 'How to setup zsh files as replacement for bash', 'n', 'https://apple.stackexchange.com/questions/388622/zsh-zprofile-zshrc-zlogin-what-goes-where', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(67, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Spectrum TV Out of Sync', 'How to resync voice/audio to picture', 'Recommended steps:n n Send a refresh signal to your receiver.n Change channels to determine if the audio mismatch is channel-spe', 'n', 'https://www.spectrum.net/support/tv/new-spectrum-guide-audio-troubleshooting/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(68, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Zsh Conversion', 'Moving to Zsh', '', 'n', 'https://scriptingosx.com/2019/07/moving-to-zsh-06-customizing-the-zsh-prompt/#:~:text=zsh%20uses%20the%20same%20shell%20variable', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(69, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Finder to show hiddent files', 'CMD->Shift->Period', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(70, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Find Missing/Lost Cursor', 'Press Command + Tab to Get to force Quit window', '', '', 'https://macreports.com/mouse-cursor-pointer-disappears-on-mac-fix/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(71, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Moore County Environmental Health Lot 143', 'Septic tank information', 'No Map yet', 'n', 'https://gis.moorecountync.gov/mooreinfo2010/default.aspx?PARID=20040395', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(72, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Septic Tank - Kill Roots', 'Add Copper Sulfate to Distribution point to kill roots growing in n septic lines - Tim Gandy', 'Need to add clean out at distribution point', 'n', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(73, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Reset Alexa', 'Reset with button in back, in settings, hold down microphone and volume down for 20 seconds', '', 'n', 'https://www.the-ambient.com/how-to/reset-amazon-echo-1268', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(74, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Device Holder GoDonut', 'GoDonut is elegantly simple, yet highly functional holds phone ipad computer etc in easy position', 'Best of XCES Winner $24.95', 'n', 'https://getgodonut.io/blog-winner-of-the-big-ces-show-1/?lpid=788&utm_source=8639&utm_medium=5d6cd616-e942-4033-81cb-c082e3d491a', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(75, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Networ Analyzer hot spots', 'Find Wifi Strength in area', 'Ios app', 'n', 'https://www.netspotapp.com/wifi-heat-map/best-wifi-mapper-apps.html#WiFi_SweetSpots_Map', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(76, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Lan Saan', 'Get IP addresses of devices on the network', '', '', 'https://apps.apple.com/us/app/lanscan/id472226235?mt=12', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(77, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'LanScan network', 'If you use this app, clear the arp cache before (sudo arp -a -d) scanning', 'free only 4 devices $5.99', 'n', 'https://www.macupdate.com/app/mac/40742/lanscan', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(78, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Privacy Shrubs', 'Fastest growing evergreen and the best for privacy screening. Grows 3+ feet per year! They are 3ft tall in 3 gallon pots. $15 pe', 'privacy evergreen Thuja Green Giants $15 each 919-548-0017', 'n', 'Call or text 9l9 548 ool7 for details or PM.', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(79, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Google Nest Device Info', 'Find Infor on which Point a device is connected to - go to home App; Devices->Info; also can test speed or prioritize devices', '', '', 'https://support.google.com/googlenest/answer/7578264', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(80, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Files Stored for WebServer: /Library/WebServer/Documents', 'Default Directory for Websetup on localhost', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(81, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Gimp Toolbox - Tools Missing', 'Missing all tools in toolbox - make sure the group toolbox items is off in Preferences->Use Tool Groups is off', '', '', 'https://www.youtube.com/watch?v=TS6FBaF9V_s', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(82, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Scan Pages on Iphone', 'Create a new Note in Notes and Use Camera to scan page. Makes Page Background White -', 'Use this for copying Vicki Coloring books and print on Stock Paper use Tray 1', '', 'https://support.apple.com/en-us/HT210336', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(83, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Find ip and mac addresses', 'Command: arp -a - will show all ip and mac addresses on network', 'arp -a | grep 197 - find printer', 'n', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(84, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Remove/Lighten Background in Image/Picture', 'Use word to lighten background or modify picture', '', '', 'http://www.word-2013-tutorials.com/lighten-a-picture-in-word/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(85, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Propane Prices', 'Get Current Prices of Propane in NC', '', 'n', 'https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=W_EPLLPA_PRS_SNC_DPG&f=W', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(86, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Font Size In Safari', 'Make font size no smaller than x - preferences->advanced->font size 14', '', '', 'https://www.idownloadblog.com/2020/03/02/how-to-make-text-bigger-in-safari/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(87, 'Eliminate slice', 'Golf', '', 'Golf - Remove Slice', 'Eliminate Slice - club face square to ball', 'https://www.youtube.com/watch?v=lemsx2_ArnQ&list=PLD39949332C7FB168&index=2', 'Golf', '', '', '2025-06-25 21:22:37', '2025-11-08 14:58:00'),
(88, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Find Device or IP Address using MAC Address', 'Get ip address from macId', '', '', 'https://www.pcwdld.com/find-device-or-ip-address-using-mac-address', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(89, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'hla-dq2 Primary Gene for Celiac Disease', 'Celiac Gene - hla-dq2', '', 'n', 'https://www.verywellhealth.com/hla-dq2-the-primary-celiac-disease-gene-562569', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(90, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'DQ8 Gene - Celiac', 'Gene Test', '', '', 'https://www.verywellhealth.com/hla-dq8-one-of-the-main-celiac-disease-genes-562571', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(91, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'LG Claim for Paramount+ Rebate $100', 'Rebate', '$100 credit paramount+', '', 'https://entertainment.lg-promos.com/tvoffer/en-US/track-claim', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(92, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Hexagonal Calculator', 'Determine size of Hexagonal dimensions', '', '', 'https://www.omnicalculator.com/math/hexagon', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(93, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Alexa Echo Update', 'How to update alexa echo software', 'Say Alexa check for software updates', 'n', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(94, 'SUBSUBCAT', 'tutorial', 'mysql', 'mySql Tutorial', 'Has good examples of queries and subqueries', '', 'tutorial, mysql', 'xhttps://www.mysqltutorial.org/mysql-subquery/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(95, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Dew Point', 'Ask Alexa - Alex ask Big Sky what the dew point is?', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(96, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Long Term Electric Battery Storage - Vanadium', 'Watch for vanadium development to hold electricity from wind/solar for up to 30 years; develop by us govt - sold to china', 'watch company - UET uniEnergy Technologies', '', 'https://www.mprnews.org/story/2022/08/03/npr-new-battery-technology-china-vanadium', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(97, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Tps Stock Truck Automation', 'Leader in Truck Automation cost about $9.5 target price 20.35 ravi shanker morgan stanley', 'strong Buy - 20220803 https://www.tipranks.com/stocks/tsp/forecast', '', 'https://www.yahoo.com/video/jim-cramer-says-now-time-132240832.html?guccounter=1&guce_referrer=aHR0cHM6Ly93d3cuZ29vZ2xlLmNvbS8&g', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(98, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Sketchup -', 'Create 3d plans', '', '', 'https://www.youtube.com/watch?v=0ay583JF7uk&list=PLIiM-fMXa1uy0M4ogrV2QqpXXITYd4XR0', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(99, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Pallets', 'Bad Pallets are marked MB Methyl Bromide - EUR are all bad', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(100, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Medicines health Info', 'Info is in medicines.txt in ~/lbin/medicines.txt', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(101, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Make Track Saw', 'Home Made track saw for circular saw', '', '', 'https://www.youtube.com/watch?v=H0BZLbW1lvQ', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(102, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Workbench with shelves', 'Good Tips on how to make and glue and attach', '', 'n', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(103, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Alexa Dot Echo - Updates', 'to Update Dot/Echo Say, Check for software updates to install software on your Echo device.', '', '', 'https://www.amazon.com/gp/help/customer/display.html?ref_=hp_left_v4_sib&nodeId=GEYUPNHC9AYVL4Q3', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(104, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Bandsaw blade selection', 'When it comes to choosing a blade for woodworking, the correct answer will depend largely on your own needs. Do you need very ac', 'When it comes to choosing a blade for woodworking, the correct answer will depend largely on your own needs. Do you need very ac', 'n', 'bandsaw, blades, tips, woodworking,', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(105, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Show Menu Bar on Extended Display', 'Show Menu Bar by changing Display Settings ->Menu Bar  to Show not QUTO HIDE', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(106, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Shorten URL Links', 'How to shorten URL', '', '', 'https://www.bitlylinks.com/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(107, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Adobe Collage - Adobe Express', 'Make simple Collage MacOs', '', '', 'https://www.bitlylinks.com/cRXksVtYl', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(108, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Remove Applications MacOs', 'Remove application with all associated files: macCleaner, appCleaner', '', 'n', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(109, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Mirror to FireTv', 'How to mirror iPhone/Mac to Fire Stick use application: Airscreen, apower mirror', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(110, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Stop Collar 1.24 ID', 'Use for easy setup of tools on shopsmith to get a standard height', 'Took one from lath end stand', 'n', 'https://www.youtube.com/watch?v=-7LlNgHkjp8', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(111, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Mitre Saw Dust Collector Box', 'How to build a box to collect dust on mitre saw', '', '', 'https://www.bitlylinks.com/of8xsaAbb', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(112, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Shopsmith table saw dust collection', 'fix for table saw dust collection', '', '', 'https://www.bitlylinks.com/Pznu89iaB', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(113, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Drill Bits - Best Metal', 'Best Drill bits for drilling metal/steel have cobalt tip can sharpen - but expensive ; add drop of oil and board under for suppo', '', '', 'https://www.bitlylinks.com/twCmIOMa1', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(114, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Trying to get scp/rsync to work', 'How to setup but not working', 'Not working help!', 'n', 'https://www.bitlylinks.com/F0kLzhsMD', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(115, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Price Tracker Amazon', 'Track prices / deal - Keepa.com camelcamelcamel.com', 'Track pricing before you buy items on amazon', '', 'https://keepa.com', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(116, 'Golf club square face', 'Golf', '', 'Golf Swing Square Club Face', '3 things you do wrong to cause slice', 'golf range', '', 'https://rb.gy/kewj3i', '', '2025-06-25 21:22:37', '2025-11-08 14:52:00'),
(117, 'Mental side of golf', 'Golf', '', 'Golf Tips Mental part of game', 'How to get your game back after years off!', 'https://theleftrough.com/getting-back-into-golf/', 'Golf', '', '', '2025-06-25 21:22:37', '2025-11-08 14:56:00'),
(118, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Jet Bandsaw', 'Model Jwbs-14cs 105 blade', 'https://bit.ly/3ZrcF1o', 'n', 'https://uwm.edu/psychology/wp-content/uploads/sites/64/2014/10/Jet-Bandsaw-Model-JWBS-14CS.pdf', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(119, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Carbide Ratings/Rankins', 'C3 carbide stays sharp for longer periods of use but does require extra care to prevent chipping. C2 carbide is the more economi', 'Define quality of router bits', '', 'https://www.precisionbits.com/beginners-router-bit-buyer-guide-old.html', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(120, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Epoxy for Tables', 'Epoxy at huge discounts', '', 'n', 'https://overstocckepoxy.com', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(121, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'NU Stock Warren Buffet 8th largest  holding', 'Target price over $11 - Buy under 4.5', 'Watch stock', '', 'https://seekingalpha.com/article/4584867-nu-holdings-im-buying-buffett-fintech-play', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(122, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'NC Sales Tax', 'North Carolina state sales tax rate is currently 4.75%. The Moore County sales tax rate is 2.25%. = 7%', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(123, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'COVID Test Nc', 'free covid tests order 1st each month 2 tests', 'Order ID: ACT-NC-81HUHT0E', 'n', 'https://safercovid.org/mytest/trackorder.html?lang=en&orderID=ACT-NC-81HUHT0E', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(124, 'Golf balance board ', 'Golf ', 'Driver', 'Golf Down Under Board (DUB)', 'Helps to fix balance, follow through, compression through ball opens to 18 10.5 wide - slider with 2 wing nuts; about a .5-1 off', 'https://www.youtube.com/watch?v=CDQyqAOT8M4', 'Golf ', '', '', '2025-06-25 21:22:37', '2025-11-08 14:57:00'),
(125, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Router Sled  Jig', 'Use to flatten boards', 'Paste Wax to bottom to make router slide easier', '', 'https://www.youtube.com/watch?v=E_s8WCMu0GQ', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(126, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Premium Sheildz anti bacterial glass for iphone 12', 'Replacement $4.99', '', '', 'https://premiumshieldz.com/warranty-replacement/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(127, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Date Night Cypress Bend Vineyards', 'Jazzy Fridays $15 21904 Riverton Rd Wagram, NC 28396', 'Arnold from Kees Appliance Recommended', '', 'https://www.cypressbendvineyards.com/events/jazzy-fridays/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(128, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Add Time capsule to Windows', 'Must turn on SMB Client on Windows; Look for features turn on/off', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(129, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Access iCloud from command line', 'cd ~/Library/Mobile Documents/com~apple~CloudDocs/', 'not sure all files show up', 'n', 'https://osxdaily.com/2017/11/16/access-icloud-drive-command-line-mac/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(130, 'SUBSUBCAT', 'CAT', 'SUBCAT', '1Pass', 'One Password', 'Rick-Beach-732-319-6727-1P;', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(131, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Change Root password', 'go to Directory Utility; under edit change root password', 'drumhill1;', 'n', 'https://www.youtube.com/watch?v=vaCAs3jrY64', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(132, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Bookmarklet Tool', 'Tool to make bookmark javascript code', '', '', 'https://caiorss.github.io/bookmarklet-maker/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(133, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Area Code Lookup', 'Look up area codes', 'change 908 to number to lookup ; run areacode app lbin', '', 'https://www.localcallingguide.com/lca_prefix.php?npa=908', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(134, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Remove html tags', 'sed \'s/<[^>]*>//g\'', 'easy way to remove all html tags', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(135, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'javascript formatting', 'Format Javascript - js', '', '', 'https://beautifier.io', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(136, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Deer Repellent Device', 'PGFIT Latest 2023 Ultrasonic Animal repeller; solar with flashing led light and alarm', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(137, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Henckel Modernist Knife Set', 'Costco 20-piece Set Includes: 3.5 Paring Knife; 4 Paring Knife; 5 Serrated Utility Knife; 5.5 Prep Knife; 5.5 Boning Knife; 6 Ut', 'Sizes are in inches - to determine which is which', '', 'https://www.costco.com/henckels-modernist-20-piece-self-sharpening-knife-block-set.product.100512545.html?qid=91c1c91c393811ee81', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(138, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Used Turf', 'Used Turf and Putting Green Material', 'Contact Zack 464 belle-oaks dr suite 105 Charlotte, nc 28208 9514148153', '', 'https://raleigh.craigslist.org/fod/d/sanford-buy-one-get-one-used-turf-sale/7663494062.html', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(139, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Convert Photo to black and white no grey background', 'Open your image in GIMP.Duplicate the layer containing your image by right-clickingon the layer in the Layers panel and selectin', 'Convert to Black & White first: Image->Mode-GreyScale', 'n', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(140, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Convert text to 60 characters wide in each line in vim', ':%gq/.{1,60}>/', 'Convert carriage return on each line to add \\ before last character: 1,$s/$/\\', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(141, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Missing programs', 'sweetHome (sh3d)', 'List of files/applications missing from macbook air', '', 'https://www.sweethome3d.com/download.jsp', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(142, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Apple Rapid Security Response and MDM', 'Adds info to your path: /var/run/com.apple.security.cryptexd/codex.system/bootstrap/usr/local/bin:/var/run/com.apple.security.cr', 'confirm this is ok with apple', '', 'https://support.apple.com/guide/deployment/rapid-security-responses-dep93ff7ea78/web', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(143, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Inmotion Info', 'runsh - intellihome01; runsql - to run commandline mysql -', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(144, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Users Passwd', '/etc/passwd file only used in single user mode to see users: dscl . -ls /Users - users - prints out who is logged in; User info:', '', '', 'https://superuser.com/questions/592921/mac-osx-users-vs-dscl-command-to-list-user#:~:text=Get%20a%20list%20of%20all%20users,%28j', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(145, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Homebrew - brew installs applications', 'homebrew installs in /opt/homebrew/bin not /usr/lbin as before', '', '', 'https://brew.sh/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(146, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Brew Commands', 'brew upgrade - update Brew; brew outdated - outdated installs; brew upgrade - to updat loaded apps', 'Installs apps in /opt/homebrew', 'n', 'https://tinyurl.com/2baw9xrp', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(147, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'SSH Tips', 'See if Setup: sudo systemsetup -getremotelogin', 'Turn On: sudo systemsetup -setremotelogin on; Connect: sudo systemsetup -setremotelogin on; Connect ssh technastic@eagle.example', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(148, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Lutron Caseta Switch Reset', 'To Reset: Press 3X on Switch then Hold for 3 Sec. 2) Until it flashes - Release Tap On 3X will turn on Full; Press hold off 10 s', 'https://support.lutron.com/us/en/product/casetawireless/article/troubleshooting/How-to-Factory-Default-Caseta-Dimmers-and-Switch', '', 'https://www.youtube.com/watch?v=-hPMDZCisj0', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(149, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'IOS to ClipBoard', '1) Copy content on your iPhone. The content could be a block of text, an image, a link, or other content that can be copied.', 'Must do Copy on iPhone then go to Mac for it to paste right info!', '', '2)The copied content is now saved to the iPhone clipboard. It\'s also automatically added to the Mac clipboard.', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(150, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Bow X Xtender 46', 'Bow XT Xtender - $229 kit $149 for fence - foam feather boards, push stick hold downs', 'Look for it on sale and as a kit', '', 'https://bow-products.com/product-category/woodworking/xt-xtender/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(151, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Find exec', 'Change Owner sudo find /path/to/directory -type f -exec chown rbutareOld {} ;', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(152, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Router Jack', 'Using a car jack to make lift', '', '', 'https://www.youtube.com/watch?v=3_JBFmbieVY', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(153, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Spectrum IP Address', '65.191.164.168', '', '', 'https://whatismyipaddress.com/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(154, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Save Files and Photos on Iphone to USB Drive', 'Backup files and photos ios', '', '', 'https://www.pocket-lint.com/how-to-use-external-storage-device-with-iphone/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(155, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Waterfalls NC', 'From Julie on Okcupid', '', 'n', 'https://explorebrevard.com/top-10-waterfalls/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(156, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'pdf tools', 'pdf expert best but expensive; Office Only is Only pdf tool', 'Features Need: reduce size, drag photos in, put picture one sid and text on other side', 'n', 'https://rickbeachlbi.onlyoffice.com/rooms/shared/filter?searchArea=Active&page=1&sortby=DateAndTime&sortorder=descending', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(157, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Floor Plan Line Drawing', 'Can\'t Print or export without buying; but can do screen capture and print', '', '', 'https://app.smartdraw.com/editor.aspx?templateId=884b74c6-1bd8-41c3-9bff-aafb8b9c4cae&flags=128#depoId=53413077&credID=-5829196', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(158, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Hvac filters', 'Replace every 6 months airflow value should be 5-8; arrow is pointing in', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(159, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Lookup Information on People', 'What websites to get information: voterrecords.com nuwber.com (get neighbors to)', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(160, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Recipe Application Paul Recommended', 'Paprika 3 - IPhone Recipe Application', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(161, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Star Knobs', 'Easy to make star knobs - use forstner bit to star - drill center hole then use circle bit', 'Watch video - draw circles, make points at 12, 3, 6, 9 on circle, use forstner bit on outside, drill center hole, use round dril', '', 'http://tinyurl.com/2jdnj6f2', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(162, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Macos Contacts backup', 'Backup - export to vcf then you can conver to other formats', '', 'n', 'http://tinyurl.com/mv99wbp4', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(163, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Celiac Disease Video', 'Documentary on impact of celiac on body', '', '', 'https://vimeo.com/377383298', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(164, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Replacement vinyl leather', '', '', '', 'https://www.sofarefinish.com/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(165, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Measuring Tape Clip', 'Clip to help measure more accurately by using end of metal clip instead of tape measure', '', '', 'http://tinyurl.com/25n6by2h', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(166, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Lawn Mower Blade Sharpener', 'Bought from temu', '', '', 'http://tinyurl.com/y2nv9mcv', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(167, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Rebuild Spotlight', 'sudo mdutil -E /', '', '', 'hhttps://tinyurl.com/5n74ahdj', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(168, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Change Priority of Background low Priority jobs', 'sudo sysctl debug.lowpri_throttle_enabled=0;Now open Time Machine and click the Backup Now button to start the process;sudo sysc', 'Make sure you turn on low priority command after you run spotlight or timemachine', '', 'https://tinyurl.com/3wf7c9j3', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(169, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Start time Machine backup from Terminal', 'tmutil startback -d /Volumes/Name_offYouBackDisk', '', '', 'httpshttps://tinyurl.com/msdhwpdu', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(170, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Time Machine Primer', 'How to use tmutil', '', '', 'https://tinyurl.com/24srues8', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(171, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Check Square is Square', 'Go to board factory edge - line - flip over make another one over the one you just made - should line up', '', '', 'https://tinyurl.com/ye5k2btm', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(172, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'MSQL 8.0 > Passwords', 'SHOW VARIABLES LIKE \'validate_password%\'; - show level of security for passwords', '', '', 'https://www.bing.com/search?q=mysql+security+definer&FORM=QSRE1&showconv=1', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(173, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Processes Running', 'See what top processess are running  top -stats pid,command,cpu,th,pstate,time', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(174, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Speed up backup timemachine', 'start the process;sudo sysctl debug.lowpri_throttle_enabled=1 give it a high priority', 'Turn Off sudo sysctl debug.lowpri_throttle_enabled=1', '', 'https://tinyurl.com/288ykdat', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(175, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Spectrum Outage map', 'Show if Spectrum is down', '', '', 'https://tinyurl.com/43wpw66e', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(176, 'Putting tips', 'Golf', 'Putting', 'Golf Putting Tips', 'Michael Breed - Big Moss Recommended teacher', 'https://youtu.be/IO48vnDMi9Q', 'Golf, putting', '', '', '2025-06-25 21:22:37', '2025-11-08 14:53:00'),
(177, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Check Tax Return Status', '', 'Check Turbo tax status', '', 'https://ttlc.intuit.com/turbotax-support/en-us', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(178, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Image Search', '', '', '', 'https://tineye.com', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(179, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'ClipBoard Manager', 'Clip board that sits in toolbar - maacy', '', '', 'https://maccy.app/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(180, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Toolbar expander', 'Shows a large number of Icons in tool bar: ibar - menubar', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(182, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'PHP check Syntax', 'php -l filename', 'Check code for errors', 'n', 'https://phpcodechecker.com/', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(183, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Vim to format an entire file with indents', 'gg=G - gg - first line = indent G end of document', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(184, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Food Recipes', 'Recipes for Dairy Free, GF, Soy, Nut Recipes', 'Site has good food ideas', 'n', 'https://tinyurl.com/tazz5vpb', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(185, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Perltidy to update html file with indents', 'run :%!perltidy on file', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(186, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Hot Tub Info tips', '9 points to not making mistakes on hot tub spa', '', 'n', 'https://www.youtube.com/watch?v=5pJm9hY5aEc', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(187, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Add macbook as webserver', 'Edit file: /etc/apache2/extra/httpd-vhosts.conf to add lines<VirtualHost *:80> DocumentRoot /path/to/your/fidelity ServerName fi', 'Allows access to webserver files in directory listed', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(188, 'FileZilla', 'ftp', '', 'FileZillia Configuration\r\nhost: ftp.wefixyourtech.com file path: /public_html/jamwed/', 'Make sure you create ftp login in cpanel', '', '~', '', '', '2025-06-25 21:22:37', '2025-11-07 05:15:00'),
(189, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Vim earlier version', ':earlier 2h 2m 2days', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(190, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Root Password', 'drumhill1; for su for sudo DrumHill1;', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(191, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Check Disk Not sure if this will fix drive', 'diskutil list - list disk sizes; diskutil unmount - unmount busy drive', '', '', 'https://www.bing.com/copilot?toWww=1&redig=6B9934C6512348789DD356E6E445CC2D', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(192, 'Cleanup Backup - TimeMachine', 'timemachine', '', 'TimeMachine Cleanup\r\n\r\n', 'Go to /Volumes in Finder click on each sparsebundle to open each partition of drive\r\n\r\nGoto terminal /Volumes/[nameOfDrive] rm -rfv *.interupted files', '', 'timemachine, cleanup', '', '', '2025-06-25 21:22:37', '2025-11-08 13:35:00'),
(193, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Can\'t remove a file/directory as root', 'Must reboot in Safe mode and to to directory and try to remove sudo rm -rfv fileName', 'try sudo and su to remove', '', 'https://www.bing.com/copilot?toWww=1&redig=6B9934C6512348789DD356E6E445CC2D', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(194, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Copy a file from mac to iCloud', 'cp file ~/Library/Mobile Documents/com~apple~CloudDocs/', 'Easy way to backup files cd /Users/rbutare/Library/Mobile Documents/com~apple~CloudDocs', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(195, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Apache Setup', '', 'Good Document with details', '', 'https://www.git-tower.com/blog/apache-on-macos/#3-apache-configuration', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(196, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Convert Contacts to Excel, Csv', 'Goto app store get: Export Contacts to Excel, CSV; works great', 'backup files are in ~/contacts', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(197, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Apache server setup for rickWeb to get files in $HOME/Sites - http://rickWeb/info.php', 'Works for php and html', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(198, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Screen Capture options', 'Cmd->Shft-3 - Full screen Cmd->Shift->4 Partial Screen Draw Cmd-Shift-5 - Options for full screen', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(199, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Remove background garbage from jpg image so you can print', 'Go to Gimp Goto Colors Menu -> ThresholdThreshold Tool: Open your image in GIMP, go to the Colors menu, select Threshold to conv', '', '', 'https://www.lifewire.com/how-to-remove-background-gimp-4689190', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(200, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Reminders App - To Move Item from one list to another', 'Select Task - Hold down CMD and click item - Drag once you get new reminder icon', 'how to move items - doesn\'t work consistently', '', 'https://tinyurl.com/46scbx8a', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46');
INSERT INTO `tips` (`id`, `title`, `cat`, `subCat`, `descr`, `comments`, `links`, `tags`, `moreInfo`, `attachments`, `tipCreate`, `tipMod`) VALUES
(201, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Usb Drive Not Mounting automatically', 'Listing of disk Mounting Points stored in lbin/dataFiles dfOut.txt mountOut.txt; Use these if you have to force mount the drive', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(202, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Finder Defaults', 'Open Finder -> Go to As List ->Cmd+J - set defaults', 'Show Hidden Files: Cmd + Shift + .. ', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(203, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Clean up disk space', '', 'Good tips', '', 'https://tinyurl.com/2b59tjsm', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(204, 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Cleaning up Big Files', 'Empty Trash; goto settings->storage wait then go into each section to find large files; In messages you can remove large video f', 'Clean up big videos in Messages', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(206, 'free test2', 'images', 'photos', 'Images for Web - no cost, copyright, attributions', 'Get free images for web use commercial/personal', 'Did this change update time 17:22:37 and 17:23:46 vs ', 'n', 'https://www.pexels.com/', 'Free Stock I', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(213, '// These ini_set lines should be at the very top of your script ', '// These ini_set lines should be at the very top of your script ', '// These ini_set lines should be at the very top of your script ', '// These ini_set lines should be at the very top of your script\r\nini_set(\'display_errors\', \'Off\'); // Keep this off on live sites\r\nini_set(\'log_errors\', \'On\');\r\nini_set(\'error_log\', __DIR__ . \'/php_error.log\');\r\n\r\nadd thes lines her\r\n', '// These ini_set lines should be at the very top of your script\r\nini_set(\'display_errors\', \'Off\'); // Keep this off on live site', '', 'test', '// These ini_set lines should be at the very top of your script\r\nini_set(\'display_errors\', \'Off\'); // Keep this off on live site', '', '2025-06-26 20:54:30', '2025-06-26 20:55:38'),
(262, 'Test Script - Unit Test', 'testing', '', 'Good testing options\r\n~/lbin/testFname.sh\r\n\r\n', 'Getopts vs case\r\n-h vs --help', '', 'macos,sh,bash', '', '~/lbin/testFname.sh', '2025-11-05 13:04:00', '2025-11-05 13:04:00'),
(215, 'Grasses', 'Outdoor', 'plants', 'Pink and Green Grasses', 'Ruby Muhly Grass - $10', '', 'Plants', '', '', '2025-09-30 12:20:00', '2025-09-30 12:21:00'),
(216, 'Golf Simulator', 'Golf', '', 'Using foam Golf balls; Using Optishot2 $300 Screen: $200 $800 projector brighter lumens;\r\nUsing foam balls only 4” off the wall ', 'added new comments', 'https://www.msn.com/en-us/health/yogapilates/how-to-build-a-realistic-home-golf-simulator-on-a-budget/vi-AA1MEVSX?ocid=msedgntp&', 'Golf', '', '', '2025-09-30 13:14:00', '2025-09-30 13:14:00'),
(217, 'Cool Tools ', 'woodworking', 'Tools', 'Ideas on how to use other tools; like idea for chainsaw blade', '', 'https://www.facebook.com/share/r/175zQufqzQ/', 'tools', '', '', '2025-09-30 15:00:00', '2025-09-30 15:00:00'),
(218, 'Flop Shot', 'Golf', 'Chip', 'Flop shot - open face\r\nlower handle step back wider stance\r\nlong swing - back; break wrist;  need to release wrists and club go vertical - release and catch', '', 'https://www.facebook.com/reel/700387316366642', 'Golf', '', '', '2025-09-30 15:47:00', '2025-09-30 15:47:00'),
(219, 'ForeverGreen', 'golf', 'Tips', 'Multiple pages of tips and videos', '', 'https://golfgreens.com/golfgreens-tip-of-the-day/keep-stroke-short-short-distance-putts/', 'golf', '', '', '2025-10-03 20:21:00', '2025-10-10 20:21:00'),
(220, 'Macos Tahoe New Spotlight', 'macos', 'tahoe', 'When you invoke Spotlight Search with Command + Spacebar, you can switch to its dedicated modes like so: Applications (Command + 1), Files (Command + 2), Actions (Command + 3), and Clipboard (Command + 4). However, you can switch to these modes faster simply by adding the requisite number to your initial Spotlight invocation. For example, Command + Spacebar + 2 takes you straight to a Files search.', 'markdown - notes; spotlight - apps, files search\r\nMessages - polling; \r\nLock Screen - settings Clock\r\nFacetime - live translatio', 'https://www.macrumors.com/2025/09/24/all-the-new-macos-tahoe-features/', 'macos, tahoe', 'GenMoji - combine emojis\r\nPersonal Voice ; settings\r\nMultiple - Control Centers\r\nHold - assist phone?\r\nJournal - new app;\r\nClipb', '', '2025-10-04 01:55:00', '2025-10-04 01:55:00'),
(221, 'Get my ip Address', 'ip', '', 'How to get my ip address: https://whatismyipaddress.com/\r\n65.191.206.37 ', '', 'https://whatismyipaddress.com/', 'ip address,ip', '', '', '2025-10-06 00:46:00', '2025-10-06 00:46:00'),
(222, 'Visual Studio', 'vsc', 'tutorial', 'Videos for Visual Studio tutorials\r\n', '', 'https://code.visualstudio.com/docs/getstarted/introvideos', 'code, vsc,', '', '', '2025-10-04 01:29:00', '2025-11-08 13:47:00'),
(225, 'AI Code Tips', 'ai', 'code', 'TIps on Code \r\nvalid html, semantics included, responsive, error handling, \r\ndebug code via variable on or off, \r\n\r\nFeatures\r\n======\r\n- bs5\r\n- tailwind.css\r\n\r\ntemplate: \r\n=======\r\ndivPage, divNavBar, divToolBar: divToolBarLeft, divToolBarCenter, divToolBarRight, divTabs,\r\ndivContentMain\r\ndivContent: divContentLeft, divContentCenter, divContentRight\r\ndivFooter: divFooterLeft, divFooterCenter, divFooterRight\r\n\r\n Functions:\r\n========\r\n\r\nTheme Choose\r\nspinner for long processing calls i.e. Ajax\r\nscroll icon up/down on page - goto top/bottom', '', '', 'code, template', '', '', '2025-10-06 11:33:00', '2025-10-06 11:46:51'),
(226, 'TailWind.css Setup', 'code', 'css', 'set up in TailWind.css:\r\n-create tailwind.config.js\r\n- run tailwindcss --output styleTailWind.css\r\nThis will reduce the size of css to use only css needed\r\nTodo\r\n===\r\nmegamenu ../tailWind/tailWindMegaMenu.html\r\n../tailWind/navBarMega.html\r\n', 'tailwind.config.js\r\nmodule.exports = {\r\n  content: [\r\n    \'./*.php\',\r\n    \'./**/*.php\',\r\n    \'./*.html\',\r\n    \'./**/*.html\',\r\n    \'./*.js\',\r\n    \'./**/*.js\'\r\n  ],\r\n  theme: {\r\n    extend: {\r\n      colors: {\r\n        primary: {\r\n          DEFAULT: \'#2563eb\',\r\n          light: \'#3b82f6\',\r\n          dark: \'#1e40af\'\r\n        }\r\n      }\r\n    }\r\n  },\r\n  plugins: []\r\n};', '/opt/homebrew/var/www/rbutare/tailWind/', 'css', '<script src=\"https://cdn.jsdelivr.net/npm/@tailwindcss/browser@4\"></script><script src=\"https://cdn.jsdelivr.net/npm/@tailwindcss/browser@4\"></script><script src=\"https://cdn.jsdelivr.net/npm/@tailwindcss/browser@4\"></script><script src=\"https://cdn.jsdelid', '', '2025-10-07 10:48:00', '2025-10-07 10:48:00'),
(227, 'Convert HEIC to jpg', 'images', '', '?? Convert HEIC to JPG Using Finder Quick Actions\r\n-Open Finder and locate your .heic files.\r\n-Select one or multiple HEIC images.\r\n-Right-click (or Control-click) the selection.\r\n-Choose Quick Actions ? Convert Image.\r\n-In the pop-up:\r\n  -Set Format to JPEG\r\n-Choose Image Size (Small, Medium, Large, or Actual Size)\r\n-Click Convert.', '', '', 'heic, image, jpg', '', '', '2025-10-11 20:42:00', '2025-10-11 20:43:08'),
(228, 'FTP Applications', 'ftp', 'apps', 'Working:\r\n======\r\nfilezilla -\r\nMonsta - https://intellihometech.com/monstaFtp/\r\nftp2024@intellihometech.com\r\nftp.intellihometech.com\r\nhttps://intellihometech.com/monstaFtp/\r\nRick-Beach-732-319-6727-1P;\r\n\r\nFTP Username: ftp2024@intellihometech.com\r\nFTP server: ftp.intellihometech.com\r\nFTP & explicit FTPS port:  21\r\n\r\nNot working:\r\n=======\r\nTransmit\r\nCyberDuck\r\n\r\nLogin: ftp2024@intellihometech.com p: DrumH1;', '', '', 'ftp', '', '', '2025-10-12 18:03:00', '2025-11-08 17:45:00'),
(229, 'Five Crowns Development', 'develop', 'game', 'Todo\r\n===\r\ncardStyle - for deck pile offset images\r\n', '', '', 'dev', '', '', '2025-10-12 18:05:00', '2025-10-12 18:05:00'),
(230, 'SlideShow Dev', 'dev', '', 'Todo\r\n- why 2 json\r\n- save config to json \r\n- auto load with config\r\n- config: run, dev, test, dir?\r\n', '', '', 'dev', '', '', '2025-10-12 18:07:00', '2025-10-12 18:07:00'),
(231, 'Tips Development', 'dev', '', 'Tips Default to current time on load for add - add = mod; create always readonly \r\nChange Banner page and icon \r\nHow to create page icon\r\nMake Links if has string as http: a href\r\nsort by last modDate or id?\r\n\r\n\r\n\r\nhttps://fid.intellihometech.com/apps/tips/gemini/tips.php', '', 'http://localhost/rbutare/gemini/tips.php', 'dev', '', '', '2025-10-12 18:08:00', '2025-10-12 18:08:00'),
(232, 'Tail Winds Development', 'tutorial', 'tailwinds', 'Tailwinds.css - sample ideas\r\n', '', 'http://localhost/rbutare/tailwind/cruip-tutorials-main/', 'dev', '', '', '2025-10-12 18:11:00', '2025-10-12 18:11:00'),
(233, 'Tips for Unix Commands', 'unix', 'macos', 'find . -type f -exec chmod 664 {} \\;\r\nfind . -type d -exec chmod 775 {} \\;', '', '', 'macos,unix', '', '', '2025-10-12 20:51:00', '2025-10-12 20:51:00'),
(234, 'Vim Reset Width', 'vim', '', 'gg gqG \r\ng means : go to the beginning of buffer;\r\ngq means :\r\n\r\nSet textwidth to 80 (:set textwidth=80), \r\nmove to the start of the file (can be done with Ctrl - Home or gg), \r\nand type gqG. \r\ngqG formats the text starting from the current position and to the end \r\n\r\n', 'Non-Ascii characters\r\n/[^\\x00-\\x7F]\r\ng//[^\\x00-\\x7F]/s///g\r\n\r\nSet in Defaults\r\nset textwidth=80\r\n:set wrapmargin=2', 'https://stackoverflow.com/questions/5136902/vim-textwidth-has-no-effect', 'vim', '%s/[^[:print:]]//g', '', '2025-10-12 23:58:00', '2025-11-13 12:21:00'),
(235, 'Setup Config', 'vsc', 'coding', 'Visual studio setup \r\n.configs\r\nShell\r\nshellcheck fileName\r\nBrew installs - store what is installed\r\n\r\nHow to: \r\nrunsh - for access to remote files\r\ncreate a version - and move on\r\n', 'Todo', '', 'tips, setup, vsc', '', '', '2025-10-15 14:07:00', '2025-11-08 13:47:00'),
(237, 'Php', 'php', '', 'If php code in file.html - it is avoided ; if you change name to file.php ; then the code is executed.\r\ngood tip to link files so you can run either (sliceImg.php - sliceImg.html); one reads directory other just reads json file ; will also check for modifications dates to see if need to update list or json file', '', 'http://localhost/rbutare/airPlay/sliceImg.php', 'php,html', '', '', '2025-10-17 14:32:00', '2025-10-17 14:32:00'),
(238, 'Hacks - add type', 'hacks', '', 'Tool hacks - list types of hacks in video', '', 'https://www.facebook.com/share/r/1BG3Sdsk4S/?mibextid=wwXIfr', 'hacks, tools, todo', '', '', '2025-10-18 12:10:00', '2025-10-18 12:10:00'),
(239, 'Unix Comand Tips', 'tips', '', 'count files in directory - return only number found \r\nls -1 Docs/*.md | wc -l && ls -1 *.md 2>/dev/null\r\n\r\n\r\n', '#!/bin/zsh\r\n\r\necho \"=== MD files in Docs ===\"\r\ncount=$(ls -1 Docs/*.md 2>/dev/null | wc -l)\r\necho \"$count files\"\r\n\r\necho \"\"\r\necho \"=== MD files in root ===\"\r\nls -1 *.md 2>/dev/null || echo \"None (good!)\"\r\n', '', 'unix, cmd', '', '', '2025-10-18 20:52:00', '2025-11-08 13:44:00'),
(240, 'Add Applications for Slide Gallery', 'apps', 'code', 'brew install\r\n=======\r\n\r\npuppeteer \r\nplaywright\r\nfmpeg is a universal media converter\r\nnode\r\nPandoc is a Haskell library for converting from one markup format to\r\n       another\r\nhtmldoc - convert html to pdf; htmldoc -f output.pdf output.html;', 'Convert to pdf\r\nmarkdown WEDDING_SLIDESHOW_GUIDE.md > docs/WEDDING_SLIDESHOW_GUIDE.html\r\n\r\ncd /opt/homebrew/var/www/rbutare/airPlay\r\nfor file in docs/*.html; do\r\n    /Applications/Google\\ Chrome.app/Contents/MacOS/Google\\ Chrome \\\r\n        --headless --print-to-pdf-no-header \\\r\n        --print-to-pdf=\"docs/$(basename \"$file\" .html).pdf\" \\\r\n        \"file://$PWD/$file\"\r\ndone\r\n', '', 'brew, todo', 'update more information\r\n', '', '2025-10-19 23:18:00', '2025-10-19 23:18:00'),
(241, 'New Tools python', 'code', 'python', '? Other Ways to Use json.tool:\r\n1. Format a JSON file:\r\n2. Save formatted output:\r\n3. Validate JSON:\r\n4. Sort keys:\r\n? Alternative Tools:\r\nYou could also use:\r\n\r\n1. jq (more powerful):\r\n\r\n2. Node.js:\r\n\r\n3. PHP itself:\r\n\r\nphp listJson.php | php -r \"echo json_encode(json_decode(file_get_contents(\'php://stdin\')), JSON_PRETTY_PRINT);\"\r\n? Why We Used It:\r\nIn our case, we used it to verify the PHP output was:\r\n\r\n? Valid JSON\r\n? Properly formatted\r\n? Includes playlists from subdirectory\r\n? Easy to read and confirm\r\n? Summary:\r\nPart	What It Does	Example Output\r\nphp listJson.php	Runs PHP, outputs JSON	[\"a\",\"b\",\"c\"]\r\n|	Passes output to next command	(invisible)\r\npython3 -m json.tool	Formats JSON nicely	[\\n  \"a\",\\n  \"b\",\\n  \"c\"\\n]\r\nResult: Beautiful, readable JSON! ?\r\n\r\n', '', '', 'phython', '', '', '2025-10-20 22:26:00', '2025-10-20 22:26:00'),
(242, 'json validator', 'json', '', 'python3 -m json.tool faq.json > /dev/null && echo \"? JSON is valid\" || echo \"? JSON is invalid\"', '', '', 'json, validate, python', '', '', '2025-10-20 23:33:00', '2025-10-20 23:33:00'),
(243, 'MacOs/Unix Command Tips', 'todo', 'todo', 'ls -AGFp does not work on large directory; need to set COLUMNS=80 in ~/lbin/profileZsh\r\nmaster todo\r\n\r\nTips\r\n- fix sort to be newest to oldest\r\n- mega menu reports: kids, grand, bank, all Tots, managed, non, both man/non\r\nairPlayer\r\n=======\r\n- production run - uses config.json - should be production.json and playListProduction.json - test to make sure they both exist and are current ; create summary of config before running\r\n- find sh created for this\r\n\r\n\r\n', 'Other things todo:\r\n- find visual diff tool for csv8 9 and 9-10 with clipboard fix\r\n- locate working ftp\r\n\r\nVisual Code\r\n=================\r\nallow shell integration for commands to run automatically\r\n- find tutorials\r\n\r\n\r\n', '', 'macos,unix,commands', 'more info ideas from ', '', '2025-10-21 00:02:00', '2025-11-08 13:43:00'),
(244, 'Bocce Court Installation', 'bocce', '', 'Layers\r\n3-4\" stone ABC\r\n2\" Top Layer Screenings', '', 'https://www.legreillon.com/the-ultimate-diy-guide-to-bocce-court-construction-projects/', 'bocce', '', '', '2025-10-21 11:57:00', '2025-10-21 11:57:00'),
(245, 'Putting Green Installation Ide', 'golf', 'Putting', 'Good tips on setting up golf green \r\nIdeal Turf - Texas https://ideal-turf.com\r\nSoftware - \r\nCost Calculator - Not available \r\n\r\nTonage Calculator: https://www.hedrickind.com/tonnage-calculator/\r\nTons to Yds: https://cubicyardcalculator.org/tons-to-cubic-yard-calculator/\r\n54 tons to yds 41 Abc 60x50 3\"\r\n45 tons to yds 34 Abc 60x50 2.5\"\r\n40 tons to yds 30 Abc 60x50 2\"\r\nScreenings\r\n21 tons to yds 41 Abc 60x50 2\"\r\n', 'Do you want holes in putting green turf? Won\'t sand wash out and under turf?\r\nDIY Outdoor Putting Green Kits for the Backyard | Ultra Base\r\nhttps://www.ultrabasesystems.com/diy-designer-golf-kits.html', 'https://www.golfwrx.com/659400/taking-the-backyard-putting-green-plunge/?edge_reader_page#', 'putting,install', '', '', '2025-10-22 11:28:00', '2025-12-11 15:50:00'),
(246, 'Tips todo', 'Todo', 'todo', '== heading of Todo ==\r\n\r\n\r\n- add iPhone\r\n\r\n- add row expansion ;\r\n- add button in actions to view as html page in new tab\r\nxAdd delete \r\n- Data Reports Funcion \r\n- add navbar - Admin, help, etc,\r\n- View info iPhone\r\nxSort by newest \r\nxSet dates on add new\r\nxConfirm date mod on chg \r\n- move css and js scripts to external files of all reusable components \r\n- expansion needs to look like part of same row not different color; perhaps offset when expanded\r\nNeed a better ux to show filter is enabled; after update with a filter on new record is not shown? confusing - what is best approach; always clear filter after add or keep?\r\n\r\n\r\nAdd delete \r\nView info iPhone\r\nSort by newest \r\nSet dates on add new\r\nConfirm date mod on chg \r\nNeed a better ux to show filter is enabled; after update with a filter on new record is not shown? confusing - what is best approach; always clear filter after add or keep?\r\n\r\n', '-Add delete to update screen\r\n- datatable to show what filtering is happening; button to clear filter\r\n\r\n\r\n\r\ntips \r\n===\r\ndefault to sort order be by latest mod time or id\r\nadd dates not local time by default\r\n- url should be text and image to goto link\r\nReason for link/url - url is editable link is for active link\r\n', 'https://fid.intellihometech.com/apps/tips//tipsNew.php', 'Todo', 'delete or chg', '', '2025-10-22 12:21:00', '2025-12-13 15:38:00'),
(247, 'Tree Command', 'macos', 'todo', 'homebrew tree command\r\ntree -dsa\r\nget tree view with size in bytes\r\n', '', '', 'macos,todo, command', '', '', '2025-10-25 14:07:00', '2025-11-08 13:44:00'),
(248, 'PHP', 'php', '', 'php commands\r\nphp -m ; installed components\r\nphp -l test for syntax errors', '', '', 'php', '', '', '2025-10-25 14:11:00', '2025-10-25 14:11:00'),
(249, 'Node', 'node', 'todo', 'Tools \r\nnode -c assets/js/main.js - check syntax without executing\r\n', '', '', 'todo, node', 'Find tools to use with visual Studio Coding markdownlint README.md', '', '2025-10-25 19:08:00', '2025-11-08 13:44:00'),
(250, 'good tips', 'Tips', '', 'join boards at corner\r\nBottle cap screw onto tarp\r\nJoin two same size pipes heati', '', 'https://youtube.com/shorts/UwtHJoB0YX4?si=whz0dfMR4cDyl2vJ', 'Tips', '', '', '2025-10-27 16:09:00', '2025-10-27 16:09:00'),
(251, 'ai copilot', 'ai', 'copilot', 'ask copilot to compare info a cross tabs\r\nSmarter Edge “Copilot Mode”\r\nMulti?tab analysis – I can compare products, summarize across all your open tabs, or consolidate research into one view.\r\n\r\nJourneys – Your browsing history gets grouped by topic (say, “robot vacuums” or “travel planning”), so you can pick up research right where you left off.\r\n\r\nCopilot Actions – I can now handle tasks like unsubscribing from emails, booking reservations, or even opening pages by voice.\r\n\r\nRick, given your love of modular, stepwise workflows, I think the multi?tab analysis + Journeys combo in Edge might be right up your alley—it’s basically a research accelerator. Want me to show you how those two features could streamline your current robot vacuum research project?', 'Long?term Memory – I can now remember key details you share across sessions (and you can edit or delete them anytime). This makes our conversations more continuous and personalized.\r\n\r\nMico (Clippy 2.0) – An optional visual companion that reacts, listens, and adds a more expressive layer to our chats. Totally optional, but fun if you like a more animated presence.\r\n\r\nReal Talk Mode – A new conversation style where I’m more direct and transparent, great for when you want less polish and more straight talk.\r\n', '', 'tips, junk', 'Not sure what this is for\r\n', '', '2025-10-29 02:14:00', '2025-10-29 02:14:00'),
(252, 'Macos Performance', 'macOS', '', 'Optional: Using:  memory_pressure\r\nUsing vm_stat for detailed stats: vm_stats\r\nChecking Memory (RAM) Usage top -l 1', 'For overall storage management, identify large files with du commands and remove unnecessary files.\r\nTo continuously monitor memory and CPU usage, you can use:\r\ntop -stats pid,command,cpu,mem', '', 'macOS', 'Overview of all mounted filesystems using df: df -h\r\n\r\ndu -sh ~/Documents\r\n\r\nFinding the Largest Files and Folders: du -ah ~/ | sort -rh | head -n 10', '', '2025-10-29 02:16:00', '2025-10-29 02:16:00'),
(253, 'Ai docs requirements ', 'Vsc', 'Coding', 'create docs requirements.md\r\nPlan.md tasks.md', '', 'https://blog.jetbrains.com/junie/2025/10/how-to-use-a-spec-driven-approach-for-coding-with-ai/', 'Ai, coding todo', 'add samples', '', '2025-10-31 12:50:00', '2025-10-30 12:50:00'),
(254, 'How to create favicon', 'image', 'favicon', 'Generate favicon.ico with Text - one lettter', '', 'https://favicon.io/favicon-generator/', 'image, favicon', 'https://favicon.io/favicon-generator/ Text', '', '2025-11-01 14:09:00', '2025-11-01 14:09:00'),
(255, 'Convert Video', 'images', 'ffmpeg', 'convert to smalller mp4\r\nffmpeg -i A211.webm -vcodec libx265 -crf 30 -c:a copy -strict experimental A211.mp4; \r\n\r\n\r\n0\r\n\r\n', '', 'https://stackoverflow.com/questions/18123376/webm-to-mp4-conversion-using-ffmpeg', 'ffmpeg, images, video, mp3,mp4,webm', 'Trim/Shorten/Cut\r\nhttps://shotstack.io/learn/use-ffmpeg-to-trim-video/\r\n\r\nffmpeg -sseof -600 -i input.mp4 -c copy output5.mp4\r\nffmpeg -sseof -00:10:00 -i input.mp4 -c copy output6.mp4\r\nBoth of the above two commands will make a cut of the last 10 minutes of the input video.\r\n\r\nCut Front/Beginning\r\nffmpeg -i $fileOutput1 -ss 00:00:00 -to 00:6:08 -c:v copy -c:a copy $fileTrim\r\nuse time on left to cut at the end\r\n\r\nThe above command uses -to to specify an exact time to cut to from the starting position. The cu', '', '2025-11-01 20:00:00', '2025-11-01 20:00:00'),
(256, 'List Directory Code', 'listdir', 'code', 'All Directories\r\nhttp://localhost/rbutare/airPlay/listDirAll.html\r\n\r\n\r\n\r\nhttp://localhost/rbutare/airPlay/utilities/php/listDir.php\r\n\r\n', 'http://localhost/rbutare/airPlay/airPlay/utilities/php/listDir.php\r\nhttp://localhost/rbutare/airPlay/airPlay/utilities/php/listDirectory.php\r\nhttp://localhost/rbutare/airPlay/memoriesPlayer/listDirExplorer.php\r\nhttp://localhost/rbutare/airPlay/memoriesPlayer/listDirGraph.php\r\nhttp://localhost/rbutare/airPlaymemoriesPlayer/listDir.php', 'http://localhost/rbutare/airPlay/listDirAll.html', 'directory, listdir', 'explorer', '', '2025-11-01 22:41:00', '2025-11-01 22:41:00'),
(257, 'Ai Accounts', 'ai', 'code', 'Accounts: zencoder - rickbeachlbi@gmail.com  ', 'xx', 'x', 'openai, ai, code', 'xxx', 'xx', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(258, 'mySql Access', 'mysql', '', 'If mysql access gets denied from localhost;\r\ngo to cpanel.intellihometech.com - mysql Remote add ip address to allow access\r\n', 'sue ip: 136.56.107.113', '', 'mysql', '', '', '2025-11-03 18:26:00', '2025-11-03 18:26:32'),
(260, 'Tips Fidelity', 'app', 'todo', 'Create a new set of code to work from to \r\n- cleanup ui\r\n- fix navbar menus; toolbar mouse over icons\r\n- all data search/report\r\n- master app - toggle columns, copy, print, csv, buttons\r\n\r\nTodo for fidelity app https://fid.intellihometech.com/table.php\r\n- Report on high low for year\r\nbegin end year report\r\nreturns for Year, ytd, all; aTot, bTot, cTot etc ', '- Mega Menu\r\n- DataTable\r\n- Search by column\r\n- update connDb - code - refactor \r\n5-18-2018 1,241,302.68\r\n\r\n', 'https://fid.intellihometech.com/table.php', 'apps, fidelity', '', '', '2025-11-05 11:29:00', '2025-11-08 13:42:00'),
(261, 'Bootstrap 5 Examples', 'bootstrap', 'todo', 'List of all bootstrap examples\r\n~/lbin/tipsSrc/themePlay/bootstrap-5.0.2-examples', '', '/tipsSrc/themePlay/bootstrap-5.0.2-examples', 'todo, bootstrap, example', '', '~/lbin/tipsSrc/themePlay/bootstrap-5.0.2-examples', '2025-11-05 11:40:00', '2025-11-05 11:40:00'),
(263, 'Chat questions ', 'Ai', 'S', 'D', 'C', 'https://www.tomsguide.com/ai/i-created-one-chatgpt-prompt-that-works-in-absolutely-any-situation-heres-how-to-use-it', 'Ai', 'M', 'T', '2011-12-25 05:00:00', '2011-12-24 05:00:00'),
(264, 'Golf putting', 'Golf ', '', 'Putting tips', '', 'https://www.facebook.com/share/v/1CWMiKXUE2/?mibextid=wwXIfr', 'Golf, putting', '', '', '2025-11-07 06:16:00', '2025-11-07 06:16:00'),
(265, 'MacOs Tools Cleanup - Space', 'macOs', '', 'Downloaded from app store: \r\nDisk Diag: - Clean up system files shows good view of disk\r\nMemory Diag: - clean memory\r\n\r\nHomebrew:\r\njdupes - Duplicate file (newer/faster)\r\nfdupes - Duplicate file (finds pairs)', 'CLI/Shell \r\n~/lbin/macCleaner - tool to cleanup system and large files\r\n~/lbin/brewInfo - files installed by homebrew\r\n', '', 'macOs, tools, disk, cleanup', '', '/Users/rbutare/lbin/macCleaner', '2025-11-07 13:50:00', '2025-11-07 13:52:00'),
(266, 'Visual Diff Tool', 'diff', 'vim', 'Visual diff of two files:\r\nvimdiff file1 file2', 'Good tool to see diffs between two files', 'https://lynxbee.com/compare-files-with-visual-file-diff-tool-of-vim/', 'vim, diff', '', '', '2025-11-07 15:07:00', '2025-11-07 15:07:00'),
(267, 'Microsoft Copilot Features', 'copilot', '', 'Tips copilot edge msft 365', 'kevinstratvert.com\r\n\r\nTop 10 Copilot Features to Boost Productivity\r\nCompare Files in OneDrive\r\n\r\nUse Copilot to quickly compare two documents side-by-side and highlight differences.\r\n\r\nSummarize Emails in Outlook\r\n\r\nCopilot can extract key points from long email threads, saving time and reducing inbox fatigue.\r\n\r\nGenerate PowerPoint Presentations\r\n\r\nCreate branded, professional slides from a simple prompt or Word document.\r\n\r\nAnalyze Excel Data\r\n\r\nAsk Copilot to find trends, generate charts, or explain for', 'https://youtu.be/sdN7C8xRoH4?si=6PKwBW5XiIGlTOKc', 'msg, edge, copilot, tips', '', '', '2025-11-07 15:28:00', '2025-11-07 15:33:00'),
(268, 'Outlook - Tips', 'outlook', 'tips', 'How to search:\r\nfrom:spectrum AND isflagged:false - no flag\r\n\r\nUse filter to get advanced search', '', '', 'outlook', '', '', '2025-11-08 12:40:00', '2025-11-08 12:40:00'),
(269, 'Cleanup Directories Files', 'cleanup', 'todo', 'Goto terminal /Volumes/[nameOfDrive] rm -rfv *.interupted files\r\nscreenshotter - icloud get icons images colors\r\n', 'Cleanup icloud;\r\n\r\nHow to clean up messages of big images/movies\r\n\r\nhttps://beebom.com/how-clear-icon-cache-mac/', 'https://beebom.com/how-clear-icon-cache-mac/', 'cleanup, todo', '/Library/Caches/com.apple.iconservices.store - can cleanup ', '', '2025-11-08 13:36:00', '2025-11-08 13:42:00'),
(270, 'Apple Genius Bar', 'MacBook', '', 'Problems:\r\nRunning out of Application Memory\r\n- calendar in toolbar/menubar\r\n- remove images from messages\r\n- remove system backup /temporary files\r\n- remove language files\r\n- devtools?', '', '', 'apple, genius', '', '', '2025-11-08 13:50:00', '2025-11-08 13:50:00'),
(271, 'Southwest trip', 'Trip', '', 'National Park ', '', 'https://www.facebook.com/share/r/1HnKW2mULm/?mibextid=wwXIfr', 'Trip', '', '', '2025-11-08 14:36:00', '2025-11-08 14:36:00'),
(272, 'Golf swing door', 'Golf', '', 'door frame swing method', '', 'https://www.facebook.com/share/v/14Vy2TgQdrK/?mibextid=wwXIfr', 'Golf', '', '', '2025-11-08 14:44:00', '2025-11-08 14:44:00'),
(273, 'Trips nc', 'Trips', 'Waterfalls ', 'Top 10', '', 'https://www.facebook.com/share/r/17PbYcKLLF/?mibextid=wwXIfr', 'Nc,trip, waterfall ', '', '', '2025-11-08 16:13:00', '2025-11-08 16:13:00'),
(274, 'Vsc Requirements documents', 'vsc', 'todo', 'Terms:\r\nModular resuable components, toast, html, bs5, fontawesome, Follow DRY (Don\'t Repeat Yourself) principles,camelCase, card based theme, mobile responsive, \r\nprofessional look and feel, dashboard\r\nfunctions: use/chg bs themes, spinner for slow tasks, page up/down, toast messaging, \r\nadmin: database checks, security. checks, duplicates, bad records, dashboard, tools to add to faq, missing days stock market open (id list of holidays/closings), adhoc queries and tools;  todo list of new/bug features\r\nSettings: global settings debugFlg, theme, user level, adv debugging - additional error messaging depending on the error level\r\n\r\nuse of json configuration files for customization/setup\r\n\r\nDocumentation:\r\nuser, programmer, function calls, flow charts, recommendations for improvement\r\n\r\nimprovements;\r\nrefactor, performance, id long running processes, duplicate/obsolete code, o\r\n\r\nCode breakdown/modules designed for re-use in other apps; organize that way;\r\nstandard app configuration: ', 'Phase 2 (if desired):\r\n\r\nCharts & visualizations\r\nAdvanced filtering sidebar -  flat picker\r\nRecent reports widget\r\nKeyboard shortcuts\r\n\r\nPhase 3 (future):\r\n\r\nUser preferences panel\r\nFavorites system\r\nInteractive tour\r\nCustom report builder\r\n\r\nNext up is implementing report tabs for Data/Chart/Summary views\r\nCan you build an app that \r\n\r\nStructural divs in MVC Template \r\nNow let\'s refactor the includes to be content-only (no major structural divs):', 'https://code.visualstudio.com', 'vsc, todo, requirements', '', '', '2025-11-08 23:19:00', '2025-11-13 03:07:00'),
(275, 'Golf swing ', 'Golf', '', 'alignments practice ', '', 'https://www.facebook.com/share/r/17jU7GS6rA/?mibextid=wwXIfr', 'Golf, practice ', '', '', '2025-11-09 01:56:00', '2025-11-09 01:56:00'),
(276, 'Piwigo Gallery Software', 'photoGallery', '', 'Piwigo has been successfully installed at :\r\nhttps://intellihometech.com/piwigo\r\nAdministrative URL : https://intellihometech.com/piwigo/identification.php\r\nadmin page; \r\nhttps://intellihometech.com/admin.php?page=site_update&site=1\r\n', 'admin: OurLifeInPics;\r\n', 'https://intellihometech.com/piwigo', 'piwigo,photos', '', '', '2025-11-09 12:23:00', '2025-11-09 12:45:00'),
(277, 'Chip with tee', 'Golf', 'Chip', 'Tee grip length in front of chip\r\nFollow thru over tee\r\n\r\n3 tips\r\n\r\n\r\nhttps://www.facebook.com/share/v/167eTLBUT8/?mibextid=wwXIfr', 'Chip with stick in belt\r\nhttps://www.facebook.com/share/r/1QmZ1TLuNh/?mibextid=wwXIfr', 'https://www.facebook.com/share/r/1HTf6T79hh/?mibextid=wwXIfr', 'Golf,chip', '', '', '2025-11-11 04:12:00', '2025-12-14 16:50:00'),
(278, 'Wish List', 'wish', '', 'Wish List Items\r\n============\r\n- Weather Station\r\n- Heated Blank\r\n- \r\n- Power hedge trimmer\r\nEGO POWER+ 56-volt 26-in Battery Hedge Trimmer 2.5 Ah Battery Included , Charger Included\r\nItem #5207557 |Model #HT2601 $269 lowes with charger; \r\nModel Next door: \r\n- New Vacuum - Hazel\r\n- new slippers or Same shoes\r\n', '', 'https://www.protoolreviews.com/ego-carbon-fiber-rail-hedge-trimmer-review/', 'wishlist', '', '', '2025-11-11 16:54:00', '2025-11-11 21:21:00'),
(279, 'Websites info', 'Web', 'Hosting', 'website host: inmotionhosting\r\nRegistration : NAMECHEAP.com', '', 'https://www.namecheap.com/myaccount/signout/?loggedout=yes', 'Web,up, hosting,website', '', '', '2025-11-12 07:09:00', '2025-11-12 07:09:00'),
(280, 'Git Hub Ticket System', 'gitHub', '', 'Ticket system for github', 'Paid on 20251106 $100 for gitpro?', 'https://support.github.com/tickets/personal/0', 'github, support', '', '', '2025-11-12 14:43:00', '2025-11-12 14:43:00'),
(283, 'Best ai use cases', 'Ai', '', 'Ai for ', '', 'https://github.blog/ai-and-ml/github-copilot/which-ai-model-should-i-use-with-github-copilot/?utm_campaign=LCM_CopilotProOnboarding_dev&utm_source=github', 'Ai, ', '', '', '2025-11-12 20:55:00', '2025-11-12 20:55:00'),
(282, 'Putting Green Quotes - Excel', 'quote', 'golf', 'Putting green quotes excel ', '', '', 'quote,golf,putting, ', '', '~/Golf/golfFinal/20251111QuotesAll.xlsx', '2025-11-12 15:08:00', '2025-11-12 15:08:00'),
(284, 'Unix/Macos Commands', 'macos', '', 'curl -X GET \'http://localhost/rbutare/fid/templates/v2/common/admin/tools/permission-checker.php?action=critical\'\r\n\r\nsync directories\r\nrsync -av old new\r\n ', '', '', 'unix, macos', '', '', '2025-11-15 12:45:00', '2025-11-15 12:45:00'),
(285, 'Git tutorial ', 'Git', '', 'These key commands are now in your toolkit: git init, git add, git commit, git status, git log, git branch, git checkout, git merge, git push, git pull, and git clone.\r\n', '', 'https://deployn.de/en/blog/git-tutorial/', 'Git, tutorial', '', '', '2025-11-17 12:36:00', '2025-11-17 12:36:00'),
(286, 'Ai best model', 'Ai', 'ai', 'Which model is best for ? \r\nFill in \r\n', 'https://github.blog/ai-and-ml/github-copilot/which-ai-model-should-i-use-with-github-copilot/?utm_campaign=LCM_CopilotProOnboarding_dev&utm_source=github', 'https://github.blog/ai-and-ml/github-copilot/which-ai-model-should-i-use-with-github-copilot/?utm_campaign=LCM_CopilotProOnboarding_dev&utm_source=github', 'Ai, todo', '', '', '2025-11-18 13:18:00', '2025-11-19 12:21:00'),
(287, 'Vsc plan agent', 'Vsc', 'Ai', 'Plan agent \r\nDefine requirements then see plan to execute ', 'Try out', 'https://youtu.be/xR3fuKtWGN0', 'Vsc,ai', '', '', '2025-11-20 10:52:00', '2025-11-20 10:52:00'),
(288, 'Testing Commands', 'test', '', 'Confirm sql is running: \r\nnc -vz intellihometech.com 3306\r\n# or\r\ntelnet intellihometech.com 3306', 'add more to this', '', 'test, todo', '', '', '2025-11-20 04:38:00', '2025-11-20 04:38:00'),
(289, 'ClipChamp Video Editor', 'video', '', 'Video editor to create easy to use', '', 'https://app.clipchamp.com/consumer/home', 'img, video', '', '', '2025-11-23 00:38:00', '2025-11-23 00:38:00'),
(290, 'Setapp - macpaw', 'macos', 'apps', 'Setapps - 260 plus apps and ios apps\r\nmacCleaner, cleanMyMac, bartender, istat, cyberduck, unclutter, menubar, menubarX\r\nunite?, forklift, cleanmyIphone, touchRetouch, glyphs mini, expressions, \r\nssh config,sql pro,   swiftly Launch, typingmind, riveo, moonlock, mindNote Next, joyCast - improve audio\r\ncommandOne, houdah spot, pdfSqueezer, gemini, supercharge, bartender, displaybuddy, \r\n\r\nwriteCode, permute -convert files, bartender\r\n\r\nAI: boltAi, plus, ', 'Future want eney - ai assistant', 'https://setapp.com/pricing?irgwc=1&afsrc=1&clickid=SqozojQHtxycRgRz93xED1iiUkpWOIxuUzpLyw0&iradid=368247&irpid=2003851&utm_content=TEXT_LINK&utm_campaign=Bing%20Rebates%20by%20Microsoft&sharedid=EdgeBingFlow&utm_medium=affiliate&mpaid=3&utm_source=impactra', 'macos, apps, ios, macpaw', '', '', '2025-11-24 18:09:00', '2025-11-24 18:09:00'),
(291, 'macos tools', 'macOs', '', 'Tools to test:\r\nmacCleaner - clean up files to get more space\r\nsysDashBoard - Dash board\r\nsysDashBoard.txt - Requirememnts\r\nmemDashBoard - memory Dashboard\r\nmemChk - memory check\r\n\r\n', 'sysDashBoard -h\r\nSystem Dashboard Help\r\n---------------------\r\nOptions:\r\n  --help, -h       Show this help message\r\n  --memory, -m     Memory overview + top processes by RSS\r\n  --cpu, -c        Top processes by CPU usage\r\n  --disk, -d       Disk space usage\r\n  --load, -l       Load average\r\n  --proc, -p       Total process count\r\n  --swap, -s       Swap usage\r\n  --all, -a        Run full dashboard (all checks)', '', 'macOs,lbin', '', '', '2025-11-24 20:24:00', '2025-11-24 20:24:00'),
(292, 'Brew - all installed files', 'brew', '', 'Installed files/apps from brew\r\nbrew list\r\nsee file in: ~/lbin/brewList.txt', 'fd .mov -E Library -X ls -lh - exclude Library and show ls -lh\r\nfid txt lbin - search directory lbin\r\nfd \"^x.*.txt\" lbin -X vim - send items found to vim\r\nfd  \"xm\" lbin -E  \"*.txt\"  - find files xm without .txt\r\nfd \"^x.*.txt\" lbin  - need to use regular expressions to get all the files \r\nfd  . lbin -e psh -X cat - find anything . in lbin with extension psh -X send to cat', '', 'brew, macos, apps', '', '~/lbin/brewList.txt', '2025-11-26 12:34:00', '2025-11-26 12:34:00'),
(293, 'macOS applications ', 'Macos', '', 'Mac apps\r\nhttps://github.com/jaywcjlove/awesome-mac', '', 'https://github.com/jaywcjlove/awesome-mac', 'macOS, software ', '', '', '2025-11-26 18:29:00', '2025-11-26 18:29:00'),
(294, 'Alexa development', 'alexa', 'code', 'alexa Development \r\n', 'alexa ideas:\r\nAlex tell me the weather outside (from my current location) give temperature, real feel and humidity, todays high and low; ', 'https://www.youtube.com/@AlexaDevelopers', 'alexa, code', '', '', '2025-11-30 13:02:00', '2025-11-30 13:02:00'),
(295, 'Cleaning up disk space ', 'macos', '', 'Commands to cleanup mac disk:\r\n~/lbin/macCleaner\r\n~/lbin/macCache - cache cleaner', 'key folders to check\r\ndu -sh /Users/rbutare/Library/Caches\r\ndu -sh /Users/rbutare/Library/Caches/Google/Chrome\r\ndu -sh /Users/rbutare/.cache\r\ndu -sh /Users/rbutare/.npm\r\n\r\nsudo softwareupdate -l        - shows updates ready to install\r\nsudo softwareupdate --clear-catalog     - clears out files maybe left over from updates of apple installs\r\n\r\nsudo softwareupdate ', '', 'macos', '', '', '2025-12-02 14:34:00', '2025-12-02 14:34:00'),
(296, 'API keys', 'Api', '', 'API dev keys\r\nFINNHUB_API_KEY=d198di1r01qkcat6n9mgd198di1r01qkcat6n9n0', '\"ALPHA_VANTAGE_API_KEY\": \"A40SNBVIKGJ5KCAR\",\r\n        \"FINNHUB_API_KEY\": \"d198di1r01qkcat6n9mgd198di1r01qkcat6n9n0\",\r\n        \"TWELVE_DATA_API_KEY\": \"1fc95863eb26405aa1c0925bb7ab7b96\",', '', 'Api', '', '', '2025-12-03 01:47:00', '2025-12-03 01:47:00'),
(297, 'Green 2 ', '', '', 'Xgolf ultra base\r\nMonterey $6400 + shipping Nancy\r\n\r\nPlate compactor venom $409\r\nConcrete cutter $110\r\n2” pavers bocce walkway\r\n3” 45/30\r\n', '', '', 'Putting ', '', '', '2025-12-03 02:49:00', '2025-12-03 02:49:00'),
(298, 'Plate Compactor', 'tools', 'compactor', 'Vevor Model: RYPBYS35165HP8ZULV0\r\nPlate 23.7 x 18.9\"\r\nCoupon code\r\nAE82CE7CA0CB104E', 'Lowes: https://www.lowes.com/pd/VEVOR-Plate-Compactor-23-7-in-x-18-9-in-Tampers/5015875849?irclickid=SRD0U2V0dxycRtrQtXxZYVEuUkpTErx2UzpLyw0&irgwc=1&afsrc=1&cm_mmc=aff-_-c-_-prd-_-mdv-_-gdy-_-all-_-EdgeBingFlow0-_-2003851-_-0 $399', 'https://www.bing.com/videos/riverview/relatedvideo?q=RYPBYS35165HP8ZULV0&ru=%2fsearch%3fq%3dRYPBYS35165HP8ZULV0%26FORM%3dSHOPZR&mmscn=vwrc&mid=DBC4DB3FACB00F14B225DBC4DB3FACB00F14B225&FORM=WRVORC&ntb=1&msockid=cf1fe8bed03311f0924e20f7910f87ae', 'compactor, tools', 'https://www.vevor.com/promotion/coupon-center-special-119.html?currency=USD&lang=en', '', '2025-12-03 11:09:00', '2025-12-05 09:53:00'),
(299, 'Weather', '', '', '#!/usr/bin/env php\r\n<?php\r\n// weather.php - Dispatcher-style CLI for VEVOR station\r\n\r\n$options = getopt(\"\", [\"station:\", \"color\", \"debug\"]);\r\n$stationId = $options[\'station\'] ?? \'YOUR_STATION_ID\';\r\n$useColor  = isset($options[\'color\']);\r\n$debug     = isset($options[\'debug\']);\r\n\r\n// Fetch JSON from Weather Underground API\r\n$url = \"https://api.weather.com/v2/pws/observations/current?stationId={$stationId}&format=json&units=m&apiKey=YOUR_API_KEY\";\r\n$json = file_get_contents($url);\r\n$data = json_decode($json, true);\r\n\r\n// Dispatcher: route events\r\nfunction dispatch($data, $useColor) {\r\n    $temp = $data[\'observations\'][0][\'metric\'][\'temp\'];\r\n    $wind = $data[\'observations\'][0][\'metric\'][\'windspeed\'];\r\n    $rain = $data[\'observations\'][0][\'metric\'][\'precipRate\'];\r\n\r\n    $alerts = [];\r\n    if ($temp < 0) $alerts[] = \"Frost Alert\";\r\n    if ($rain > 10) $alerts[] = \"Heavy Rain\";\r\n    if ($wind > 40) $alerts[] = \"Storm Warning\";\r\n\r\n    foreach ($alerts as $alert) {\r\n        echo $useColor ? \"\\033[31m$alert\\033[0m\\n\" : \"$alert\\n\";\r\n    }\r\n}\r\n\r\n// Run dispatcher\r\ndispatch($data, $useColor);\r\n\r\nif ($debug) {\r\n    print_r($data);\r\n}\r\n', 'How to get my zip', '', 'Todo', '', '', '2025-12-04 12:16:00', '2025-12-04 12:16:00'),
(300, 'zen coder test on lbin', 'code', '', '~/lbin/.zencoder/rules\r\nquetions\r\nWhat would you like me to do?\r\n\r\nDefine coding standards for your project from scratch?\r\nReview and improve existing documentation/coding standards?\r\nCreate specific documentation (e.g., contribution guidelines, code style guide)?\r\nSomething else?\r\nScope - Which part(s) of your repository should this apply to?\r\n\r\nAll scripts (Bash, Shell, Python, PHP, AWK, JavaScript)?\r\nSpecific language or component (e.g., just the Bash scripts, or just Python)?\r\nThe entire lbin project?\r\nFocus Areas - Are there specific aspects you\'d like standards for?\r\n\r\nNaming conventions?\r\nError handling and logging?\r\nCode organization and structure?\r\nDocumentation/comments?\r\nSecurity practices?\r\nPerformance considerations?\r\nAll of the above?\r\nDocumentation Format - What documentation would be most useful?', 'Files Recommended for vsc\r\nCONTRIBUTING.md for contributors?\r\nCODING_STANDARDS.md or STYLE_GUIDE.md?\r\nREADME updates for specific components?\r\nInline examples in existing files?\r\n', '', 'code,todo', '', '', '2025-12-04 21:12:00', '2025-12-04 21:13:00'),
(301, 'Setapp Apps downloaded', 'setapp, macos, ios', '', 'Macos Apps\r\nAnyTrans - transfer to from ios/macos\r\nistat - system status\r\nmacCleaner - clean up mac $50\r\nBolt AI - AI - coding helper\r\nhoudaspot - $19', 'ios Apps\r\nAnyTrans - transfer to from ios/macos', '', 'setapp, ios, macos', '', '', '2025-12-04 21:22:00', '2025-12-08 16:11:00'),
(302, 'htaccess', 'webserver', '', '.htaccess\r\n\r\n  1 Options +Indexes$\r\n  2 IndexOptions ScanHTMLTitles FancyIndexing IconsAreLinks$', '', '', 'webserver', '', '', '2025-12-04 21:32:00', '2025-12-04 21:32:00'),
(303, 'Golf drill no right hand', 'Golf', '', 'Open right hand and swing thru', '', 'https://www.facebook.com/share/v/17hsbxccTc/?mibextid=wwXIfr', 'Golf', '', '', '2025-12-05 09:44:00', '2025-12-05 09:44:00'),
(304, 'macos pipe settings', 'macos', '', 'set -euo pipefail \r\n\r\nis a common “strict mode” line that makes your shell script fail fast and not silently ignore errors.?\r\nWhat each flag does\r\nset -e\r\nExit the script immediately if any simple command returns a non?zero status (an error), instead of continuing and possibly doing the wrong thing based on bad state.?\r\nset -u\r\n\r\nTreat use of unset variables as an error and exit, which helps catch typos and missing environment variables ($FOO when FOO was never set).?\r\n\r\nset -o pipefail\r\n\r\nMake a pipeline like cmd1 | cmd2 | cmd3 return a non?zero status if any command in the chain fails, not just the last one; this prevents errors in the earlier stages of a pipeline from being silently ignored.?\r\n\r\nTogether, set -euo pipefail makes scripts much safer: they stop on the first real error, they don’t quietly substitute empty strings for missing variables, and they properly detect failures inside pipelines instead of reporting success when something actually broke earlier in the chain.?\r\n\r\n\r\n', '', '', 'macos, tip', '', '', '2025-12-05 23:43:00', '2025-12-05 23:43:00'),
(305, 'Pinehurst 360 view', 'golf', '', 'Pinehurst 360 view of site', '', 'https://homeofgolf.com/360-tour/?utm_source=newsletter&utm_medium=email&utm_campaign=April2025', 'golf', '', '', '2025-12-06 15:39:00', '2025-12-06 15:39:00'),
(306, 'Golf swing ', 'Golf', '', 'Alignment stick to club\r\n1 goes down front leg\r\n2 back point to ground\r\n3 follow thru not hit body', '', 'https://www.facebook.com/share/r/1AUYnUjk5F/?mibextid=wwXIfr', 'Golf', '', '', '2025-12-07 06:58:00', '2025-12-07 06:58:00'),
(307, 'Lazy guy', 'Woodworking ', '', 'Puzzle table \r\nhttps://lazyguydiy.com/how-to-make-a-puzzle-tray-with-storage/', '', 'https://lazyguydiy.com/how-to-make-a-puzzle-tray-with-storage/', 'Woodworking ', '', '', '2025-12-07 13:21:00', '2025-12-07 13:21:00'),
(308, 'Bootstrap Theme Generator', 'bootstrap', 'colors', 'How to generate Bootstrap themes\r\nhttps://www.haketi.com/bootstrap-themer/\r\n\r\nhttps://bootstrap.build/app\r\n\r\nSimple\r\nhttps://huemint.com/bootstrap-basic/\r\nReal Orange\r\nAdd this to your custom.scss file to override the default bootstrap colors - add this before @import \"bootstrap\";\r\n\r\n$white: #ffffff;\r\n\r\n$theme-colors: (\r\n    \"light\":      #f8e7a9,\r\n    \"dark\":       #f67600,\r\n    \"primary\":    #45342f,\r\n    \"secondary\":  #5a5c66,\r\n    \"info\":       #f97360,\r\n    \"accent1\":    #47cbca,\r\n    \"accent2\":    #008876,\r\n    \"accent3\":    #00a366,\r\n    \"success\":    #59a900,\r\n    \"warning\":    #ffc165,\r\n    \"danger\":     #f40063,\r\n);\r\n\r\nhttps://bootstrapcolors.com/', 'Color Pallettes\r\nhttps://colorhunt.co/palette/\r\n\r\nhttps://piktochart.com/tips/orange-blue-color-paletteAdd this to your custom.scss file to override the default bootstrap colors - add this before @import \"bootstrap\";\r\n\r\n$white: #ffffff;\r\n\r\n$theme-colors: (\r\n    \"light\":      #ede8e8,\r\n    \"dark\":       #0b0400,\r\n    \"primary\":    #224d9d,\r\n    \"secondary\":  #396cb6,\r\n    \"info\":       #3d9dc7,\r\n    \"accent1\":    #603510,\r\n    \"accent2\":    #554d4b,\r\n    \"accent3\":    #aba7aa,\r\n    \"success\":    #1b9f5d,\r\n  ', 'https://www.haketi.com/bootstrap-themer/', 'bootstrap,theme', '', '', '2025-12-07 15:07:00', '2025-12-07 15:30:00'),
(309, 'Make command file part of macOS Dock', 'macOS', '', '?? How to make your tips.cmd (zsh script) Dock?ready\r\nOpen Automator ? create a new Application.\r\n\r\nAdd Run Shell Script.\r\n\r\nPaste the contents of your tips.cmd (zsh commands).\r\n\r\nSave as Tips.app.\r\n\r\nDrag Tips.app into the Dock.\r\n\r\nNow clicking the Dock icon runs your zsh script like an app.\r\n\r\n? So yes, the file needs to be packaged as a .app (via Automator or similar). A raw .cmd or .zsh file won’t execute from the Dock by itself.', 'For ~/lbin/tips.cmd', '', 'macOS', '', '', '2025-12-07 15:52:00', '2025-12-07 15:52:00'),
(310, 'Amazon Resale ', 'purchase', '', 'Amazon refurbished\r\nhttps://www.amazon.com/resale\r\namazon warehouse\r\n\r\nOn page seach for Used to find other at lower price', '', 'https://www.amazon.com/resale', 'purchase', '', '', '2025-12-08 15:06:00', '2025-12-08 15:06:00'),
(311, 'Eney - mac Paw ', 'macOS', '', 'AI assistant\r\n', '', 'https://macpaw.com/eney', 'macaws', '', '', '2025-12-08 20:12:00', '2025-12-08 20:12:00'),
(312, 'File Differ', 'macOS', '', 'vimdiff file1 file2\r\n\r\nGood file comparison tool', '', '', 'vim, macOS', '', '', '2025-12-08 22:06:00', '2025-12-08 22:06:00'),
(313, 'fd Fast file Find', 'macOS', '', 'fd from brew\r\n\r\nfd -H /Library - means ignore directory\r\n\r\n$HOME/fdignore\r\n/Library\r\n', '', '', 'macOS', '', '', '2025-12-09 00:31:00', '2025-12-09 00:31:00'),
(314, 'Pro Cutta - cutting turf', 'turf', '', 'Tool to ease the cutting of seams\r\n 16 ft $599  6ft $249', 'Cutter \r\nhttps://www.jcturf.com/artificial-grass/maintenance/repairs/cut/', 'https://procutta.com/pages/get-out-of-the-harsh-weather-faster', 'turf, golf', '', '', '2025-12-10 03:28:00', '2025-12-10 03:43:00'),
(315, 'Ecovacs', 'ecovacs', '', 'Model: T80 Omni 12/8/2025 Serial\r\nis there a mode to mop and not go on rugs?\r\nset to deep clean and 2x passes! will cover entire area\r\n\r\nMop & Vac (vac and mop only living area; no bedrooms, laundry, bathrooms, office)\r\nVac  Only (vac only living area; no bedrooms, laundry, bathrooms, office)\r\n', 'Mop all rooms and not go on rugs:\r\nFirstly, you can go into the map, then select the carpet. You can choose the carpet\'s shape(round or rectangular). Once you have completed all the steps, select the No Entry option. Thus, your Deebot will avoid mopping or sweeping those areas where you placed carpets.\r\nThen to just vacuum the rugs?\r\nYou can go back to carpet settings, select the carpets, then select vacuum only.', '', 'ecovacs', '', '', '2025-12-11 20:15:00', '2025-12-11 20:48:00'),
(316, 'AI - apps Setapp', 'setapp', '', 'List of AI Apps\r\nBoltAI — Beautiful & powerful AI chat for professionals.\r\nElephas — Personal AI writing assistant for Mac.\r\nJoyCast — Improve meeting audio quality.\r\nKeep It Shot — Rename screenshots with AI.\r\nMurmurType — Transcribe your speech.\r\nPDF Pals — Chat with your PDFs.\r\nPlus — Work with text using AI.\r\nReady to Send — Generate draft email replies.\r\nSoulver — Convert and calculate in notes.\r\nSpellar AI – Improve meeting productivity.\r\nSubstage — Control Finder with natural language.\r\nTypingMind — Use a new UI to chat with AI.\r\nWhisperTranscribe — Turn voice into text content.\r\n', 'boltai - works good', '', 'setapp, macos', '', '', '2025-12-12 02:48:00', '2025-12-12 02:48:00'),
(317, 'USB Validator', 'usb', '', 'How test old usb drive to see if worth saving\r\ncrystalmark test 3d', '', 'https://crystalmark.info/en/download/#CrystalDiskInfo', 'usb', '', '', '2025-12-12 21:59:00', '2025-12-12 21:59:00'),
(318, 'Visual Studion Code - vsc', 'vsc', 'todo', 'standard Documents - list documents here\r\n', '# Documents\r\n- ENGINEERING_STANDARDS.md,  (put system wide requirements: spinner, scrollbars etc)\r\n- PROJECT_GUIDELINES.md, or \r\n- CONTRIBUTING.md at the root.\r\nCopy/adjust that file into new repos so “no dead controls; disable/hide if not implemented” is part of your default engineering standards.', '', 'vsc,code', '', '', '2025-12-12 22:45:00', '2025-12-14 11:37:00');
INSERT INTO `tips` (`id`, `title`, `cat`, `subCat`, `descr`, `comments`, `links`, `tags`, `moreInfo`, `attachments`, `tipCreate`, `tipMod`) VALUES
(319, 'zsh - commands history', 'macos', 'zsh', 'In zsh, you can easily rerun previous commands from your command history using the following methods:\r\n\r\n1. Using the Arrow Keys\r\nUp Arrow Key: Press the ? (up arrow) key to scroll back through your command history. Each press will take you to the previous command.\r\nDown Arrow Key: Press the ? (down arrow) key to scroll forward through the command history.\r\n2. Using history Command\r\nYou can type history to display a list of previously executed commands. Each command will have a corresponding number.\r\nTo rerun a command, type ! followed by the command number. For example, if the command is listed as 42 in your history, you would type:\r\n!42\r\n3. Using fc\r\nYou can use the fc command to edit and rerun previous commands. By default, fc opens the last command in your default text editor (usually vi or nano):\r\nfc\r\nYou can also specify a range, like this:\r\nfc -l -10\r\nThis would list the last 10 commands. You can then edit the desired command and save it to run it.\r\n4. Using Search\r\nYou can search through your command history interactively by pressing Ctrl + r. This will allow you to type part of a previous command, and it will show you the most recent match.\r\nKeep pressing Ctrl + r to cycle through earlier matches. When you find the command you want, press Enter to run it.\r\n5. Repeating the Last Command\r\nTo quickly repeat the last command you executed, simply type:\r\n!!\r\nThis will execute the most recent command in the history.\r\nSummary\r\nThese methods allow you to efficiently access and rerun previous commands in zsh, making it easier to work with your command line history.', '', '', 'zsh,macos', '', '', '2025-12-14 11:43:00', '2025-12-14 11:43:00'),
(320, 'testRick', '', '', 'a', '', '', 'test', '', '', '2025-12-14 14:39:00', '2025-12-14 14:45:00'),
(322, 'Rick1', 'rick1', 'new SubCat', 'rick1', '', '', 'rick1', '', '', '2025-12-14 14:46:00', '2025-12-14 14:46:00'),
(323, 'New google maps', 'Maps', 'Todo', 'New ai features \r\nFind gf restaurant on my route', '', 'https://www.cnet.com/tech/services-and-software/google-maps-is-getting-more-hands-free-for-when-youre-driving/', 'Maps', '', '', '2025-12-15 16:37:00', '2025-12-15 16:37:00');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tips`
--
ALTER TABLE `tips`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tips`
--
ALTER TABLE `tips`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=324;
COMMIT;

