Monday, December 7, 2020

Bookmark Management Productivity Tool Review: Focus on YouTube Time Stamp bookmarks.

Summary:

I am seeking an easy to use, feature rich yet clean link management tool with some basic collaboration features and video timestamp compatibility functionality. In short I need a tool to help save video time stamps, take notes on those time stamps and organize the links into categories. This helps with research and/or education activities. Specifically I need a tool that allows me to save YouTube time stamp bookmarks and then easily play them back. I compared several tools in 2020. Below are ratings for most of the tools that I used including comments on usage & screen recordings that demo each app. Specifically I am seeking the following features:

1) Link management : save, tag, organize links

2) Has an Android App

3) Has a PC App / Chrome Extension

4) Allow Save and Play of time stamped video links.

5) Basic collaboration

Winners : Diigo and KeepLink

get an Intro into the world of Bookmarking Tools

Details

1. Linkeep:

Rating: 3

Android App: Y; Chrome Extension: N; Web App: N; PC Install: Y

Comments: Android basic functionality, no share to option. PC requires an install.

Screen Recording Demos:

Android Usage:
PC Usage:

2. KeepLink: LinksSaver

Rating: 2

Android App: Y; Chrome Extension: N; Web App: N; PC Install: Y

Comments: Copy of Linkeep, looks and functions almost 100% the same. Only colors on UI are different.

Screen Recording Demos:

Android Usage:
PC Usage:

3. MyLinks

Rating: 3

Android App: Y; Chrome Extension: N; Web App: N; PC Install: N

Comments: Android app is great, integration between NewPipe, YouTube is clean and the UI is clean and concise with Categories and Links, The only complaint I have is search is limited to Categories only. On the PC side: I could not find any way to access links. I would use this app if it had a PC option?

Screen Recording Demos:

Android Usage:

4. Keeplink: Links/Bookmarks

Rating: 2

Android App: Y; Chrome Extension: N; Web App: N; PC Install: Y

Comments: Seems like a clone of another link app like Keep Link Links Saver or vice versa. The integration with NewPipe & YouTube does not work; you can not share to KeepLink. Thus I had to create links manually, that on top of the mediocre UI and not PC option leaves me no option except to give it a 2 or 3.

Screen Recording Demos:

Android Usage:

5. Pocket

Rating: 3.5

Android App: Y; Chrome Extension: Y; Web App: N; PC Install: Y

Comments: Very feature rich productivity tool that includes more than just link management: this tool allows user to save, share and manage articles & links in lists. Its does exactly as it claims “Save the articles, new stories and videos you want to read and watch later to Pocket. “ Pocket also integrates ok with NewPipe and YoutTube, however there are some gotchas. Each list item has a category and includes tagging & favorite features plus more. On the PC side, a Chrome Extension provides near identical functionality to the app. If you are looking for a producutivy app to manage articles & vidoes this is an alternative to Diigo. IMHO it is not as feature rich as Diigo.

Cons: However, there are 2 BIG issues that prevent me from using pocket: 1) Saving a video link:No description/notes when saving a link and 2) Opening a Video Link: When I open it link in Andorid or PC the video goes to the 00:00 ignoring my timestamp. The Timestamp is only used if I share the list item to YouTube.

When saving a link (NewPipe or YouTube Share to Pocket) I can select a tag and nothing else. In short this tool is not timestamp friendly if you are saving several links in the same video.

Screen Recording Demos:

Android Usage:
PC Usage

6. Keep Link

Rating: 4

Android App: Y; Chrome Extension: Y; Web App: N; PC Install: Y

Comments: Save bookmarks from anywhere easily and quickly. KeepLink is great at saving links. The Android app is very clean and it does 1 job very well: Saving & managing book marks. The UI in Android is modern and clean, rounded corners & searching is a great feature in this tool allowing multiple fields to search on. Bookmarked items include description, title, tag and category. Tag and category properties are extensible allowing user defined values for each.

Cons: There is only 1 list in the Lists. Having 100’s of items may become unwieldy. There is no PC / Chrome Extension I could in thus I was unable to use the bookmarks on a PC without copying/sharing from my phone to my email & opening on a PC. Hopefully this will be resolved in the future.

Screen Recording Demos:

Android Usage:

7. Diigo

Rating: 5

Android App: Y; Chrome Extension: Y; Web App: Y; PC Install: N

Comments: Extremely feature rich link, annotation and collaboration tool that includes all of my requested functionality and more. Annotations, tagging, description, notes, collaboration groups and seamless Android integration are all included in Diigo. The only tool that comes close is Pocket in terms of number of features and KeepLink in terms of the UI. Diigo does exactly what it claims to do and more: “Diigo Browser allows you to save, annotate and share bookmarks easily!”. Saved bookmark items including title, url, description, tag & group. Tag and group properties are extensible allowing user defined values for each. Group permits customizable authorization via an Admin setting, this feature permits expanded collaboration on items, articles, notes and annotations. This allows multiple users to edit an item, great for small teams working on research.

In android, sharing from NewPipe and YouTube to Diigo for time stamped links works perfectly and playing time stamped links open to the correct time marker on both PC and android.

Cons: The android app is a little clunky, due to it being its own browser. It just takes a little time to get use to. I recommend using the Chrome Extension first then using the Android app, this will decrease the learning curve.

Screen Recording Demos:

Android Usage using Saved Link

Android Usage saving a Link:
PC Usage

More Info:

Overview of Similar Tools

Diigo Guide: Its awesome!

Wednesday, November 25, 2020

Tasker: Install on new phone then restore settings, permissions and configuration:

Tasker: Install on new phone and restore settings, permissions and configuration: including profiles, actions and settings. Some manual steps are involved + adb commands from PC. Assumes adb is setup from PC with basics of adb understood by user.

 

