Posts

Google Spreadsheet automate Cell Clear and add Cell Value on Open event

Image
This is a continuation of my post  http://itskhembot.blogspot.com/2018/07/populate-google-spreadsheet-cells-with.html  , since I want it to update cell API data value on Open (or on hour basis, which you can set on triggers) I know it will be useful too on other circumstances. If you've followed my previous post you'll know where to add the script in Tools > Script Editor Now this time we will add new scripts, first one would be the clearSheet function: function cleanSheet() {   var sheet = SpreadsheetApp.getActiveSheet();   sheet.getRange('A:C').clearContent(); } I'm clearing A to C columns only since I only have data on those columns, you can put your desired range on it. Append the above code to our existing ImportJSON script Save. Now we will add triggers On the same window, click Edit > All your triggers It will popup a window for the triggers, click add if you have no triggers yet Next set trigger with event From Spreads...

Populate Google Spreadsheet cells with JSON API data, conversion tutorial

Image
For this tutorial we will populate Google Spreadsheets cells with API data, target columns and rows on it. First check the archived page for the ImportJSON documentation at  https://rawgit.com/bradjasper/ImportJSON/master/archive/blog.fastfedora.com/projects/import-json.html Next open up the latest version of ImportJSON script found at this repo link  https://github.com/bradjasper/ImportJSON Open ImportJSON.gs, click raw > copy the whole script Now on google spreadsheet, create new spreadsheet or open existing one which you'll populate data with Click Tools > Script Editor It will popup a new tab/window, delete the default script inside Then paste the ImportJSON code you've copied from the repo Save and name the project Now back to the spreadsheet click cell A1, from the documentation we know how to call the function ImportJSON I'll be using this sample JSON API link  https://api.github.com/users/hadley/repos on ...

GSuite not receiving Wordpress/Godaddy Contact Form emails [FIX]

Image
I've encountered this problem and what was puzzling was that yahoo and normal gmail were working properly. Reinstalled contact forms/updated plugins/set everyone option for email in Gsuite admin and none of them worked, finally I've checked a solution for the Godaddy CPanel setup stuff and here are the steps Login to your GoDaddy CPANEL Under Email group find MX Entry Click on it, it will load another screen Now by default, it is set to Local Mail Exchanger, click Remote Mail Exchanger > Click Change Test your contact forms and GSuite email. Everything should forward and work properly now!

Converting JSON API returned data into 2016 SQL table rows

Image
To start the setup you must have the 2016 version of SQL Server(or higher version) Create the table beforehand along w/ desired columns(sample columns added) Fetch API data w/ POSTMAN chrome extension tool or simply use your API fetching custom app to retrieve the data(browser will do too) In SQL Server 2016 create new query to your db > table Copy > Paste the following script DECLARE @json NVARCHAR(MAX) SET @json = N'[<json>]' INSERT INTO <table> SELECT * FROM OPENJSON ( @json ) WITH ( <fields> ) where <json> is the returned data from POSTMAN/browser, <table> is the SQL table to which you want the data to be added, <fields> would be the matching fields we add from JSON to SQL column an example for this with exact sample values would be: DECLARE @json NVARCHAR(MAX) SET @json = N'[ { "Order": { "Number":"SO43659", "Date":"2011-05-31...

Error 0x80070571 External Hard Drive

So I got this problem with my Toshiba 1TB External Hard Drive when I tried to copy files to it(or create folders,text,etc), something about writing new files on the drive is making the error, though copying files from it is fine.  I've scoured the interwebs for the answer for this error, and I've found the simple solution for it.  Step 1:  Connect your external drive to your computer/laptop.  Step 2:  open Command Prompt (Window key + R) for older versions, (Window key) + type 'cmd' for Win7 up and press enter.  Step 3:  type 'chkdsk /f F:' given that F: is the drive letter of your external drive  Step 4:  Wait for it to finish the check disk command, and VOILA! it works properly again! Cheers!

Tree of Savior CBT2 - English Review

Image
Hi everyone! It's been awhile since I've posted something on this blog. Anyways, since the OBT for STEAM is coming sooner this Spring, I'll make a review this time for an upcoming MMORPG developed by the same korean devs(well some of them maybe) IMCGAMES who've worked on and brought us RAGNAROK ONLINE way back 10+ years ago. Introducing TREE OF SAVIOR , this time, they've upped the playstyle, classes, quests, hats, etc basically everything we've loved from RO was being upgraded. They also retained the friendly character designs and UI in game, it's more like a 2D-3Dish interface with evasion and fluid spell/character controls. I know! I know! some of you have found this gem already and played through the 1st Close Beta, this round though I got lucky and was given a key to enjoy and explore this game. System Requirements:                                   Minimum OS:  Windows XP. Pr...

OOTB Valvrave III Hikaminari 1/144 Review

Image
This week I finally got a hold of this Valvrave kit: Now I'm gonna show you a quick review on this amazing mecha. First I've built the kit out of the box a day ago, so now I'm gonna take off the removable parts and let you peak through of what it looks like ;) By the way here are the size comparisons, size against a 1/144 G-Exes: Pretty big compared to most 1/144 right? Let see the size compared to an 1/100 MG Aile Strike: Aha! the Aile Strike Head is much taller than the Hikaminari Head, but the overall kit is pretty much the same or taller than the Aile. Sweet! :) Alright! Now we're moving on to the parts! yay! I've removed the important pieces so you can see which of them can be detached/attached. To enumerate you have 2x Armstronger, 2x Arms, 2x Legs, 2x Chain Saucer, 2x Dai Arms, 1x Head, 1x Chest, 1x Hip We will start checking out the head first ;) As you can see it doesn't have too many pieces. The left and right face are to be snap f...