Google Calendar for OpenERP 7.0 installation notes

Google Calendar for OpenERP 7.0 installation notes

Hello Malaysia , Singapore openERP community , how are you , lately what are you working on ? And this time i want to share something that i use a lot that is project calendar of openERP and if you are like me been a heavy user of both Gmail and openERP , then you must be wishing for a module to sync both of your calendar , in the past , we have this ical but in the latest version , the support was gone and it has been a disappointment for many but fear not as I found this great module and want to share here so that you all are aware of it .

The installation procedures are:

• To install google api client 

Before you are able running this module you must install google api client for python :https://developers.google.com/api-client-library/python/start/installationNow install the google_api module in your OpenERP 7.0 system. If any errors occur this has to do with the needed dependencies the module need (apiclient, httplib2, oauth2client, uritemplate, argparse).

• Setup google account to use google api

In Settings->Users->Users enable "Google API / Manager" in "Access Rights" for those users having admin rights. Enable "Google API / User" for those users you want to have synchronization enabled for there calendars.
Setup a google account for using google api:https://code.google.com/apis/console/Follow the instructions by google to create such an account if you haven�t got one yet. In the console create a new project. Give it a name (for example: API Project). Go to the �Services� section of your created project and switch �calendar API� to �on�.Now go to the �API settings� section of your project and click on �Create another client ID �� and select �Installed application� as Application type. Select �other� as Installed application type (this option will be visible after selecting the correct Application type). Now click on �Create client ID�.Now you have a �Client ID for installed applications� with a Client ID, Client secret, Redirect URIs. On the right you see a button �Download JSON�. Click on this button and save this file on a location where your OpenERP system has access to it (read/write).

• Authorize the google calendar to be managed by openERP

In OpenERP login as admin, you have a menu �Google API�. Create an account for accessing your google API. Go to �Google API->Configuration->Accounts�. Click on the create button ,give your account a name.In �Secrets path� enter the full path of your json file you just have downloaded (example: d:\openerp\special\google_calendar\client_secrets.json). In �Credential path� enter a full path (filename included) where google_api will find/create the credential file (example: d:\openerp\special\google_calendar\ credentials.dat). The first time this credentials file does not exists.When you�re done save your account,  click on this button �Authorize� becomes red. To test if everything is correct.It's important that you have your browser opened on the same machine as OpenERP-Server is running.If everything goes well a new page opens in your browser, asking to accept that the openERP module google_api wants to manage your calendars and to view your calendars (if not visible you have to login first). Click the accept button. Now the credential file is created.If you have problems using this method deactivate "Use local browser" in "Google Api->Configuration->Accounts->[your account]", stop your OpenERP-Server and run it in interactive mode (on ubuntu from the location where you installed OpenERP-Server: ./openerp-server -c /etc/openerp-server.conf).After clicking the "Authorize" button in your terminal you see a link. Copy this link and paste it in a browser on a device where this is possible. Here you will receive a code, enter this code in your terminal where the system is waiting for it. Stop OpenERP-Server and start it again the way you always do.

• Setup Calendar you want to sync.

The last thing you have to do is to create calendars in your account you want to sync with OpenERP. For each user you want to have this option you must create one calendar. See http://www.google.com/calendar to create your calendars. Don�t forget to share this calendar with the user for whom this calendar is. This user also must have a google account.In the calendar settings you have a Privat address with a little xml button.Click on it and copy the link into an text editor.

The link looks like:https://www.google.com/calendar/feeds/ghzfw33qcgtoahz1hq7cdsj321%40group.calendar.google.com/private-35403bc2f4aad7ce56b21a976516b21/basic

Now copy the string between �feeds/� and �/private�, you have something like this:ghzfw33qcgtoahz1hq7cdsj321%40group.calendar.google.com

Replace �%40� with the �@� sign, resulted in the following Google calendar id:ghzfw33qcgtoahz1hq7cdsj321@group.calendar.google.com