[Old Phone]


1. Backup Tasker apk
2. Backup config (backup.xml) using menu Tasker | Data | Export.
    - in my case I am backing up to a network drive.
    - new phone will access apk and backup.xml
    - result as follows:
        http://prntscr.com/vpo4uu
   
   

[New Phone]


3. Install apk on new phone       

4. Configure other task manager style apps to whitelist tasker
    e.g: "all-in-one toolbox" android
    "boot speedup"
    http://prntscr.com/vpnkqj

    Advanced Tasker White List
     http://prntscr.com/vpnkj3

5. Set Tasker Settings
    Tasker Settings:
    http://prntscr.com/vpnofj

    Task Settings: SD Card
    http://prntscr.com/vpnosg

5. Set Android Permissions
    Android Permissions
    http://prntscr.com/vpnzt3
    http://prntscr.com/vpo0b2
    http://prntscr.com/vpo0i6

6. Connect phone to PC, Run adb,  Set permissions via Adb

-- See below links
https://tasker.joaoapps.com/userguide/en/help/ah_adb_wifi.html
https://tasker.joaoapps.com/userguide/en/help/ah_read_logs_grant.html
https://www.reddit.com/r/tasker/comments/9u6fbr/tasker_storage_access/
https://tasker.joaoapps.com/knownissues.html

- Sample Command output
C:\WINDOWS\system32>adb devices
List of devices attached
LMV405TA76466767        device


C:\WINDOWS\system32>adb tcpip 5555
restarting in TCP mode port: 5555

C:\WINDOWS\system32>adb shell pm grant net.dinglisch.android.taskerm android.permission.READ_LOGS

C:\WINDOWS\system32>adb shell am force-stop net.dinglisch.android.taskerm

C:\WINDOWS\system32>adb shell pm grant net.dinglisch.android.taskerm android.permission.WRITE_SECURE_SETTINGS


7. Run test actions
    - File Copy
    - Turn Airplane Mode on and Off
    - Ect

Monday, November 2, 2020

Compare Android Receipt Tracking Apps: Best & Worst Scan + OCR Receipt Apps for Small Business

Finding the Best and Worst Android Receipt Management Apps with a focus on Scan, OCR & small business functionality,.

 

Summary

The following review focuses on finding a stable and affordable receipt tracking app that includes the following functionality either in the app directly or via the browser. Scan & OCR functions must reside in native app while reporting & settings may exist in browser. This is a summary review focusing on OCR accuracy, ease of use & functionality that can satisfy tax related use cases for small business/sole-proprietor.

Requirements

1. Ability to scan a receipt via phone camera

2. OCR Capability for scanned receipts

3. OCR accuracy is > 90%

4. OCR picks up minimally following fields:

a. Pricve

b. Date of transaction

c. Merchant / Store Name

d. Category – Filled 90% with accuracy at or above 50%

5. Scan & OCR will involve at most 2 user events: Camera Click & Button Click.

6. Pricing either :

a. Subscription of < 5$ per month for 1-2 user or

b. 100$ one time for life of product

7. Ability to create simple report &/or export including:

a. Transaction detail

b. Transaction Summary

8. Reports shall allow user to filter by Start / End Date

9. Export Report to csv

Optional / Nice To haves:

1. Ability to identify / resolve / merge duplicates

2. Ability to scan a receipt via email

3. Search feature allowing to find tx by merchant, amount and/or category

4. Customer service with chat capability or email response

5. Ability to import from another expense platform, E.g: Import from Expensify.

The following apps were downloaded & tested on Android 10 Kernel Version 4.9.193 on LG V40 model V405TA30b :

Test Case:

1. Create Account

2. Create 3 receipts: Scan & OCR, see #6 below

3. Verify fields populated by OCR:

Date

Merchant

Amount

Category

4. How many events to create a receipt?

5. What is the pricing amount & pricing model?

6. Sample Receipts used in testing

Test Results

Apps failed due to 1 or more of the following conditions, noted by the leading symbol below : , denoted with leading in

1 - OCR in-accurate or non-existent

2 - pricing exceeds 5$ per month or $120 per year

BEST of the BEST

1tap receipts Tax Calculator & Receipt Scanner

Test Results Notes:

1. Create Account - Easy, Google OAuth.

2. Create 3 receipts: Scan & OCR. - 1 step; process time: <1 hr

3. Verify fields populated by OCR: (% of 3 receipts)

Date - 100%

Merchant - 100%

Amount - 100%

Category - 100% Accurate!

4. How many events to create a receipt?

- 1 !

5. What is the pricing amount & model for app?

- $2.08 per MONTH! Billed annually!

Pricing Details:

More Info: support@1tap.zendesk.com

6. Ease of Use: - High

7. Pros: - Very accurate & fast, simple UI, great fit for small business who wants no frills & hughly accureate OCR receipt scanning

8. Cons: basic reporting, limited filtering, did not see a way to search for a receipt. Not

Receipt Scanner: smart receipts & expense tracker

Test Results Notes:

1. Create Account - Easy, Email.

2. Create 3 receipts: Scan & OCR. - 1 step; process time: <1 hr

3. Verify fields populated by OCR: (% of 3 receipts)

Date - 100%

Merchant - 100%

Amount - 100%

Category - 100% Accurate!

4. How many events to create a receipt?

- 1 !

5. What is the pricing amount & model for app?

- $3/ month paid yearly !

Pricing Details:

More Info: contact@easy-expense.com

6. Ease of Use: - High

7. Pros: - Very accurate & fast, Clean & simple UI, great summary dashboard. Info on importing: Break expensed into Biz/personal

8. Cons: limited browser, in work.

