Monday, September 4, 2017

Expression.Error: The column 'xxxxxxxx' of the table wasn't found

Hello Everyone,

Yes, I'm on fire. Two posts in one day. :)

I'm not a Power Bi expert, that's why i don't want you to be like me, got lost for hours because of the error when trying to edit my query, I got the error message "Expression.Error: The column 'bla..bla..bla' of the table wasn't found" . This might be because you have renamed the header of your table, and because of that, power bi does not recognize it. Well, that was in my case :). Even after changing back the table header to the old name, still Power Bi did not like it. How to solve ?

Well, not exactly a great savvy high level programming way :).. In my case, i just wanted to redo..

  1. Rename the file source's table header the way you wanted it. So that you don't need to rename it on Power Bi.
  2. Make a new Power Bi file by using the source of the file that you have changed. (you just wanted to get the correct format of script)
  3. Open Data -> Edit Queries -> Advanced Editor
  4. Copy all line on  #"Changed Type"
  5. Open the Error Power Bi file, on Advanced Editor, replace the #"Changed Type" line with the one that you have copied.
  6. Replace "Renamed Columns" under "in" with "Changed Type" 
That makes it back to original one... Don't make anymore error :)




Incremantal Data Load Google Sheets

Hello Everyone !!!

Ya, you might think that this blog has lost focus. It's actually not. I found how to do the incremental data load using google sheets when i was in Saudi Arabia. So, it's still relevant :).. After dwelling around for hours on internet, i found the answer. This is how..

First of all, what is incremental data load ? This is one of examples. In case you have a list of employee and you need to record their attendance by using google sheets. This may look like this;


Okay, that's easy. Just need to put it down on the bottom of the last sheet. But, what if for some reasons, you already have the template on another google sheets, and the data need to be merged with above sheets, plus you want it to be placed on the bottom of the above sheet. Got it ?

1. On google sheets, go to Tools -> Script Editor
2. On Script Editor, paste below script:

function myFunction() {var ss = SpreadsheetApp.openById('XXXXXXX'); //replace with source ID
 var source = ss.getSheetByName('Sheet1'); //replace with source Sheet tab name
 var sourceRange = source.getRange('A2:O44'); //assign the range you want to copy
 var data = sourceRange.getValues();

 var tss = SpreadsheetApp.getActiveSpreadsheet('XXXXXX'); //replace with destination ID or keep it empty if you are running this script on destination google sheets.
 var ts = tss.getSheetByName('Sheet2'); //replace with destination Sheet tab name
 ts.getRange(ts.getLastRow()+1, 1, data.length, data[0].length).setValues(data);
 
}


3. Change the highlated yellow above with your Google sheets source and destination sheets.
4. Good Luck.. :)



Wednesday, December 14, 2016

How to apply UAE Visa online for GCC Resident

Hello,

I've just applied for UAE Visa, and it took awhile for me to figure it out how exactly to fill in all the form online. All info that i found on internet, do not tell how exactly to fill the form, and all of them based on the old form.

Actually, you can chat online directly to one of UAE Ministry of Interior agent 24/7 in this page, if you need something to clarify. I got my visa within 24 hour and for my family within 48 hour. The bottom line is, you need to apply for your visa first. Once your visa approved, then you can apply for your family by attaching your approved visa, and create individual application for every single one of them.

This is how you should fill the form;
  1. Create account on this web 
  2. Once your account created, click GCC Resident to create new application form.
  3. For your visa application, choose "Establishment" as  "Sponsor Type in GCC Country". Type in your company as your sponsor. 
  4. Above questions, are the one that actually confused me. The rest of the questions in this first page are straight forward.
  5. If you've finished fill all info on the first page, click NEXT to continue.
  6. In the second page, you will be asked your address in UAE. In my case, i put my hotel. Btw, the email that you put in this page will be used to receive the approved visa. 
  7. Finished with second page, continue to the next page where you will be asked to attach document. You need to attach the Photo, letter from your company stating that you are the employee, passport and iqama. You need to reduce the size of your scanned document. I used software "paint" in windows to reduce the size of the document, and save it as JPEG. It has to be less than 100kB.
  8. Once all document attached, continue to next page to pay.

To apply for your family;

  1. Login to your account that you created.
  2. If you have five family member, then you need to create and repeat all of this processes for every single one of them.
  3. Click GCC Resident to create new application
  4. Under "Sponsor Type in GCC Country" choose "GCC Resident". and fill your info in it, because you are the sponsor of your family.
  5. The rest of the process are the same as yours.
  6. On the attach page, attach the photo, your approved visa, your pasport, their iqama, and their passport.
