Vinod Kotiya

How To Connect Sony XPLOD MEX-BT2500 Bluetooth CD Receiver with ur mobile

1.Press the “OFF” button,
2. and after the clock or demonstration appears
3. press and hold the “EQ/BLUETOOTH” button. (Assuming Your mobile handsets bluetooth is on)
4.After about 7 seconds the Bluetooth logo will appear, and in your phone (or MP3 player) display you'll see connect to “XPLOD”.
5. If ask password then enter "0000" 4 times zeros
6. Connect the two devices, and you are ready to talk, play music.

-Vinod Kotiya
NTPC Limited
www.vinodkotiya.com

How to copy restricted files (inside desktop and mydoc) from 1 pc to another:


Ø remove simple file sharing from Folder Options

Ø right click folder > security > permission give full permission to Everyone



in permission entries only Everyone should remain



Ø go to owner > check mark Replace Owner and apply


Done



-Vinod Kotiya
NTPC Limited
www.vinodkotiya.com

Oneway traffic problem in server2003


Solution-1

When server is able to ping everybody but no one can ping the server.

To solve change firewall policy of antivirus:





Click desired ip range NIC and click edit.






To add new exception list click add.




Select both inbound outbound and save.



Now it works.




Solution2:



If ISA is running then it may block certain IP's to ping the server:







This may include NTPC WAN range.


Similarly to Access from 10. series network do this



-Vinod Kotiya
NTPC Limited
www.vinodkotiya.com

F-47 Advance Down Payment & Settlement



After release of Misc Service PO / Purchase Document

(Click to enlarge images)

Run F-47


Document no shall be generated automatically when Click New ITEM



DON’T FILL ANYTHING ACCEPT 3 ITEMS AND CLICK SAVE. Enter PO no in assignment






NO NEED TO FILL TAX CODE… PRESS ENTER





ONLY FILL REASON CODE: 309 MISCLANEOUS and save



Errors






Settlement of Advance



For settlement of advane run MIR7 and follow procedure for park incoming invoice.


And specifically mention that this is not for payment.


Send the document no generated to F&A


- Vinod Kotiya
www.vinodkotiya.com

Invoice Parking

MIR7

Enter PO No. and Adopt





Rounded Rectangular Callout: 1) Press this to enter PO lines as aboveRounded Rectangular Callout: 2) After entering PO No. and line No. Press Adopt Button





Check Final Invoice should be as per PO

Click Account Assignment







In Account Assignment window as above



Fill amount and click Check

Click Back and Simulate.





Now your Invoice is ready for Parking if Green Light is coming.





Rounded Rectangular Callout: 5) Paste the qty here in ‘PO reference’ Tab as mentioned in step 4.









-Vinod Kotiya

Preparing MB Service Entry Sheet
(Click images to enlarge)
Step 1 Create SES ( ML81N)

1 & 2 Enter RA Bill No. & invoice no in external no

3 Click services to get B0Q items


4 Select PO




5 Select Service from line

6 Click Services




6 & 7 enter quantities

8. Click green flag

9. Save



Step 2 Print SES

Now Print service entry Sheet (ZMM022)



Step 3 (EIC) Release

Get it Release from EIC (ML85) or ( ML81N)

ML81N Process

Click other purchase order and enter service entry sheet no




Click on Change



Click on Green Flag to affect release


Click on Save.


Step 4 (EIC) Park Invoice

Go for Parking Invoice(MIR7).

Enter SES no to Adopt : Read Park Invoice Documentation for Details.



- Vinod Kotiya

Remote login for Limited account user:



Goto control panel>admin tool>local policy



Add Everyone in following setting








- Vinod Kotiya

Windows uses 20% of your bandwidth! Get it back, Also Turn Automatic windows update OFF


1. Turn Automatic windows update OFF

Just Disable Automatic Windows Update
The default setting in Windows XP is to have XP scan for updates automatically. If you follow a specific routine for your updates or if your connection doesn’t effectively support having this feature run automatically, disable it as follows:

Goto[Control Panel]->[Performance and Maintenance]->[System]->select [Automatic Updates]



2. Increase Net speed by 20%

A nice little tweak for XP. M*crosoft reserve 20% of your available bandwidth for their own purposes (suspect for updates and interrogating your machine etc..)

Here's how to get it back:

Click Start-->Run-->type "gpedit.msc" without the " (or alt+ctrl+delete then new task)

This opens the group policy editor. Then go to:

Local Computer Policy-->Computer Configuration-->Administrative Templates-->Network-->QOS Packet Scheduler-->Limit …

How To Migrate IFAS Data to ERP Template:

By: Vinod Kotiya Engineer(IT) and Ravi Kiran (Xcel Software)

1 create a blank access file

2 from file> import data

import payroll/pay0407\run\ codemas>code407.dbf and create a table
import totpay>totalpay.dbf and create a table add new field codename

3 create blank table with inlk fields

4 fill the codename field in tot407 table using following query(codequr)

UPDATE TOT407, code407 SET TOT407.codename = code407.name
WHERE CODE407.CODE=tot407.code;

5. make the net ammount using pay_tag of totpay407. query(update_paytag)

UPDATE tot407 SET amt = -1*amt
WHERE left(pay_tag,1)='2';