BEST

Zoho Expense - Expense Reporting and Approval

Test Results Notes:

1. Create Account - Easy, Google OAuth.

2. Create 3 receipts: Scan & OCR. - 1 step; process time: <1 hr

3. Verify fields populated by OCR: (% of 3 receipts)

Date - 100%

Merchant - 100%

Amount - 100%

Category - 0% Accurate!

http://prntscr.com/vcbpqa

4. How many events to create a receipt?

- 1 !

5. What is the pricing amount & model for app?

- 5$ per mos

6. Ease of Use: - High

7. Pros: - OCR was fast, however category not filled in, Many features for mid sized business.

8. Cons: OCR

Foreceipt - Receipt Scanner Expense Tracker Cloud

Test Results Notes:

1. Create Account - Easy, Google OAuth.

2. Create 3 receipts: Scan & OCR. - 1 step; process time: <1 hr

3. Verify fields populated by OCR: (% of 3 receipts)

Date - 100%

Merchant - 100%

Amount - 100%

Category - 0%

4. How many events to create a receipt?

- 2

5. What is the pricing amount & model for app?

- 3.99$ per mos (220 scans only)

6. Ease of Use: - High

7. Pros: - OCR was fast, however category not filled in, Many features for mid sized business.

8. Cons: OCR & pricing is only 200 scans per month

Wave Invoicing

Test Results Notes:

1. Create Account - Easy, Google OAuth.

2. Create 3 receipts: Scan & OCR. - 1 step; process time: <1 hr

3. Verify fields populated by OCR: (% of 3 receipts)

Date - 100%

Merchant - 100%

Amount - 100%

Category - 0% Accurate!

4. How many events to create a receipt?

- 1 !

5. What is the pricing amount & model for app?

- 35$ per mos

https://www.waveapps.com/pricing

6. Ease of Use: - High

7. Pros: - OCR was fast, however category not filled in, Great features for mid sized business.

8. Cons: Category OCR and price!

Expensify - Expense Reports

1. Create Account - Easy, Email or Google OAuth.

2. Create 3 receipts: Scan & OCR. - 1 step; process time: Slow > 2 hours

3. Verify fields populated by OCR: (% of 3 receipts)

Date - 100%

Merchant - 100%

Amount - 100%

Category - 50%

4. How many events to create a receipt?

http://prntscr.com/vcbumb

- 1 !

5. What is the pricing amount & model for app?

- 4.99$ per mos

https://www.expensify.com/pricingw

6. Ease of Use: - High

7. Pros: - OCR was slow, but accurate. Most fields filled in, duplicates management. Great features for mid sized business.

8. Cons: OCR is slow, Fees & overcharging, customer service.

WORST: Worst / Not applicable

Fyle: Receipt Scanner & Expense Reports


fail reason: 1

Chrome River


fail reason: 2

Abacus


fail reason: 2

SAP Concur


fail reason: 2

Volopay


fail reason: 2

Veryfi - expenses, receipts & projects


fail reason: 2

Foreceipt - Receipt Scanner Expense Tracker Cloud


fail reason: 1

Smart Receipts


fail reason: 1

Receipt Bank


fail reason: 1

QuickBooks Online Accounting, Invoicing & Expenses


fail reason: 2

Free Expense Tracker & Budget Planner - Bookipi


fail reason: 1

MrReceipt - your receipts in one place


fail reason: 1

Receipt Box


fail reason: 1

Smart Receipts


fail reason: 1

Easy Receipt Log


fail reason: 1

Import Export Links:



Test Results Details & Figures:

1Tap:

Browser/Admin UI:

https://my.1tap.io/my-expenses/overview/2020



Report Request





Report Output



OCR Results:


Easy-Expense:          

Browser/Admin UI:

https://app.easy-expense.com/

OCR Results:



 Dashboard


Export:


Easy Expense Import


Expensify:

Wednesday, October 7, 2020

Find Files by : Search files containing Text : Which tool is fastest on Windows?

Comparing 4 tools today, TextPad, Notepad++, VisualStudio2017, Grep for Win and Everything.

Clear winners:

Everything

Grep for Windows

2nd Place:

Textpad

Visual Studio 2017

LAST:

Notepad++

Here are summary of tests and results, in order that I tested them:

Find File by search file with text search: plain text


   
    Text pad:
        Searching for: public static string BuildURLTransactionDetail
        Dir Structure: 15GB, 131K Files
        Pattern: *.cs
        Find in Files params: http://prntscr.com/uv0p5m
        Results:
            Memory: 21 MB
            CPU: 25%
            Elap Time: 55s,
        App Results:
            http://prntscr.com/uv0ulf
        
            Found 4 occurrence(s) in 4 file(s), 53257 ms

    Notepad++:
        Searching for: public static string BuildURLTransactionDetail
        Dir Structure: 15GB, 131K Files
        Pattern: *.cs
        Find in Files params: http://prntscr.com/uv0rew
        Results:
            Memory: 120 MB
            CPU: 8%
            Elap Time: 235s (3m55s!!),
        App Results:
            http://prntscr.com/uv0u5a

    VS2017 Find in Files:
        Searching for: public static string BuildURLTransactionDetail
        Dir Structure: 15GB, 131K Files
        Pattern: *.cs
        Find in Files params: http://prntscr.com/uv0vh7
        Results:
            Memory: devenve.exe+15MB MB
            CPU: 50%
            Elap Time: 20s !!!
        App Results:
            http://prntscr.com/uv0wdt
           
   
    Everything:
        Searching for: public static string BuildURLTransactionDetail
        Dir Structure: 15GB, 131K Files
        Pattern: *.cs
        Find in Files params: http://prntscr.com/uv10pt
        Results:
             Memory: 80MB
            CPU: 10%
            Elap Time: 5s !!!
        App Results:
        http://prntscr.com/uv0zl3


    grepWin-2.0.4_portable:
        Searching for: public static string BuildURLTransactionDetail
        Dir Structure: 15GB, 131K Files
        Pattern: *.cs
        Find in Files params: http://prntscr.com/uv1656
        Results:
            Memory: 20MB
            CPU: 20%
            Elap Time: 10s !!!
        App Results:
            http://prntscr.com/uv16ta