Good luck.


Saturday, September 10, 2016

How to turn wired printer to wireless

Assalamu'alaikum,

Hello Bapak/Ibu,

Saya hari ini senang sekali, karena berhasil membuat printer saya yang biasanya harus konek ke laptop dengan kabel, menjadi printer yang wireless. Hehehe.. saya tau, Bapak/Ibu, pasti bertanya. kok jadi pakar IT sekarang ? ya, saya anggap itu menjadi bagian hidup di Saudi Arabia. You have to be all.. :)

In my case, i use print server in order to turn my wired printer into wireless. I bought a cheap print server from ebay. It costed me USD 20 (including shipment). By the way, i use zain 4G router (huawei Model B315s-22).

Okay, this is what you need to do;
  1. Connect printer to printer server by using USB to USB b-type (included in the package), then by using Ethernet cable, connect print server to router. Power up all.
  2. Install software launch network printer wizard (included in the CD package). Then by using the wizard, find your printer. In my case, it is HP LaserJet CP1025. 
  3. I was able to print flawlessly. But then, the problem arose. The connection is unstable. It keep losses connection. :(

After dwelling around internet, i found this link that really helps. There is suggestion to connect the print server by assigning static IP address to the print server. This is what should you do;

  1. Connect directly print server to your laptop by using ethernet cable.
  2. Open your internet browser, then type: 169.254.10.10 to open Network Print Server management web page.
  3. On Network Print Server management web page, click Network, then change DHCP setting from Enable to Disable, in order to change the IP address of print server to fixed.
  4. Assign an IP address to your print server. In my case, Zain 4G router (Huawei B31s-22) ranging from 192.168.1.100 to 200. Just chose one of them.
  5. Click Submit. This will restart your print server.
  6. Connect your print server to printer, then print server to router. 
  7. Run the add printer wizard on windows. Chose connect to local printer, TCP/IP Port. You can find details in this link
  8. Then, you should be able to connect to your printer.   

Thursday, February 11, 2016

How to unlock mobily 4G LTE router Model QDC

Hello,

Untuk Bapak/Ibu sekalian, mohon maaf, karena tulisan ini akan saya tulis dalam bahasa Inggris. Biar banyak manfaatnya.

Hello,

I intentionally write this post in English, so that more people will gain benefit. This is how to unlock mobily 4G LTE router model QDC. I consider this to be part of living in Saudi Arabia :)

Actually I copied the steps in this blog. I found the file that i downloaded was saved in secured place, without "strange" pop up windows. You can download the files required in this link. I will not mention the steps in detail, but i would just mention trick for smoother unlock.

  1. Downgrade the firmware in step-wisely. The unlock is available for version 1.02.32. If your firmware happened to be in the version higher than 1.02.33, i.e 1.02.41 then downgrade it to 1.02.33 (mr7015al-zz_r0b_FW_1.02.33(20120618)), then to 1.02.32  by using (mr7015al-zz_r0b_FWN_1.02.32(20120330) .  
  2. Once your firmware in 1.02.32, then flash the LTE module.
  3. There are some reports that their router keep updating automatically to 1.02.41. I think they forgot to change the auto firmware info url to 0.0.0.0 (actually it is there, written in tagalog..:)).
  4. Setup the APN, then you should be able to connect.
------- update 29 Feb 2016

After unlocking the router, my router keeps disconnected when idle. To connect it, i had to restart the router. It drove me crazy..!!! 

After a month dwelling around internet, and hundred times of testing, i finally solve it. Alhamdulillah.. 

Mine was solved by upgrading the LTE module to the latest version. So, basically you don't have to flash the LTE module when unlocking :)..

If you already flashed the LTE module when unlocking, and changed the url to 0.0.0.0 you just need to change it back to the default url before unlocking (see above picture for default url), then trigger LTE module update.

You can also update the firmware to 1.02.33, but you can't update to the latest firmware, because it's going to lock your router back to mobily. 

Don't forget to switch the url back to 0.0.0.0, if you don't want the router to update the firmware automatically and lock you back to mobily.

Tuesday, June 30, 2015

Kirim shipment murah dengan Saudi Post

Hello...Hello...!!!
Assalamu'alaikum,

