How to use crmsvcutil.exe in CRM 2011

Another Archive for CRM Development

CrmSvcUtil.exe /url:http://crmdevmscrm/CRM2011DEV/xrmServices/2011/Organization.svc/out:HosksGeneratedCode.cs    /username:Hosk /password:Hoskpassword

Source : http://crmbusiness.wordpress.com/2011/01/29/crm-2011-simple-crmsvcutil-example-for-creating-early-bound-classes/

Cara mencari String atau text di dalam Stored procedure di SQL server

Sumber : http://blog.sqlauthority.com/2007/11/10/sql-server-2005-2000-search-string-in-stored-procedure/

Cuma sebagai archive lagi... Cara mencari String atau text di dalam Stored procedure di SQL server *Tested di SQL Server 2008

SELECT DISTINCT o.name ,o.xtype
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE c.TEXT LIKE '%text yg dicari%'

Query untuk mendapatkan nama kolom di SQL Server

Sumber : http://blog.sqlauthority.com/2008/08/06/sql-server-query-to-find-column-from-all-tables-of-database/

Sama seperti post sebelumnya. Saya mendapatkan ini di post dengan bahasa inggdri. Saya hanya mengetikkan ini disini sebagai archive agar saya tidak lupa...

Terkadang saat kita maintenance aplikasi yg telah jadi, terdapat table di sql server yg tidak memiliki foreign key. Untuk itu kita harus mencari nama kolom tersebut manual. Untuk mencarinya dengan cara cepat kita dapat menggunakan : 

SELECT t.name AS table_name,

SCHEMA_NAME(schema_id) AS schema_name,

c.name AS column_name

FROM sys.tables AS t

INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID

WHERE c.name LIKE '%NamaTable%'

ORDER BY schema_name, table_name;

Semoga membantu.. *ma'af repost... cuma sebagai archive

Cara Membuat Hot Spot WiFi melalui Laptop

Hm... Sepi sekali blog ini...

Next post akan pakai bahasa indonesia. Saya habis tidak lulus kelas bahasa inggris. *malah curhat...

Beberapa waktu lalu saya membeli HP baru... (Sombong... Sombong...). Lenovo K860. Sebuah hp yang cukup kuat untuk memainkan game game. Lalu saya juga membeli sebuah modem smartfren rev b. (Selama masa promosi cepat lho. Download di surabaya mencapai 500 kb/s di kuta bali mencapai 300 kb/s) Tujuannya, saya ingin menjadikan smartfren saya menjadi hotspot wireless (wifi hot spot).

Awalnya saya kira saya hanya perlu membuat sebuah koneksi ad hoc. *Peer to peer device saya dengan laptop. Sayangnya, hal ini tidak dimungkinkan... Setelah mencari beberapa lama. Saya menemukan sebuah artikel.... *Ma'af linknya hilang...

Yang kita lakukan adalah mengubah laptop kita menjadi hosted network. Jika anda tidak ingin membaca dari sumber berbahasa inggris, anda dapat membacanya disini...

1. Connectkan modem anda ke internet
2. Di connection properties modem anda, buat agar komputer lain bisa mengaksesnya. Caranya klik start : control panel  : network and internet  :  network and sharing center
3. Click di link koneksi wireless anda. Disini saya menggunakan smartfren. Yang terlihat adalah ZTE Wireless Terminal
4. Akan terbuka jendela status ZTE. Klik Properties
   
5. Di jendela properties klik sharing dan centang allow other network users to....
6. Klik Ok
7. Masuk CMD as administrator (Buka start  :  ketik CMD di menu search  :  klik kanan  :  Run as Administrator)
8. Ketikkan Perintah Berikut di CMD (Tidak pakai kurung siku) :
   netsh wlan set hostednetwork mode=allow ssid=[NamaNetwork] key=[Password]
   netsh wlan start hostednetwork
9. Viola, laptop anda sekarang menjadi sebuah hot spot pribadi.

NOTE :

1. Untuk melihat apakah network anda sedang menyala atau tidak ketik :
   netsh wlan show hostednetwork
2. Untuk menghentikan share anda ketik :
   netsh wlan stop hostednetwork

Semoga membantu......

How to see Dynamic CRM data GUID

Hi hi... Another short post from me.

I will tell you some trick in as CRM admin. Dynamic CRM always use GUID as ID in each Data. Sometimes you need those GUID. There is an easy way to do that which is by using the URL.