Friday, September 11, 2020

Google API App Errors: Less Secure App Access setting

If you have an app that interfaces with Google or use a 3rd party API integration, for example sendEmail smtp utility, you may start receiving an error in scripts that worked previously,. The error may look like:

 

C:\Temp\Tools\sendEmail-v156>Synch.OneWay.MyDocs.GDrive.Zip.Email
Sep 11 15:06:19 doylejsurface2 sendEmail[16576]: ERROR => ERROR => SMTP-AUTH: Authentication to smtp.gmail.com:587 failed.

To resolve enabel the less secure app access toggle in your Google profile:

Update Less secure app access in google

normally the setting is located here

Friday, August 14, 2020

Covid Positive Diary: Our Daily Log of our activity, experiences and observations

My wife and I both tested Covid positive recently. Also, my wife and I both had bad Influenza late 2019. We were prescribed the antiviral Tamiflu (Oseltamivir ) & antibiotic azithromycin (ZPack) late 2019 to be taken on an as needed basis for flu symptoms. We had 2 weeks worth remaining of these meds.  Both are common meds to treat wide ranging symptoms. These are our observations ONLY & this is NOT medical advice in any way. Everyone is different.  Be well:

Some key takeaways we have observed:

  • 1) There is some overlap of symptoms between flu, ear infection and Covid
  • 2) The duration is unusual the severity was not for us.
  • 3) AntiViral and Zpack helped alleviating some symptoms we had.
  • 4) Red meat exacerbates symptoms. Red meat caused stomach inflammation & mucus build up. This makes t more difficult to breathe. Observed on day 2 & 8

Background:

Age: me: 45 M 5’10” / her: 50F 5'4" / Avg Weight

BMI: Normal / No major illnesses / No Comorbidity / Gym 2X per week / Surf / We work office

Pre Existing: No major/ former smoker 10 yrs ago

Starting 8/6 we were confirmed to be Covid positive, contracted illness 8/3. Current symptoms range slight fever, coughs, clogged sinus to sore throat. Later on shortness of breath

Beginning 8/7 we began taking our Oseltamivir, as the sinus pressure and headaches associated with Covid are very similar to a start of the flu. If we didn't know we had Covid we would assume this was either flu or a middle ear infection. This is not medical advice. Be well:

This is our daily treatment log :

Day 1 :

- Date: 8/7/2020

- Meds

  • o Oseltamivir : None
  • o ZPack: 300 mg

- Supplements: (taken daily)

  • o 4000 mg VitaminC / 2000mg VitD / Zinc: 200 mg
  • o Other: NAC/2000mg Bee Pollen/Mile Thistle/Probiotic

- Comments

  • o Day #5 of illness
  • o Awoke with Sore throat

Day 2:

- Date: 8/8/2020

- Meds

  • o Oseltamivir : 300 mg (100mg BEFORE Bed)
  • o ZPack: 200 mg (100mg BEFORE Bed)

- Supplements: (taken daily)

  • o 4000 mg Vitamin D + 5000 mg Vit C + 200mg Zinc
  • o Other: NAC/Bee Pollen/Mile Thistle/Probiotic

- Comments

  • o Day #6 of illness
  • o Awoke with BAD Sore throat, no other symptoms

Day 3:

- Date: 8/9/2020

- Meds

  • o Oseltamivir : 200 mg (100mg BEFORE Bed)
  • o ZPack: 200 mg (100mg BEFORE Bed)

- Supplements: (taken daily)

  • o 4000 mg Vitamin D + 4000 mg Vit C + 200mg Zinc
  • o Other: NAC/Bee Pollen/Mile Thistle/Probiotic

- Comments

  • o Day #7 of illness
  • o Awoke with NO Sore throat, tired, body aches, cough, feels like head cold, ear ache
  • o Taking Oseltamivir BEFORE bed certainly helps to awake with less symptoms!
  • o Symptoms worse me in AM, before bed and AFTER I eat red meat. Will reduce red meat intake

Day 4:

- Date: 8/10/2020

- Meds

  • o Oseltamivir : 200 mg (again 1 before bed)
  • o ZPack: 200 mg (again 1 before bed)
  • o Mucinex + 3 tylenol + 3 motrin

- Supplements: (taken daily)

  • o 4000 mg Vitamin D + 3000 mg Vit C + 200mg Zinc
  • o Other: NAC/Bee Pollen/Mile Thistle/Probiotic

- Comments

  • o Day #8 of illness
  • o Awoke with stuffy nose, tired all day, body aches, slight cough, feels like it has moved to my chest
  • o I ate red meat on Day 3 and I felt like CRAP after easting (pork). I am switching to ONLY fish and chicken + veggies. Red meat contributes to inflammation and congestion.
  • o Ate corvina fish + rice tonight
  • o Had diarrhea due to VitC, I am reducing Vitc to 3000mg

Day 5:

- Date: 8/11/2020

- Meds

  • o Oseltamivir : 200 mg (again 1 before bed)
  • o ZPack: 200 mg (again 1 before bed)
  • o Mucinex + 3 tylenol + 3 motrin

- Supplements: (taken daily)

  • o 4000 mg Vitamin D + 3000 mg Vit C + 200mg Zinc
  • o Other: NAC/Bee Pollen/Mile Thistle/Probiotic (Corganic!!!)

