Personal Folder

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

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

Helpdesk question of the day:
=CHOOSE(WEEKDAY(A1),"Minggu","Senin","Selasa","Rabu","Kamis","Jumat","Sabtu")

          LSMW will produce error if text data transported have carriage return character. We have to replace it with another character. But, how to search that character on text. I’m using ms excell to search and replace the character. On the search/replace window, hold down alt and type 013, release alt key. Carriage return key will be found/replaced. For line feeds character, type 010.
In excell, long text with carriage return will go across the screen. To view them as multiple line, go to Format Cells menu, tab Alignment, tick the Wrap text check box.

Professional appearence with traditional skill.. hehehe…

Daily job, annoying sometimes (when it goes wrong).

1. Gate checking, at 08:00 and 16:00.

Common problem are:

• RPU disconnect. Handled by restart esofgate service.
• IP disconnect (since we manage two different gates on Merak and Jakarta). Handled by telnet to port 9999 and restart connection.
• Time dis-synchronized. Handled by sending time parameter to all reader.

Has to check twice a day, because if there is problem, we have to be found it early since esofgate hardware memory only store 3000 absent data.


2. Daily Absent Process and Daily Tracking Notification

Daily Absent Process Application is pre-processed raw data from gate so it can be user friendly report (user can monitor their entry to and leave from plant via intranet application). While Daily Tracking Notification Application is sending automatic email notification for outstanding tracking job. Both are massively using database operation. And sometimes the operation fail because of deadlocks, so we have to run it manually.


3. Canteen Sceduler

Data from canteen reader build a .RAW file per day, and has to be pre-processed to send it to database. If it not run normally, we have to run it manually by selecting proper RAW file.

Batch copying and compressing of MSSQL backup file from S10 to S4 server has been succeed. I think it is o.k. with my batch programming in this session.

I need to compress .bak backup MSSQL database file and copy to another server weekly. One option of doing it is using batch command and run it by scheduler.

This batch programming below is capture current year month, and compressing file based on file name (the filename has month description in itself).
-------------
::Display command at screen
echo on
::variable definition
set yyyy=none
set mm=none
set yyyymm=none
::take year and month parameter
for /F "tokens=2 delims=/ " %%i in ('date /t') do set mm=%%i
for /F "tokens=3 delims=/ " %%i in ('date /t') do set yyyy=%%i
::fill year month parameter
set yyyymm=%yyyy%%mm%
::looping at criterialysized file list at directory (by year month) and creating compressed 7z file

set source=D:\BackUp
pushd "%source%"
for /f "skip=1 delims=" %%z in (' dir /b *%yyyymm%*.bak') do 7z a Z:\backup%yyyymm%.7z "%%z"
popd

Todays job is uploading PO that has been already GR by store. How come doing Good Receipt without PO? Hehehe.. this early phase of SAP implementation is not perfect yet, we have to do 'back door' things to keep the plant running and money in balance.

Meanwhile, our Sales and Distribution key users and IT who guard this module is in holiday (ups, it is me who take the job on Saturday). Warehouse and sales team start asking about Sales Quotation, Sales Order, Delivery, Credit Limit Check, Finish Goods Stock Balance, Consignment, etc etc.... Gotta hardly remember SD things one year past.

Dear Team, We need your fully support  since period is open today (1 month late ) and very tight target (only 2 days). The real problem usually occur on first posting activities.
Pak Ezal, please standby for Transport Request from us.
Pak Joko/Pak Hilal/Pak Farid, please come to Curug on Thursday & Friday (6-7 August) and assist the user to post transactions.
Thank you for your valuable support.
Thanks & regard

----------

First SAP open period for our newly joined company…………. &%$*&$%^$#

Test posting from Windows Live Writer.

Our IT department have few candidates to join to our company. Generally there are three selection steps for those candidates to be accepted. First are general and professional knowledge. At this step candidates will do a written exam, testing their general logic and intelligence, professional knowledge in IT matters, and English proficiency. The second test, which I am managed to be attended, is interview. Representative from IT department will have a discussion with candidates about his/her ‘real’ skill and personality. Hopefully this spoken test can get some point that didn’t grabbed at the first written step. The interviewer have a list of elements need to be scored for the candidate, there are: candidate appearance, self confidence, job relevancy, communication, intelligence, problem solving, initiative, ambition, tendency to stay, special condition, etc. Any candidate look superior to company requirements, he/she will soon meet the general manager, since employee recruitment need big boss approval. The last test is physical test. It has been a common secret the one that announced go to this step will be accepted as a new employee. Unless he has a serious illness that make him fail for the physical test of course.