Personal Folder

Programmer team current project.

Project	Description	Status
MSSR	Material Selling System (non finish goods, waste, etc).	Application done, waiting integration with SAP.
TLIMS	Web application replacing old LIMS.	User trial.
Export Trading	Maintain export trading data related to sales order, such as arrange shipment, forwarder, forwarder commission, etc.	User trial.
Import non Trading (Procurement)	Maintain import trading data (procurement import purchase order).	Define user requirements.
Account Payable (AP) Workflow	Track invoice status that accounting received from vendor.	Workflow and application design done, go to coding.
SAP Server Relocation	SAP server relocation currently abroad to local site.
SAP Trading	Set new company code that will handle all corporate trading transaction. Since the company is registered as manufacture company, we have to set trading transaction separately from current system.	Design organizational structure.

Current major system maintained by IT (besides SAP). Most are inhouse applications developed by our software programmer division team.

System	Development	Description
CAF	inhouse	Contract System - Manage company contract related to vendor.
CRDS	inhouse	Customer Relation Database System - Provide information about PT TITAN customer (integrated with SAP already), specific customer requirement for the product, competitor purchasing information, etc. - Record technical and sales visit of our technical service staff. - Process sample request, customer trial request from customer. - Manage customer complaint or record customer satisfaction from customer.
EDS	inhouse	Electronic Document System - Manage company document electronically such as ISO Document, etc.
ERM	inhouse	Enterprise Risk Management - Manage risk of a job/project to ensure its safety aspects (identify risk, search for outcomes, etc).
HR System	inhouse	HR System for Employee - Web base application to create/display/approve employee annual leave, business travel, attendance report. - Display employee personal data, medical record history. - Display company HR related form and publication (Internal Memorandum, Organization Notice, etc).
IT Support/IT Helpdesk	inhouse	IT Support System. - Record application and database backup routine. - Record any event/problem on server system, application, network, pabx, etc. - Managing IT helpdesk request from user.
LIMS	external	Laboratory Information Management System - Maintain experiment and laboratory data about characteristic of a product)
LDS	inhouse	Laboratory Data System - Maintain laboratorium data related to products development and quality control. The system consume LIMS data for a judge that a product is sold as Prime, Near Prime etc.
Online Application	inhouse	Web based application for Admin Service Department request for service, such as transportation request, meal, office stationaries, business card, uniform request.
Personel	inhouse	HR System for HR Department - Manage employee personal data, - Maintain employee personal information data, family data, working experience, education, annual leave, medical, training and position history. - Recognition achieved and warning accepted from the company. - Create employee work schedule, process employee absens.
PTService	inhouse	SAP to Local Database Data Transporter (SQL) - A system to download SAP mature data to TPN local database server.
Corporate Intranet	inhouse	PT TITAN Intranet web, provide corporate matters, department links and publication. Also provide links to another application (Phone Book, Web Mail, HR System for Employee, etc)
Services	inhouse	Admin Service System - Process logistic operation such as vehicle kilometers and petrol entry, telephone usage, laundry, employee meals.
Tracking	inhouse	HSE Related Software - Software for tracking Safety related issue of the company. Such as record any incident report, near miss, sub standard, safety talk performed, inspection walkthrough, ideas/suggestion, emergency drill, housekeeping, HSE Comitte and HSE Audit, Non Conformity Report and Safety Assesment.
Weightbridge System	external	Weightbridge System - A system that validate between real truck load with product weight shows on Delivery Order, in order to deliver finish product to customer.

Pemasangan fingerprint untuk di beberapa site di plant untuk menggantikan reader absensi dengan proximity card, Jumat dan Sabtu 30-31 Juni 2010 (2 hari).

Point safety:
1. Safety induction untuk si pekerja.
2. Pemakaian perlengkapan safety.

a. Glasses

b. Helmet

c. Jaket lengan panjang

d. Safety Shoes

e. Body harness (khusus untuk pemasangan di gate 2)

3. Pembuatan permit berdasarkan tipe pekerjaan.

Deskripsi pekerjaan:
1. Pemasangan fingerprint yang melekat di tembok. Mungkin perlu melakukan pekerjaan bor dinding. Mungkin juga ada pekerjaan pengelasan untuk pemasangan di store.
2. Pemasangan (penarikan) kabel jaringan dari lokasi fingerprint ke hub terdekat.
3. Khusus untuk pemasangan di gate 2, ada pekerjaan di ketinggian +- 4 m di atas permukaan tanah untuk pemasangan koneksi relay.