- Comments

  • o Day #9 of illness
  • o Awoke with only slight stuffy nose and slightly tired. Not sure if tiredness is caused by Covid. My appetite is normal, however desire for alcohol is very low, since alcohol accentuates the tiredness
  • o Today is best I have felt in 5 days. Don’t feel as tired
  • o Plan to eat grapefruit in AM, Chicken and Fish for lunch/dinner!

Day 6:

- Date: 8/12/2020

- Meds

  • o Oseltamivir : 200 mg (again 1 before bed)
  • o ZPack: 200 mg (again 1 before bed)
  • o Mucinex + 1 tylenol + 3 motrin

- Supplements: (taken daily)

  • o 4000 mg Vitamin D + 4000 mg Vit C + 200mg Zinc + Selenium
  • o Other: NAC/Bee Pollen/Mile Thistle/Probiotic

- Comments

  • o Day #10 of illness
  • o Awoke with no symptoms, however as day went on felt a little tired. Went to sleep feeling a slight shortness of breath, worried a little
  • o Wife has consistent cough shortness of breath thru the day, he symptoms are worse than mine.
  • o Ate starbucks, fruite, light meals
  • o Noticed that small meals do not result in tiredness, no desire for alcohol

Day 7:

- Date: 8/13/2020

- Meds

  • o Oseltamivir : 100 mg (again 1 before bed)
  • o ZPack: None
  • o Mucinex + 2 tylenol + 2 motrin

- Supplements: (taken daily)

  • o 2000 mg Vitamin D + 2000 mg Vit C + 200mg Zinc + Selenium
  • o Other: NAC/Bee Pollen/Mile Thistle/Probiotic/Astragulus/Tumeric

- Comments

  • o Day #11 of illness
  • o I awoke slight shortness of breath, took Astragulus+ Tumeric this helped!
  • o Wife symptoms are lingering longer than mine, cough & shortness of breath
  • o Ate pork, BAD IDEA!. I could feel inflammation & mucus 1 hour after eating.

Day 8:

- Date: 8/14/2020

- Meds

  • o Mucinex + 2 tylenol + 2 motrin

- Supplements: (taken daily)

  • o 2000 mg Vitamin D + 2000 mg Vit C + 200mg Zinc + Selenium
  • o Other: NAC/Bee Pollen/Mile Thistle/Probiotic/Astragulus/Tumeric

- Comments

  • o Day #12 of illness
  • o I awoke feeling back to 100% back normal! Will continue supplement regiment for 3 days. shortness of breath, took Astragulus+ Tumeric this helped!
  • o Wife symptoms are lessened, Astragulus+ Tumeric seem to help repertory area,
  • o Had small beef in AM (yuck) / Fish+scallops + rice for dinner

Tested Sunday

DIET is SO important!!

For us: Food and Vitamins are a HUGE influence on how your body deals with this illness!!!

If you are Obese or smoke, this should be a wake up call: GET FIT. I would not want to be obese or smoke with this illness.

For us, the duration of the illness was the only worry while the severity was never as bad as the flu

Also: DONT watch the news: it only makes you feel worse. Go out for a walk and get some light exercise!!!

Links to Resources that I used manage my health

Coronavirus, Precautions, and Strengthening the Immune System Urology
COVID-19 Supplements: Melatonin
COVID-19 Treatments: An Updated List of Drugs and Medications in Development - GoodRx
Azithromycin and SARS-CoV-2 infection: Where we are now and where we are going
Oseltamivir recipients recover faster from coronaviruses other than SARS-CoV-2
COVID-19 Research - Drug Target Review
Using vitamin C
VITAMIN C health

Thursday, May 21, 2020

Excel Tutorial for Christa NO EXCUSES 20 min per day

Plural Sight Videos !!!

Download each folder lesson and DO lesson:

https://drive.google.com/drive/u/0/folders/1aRM7mLY9v_I2vi3JlSiiirBirPfKBRDh

1. Beginner Lessons

Loading Data into Excel

Searching and Manipulating Data in Excel

 

2. Intermediate

Calculating Cell Values with Formulas

Recording and Managing Excel Macros

3. Advanced

Summarizing and Organizing Data in Excel

Exploring Data with PivotTables

Distributing Excel Workbooks

Charting Data with Excel

Original Plural sigh lesson is HERE

 

Youtube & Free!!!

Basic: Formulas and Functions

1. Excel Basic Formulas and Function

2. Sum all lookups

LookUps:

Lookups : Lookups will allow you to merge worksheets. E.g:  Match Invoices to Rates.

V Lookup : 30 min or less

Learn V Lookup for basic matching, e.g: match “Acme Inc” = “Acme Inc”

1. How to Do a VLOOKUP With Two Spreadsheets in Excel

Sample: VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

2. Excel VLOOKUP tutorial for beginners with formula examples

3. V Lookup Explained

Fuzzy Lookup : 30 min+

Learn Fuzzy Lookup for advanced matching, e.g: Match ACME Incand “Florida ACME Inc

1. Download Fuzzy Lookup Add-In for Excel

2. Watch Tutorial

 

Playlist Tutorials:

1. Excel Basics

2. Tips & Formulas 

 

 

 

Paid Courses:

1. Advanced Excel: Top 10 Excel Tips & Formulas

- $34.00 Video + includes sample workbook

Thursday, May 14, 2020

Entity Framework 6 : Default Code First Conventions

EF 6 Code First Default Conventions :

1) Default Inheritance Type: Table Per Hierarchy (TPH)

2) foreign key properties

- Any property with the same data type as the principal primary key property and

