How to search content in excel files (without open the files)

Sometimes, we do need to know if we have submitted the particular issue (some word, or numbers) in whole bunches of files. but we can not open the files one by one.
Through Google, a gentleman share his great idea.
I organized by my understanding, and wrote the follow steps:

1) open a file folder

2) click "tool"

 

3) click "folder option"

 

4) click "search", then "always search file names and contents".

5) click "ok".

Now, go to windows explor, click "start", then type the drawing number you're searching for.
See what's happen.

 

 

 

Drawing Scale Changed

One day, you may find the pipeline what you put on which was on grid. but is moved over night. There could be Admin. did something, or... something we don't know. Let's talk about the solution: At first, check the other "good" drawing's scale. Go to View--Property--Grid, then write down the scale number. see the attached picture. Then, go to your drawing which all lines moved. match the scale with the good one.

ORA-00018 maximum number of sessions exceeded

ORA-00018 maximum number of sessions exceeded Cause: All session state objects are in use. Action: Increase the value of the SESSIONS initialization parameter.Reference: Oracle Documentation ORA-00018 comes under "Oracle Database Server Messages". These messages are generated by the Oracle database server when running any Oracle program. How to increase SESSION initialization parameter: 1. Login as sysdba sqlplus / as sysdba 2. Check Current Setting of Parameters sql> show parameter sessions sql> show parameter processes sql> show parameter transactions 3. If you are planning to increase "sessions" parameter you should also plan to increase "processes and "transactions" parameters. A basic formula for determining these parameter values is as follows: processes=x sessions=x*1.1+5 transactions=sessions*1.1 4. These paramters can't be modified in memory. You have to modify the spfile only (scope=spfile) and bounce the instance. sql> alter system set processes=500 scope=spfile; sql> alter system set sessions=555 scope=spfile; sql> alter system set transactions=610 scope=spfile; sql> shutdown abort sql> startup Related Links: ORA-00054: resource busy and acquire with NOWAIT specified http://nimishgarg.blogspot.in/2012/05/ora-00054-resource-busy-and-acquire.html ORA-00020 maximum number of processes exceeded http://nimishgarg.blogspot.in/2012/05/ora-00020-maximum-number-of-processes.html Original Article

OPC text missing the position

There is an interet thing happy since last week.

the "..." control the directiong of the OPC. after I changed it to left. the text missing position.

Put a new one, same thing happed.

Site Server Permition_SPPID Installation

I finished Whole process of SPPID installation. and it works well. but after I shared my remote computer with my co-workers, I found they can not open the drawings.

After asked the master, I know there is one more step need to do: right click your Site Server. then click the permissions. add your co-worker's name on it. then refresh the role in Engineering Manager. It work!

The logic is clear: your co-worker need permission to access the reference files. Otherwise, they only can connect with server but doing nothing.

How to get remote VM's shared files

There're several method:

1. Access to the VM directly.

Type \\ the name of VM\ driver$. you can directly get into the shared folder. of course, you need to know this computer's user name and password.

2. Map the shared folder to your computer, similiar as above. more convinient for next time.

3. From the VM go to the server, for example: \\ca-cab...., you suppose have your personal folder there. then put the VM file there. After that you can get your files from your personal folder.

How to add your co-worker to your VM

Two point:

1. Add their user name to your VM.

(a) my computer--Manage

(b) groups--users--property

(c) add

(d) check the dormin name first, then enter your co-workers user name.

2. Add their user name to remote

(a) Contro Panel--System--Remote

(b) click select remote users

(c) check domin first, then add user name, then check names

Now, you can tell your co-workers to try.