1. Click one data to open detail.  
2. If the address bar is not shown. Press f11 (full screen) on data you want to get the GUID, find the url http://server:5555/org/main.aspx?etc=1&extraqs=%3f_gridType%3d1%26etc%3d1%26id%3d%257bE5F67BB7-51FE-DD11-8631-000C29478A85%257d%26rskey%3d521859899&pagetype=entityrecord
3. The bold text above is the GUID.

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

official kmsi site

aduh aduh... Setelah beberapa lama akhirnya diupload juga. Websi resmi kmsi (Keluarga mahasiswa sistem informasi). Dibuat dengan jommla. Web yang dibuat ama Yanto(hoiweb.wordpress.com). Emang belum final dan masih maintenance. Tapi udah keren. Pak hoi emang dewa. (Omong-omong.. Ngupload di warnet ini lama banget yach) Karena aku mo upload gambar ga masuk2 mending langsung kunjungi webnya ya.. kmsi-its.org

Mengganti logo booting ubuntu

Nglanjutin yang remaster ya.. tapi yang sekarang ga copy paste… ini murni percobaan sendiri.

Oke.. kemarin udah buat biar bisa ngistall di live cd. Udah dicoba belum? Nnah sekarang kita (kita ?? loe aja kali gue nggak) coba untuk mengganti logo saat booting. Saat mencoba, logo saat booting tentu masih keluar logo ubuntu.

Untuk menggantinya dapat kita ubah file splash.pcx yang ada pada folder insolinux di cdrom(eits.. cdrom disini adalah folder pada postingan sebelumnya mengenai Meremaster ubuntu live cd. Yang sudah dirubah hak akses-nya itu lo). Trusss diapakan. Karena aku kurang tau format pastinta maka file splash.pcx itu edit saja melalui GIMP. Loh sebentar kan susah. Nggak kok. Kamu copy aja logo yang udah kamu buat(dipilih dengan selection tool) lalu paste di gimp. Secara otomatis gambarmu akan berubah pengaturan menjadi sesuai dengan format file tersebut. Save file tersebut. Lalu buat isonya… Selesai deh. Okey aku review ya

Folder yang dibutuhkan

~/cdrom tempat kita mengkopi isi cd livecd atau iso livecd
~/temp tempat kita me-mount file filesystem.squashfs (filesystem livecd)

1. Perisapan

Buat logo dengan format sesuai keinginan.

mkdir cdrom

Lakukan untuk folder berikutnya
2. Mount iso ubuntu anda

sudo mount -o loop -t iso9660 livecdfile.iso ~/temp

3. Copy semua isi iso file ke directory cdrom

rsync --progress –a ~/temp/ ~/cdrom/

4. Lalu rubah permissionnya

chmod 777 -R cdrom

5. Lalu Umount cdrom anda

sudo umount ~/temp

6. Lalu pada open ~/cdrom/isolinux/splash.pcx. dengan GIMP.

7. Buka file gambar yang sebelumnya kamu buat.

8. Corp gambar yang ingin dijadikan logo. Lalu tekan ctrl-c. Lalu paste(ctrl-v) pada splash.pcx yang telah kamu buka dengan gimp. Atur sesuai keinginan.

9. Save.

10. Sekarang mari kita membuat file iso-nya

sudo mkisofs -o customlivecd.iso -b isolinux/isolinux.bin -c

isolinux/boot.cat -no-emul-boot -boot-load-size 4 -boot-info-

table -r -V "Aria LiveCD" -cache-inodes -J -l cdrom/

11. Selesai. Setelah anda melakukan booting dari cd logo dari splash.pcx yang telah anda edit akan keluar.

Meremaster Ubuntu live cd

MeRemaster Ubuntu live cd.

Menambah aplikasi (Yang ngganti logo belum bisa dan belum nyoba)

Wuokeh akhirnya posting pertamaku.. Walupun copy paste tapi buat temen eh saudaraku di its pasti butuh banget nih. Buat FP(Final Projeck) Praktikum sistem operasi. Yaah moga-moga orang yang aku copy paste kagak marah. Soalnya aku lupa linknya.

Langsung aja ya.

Requirments

1. CD/ISO Ubuntu rel 6.06 ke atas (LiveCD versi sebelumnya menggunakan cloops, diluar bahasan kali ini)

2. Kernel dengan modul squashfs enabled (kernel bawaan Ubuntu 6.06 sudah memenuhi syarat ini. ya anda harus menginstall Ubuntu 6.06 dong ;-P)

3. squashfs-tools ( anda harus menjalankan: sudo apt-get install squashfs-tools )

4. koneksi internet/DVD Repo Ubuntu - opsional (jika tidak ada, anda tidak bisa menambah aplikasi baru)

Cara Install :