Go back to OpenERP and create a calendar (Google Api->Configuration->Calendars�. Here you must select the account you just have created, the user this calendar belongs to and the �Google calendar id�.Save your data and click the button �Synchronize� to test it. In Messaging->Organizer->Calendar you can see if events were created/changed and/or deleted.The module google_api synchronizes every 15 minutes. You can change this in Settings->Technical->Scheduler.

You also have the possibility you use the notifications option of google, in this case google triggers some link you must define. In this trigger you can call the do_synchronize method of the google_api module.

For downloading the module please visit OpenERP Applications

Kumpulan Contoh Program Visual Basic 6.0 Sederhana

Kumpulan Contoh Program Visual Basic 6.0 Sederhana � Maaf sobat-sobat artikel kali ini hanya untuk review dan mengingatkan beberapa source code yang bisa di download tentang contoh-contoh program sederhana dengan visual basic 6.0.

Berikut adalah link artikel kumpulan program vb 6 sederhana yang sudah di posting :
Contoh Program Kasir Sederhana
Program Sederhana Database VB 6
Kalkulator Sederhana dengan Visual Basic 6.0
Game Sederhana dengan VB 6
yang terdiri dari game :

• game snake vb
• game tic tac toe vb
• game mencocokan gambar

Untuk detailnya dan link donwloadnya silahkan di klik yang diatas tadi ;)

Tapi ada sedikit tambahan lagi untuk downloadan source code contoh program kasir sederhana dengan versi yang berbeda dengan yang diatas tadi dan game maze.

Lumayan sob.. untuk tambahan bahan referensi belajar visual basic 6.0 nya

Penampakan :

Download Source Code

Contoh Game Maze VB 6
Contoh Program Kasir dengan VB 6