- with a name that follows one of the following formats represents a FK for the relationship:

  • <navigation property name><principal primary key property name>',
  • '<principal class name><primary key property name>', or
  • '<principal primary key property name>'

3) Primary Key Convention

-property is a primary key if a property on a class is named “ID” (not case sensitive), or the class name followed by "ID".

4) If FK on the dependent entity is not nullable, then Code First sets cascade delete on the relationship.

- Nullable:

public int? CountryId { get; set; }

5) Type Discovery:

- you define a context class that derives from DbContext and exposes DbSet properties for the types that you want to be part of the model.


6) exclude a type from the model

-use the NotMapped attribute or the DbModelBuilder.Ignore fluent

7) No PK or FK: Its a complex type. Complex Type rules include:

- type does not have properties that reference entity types and

- is not referenced from a collection property on another type.

Wednesday, May 13, 2020

.Net Database Connection String Samples

1. Web.Config Connection String

<configuration> <connectionStrings> 
<add name="myConnection" connectionString="server=localhost;database=mydatabase;" /> </connectionStrings> </configuration>

2. Get connection string using the ConfigurationManager class:
string conn = ConfigurationManager.ConnectionStrings["myConnection"].ConnectionString;
3. EF Reference Connection String in DB Context Ctor:
public class DatabaseContext : DbContext {
public DatabaseContext() : base("myConnection")
{ } }
4. SQL Server Connection String Integrated Security:
<connectionStrings>
<add name="sqlServer" providerName="System.Data.SqlClient" connectionString="Data Source=localhost;Initial Catalog=MyDatabase;Integrated Security=True;" /> </connectionStrings>
5. SQL Server Connection String SQL Authentication:
<connectionStrings>
<add name="sqlServer" providerName="System.Data.SqlClient" connectionString="Data Source=localhost;Initial Catalog=MyDatabase;User Id=user;Password=pwd;" /> </connectionStrings>

6. My SQL Connection String:
<connectionStrings>
<add name="mySql" providerName="MySql.Data.MySqlClient" connectionString="Server=localhost;Database=MyDatabase;Uid=user;Pwd=pwd;" /> </connectionStrings>

7. Oracle Connection String
Data Source=ABC.Company.OraDSName;User Id=myUid;Password=mypwd;
8. SQL Server by Database Name
<add name="MyDBStage" connectionString="Database=MyDBStage;Server=.\sql2012;Integrated Security=SSPI;"
      providerName="System.Data.SqlClient" />
9. Connection String using Model:
<connectionStrings>
    <add name="MyDBEntities" connectionString="metadata=res://*/Data.MyDB.csdl|res://*/Data.MyDB.ssdl|res://*/Data.MyDB.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=SP2013E\SPSQL;initial catalog=MyDB;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>
10. MS Dynamics Connection String
<add name="Xrm" connectionString="Server=http://myCompany.crm5.dynamics.com; Domain=myCompany; Username=myUserId@myCompany.com.au; Password=Secret0102"/>
  </connectionStrings>
11. Named Connection String Integrated Security:
<add name="MyDBConnString" connectionString="Database=MyDB;Server=MyServer;Integrated Security=SSPI;"
      providerName="System.Data.SqlClient" />
  </connectionStrings>
12. References:

Connection Strings Samples
MS Connection Strings

Guide to Connection Strings

Saturday, May 9, 2020

.Net Framework vs .Net Core vs .Net Standard

What is .Net Standard and why does it show as a project platform type in Visual Studio when I click New Project?
Well, .net Standard is NOT a platform, it is a standard. If we remember that, then it makes sense. Think of .net standard as the mesh that maps the various platform version together for interoperability. See the below table:


What is .NET Standard?

.NET Standard is a specification (not an implementation of .NET) which defines the set of APIs that all .NET implementations must provide. It addresses the code sharing problem for .NET developers across all platforms by bringing APIs across different environments.
We can think of it as another .NET Framework, except that we use it to develop class libraries only. .NET Standard is a successor of the portable class library.
Ok, so .NET Standard specifies the APIs that need to be implemented.
But which APIs does it cover?
To answer this question in short – there are multiple versions of .NET Standard. Each version includes a set of APIs which we are going to cover in a while.



Wednesday, May 6, 2020

Update Android Property File

1. Download .prop file from phone to computer

2. Edit the .prop file using a text editor

3. Upload .prop file from computer to phone.

See below example script:


1. adb pull /system/build.prop c:\Temp\Phone

2. Edit Props:using notepad

3. adb push C:\Temp\Phone\build.prop /system/

Tweaks:

Tuesday, April 28, 2020

Chrome Extension Review: Pricing Tools for Comparison and Research


Price Comparison Chrome Extensions

Summary:

Yroo is the clear winner without a doubt :

- most accurate

- most stable providing consistent results

- cleanest design

- consistent and reliable

Get it Yroo - Price Comparison and Price Tracker


*************** Reviews ***************

pricescout

Amazon

found 3 prices, same as Yroo

http://prntscr.com/s7rvbz

Ebay

N/A

Performance:

Load time range: 4-6 seconds

CPU Impact: 5%

RAM: 5MB

Rating:

Pricing: 6 (Amazon: 9, Ebay: 0)

* Only works on amazon, Options screen is blank.

Browse Plus

Amazon

DID NOT WORK

Ebay

DID NOT WORK

Performance:

N/A

Rating:

Pricing: 0

* Only works on amazon

Cheaper Marker

Amazon

found 1 better price, compared to ebay

http://prntscr.com/s7r2v8

Ebay

N/A

Performance:

Load time range: 4-6 seconds

CPU Impact: 5%

RAM: 5MB

Rating:

Pricing: 6 (Amazon: 9, Ebay: 0)

* Only works on amazon

Honey