Long time not see..!!!
Dah lama ya ga ketemu..!!! Hari ni saya mau menulis. Alasannya, karena saya hari ini baru saja mendapatkan parcel yang saya tunggu2 dari Saudi Post.. Saya mau memberikan tips.. kepada Bapak2/Ibu2 sekalian, biar ga dongkol kayak saya.. :(.
Oke.. gini ya.. Kadang ntah kenapa, saat berada di Saudi, orang2 jadi hobi banget untuk belanja online.. Mungkin mrk ga ada kerjaan.. atau mungkin utk mengisi kekosongan waktu. Nah, salah satu kendala belanja online adalah mahalnya ongkos kirim. Salah satu solusinya adalah dengan menggunakan jasa saudi post. Mereka punya tarif kadang2 agak miring, semiring kalo kita nurun bukit.

Nah, berbeda dengan courier premium, yang kadang bisa dengan alamat seadanya, barang yang kita beli bisa nyampe, Saudi post agak ketat utk masalah alamat ini. Jika alamat kita ternyata tidak sesuai dengan format national address, maka barang harus di ambil ke kantor pusat mereka.

Oke, kalau mau menulis alamat di Saudi, harus mengikuti format berikut;

  1. Search dulu rumah Bapak/Ibu.. dengan melihat di map saudi post ini.
  2. Dari link itu, pilih rumah Bapak/Ibu meng-klik nomor bangunan rumah Bapak/Ibu.. Format National address punya penampakan seperti ini:
  3. Nah, tulis format alamat Bapak persis sama seperti itu.
Trus, bagaimana jika seandainya shipment bapak gak sampe, ntah nyangkut dimana. Bapak bisa mencoba hal berikut;

1. Telpon call center saudi post di 920005700, tanya shipment dimana. 

2. Jika, call center rada2 bingung, bapak bisa coba utk langsung ke kantor post pusatnya. Utk di Riyadh, bertempat di daerah Batha. Nanti bisa langsung ke bagian pengambilan yg berada di basement, atau kalo mrk bingung, bisa cb di bagian return di gate 4. Di situ sy ketemukan barang saya :)

Thursday, February 7, 2013

Cerita dari Saudi Arabia

Bapak2/Ibu Apa khabar ?

Lama juga saya tidak menulis. Hari ini (kamis) libur di Saudi Arabia. Saya ingin menulis kisah2 di Saudi Arabia. Ada cerita tentang engineer, ada tentang supir taksi, PRT dan beberapa kisah lainnya.


Tuesday, February 7, 2012

Cara membuat SIM di Saudi Arabia

Bapak/Ibu,

Apa khabar ?

Lama tidak menulis.. Masih ingat saya ? :)

Saya lama tidak menulis karena lagi tidak menemukan momentum yang tepat nih.. Ditambah saya akhirnya pindah kerja. Makanya sekali-kali saya menulis, saya ingin menyampaikan sesuatu hal yang penting. Bagaimana cara membuat SIM di Saudi Arabia ? Penting bukan ??

Thursday, July 7, 2011

Ganti operator seluler di Saudi tidak perlu rubah nomer HP

Bapak/Ibu,

Saya merasa blog ini kurang informatif. Lebih banyak menuliskan perasaan dan pandangan saya sendiri tentang beberapa hal di Saudi ini. Oleh karenanya, pada kesempatan ini saya akan memberikan informasi tentang ganti operator seluler tidak perlu merubah nomor HP. Informatif bukan ? :) Cara di Saudi sungguh paten dan menyenangkan. Tidak seperti di Indonesia.

Tuesday, July 5, 2011

Standard Salary Engineer ?

Apa khabar Pak/Ibu,

Di tengah panasnya summer di Saudi, saya menulis kepada Bapak/Ibu. Salah satu keyword yang sering di cari oleh para pencari kerja intelek (baca: siapa saja yang merasa intelek: PRT, tukang las, engineer, dsb) di internet adalah standard salary engineer, atau salary accounting, atau IT salary dsb-nya. Kata ini kadang di sambung dengan "standar salary bla..bla...bla... Indonesia". Keyword itu juga sering kali berkembang menjadi "standard salary American engineer " atau "standard salary bos from UK", karena sekedar pengen menebak berapa sih salary bos :). Jika itu yang Bapak cari, saya akan membantu Bapak menemukan jawabannya disini.

Thursday, June 2, 2011

Kisah seorang engineer kampung..

Apa khabar ?

Bapak/Ibu,

Saya menulis ini dalam keadaan gundah gulana, sedih.. Pasalnya saya baru saja men-declined offer dari perusahaan top ten dunia menurut majalah Forbes. Mungkin Bapak akan mengatakan, "gaya nih, peluang ditolak." Ya, peluang itu harus saya tolak, bukan karena offer-nya tidak menarik, bukan itu (Well, menarik ga menarik tergantung sih..) Jadi dah memutuskan menolak, kenapa sedih ? Nyesal ya ? ..................Bukan, bukan nyesal. Tapi ada yang lain.