Gimana Oke kan.. ?
Sering-sering aja kesini sob.. masih banyak koleksi yang belum saya posting..
Atau kalau tunggunya kelamaan n males download, bisa Order DVD SCVB nya saat ini sudah mencapai 200 lebih source code, 1000 lebih tips dan trik dan ratusan tutorial visual basic dalam bentuk ebook ataupun video
( maaf.. sekalian promosi :"> )
 See U.. /bye

Virtual Key di Delphi (OnkeyUp,OnkeyPress,OnKeyDown)

Sebelum mempraktekan tutorial penggunaan OnKeyDown, OnKeyPress dan OnKeyup pada delphi, saya akan bahas sedikit tentang pengertian event  tersebut. Tutorial ini biasa juga disebut dengan Virtual Key Codes yand digunakan untuk memberikan representasi pengekanan tombol pengguna, virtual code memungkinkan anda untuk mewakili nilai-nilai keyboard untuk non-alfanumerik kunci.

OnKeydown adalah event yang terjadi ketika suatu kunci keyboard yang sendang ditekan ke bawah.

OnKeyPress adalah event yang terjadi ketika suatu kunci keyboar yang sedang ditekan dan menahanya sesaat atau sebelum tombol tersebut dilepas kembali keatas.

OnKeyUp  adalah event yang terjadi ketika suatu kunci keyboard dilepaskan atau saat sesudah onKeyprees.

Pada tabel dibawah ini adalah  daftar Virtuak Key Menggunakan Hexadecimal.

Simbol	Nilai (heksa desimal)	Keyboard dan mouse
VK_LBUTTON	01	Klik kiri mouse
VK_RBUTTON	02	Klik kanan mouse
VK_CANCEL	03	Control-break processing
VK_MBUTTON	04	Klik tengah mouse (three-button mouse)
VK_BACK	08	BACKSPACE
VK_TAB	09	TAB
VK_CLEAR	0C	CLEAR
VK_RETURN	0D	ENTER
VK_SHIFT	10	SHIFT
VK_MENU	12	ALT
VK_PAUSE	13	PAUSE
VK_CAPITAL	14	CAPS LOCK
VK_ESCAPE	1B	ESC
VK_SPACE	20	SPACEBAR
VK_PRIOR	21	PAGE UP
VK_NEXT	22	PAGE DOWN
VK_END	23	END
VK_HOME	24	HOME
VK_LEFT	25	LEFT ARROW
VK_UP	26	UP ARROW
VK_RIGHT	27	RIGHT ARROW
VK_DOWN	28	DOWN ARROW
VK_SELECT	29	SELECT
VK_PRINT	2A	PRINT
VK_EXECUTE	2B	EXECUTE
VK_SNAPSHOT	2C	PRINT SCREEN
VK_INSERT	2D	INS
VK_DELETE	2E	DEL
VK_HELP	2F	HELP
	30 � 39	0  -  9 keyboard
	41 � 5A	A  -  Z keyboard
VK_NUMPAD0	60	Numeric pad 0
VK_NUMPAD1	61	Numeric pad 1
VK_NUMPAD2	62	Numeric pad 2
VK_NUMPAD3	63	Numeric pad 3
VK_NUMPAD4	64	Numeric pad 4
VK_NUMPAD5	65	Numeric pad 5
VK_NUMPAD6	66	Numeric pad 6
VK_NUMPAD7	67	Numeric pad 7
VK_NUMPAD8	68	Numeric pad 8
VK_NUMPAD9	69	Numeric pad 9
VK_SEPARATOR	6C	Separator
VK_SUBTRACT	6D	Subtract
VK_DECIMAL	6E	Decimal
VK_DIVIDE	6F	Divide
VK_F1	70	F1
VK_F2	71	F2
VK_F3	72	F3
VK_F4	73	F4
VK_F5	74	F5
VK_F6	75	F6
VK_F7	76	F7
VK_F8	77	F8
VK_F9	78	F9
VK_F10	79	F10
VK_F11	7A	F11
VK_F12	7B	F12
VK_F13	7C	F13
VK_F14	7D	F14
VK_F15	7E	F15
VK_F16	7F	F16
VK_F17	80H	F17
VK_F18	81H	F18
VK_F19	82H	F19
VK_F20	83H	F20
VK_F21	84H	F21
VK_F22	85H	F22
VK_F23	86H	F23
VK_F24	87H	F24
VK_NUMLOCK	90	NUM LOCK
VK_SCROLL	91	SCROLL LOCK
VK_LSHIFT	A0	Left SHIFT
VK_RSHIFT	A1	Right SHIFT
VK_LCONTROL	A2	Left CONTROL
VK_RCONTROL	A3	Right CONTROL
VK_LMENU	A4	Left MENU
VK_RMENU	A5	Right MENU
VK_PLAY	FA	Play
VK_ZOOM	FB	Zoom

Berikut saya contohkan untuk penggunaanya secara sederhana, hanya untuk pembelajaran saja bagi yang sudah master mungkin turorial ini tidak lah berguna, tetapi bagi yang baru berlajar nanti bisa dikembangkan lagi untuk tingkat yang lebih bagus lagi.

1. Buat form seperti dibawah ini.

2. Ketikan script pada Form1 Event OnKeyDown, OnKeyPress, OnKeyUp

• Event OnKeyDown



 procedure TForm1.FormKeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if key = VK_F11 then
  Form1.WindowState :=WsMaximized else
  if key = VK_ESCAPE then
  Application.Terminate;
end;

• Event KeyPress



procedure TForm1.FormKeyPress(Sender: TObject; var Key: Char);
begin
   if Key = char('2')then
   Panel2.Color := ClRed
  else
   if key = Char('1') then
    Panel1.Color :=  ClBlue
   else
  if Key = char('3') then
    Panel3.Color := ClBlack else
  if Key = char('4') then
  Panel4.Color := ClGreen else
  if key = char('5') then
  Panel5.Color := ClAqua else
  if Key = char('6') then
  Panel6.Color := clPurple;

end;

• Event KeyUp



procedure TForm1.FormKeyUp(Sender: TObject; var Key: Word; Shift: TShiftState);
begin
  if key = VK_F1 then
  Form1.Color := clRed else
  if Key = VK_F2 then
  Form1.Color  := clBlue else
  if Key = VK_F3 then
  Form1.Color := Clyellow;
end;

Sekian dulu untuk pengenalan menggunakan virtual key di delphi. semoga bermanfaat... terimakasih.

Download Source Code

Copy file sample in visual basic

Copy file sample in visual basic

FileCopy is the simplest way to copy a file. Use this sample or part of the example to make a efficient file copy tool.

Here is how it works:

'calling the FileCopy method, very simple         FileCopy(Source, Destination)

I made a sample project, you could download it. There is nothing special inside. I added a little function tool to help the user get the files names, SAmpleCopyFile.zip

''' <summary> ''' This is a sample ''' This show you how to use FileCopy method to copy a file ''' There are better way to copy a file other than FileCopy ''' ''' This is very basic, there is no checking, no security, no rights. ''' Use copy file for simple task or basic operations. ''' </summary> ''' <remarks></remarks> Public Class Form1     Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load         Dim Source As String = ""         Dim Destination As String = ""         'get a file name         Using oOpenFileDialog As New OpenFileDialog             If oOpenFileDialog.ShowDialog() = Windows.Forms.DialogResult.OK Then                 Source = oOpenFileDialog.FileName             End If         End Using         'Get the name to save to         Using oSave As New SaveFileDialog             If oSave.ShowDialog = Windows.Forms.DialogResult.OK Then                 Destination = oSave.FileName             End If         End Using         'calling the FileCopy method, very simple         FileCopy(Source, Destination)         Me.Close() 'close the form because the sample is completed.     End Sub End Class

---

This email is free from viruses and malware because avast! Antivirus protection is active.

5 CSS UI KIT Gratis

Untuk mempercantik tampilan situs, dan mengikuti perkembangan jaman.
kali ini admin akan berbagi tentang 5 CSS UI KIT, apa si UI ?




UI, UI adalah singkatan dari User Interface jadi bisa di maknai bahwa tool ini adalah
untuk mempercantik interface[wajah] website yang kita buat saat di buka oleh user[pengguna]

1. Pure

Download : Disini

2. Almost Flat UI

Download : Disini

3. iNK v.2

Download : Disini

4. YAUI Kit

Download : Disini

5. Metro Style Web UI

Download : Disini

Rancangan dan Analisis Kebutuhan Data untuk Aplikasi Raport Online (Sesuai Keputusan Dirjen Dikmen)

Assalamualaikum... ^_^

Kali ini IT Sasak akan share informasi terbaru terkait tentang Sekolah di Indonesia, Sekarang sudah ada keputusan terbaru dari Dirjen Dikmen Terkait dengan "Laporan Capaian Kompetensi Peserta Didik Sekolah Menengah Atas (SMA)".

Nah, Sesuai dengan keputusan tersebut IT Sasak akan membuat Aplikasi yang memungkinkan Sekolah untuk menggenrate Raport Secara Otomatis tanpa harus mengisi manual Data Raport tersebut. Aplikasi ini merupakan Aplikasi yang akan di buat menggunakan Platform PHP dan MySql supaya bisa di integrasikan dengan metode Client Server.

Sayangnya Aplikasinya masih belum selesai... ^_^

Jadi saya hanya bisa memberikan Gambaran tentang Kebutuhan Data dan Rancangan Databasenya saja...

Ingat... ini hanya Analisis Saya yah,,, jadi mungkin akan berbeda bila Agan yang sudah Mastah atau Dewa di bidang Pemrograman yang Analisis... ^_^

Berikut Analisis Saya terkait Kebutuhan Datanya:

IDENTITAS SEKOLAH

1. Nama Sekolah
2. NPSN/NSS
3. Alamat
4. Kode Pos
5. Telp
6. Kelurahan
7. Kecamatan
8. Kabupaten/Kota
9. Provinsi
10. Website
11. E-Mail

SISWA

1. Nama
2. NIS
3. Tempat Lahir
4. Tgl Lahir
5. Jenis Kelamin
6. Agama
7. Status Dalam Keluarga
8. Anak Ke
9. Alamat
10. No Telp
11. Sekolah Asal
12. Diterima di Kelas
13. Diterima Tgl
14. Nama Ayah
15. Nama Ibu
16. Alamat Ortu
17. Pekerjaan Ayah
18. Pekerjaan Ibu
19. Nama Wali
20. Alamat Wali
21. Pekerjaan Wali

KELAS

1. Id Kelas
2. Kelas
3. Wali Kelas

MATA PELAJARAN

1. Id Mapel
2. Mapel
3. Guru Mapel
4. Id Kategori Mapel

KATEGORI MAPEL

1. Id
2. Kategori Mapel (Kelompok A, Kelompok B, Kelompok C)

EKSTRA KURIKULER

1. Id
2. Ekstra Kurikuler

ABSENSI

1. id_absen
2. NIS
3. Sakit
4. Izin
5. Tanpa Keterangan

LAP 1 CAPAIAN KOMPETENSI

1. id_cap
2. id_mapel
3. NIS
4. Peng_Angka
5. Keteram_Angka
6. Dalam_Mapel (SB/B/C/K)
7. Antar Mapel

LAP 2 DESKRIPSI KOMPETENSI

1. id
2. nis
3. Mapel
4. cat_Pengetahuan
5. cat_Keterampilan
6. cat_Sikap

KETERANGAN PINDAH
Keluar

1. id
2. Nis
3. tgl
4. kelas di tinggal
5. sebab

Masuk

1. id
2. Nama
3. Nis
4. Sekolah Asal
5. Masuk Tgl
6. Masuk di Kelas
7. Tahun Pelajaran

CATATAN PRESTASI

1. id
2. nis
3. prestasi

Nah berikut Rancangan Databasenya :

Semoga Informasinya bermanfaat yah... ^_^