Posts

Showing posts from 2009

Advertisement.

TransHimalaya.in

Everest Helicopter Tour for a day

Book exciting packages at www.transhimalaya.in

Turn drag-and-drop editing on or off in office 2007

Image
Turn drag-and-drop editing on or off in office 2007

In office 2003 there was a by default feature available to drag and drop cell in columns. you highlight cell then place the cursor in the lower right corner of the originating cell until it turns into a black plus sign (note the lower right corner has a small black square in it- move pointer or drag pointer) then drag down the column it will do what you want.

This feature is not turned on by default in office 2007.

So how to make it turned on:

in office 2007 click on top left office buton > choose excel option in bottom

Now go to advanced > Edit options
from here you can Turn drag-and-drop editing on or off in office 2007 as shown in figure.


By
Vinod Kotiya

Dayara Bugyal, Uttarkashi

Dayara Bugyal (28 kms) : Bugyal or a "high altitude meadow" at an altitude of 3048 metres affords awe-inspiring view of the Himalayas. There is also a small lake here. The road to Dayara Bugyal branches off near Bhatwari(NTPC LPHPP Office), 28 kms from Uttarkashi on Gangotri road. Vehicles can go up to Barsu village, from where one has to trek.The trek itself is about 8 km and reaches an altitude of about 10,000 feet. During winters the almost 28 sq km of gradual slopes make the place ideal for skiing. Those intending to stay on will have to arrange for tents, sleeping bags.

Here are the pics:

Link: http://picasaweb.google.co.in/vinodkotiya/DayaraBugyal?feat=directlink

Slide show



Few Videos:









- Vinod Kotiya
Image
This is the Enigma Silence Must Be Heard
Video uploaded by me:

Link: http://www.youtube.com/watch?v=2BAR248VRG0



Lyrics:

Look into the others eyes, many frustrations
Read between the lines, no words just vibrations
Don't ignore hidden desires
Pay attention, you're playing with fire
Silence must be heard, noise should be observed
The time has come to learn, that silence ...
Silence must be heard
Or diamonds will burn, friendly cards will turn
Cause silence has the right to be heard
People talk too much for what they have to say
Words without a meaning, just fading away
Silence must be heard, noise should be observed
The time has come to learn, that silence ...
diamonds will burn, friendly cards will turn
Cause silence has the right to be heard

--
www.vinodkotiya.com
http://vinodkotiya.blogspot.com
cell: +919411103810 Category: Music

Hit Counter in Blog / Website

Image
Hit Counter in Blog / Website

How to show no of visitors on your blog/website:

1. Create an account in third party site like www.easycounter.com to keep track of your visitors.
2. Copy the URL from counter site to paste on your blog / website.
3. In your blog go to Edit HTML in your Edit Template section.
4. Paste the code as shown in figure and save.


so whenever visitors open your webpages the code fetch the counter result and show it.
-vinod kotiya

Open multiple home page in mozilla

How to Open multiple home page in mozilla firefox

do this

open tools > options > main > home page

and seperate all site entries with pipe (|)

eg

http://www.google.co.in/ | www.gmail.com | http://pinxart.blogspot.com/

In google chrome it has inbuilt option to do this.

done...

- Vinod Kotiya
www.vinodkotiya.com

Secure your wireless network in easy step.

Image
Secure your wireless network in easy step.

Nowadays everybody has broadband internet
connection through wi-fi modem at their home and offices.
If you dont want to provide unauthorize access of your network to strangers then
do these simple settings in your wireless modem. You must change default settings of
your modem cause everybody knows it.

1. open your modem in browser like 192.168.1.1 give userid and password.

2. go to LAN setting and change whatever default ip from 192.168.1.1 to newer one like 10.6.6.1 save and reboot the modem
now your pc/lappy got new IP

3. now go to wireless settings and change SSID from default to newer one like "VIN"

4. now go to security and change WEP Encryption to Enabled

5. current network key to 1

6. enter 13 digit network key like 123456789abcd and save

7. now again search for new network in your laptop

8. it will ask 13 digit key when click on connecting.


-Done

Vinod Kotiya

IGNOU OPENMAT MBA HALL Ticket

IGNOU OPENMAT MBA HALL Ticket generally comes very late and the online hallticket appears at ignou website before 4-5 days . I found the link for Openmat XXV and just replaced the number 24 with 25 to get the link . However I did not get the same result this time. I would suggest you to wait for few days and try this method of replacing 25 by 26 everywhere

http://stuinfonew.ignou.ac.in/OM25/OpenMatHall25.asp

for MBA Openmat XXVI august2009 it may be
http://stuinfonew.ignou.ac.in/OM26/OpenMatHall26.asp

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

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)

Image
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

Image
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

SAP transaction F-47 Advance Payment

Image
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

SAP Transaction MIR7 Park Invoice

Image
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

SAP Transaction ML81 SES

Image
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

Image
Remote login for Limited account user:



Goto control panel>admin tool>local policy



Add Everyone in following setting








- Vinod Kotiya

Increase Net speed by 20%

Image
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 …

Migrate IFAS Data to ERP Template

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…

TaskManager, Registry Editor, Folder Options in XP

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…

configure Hughes DirecWay Router

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

Image
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.

cache problem in ISA2006

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

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

.Net ASPX INTRANET

*****************************************
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 Projects

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…

Blog History - Archive 1000+ post

Show more

Google+ Followers