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