Buat folder dibawah ini (bagi yang belum tahu “~” menunjukkan folder /home/nama_user, bukan unlimited lho.)

~/cdrom tempat kita mengkopi isi cd livecd atau iso livecd
~/temp tempat kita me-mount file filesystem.squashfs (filesystem livecd)
~/work tempat kita bekerja sampai livecd kita siap di buat iso kembali

1. Perisapan

mkdir cdrom

Lakukan untuk ketiga folder berikutnya

2. Mount iso ubuntu anda

sudo mount -o loop -t iso9660 livecdfile.iso ~/temp

3. Copy semua isi iso file ke directory cdrom

rsync --progress –a ~/temp/ ~/cdrom/

4. Lalu rubah permissionnya

chmod 777 -R cdrom

5. Lalu Umount cdrom anda

sudo umount ~/temp

6. Sekarang kita akan membuat filesystem virtual dalam bentuk file.

sudo dd if=/dev/zero of=livecdfs.ext2 bs=1M count=2147

7. Jika sudah mari kita format

sudo mke2fs livecdfs.ext2

8. Jika sudah selesai memformat. Waktunya kita me-mount file filesystem.squashfs di temp/ dan livecdfs.ext2 ke work/ lalu meng-copy isi temp/ ke work/

sudo mount -t squashfs -o loop ~/cdrom/casper/filesystem.squashfs

~/temp
sudo mount -o loop livecdfs.ext2 ~/work
sudo rsync --progress -a ~/temp ~/work
sudo umount ~/temp

9. Oke disini kita akan menginstall program tambahan Tapi sebelumnya kita harus memount dulu iso repository kita. (aku menggunakan iso. Sebenarnya di link aslinya ada yang connect ke internet. Tapi karena belum tak coba yaaa… pake yang iso aja ya.)

mkdir ~/work/media/dvd1

Lakukan ini lima kali (kalo dvdnya lima ya)

10. Mount file iso ke directory yang telah kita buat tadi.

sudo mount -t iso9660 -o loop ~/repos/1of5.iso

~/work/media/dvd1

Lakukan ini lima kali ya.

11. Lalu jadi root daru file di dalam folder temp

sudo chroot ~/work/

12. Edit source.list di folder ~/work/etc/apt/sources.list

deb file:///media/dvd1/ gutsy main

deb file:///media/dvd2/ gutsy main multiverse restricted

deb file:///media/dvd3/ gutsy universe

deb file:///media/dvd4/ gutsy universe

deb file:///media/dvd5/ gutsy universe

13. Sekarang lakukan update dan kita bisa menginstall dengan puassss program-program yang diinginkan.

sudo apt-get update

sudo apt-get remove openoffice.org-core

sudo apt-get install wine

Diatas hanya sekedar contoh penginstallan program.

14. Mempersiapkan pemaketan kembali. Jangan lupa untuk melepas mount cd/repo
anda dan menghapus atau mengembalikan kondisi file dan filesystem seperti semula.

sudo umount ~/work/media/DVD1

Lakukan ini lima kali keyh…

15. Lalu kita meng-update daftar aplikasi yang baru

sudo chroot ~/work dpkg-query -W --showformat='${Package}

$Version}\n' > ~/cdrom/casper/filesystem.manifest

16. Kemudian kita membersihkan (lagi) semua space yang tidak terpakai. Kita akan menggunakan dd untuk mengkompress space kosong tadi ke sebuah file yang lantas kita hapus.

sudo dd if=/dev/zero of=~/work/filekosong
sudo rm ~/work/filekosong

17. Selanjutnya, membuat file squashfs dari hasil remaster kita

sudo rm ~/cdrom/casper/filesystem.squashfs
cd ~/work
sudo mksquashfs . ../cdrom/casper/filesystem.squashfs
cd ..

Proses ini akan terasa cukup lama(memang lama mas)

18. Membuat file iso. Sebelumnya kita akan meng-generate md5sum yang baru.

cd cdrom
sudo find . -type f -print0 |xargs -0 md5sum |sudo tee md5sum.txt
cd ..

19. Sekarang mari kita membuat file iso-nya

sudo mkisofs -o customlivecd.iso -b isolinux/isolinux.bin -c

isolinux/boot.cat -no-emul-boot -boot-load-size 4 -boot-info-

table -r -V "Aria LiveCD" -cache-inodes -J -l cdrom/

20. Selesai bung… Kita bisa mencari file iso di directory home anda. Anda bisa mencobanya di virtualbox atau jika di windows bisa pakai vmware.

Sumber : http://www.linuxindo.web.id/