Amazon

found 10+ coupion code, no prices

http://prntscr.com/s7r1yo

Ebay

found 1 code, activated, no price compare

http://prntscr.com/s7r258

Performance:

Load time range: 1-3 seconds

CPU Impact: 5%

RAM: 5MB

Rating:

Pricing: 1, Coupon: 10

Yroo - Price Comparison and Price Tracker

Amazon

works ok, quick price compare, comapres to ebay and others

http://prntscr.com/s7qyrd

Ebay

works OK, 14 second load time, compares to google and walmart. ** did not compare to amazon?

http://prntscr.com/s7qzjv

Performance:

Load time range: 5-15 seconds

CPU Impact: 10%

RAM: 30MB

Rating:

7

* Works on all sites, a little slow when loaded with other ext's

Prickle

Amazon

works ok, quick price compare, comapres to ebay and others

http://prntscr.com/s7s4jt

http://prntscr.com/s7s5j9

http://prntscr.com/s7s5p3

Ebay

S/A

Performance:

N/A

Rating:

9

* Works on all sites, however the process is a pain:

1. select a price

2. enter email,

3. wait and go to my email to do a price check.

Very arduous. Too tedious. May be helpfule in a researching scenario, but not for day to day shopping.

PriceBlink Coupons and Price Comparison

Amazon

works 70% of the time, rest it did not pop up or displayed wrong product

http://prntscr.com/s7sb23

http://prntscr.com/s7saa3

Ebay

worked OK, 10 second load time, worked better than amazon.

http://prntscr.com/s7sas6

Performance:

Load time range: 5-20-never seconds

CPU Impact: 10%

RAM: 30MB

Rating:

5

* Besides Yroo this is the ONLY tool that kind of worked.

Yroo is the clear winner without a doubt :

- most accurate

- most stable providing consistent results

- cleanest design

- consistent and reliable

Rest of the add-on felt like hacks and/or beta products. For a solid and reliable price checking experience, go with Yroo.

For Price Researching

These extensions can come in handy to analyze price over time, site (retailer) and volume.

Camelicer and

Keepa

are 2 of the best! Plus PriceGeeks site has some of the best price analytics spanning ebay Ended auctions for deep price history data to spot those future price trends !

http://www.thepricegeek.com/

More….

smart-price-monitor

- Does not compare prices, only tracks. Must setup a price alert, use this for pricing research not for simple shopping price comparisons

- similar to Keepa - Amazon Price Tracker

price-tracker

- Does not compare prices, only tracks. Must setup a price alert, use this for pricing research not for simple shopping price comparisons

- similiar to Keepa - Amazon Price Tracker

Windows 10 : Windows Update Service Depends Notes

If utilizing one of the various recommendations to improve Windows 10 performance such as flavors of Black Viper or other service configurations, please note that there are new services in Windows 10 related to Windows Update. The following services have dependencies with Windows Update in Windows 10 thus when changing service status to boost performance be aware that you may break Windows Update or the installer process.

The default install of Windows 10 (Pro or Home) sets these services to run Automatically it is thus a best practice to audit changes to service configuration before and after any manual updates.

1. Windows Module Installer:

Also required for msi installs, e.g: .Net FR Runtime install/updates install via direct .msi/exe execution.

2. Windows Remediation Service

Added in a cumulative update. Microsoft announced that the Windows 10 KB4023057 update patch would enhance the service components’ reliability. The patch offers reliability improvements for the following versions of the Windows 10 operating system:‘ 1507 – 1803.

The exe assoc. with this service is Sedlauncher.exe normally in the C:\Program Files\rempl directory.

3. Microsoft Compatibility Telemetry

This is a system service in Windows 10 & is part of the Windows Customer Experience,  Improvement Program and Windows Update.  The executable file for this service is used for upgrading Windows to the latest Version and installing Service Pack Updates. It is located in the C:\\Windows\System32 directory and transfers telemetry data.


More Info regarding these services:

What is Windows Remediation Service

Fix or Disable the Windows Compatibility Telemetry Service


Methods to disable services:

Windows Remediation Service

  1. Launch the Run dialog box by pressing Windows Key+R on your keyboard.
  2. Inside the Run dialog box, type “services.msc” (no quotes).
  3. Once the Services utility window is up, scroll down until you find the Windows Remediation Service.
  4. Right-click it, then select Properties.
  5. Now, go to the General tab.
  6. Stop and Disable | Apply

Windows Compatibility Telemetry Service

1. Run | gpedit.msc

2. Browse to : "Computer Configuration >  Administrative Templates > Windows Components > Data Collection and Preview Builds".

3. Set Allow Telemetry = False

See Example here

Developer and Office Productivity Extensions and Apps : 2020

1. Chrome:

Dev:

- xPath Finder : point and click xpath selector

- CSS Peeper : Chrome Extension scrape css from site quickly with support for rules and great formatting

Debug:

- Relative XPath Helper Chrome Extension

- Selectify : Alt+click any element to generate its optimum jquery selector path. Chrome Extension

-Lighthouse:  It is an open-source, load and Performance Testing tool.

Office:

- Random Text Generation in MS Word / Office: function : = lorem([numParagraphs], [numLines]) ; e.g:   = lorem(5,6)

See below Example:

Lorem Ipsum Generators: How to in Word!

- Universal Automation : Automate Job application submittals, save time and blast that resume!

2. Multiple Office 365 Accounts : Microsoft and/or Office 365 Logins

  1. Use Chrome Profile

  2. Create profile with naming pattern like O365.[acronym] e.g: O365.SB

  3. Login to portal.office.com

  4. Open any other pages, e.g: Outlook, Word, Admin Center ect.

  5. Set Home pages for profile to the open tabs