Lokasi pemasangan:
1. Gate 2
2. Kantin
3. Store
4. Control Building

Note:

- Melihat waktu pekerjaan yang singkat (hanya 2 hari), item safety bisa dipinjam melalui admin secretary (untuk visitor). Untuk pekerjaan lebih lama dapat meminta ke HSE.

- Pekerjaan mengebor dinding memerlukan secondary hot permit. Sedangkan pekerjaan pengelasan/gerinda memerlukan primary hot permit (mungkin ada pekerjaan ini untuk pemasangan fingerprint di store, mengingat konstruksi pintunya yang terbuat dari besi).

- Pekerjaan mengebor dinding perlu konfirmasi pula ke bagian yang mengurus layout bangunan (Maint. Dept.) bila ada kemungkinan di dalam dinding tersebut terdapat instalasi kabel dsb.

- Permit pekerjaan dikeluarkan per area.

- Area gate 2,kantin dan store, permit dikeluarkan oleh Admin Service Dept.

- Area control building, permit dikeluarkan oleh shift supervisor.

Get first day of current year:
SELECT     *
FROM         tbl
WHERE     (tbl.datefield = DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0))

Get last day of current year:
SELECT     *
FROM         tbl
WHERE     DATEADD(dd,-1,DATEADD(yy,0,DATEADD(yy,DATEDIFF(yy,0,getdate())+1,0)))

Get first day of current month:
SELECT     *
FROM         tbl
WHERE     select DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)

Get first day of last month:
SELECT     *
FROM         tbl
WHERE     DATEADD(mm, DATEDIFF(mm,0,DATEADD(mm,-1,getdate())), 0)

Get month part of a datetime field.
DATEPART(MONTH, A.AEDAT)

Get year part of a datetime field.
DATEPART(YEAR, A.AEDAT)

Cast field to char.
CAST(aField AS char(4))

Set 2 digit literal with trailing 0.
RIGHT('0' + RTRIM(MONTH(A.AEDAT)), 2)

Get Date Part Only of Datetime Field
CONVERT(varchar(8), GETDATE(), 112)

Get Time Part Only of Datetime Field
CONVERT(varchar(8), GETDATE(), 108)

Get Yesterday Date

DATEADD(DAY,DATEDIFF(DAY,'20000102',GETDATE()),'20000101')

And many else (from shanecooper.net) 
Monday of the Current Week
select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)
Sunday of the Current Week
set DATEFIRST 1
select DATEADD(dd, 1 - DATEPART(dw, getdate()), getdate())
First Day of the Year
select DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)
First Day of the Quarter
select DATEADD(qq, DATEDIFF(qq,0,getdate()), 0)
Midnight for the Current Day
select DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)
Last Day of Prior Month
select dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()  ), 0))
Last Day of Prior Year
select dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate()  ), 0))
Last Day of Current Month
select dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate()  )+1, 0))
Last Day of Current Year
select dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate()  )+1, 0))
First Monday of the Month
select DATEADD(wk, DATEDIFF(wk,0, dateadd(dd,6-datepart(day,getdate()),getdate()) ), 0)    

Many customized SAP reports run slowly in SAP environment. So we make a bapi to download a mature data and store it on our sql server. The program run as service on the server and run in daily basis. We also profide small application so user can update the data on request.

To install service manually

1. Go to directory in which installutill located (for me, in WINDOWS\Microsoft.NET\Framework\v2.0.50727).
2. Run InstallUtil.exe with your exe as parameter. Enter code below:
   

   installutil abc.exe

To uninstall service manually

• 
  Run InstallUtil.exe with your exe as a parameter. Enter code below:
  
  
  

  installutil /u abc.exe

Error in spool C call: spool overflow
t.code SPAD
menu path: Administration > Clean Spool

Im developing .net application in my local computer. Because we’ll develop it in team, I have to save it in share forlder so any else developer can access. Then come this error when I run the application.

Message=”Request for the permission of type ‘System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089′ failed.”

Its because .net dont trust developer location. Run caspol.exe (in directory C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727) to add developer trust site.
D:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>caspol.exe -pp off -m -ag 1.2 –url file:w:\* FullTrust