6 fetch the inlk_raw_data from pivoting empno query(inlk_raw_data_fill) in tot407 table

SELECT empno, sum(IIf(code='000',amt,0)) AS amt0, sum(IIf(code='001',amt,0)) AS amt1, sum(IIf(code='002',amt,0)) AS amt2, sum(IIf(code='003',amt,0)) AS amt3, sum(IIf(code='004',amt,0)) AS amt4, sum(IIf(code='005',amt,0)) AS a…

Enable / Disable TaskManager, Registry Editor, Folder Options in Windows XP

TaskManager.

Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Windows\CurrentVersion\Policies\System
Name: DisableTaskMgr
Type: REG_DWORD
Value: 1=Enablethis key, that is DISABLE TaskManager
Value: 0=Disablethis key, that is Don't Disable, Enable TaskManager

Click Start Click Run Enter gpedit.msc in the Open box and click OK
In the Group Policy settings window
Select User Configuration Select Administrative Templates Select System
Select Ctrl+Alt+Delete options
Select Remove Task Manager
Double-click the Remove Task Manager option
And as I mentioned above, since the policy is Remove Task Manager, by disabling the policy, you are enabling the Task Manager.

Registry Editor
) Just type following in RUN dialog box and press :

REG add HKCU\Software\Microsoft\Windows\CurrentVersion\Policies\System /v DisableRegistryTools /t REG_DWORD /d 0 /f

Type gpedit.msc in RUN dialog box and goto:

User Configuration -> Administrat…

How to configure Hughes DirecWay Router

1. connect new router to your laptop.
2. open tcp/ip setting and set it to autometically obtain ip address and leave the dns info as such
3. open "telnet 192.168.0.1 1953"
4. type b to see all properties of broadband (caution backspace doesnot work here)
5. rf is used to clear all settings
6. z is used to close the connection to host(router)
7. a is used to enter new settings
8. pw is used to save the settingssss

Main Menu:
(a) Configure Boot Parameters
(b) Display Current Configuration
(c) Display Satellite Interface Statistics
(d) Display Active Routing Table
(f) Run Software Download Monitor
(h) Display Reset History
(i) Installation

(pc) (Parameter Clear) Clear Configuration
(pw) (Parameter Write) Write Configuration
(rr) (Gateway Reset) Reset the Gateway
(rd) (Gateway Deconfigure) Force Download and Acquire New Keys
(z) Logout


LPHPP Settings


Fallback.bin Creation Date [Release #]: Jan 8 2008, 13:05:16 [5.8.0.10]
Curre…

Routing When Server is connected to 2 WAN


Server is having 2 ethernets

1. Lohari 191.254.186.1/255.255.255.0 GW 191.254.186.17
2. Broadband 10.6.56.66/255.255.255.240 GW 10.6.56.65 DNS 202.168.34.18
If there is a http request from 191.254.187.1 then server wont send the packet however respond to ping reply.

Solution:












Now I will add the 191.254.187.* network in static route so that 191.254.186.1 can know on which gateway to send packet.







Not tested. but if works than cover complete NTPC WAN.













Adding Static Routes using batch file netsh Command:

netsh routing ip add persistentroute 10.0.0.0 255.255.255.0 "Lohari" 191.254.186.17
netsh routing ip add persistentroute 191.254.0.0 255.255.0.0 "Lohari" 191.254.186.17
netsh routing ip add persistentroute 10.1.0.0 255.255.0.0 "Lohari" 191.254.186.17
netsh routing ip add persistentroute 10.6.0.0 255.255.0.0 "Broadband Uper NIC" 10.6.56.65

netsh routing ip show persistentroutes




-Vinod K.

--
Vinod Kotiya
NTPC Limited
09411103810
www.vinodkotiya.com

"Vanity...
is Definately my favorite Sin...."

*****************************************
HOW TO SETUP ASPX INTRANET
*****************************************

install MDAC
install .net framework

control panel> add windows component>
check application server>details>check mark everything > detail of IIS >
check mark everything (specially frntpage extension)

back

check indexing service
check .net framework 2.0
check networking service

insert server 2003 cd1 and cd2 while installation

open IIS

right click websites>create new

description> LPHPP
path> e:\intranet directory
ip address > 191.254.186.1
give permission 4 all> read write execute etc

for ms access database
open the folder choose > tools > folder option>disable simple file sharing
right click on (*.mdb file and choose security
give full control to iis_username(internet admin)

for uploading file to virtual directory
right click on folder> choose security
give full access for write permission

use browser http://191.254.186.1

if page under construction err…

IT Systems Design For Hydro ProjectsVinod Kotiya, Er.(IT)Any of the big projects like Loharinag-Pala Hydro Power Project (LPHPP) needs a secure and reliable means of communication for all project executives, contractors, consultants, and vendors to freely share project information from diverse locations while maintaining security and integrity.Most of us would be agree on this that at the initial phase of each project communication systems and basic infrastructure must be on top priority. Having an efficient and aggressive project plan for communication network will provide maximum teamwork and team interaction which results in lowered development costs and saved project time, thereby reducing the time to complete the project.Design of IT and communication system should be in following manner:Requirement:
Design and implement the requirements and efficient way for all executives involved in the project to communicate and collaborate. Solution:
Design and engineering Infor…