Useful CMD Commands

Hm... So for today I want to post something useful(?).

As a developer we need to know basic usage of Command Prompt. Why? For example if your program suddenly crashed. In unknown reason. And the error said, the IP was used by another process. But you don't know how you would achieve that. You could use netstat.

This is just one example. I wish this could be useful for you.

Find Server Name
nslookup 172.19.12.237

Find Port Used (Below is the example in finding netstat for port 80)
netstat -o -n -a | findstr 0.0:80

Kill process by PID
taskkill /PID

Flush DNS
If you cannot access your computer by domain name. Do the following Command
ipconfig -flushdns

Check Serial Number DLL
Use this on visual studio command prompt
for check serial number - SN -T DllNames.dll

Reset IIS
iisreset

Auto Shutdown windows with CMD command in 60 seconds
Auto Shutdown - shutdown -s -f -t 60

Synchronize
To synchronize time with Active Directory server run the following command
net time  /domain:domain.com /set

Copy and merge files
How to copy a csv files to be one big files. Start > Run > type "cmd"
copy *.csv name.csv

Find out is the port of your server is opened from client
telnet servername 80

I hope this post could be useful for you, and for your project. :)

Actually i have a lot of things to share with you. But almost all of them was just copying from another site. I think i will post it here someday.

Migrating CRM 4 to CRM 2011

Hookee.... It's been a while since I posted something in this blog. Looks like my blog is rusty now. It stays here when it is raining, and stay here when it is a sunny day. *What are you talking about Yuli... -_-"

Today is a great day for me. I've been working for almost 13 hour today (yesterday I was working 13 hour too), and now I'm still in my office. So, what am I doing here?

So, this is my story....

Long time ago, my CEO wanted to migrate the Dynamics CRM 4.0 into the Dynamics CRM 2011. My team lead, already done this in test server and staging server. So, we were absolutely ready for migrating. Everything changed when my team lead suddenly resigned from this company. I was chosen as the PIC (people in charge) for Dynamics CRM in my Office.Yeah, right.. I'm just a junior programmer, and I'm in charge in the most critical application in my Office.

So I prepared it a lot. Made a documentation, how to migrate to new CRM 2011 in test server, and it was succeed. This is how I do :

1. Backup the MSCRM_Config and delete from database server
2. Install new organization CRM (temp). (Error MSCRM_Config already exist will be occurred if step one is skipped)
3. Import old organization
4. Delele temp organization and make old organization as default server
5. Register the custom Plugin using Plugin Registration Tools
6. Install Roll up update 1-8 on server
7. Install SRSDataConnector on database server
8. Install CRM Email Router
9. Configure the Email Router
10. Bug Fixing
11. Install CRM 2011 client.

So, if I succeed, why am I in here right now.

I messed up, I installed the roll up before I was importing my old organization, and somehow, my database server cannot be reached 17 minutes after I went home yesterday. (Bad luck yuli.. (T_T) )

The result was, my import failed, my database need to be restored. In short, my work yesterday was not used.

After heard that my import failed, My new team lead came to the office in 9 PM. I'm grateful, He is so kind. (Even though he said, that "I'm the one that will be punished by CEO if we failed... No pressure. Haha...".)

Today, I've been here for 13 hour and my import still not finished.

So, my conclusion is.

1. Never install roll up before you import your old organization.
2. Never underestimate your task, even if you've already tested it and succeed. (I'm not using my documentation I made, then I went home, and think that the import will not failed. I was so arrogant, but it failed. Stupid me...)

I found out the problem. Here's my answer in Microsoft Forum :

(sorry for my english)
Did you solve this problem? I got the same issue when I was importing CRM 4 Organization to CRM 2011. The problem is in Roll Up 6.
Please see http://support.microsoft.com/kb/2710577
Here's the important update in Roll Up 10. "After you apply Microsoft Dynamics CRM 2011 Update Rollup 6, you cannot create new organizations. Additionally, you cannot import organizations."
If you haven't fix this problem. You could install Roll Up 10 then import the organization, or you can import the organization before you install the roll up.

Oh, and then I'm really sorry for someone who wrote a comment in my previous post. Asking about my old program. I don't have any internet connection in my boarding house, so i cannot send it. I'm really sorry.

Kismet Tutorial

Ok, my second post using english (bad english ofcourse n_n)

today. i'll give little tutorial about kismet. this tutorial is based on video tutorial from 3D buzz.com. Actually i have already make video tutorial. but, it think.. it's little... to... large to upload.. :D. (i don't have fast ISP. My ISP s*cks). Ok then. But before i show you the link to my tutorial. i'll show you my progress about rektorat building in ITS. i'ts still not done yet (my lecturer ask me to make it bigger. aarrrgghh...). Ok then.. this is it... :D

Yosh... as you se... my roof top still to short. And i can't make ITS logo in 3D. (aarrgghh.. i'm still newbie in 3D modeling).

next progress i will show garden of ITS Surabaya. please, wish me luck.. :D

Oh, right.. here's the link to my kismet tutorial. Click here

(oh yeah, sory bout my bad english...)

"if possible, i'd like to not have sad feelings. but they'll come to me, won't they? in those times, it would be good, if only i could say "yeah, hello! my friend", with a smile" - goodbye days english translation

INI 3D

This is my first post using english (arrghh, why i can't speak english well until now, wish i don't write a wrong words here... n_n). Ok, let's get to the point..

My final project in information system of ITS Surabaya.. INI 3D... Whooaa... wait, "INI3D"? what is it..

INI3D is acronym of ITS (Institut Teknologi Sepuluh Nopember) now in 3D. Me, and my friend's are make 3D map of our campus. And, what for... we want to help promote our campus ITS Surabaya to the world... n_n. We wish, with this 3D models of ITS surabaya... People from other island can see our campus. But not just see our campus in 3D model. We wish, that user can interact with the object on map, its like the game... (my childhood dream.. making some game.. >.<). Soo... it's very long time if we decide to develop game form scratch (we'd only had 7 man/women with 1 other man that already develop this project from last year). And we'd only have 3 month++ to finish this project... Sooooooo... we... decided to use Game Engine, which is.. UNREAL ENGINE 3... (sounds cool right, but actually we've just newbie with that engine. n_n). With 7 great people (and of course, great friend), and 1 senior developer. We hope this project was succeed, and can promote our campus Institut Teknologi Sepuluh Nopember Surabaya(not Institut Teknologi Surabaya... even the google map mas wrong bout my campus T.T).

You've interested? why don't you visit our official project blog
http://inithreed.wordpress.com/

Tutorial Pentaho

Lagi iseng2... di rumah.. ga tau kenapa seneng banget hari ini.. (2 jam ini tepatnya.. hahahah, yay yay yay... :D :D :D) biarpun perut lagi ga enak gara2 salah makan malem sebelumnya.... rahangku ga ngerti kenapa, sakit banget... tapi tetep... seneng.. dan bersyukur tentunya... :D

nah... aku cuma pingin promosi ae... eits... bukan jualan kok... ini salah satu dokumentasi tugas matakuliah ku... Data Mining dan Data Warehouse namanya.. yaahh.. mungkin bisa jadi bahan tutorial buat bikin dashboard menggunakan pentaho. Karena banyak banget gambarnya... jadi yang tertarik monggo download di scribd ya...

atau gampangnya donlot disini