Now when you open the profile in the future all pages will be loaded and logged into, likewise you could use bookmarks in the new profile for similar shortcut access to O365 pages.

I tried Session Box, however it had problems with the varying domains, for example portal.office.com and https://outlook.office365.com/ were not in same session in Session Box. Isolation was based on portal.office.com only

3. Extra Notes on Lorem Ipsum generators:

- Text

Other apps to gen random text:

Visual Studio Extension:  Dummy Text Generator

PowerPoint: same procedure as in Word

Word: As demo’d above: enter one of the following formulas in a document, replace the zero in parenthesis with the number of “number of paragraphs” & optional “number of lines”
=lorem(0): Custom length of lorem ipsum text
=rand(x,y): random selection of texts from the Word Help
=rand.old(0): a pangram repeated in custom length

QuarkXPress: The dummy text function is called jabberwocky

InDesign: Choose Type > Fill with Placeholder Text to


- Forms:

Form Samples: Best form generator

Forms Smart: various html samples

Generator + Form: Multi-Div FRormatted HTML with text:

Thursday, April 23, 2020

Enable Android 7+ Multi Window Mode

1. Enable debugging

2. Install adb

3. Enable debugging

4. Settings | Force Activities to be resizable

5. Install Taskbar

Set setting: “Freeform windows support”

6. Run Following shell

adb shell settings put global enable_freeform_support 1

7. See more here

https://www.youtube.com/watch?v=G9K8eNcc80A

Thursday, March 26, 2020

Connect to SQLLocalDB from SSMS

SQLLocalDB is used by VS.Net for local db dev and to reduce the need for SQL Express. If you would like to use SSMS (SQL Server Management Studio) to query a SQLLocalDB, see below steps.


1. Find location of SqlLocalDB.exe, normally C:\Program Files\Microsoft SQL Server\[Version]\Tools\Binn 

2. Open cmd prompt in location;

3. run SqlLocalDB –?

4. run SqlLocalDB i

output:

5. Get Connection string:

run: SqlLocalDB i  MSSQLLocalDB

output

6. Copy Connection string: e.g:

np:\\.\pipe\LOCALDB#BBCAB010\tsql\query

7. Paste into SSMS:

example:

Monday, March 23, 2020

Find Date of Manufacture of External Hard Drives (DOM)

Quick Links:

Using Serial Number: (unverified)

Using 1st 3 digits of the serial number:
Find 1st block of 3 digits in Serial#:
- M: Month production (1,2, ... Oct –> X, November –> Y, December –> Z)
- Y: Last digit of the year of production (eg. 0 for 2010, 4 for 2014, 5 for 2015)
- D: Day of production (1,2,...9,A,B,...) (eg. G –> 16)
E.g: - X1A = 10th November 2011

e.g: WX11A7317973

November, 2011, 1st


For WD Drives:


Exam the following:

(1) Determine drive’s warranty status by typing its serial number into WD’s online warranty checker:

https://westerndigital.secure.force.com/WarrantyCheck?lang=en

or



E.g:, warranty period will be 1, 2, 3, or 5 years, plus a few months.

(2) Look at the date codes on the Printed circuit board. Use a Torx 6 screwdriver.

e.g::
http://ep.yimg.com/ca/I/yhst-14437584971410_2269_336392 59

Note the “3709” on the PCB below pin #1 the Samsung SDRAM. This means: PCB was manufactured during the 37th week of 2009.

Now: examine markings on each of the chips:

Samsung SDRAM at location U2 - “940”
Marvell 88i9045 MCU at U5 - “0942”
SMOOTH chip at U1 - “0943”
Winbond “BIOS” IC at U12 - “0938”

*Chip markings are date codes in YWW or YYWW (Year / Week) format. E.g: SMOOTH chip was manufactured during the 43rd week of 2009.

From this we can infer: drive cannot have been manufactured before week 43 of 2009.


Toshiba:

Calculator!: https://www.data-medics.com/forum/toshiba-date-code-calculator-t1113.html


Per: http://forum.hddguru.com/viewtopic.php?f=13&t=32197

Model

Code:

MQ01ABB200
1234567890

1 : seem always "M" for 2.5'' drives (probably "M" is for "Mobile")
2: seem the generation / serie of drives (K for older drives ; Q for newer ones)
3 & 4: sub-family? ("01" seem very common)
5: A= SATA interface ; U = USB interface
6: ? seem always "B"
7: ? varies (...,B, C, D, ...)
8-10: three last positions = capacity in 10GB (in this example a 2 TB drive)

Code:

Y48 JP9F1T XR6 HDKFB02AZA01 T
MYJ ABCDE XYZ 123456789012 #

First block of 3 digits:
M: Month of production (1,2, ... October is X, November Y, December Z)
Y: Last digit of the year of production (eg. 0 for 2010, 4 for 2014, 5 for 2015)
J: Day of production (1,2,...9,A,B,...) (eg. G is for 16)


References:

WD Model Number Code

BackUp location

Monday, February 10, 2020

DiskStation NAS Disappears from Windows Explorer

per this article from Synology:I performed the following:

1. For DSM 6.2 22259 and later, please enable Enable Windows network discovery to allow file access via SMB under Control Panel > File Services > Advanced > WS-Discovery.

2. Under Control Panel > File Services > SMB/AFP/NFS tab > SMB section > Advanced tab, "Enable SMB 2 Lease”

3. Refresh Windows Client Network cache: As the LMB is elected by all computers, there are chances that the NAS is NOT elected as the LMB even if "Enable Local Master Browser" is ticked. Try to "Turn off network discovery" on the Windows PC, save it, and then turn it on again via Network and Sharing Center > Change Advanced Sharing Settings to clear the Windows cache.