1.

Solve : Enter into network?

Answer»

Hi folks,

Actually I am trying to create a form for the front end user.
But saving the data entered at the back end.

But, as we know that dos cannot enter the file on network

Do we have any work around?


echo off
color f0
echo **********this is a form for all the users*************

:1
Echo please enter the following details

set /p "cust_name= Pleaser enter customer name : "
set /p "ph_no= Pleaser enter Phone number     : "
set /p "printer= Pleaser enter Printer       : "
set /p "st= Pleaser enter Service ticket   : "
set /p "lead= Pleaser enter lead number       : "


echo %cust_name%
echo %ph_no%
echo %printer%
echo %st%
echo %lead%



echo %cust_name%>>c:\banner\track.xls   %ph_no%>>track.xls   %printer%>>track.xls   %st%>>track.xls   

%lead%>>track.xls

Echo
:mo
set /p "mo= Do you want to add more details? y or n"
if not defined mo GOTO :mo
if "%mo%"=="y" goto :1 else EOF:



Thanks and regards Quote

But, as we know that dos cannot enter the file on network

Could you explain more. Maybe I'm missing something, but where is the network file?

Quote
echo %cust_name%>>c:\banner\track.xls   %ph_no%>>track.xls   %printer%>>track.xls   %st%>>track.xls   

%lead%>>track.xls

Batch code cannot add records to an Excel spreadsheet file. You could create a Comma Separated Values file which can be imported into Excel.

Code: [Select]echo %cust_name%,%ph_no%,%printer%,%st%,%lead%>>c:\banner\track.csv

 
I can enter the details on the  Excel file.

I would like to enter the data on home drive that is on network like.


\\hphome\vishu

This is a network driver

but, Dos is not able to enter the file on network and gives error. Quote
but, Dos is not able to enter the file on network and gives error.

What error? Posting the error will save me time trying to guess it.

You keep REFERRING to "DOS" but there is no "DOS" on Windows XP. Are you referring to the NT command prompt?

You could try mapping the network drive to your local machine: net use N: \\hphome\vishu You would then refer to your file as n:\banner\track.xls Note: the letter N was arbitrary; chose any unused letter you want.

You can also use the UNC notation and refer to your file as: \\hphome\vishu\banner\track.xls

As previously mentioned, you cannot use batch code to update an Excel spreadsheet.

Good luck. Thanks for the reply.

But, it is not working.

Is there any way that I can enter on the network path.

So, that I can save my output file

The syntax of this command is:


NET USE
[devicename | *] [\\computername\sharename[\volume] [password | *]]
        [/USER:[domainname\]username]
        [/USER:[dotted domain name\]username]
        [/USER:[[email protected] domain name]
        [/SMARTCARD]
        [/SAVECRED]
        [[/DELETE] | [/PERSISTENT:{YES | NO}]]

NET USE {devicename | *} [password | *] /HOME

NET USE [/PERSISTENT:{YES | NO}]


I am getting this message  while I done that.

Something may be missing. Please help...

Help appreciated..

Regards

VishuActually I am trying to make a user end dos file. That will save the data on the network.

Network has a dedicated space. It is not the shared COMPUTER.

It is little bit peculiar.

But, I know since we can open drive from computer means in windows XP.
So, we should be able to open it from dos.

Cause dos is the basic unit of the computer. It can do most of the thing so, I hope it can do this as well.

I want to see

\\vishu\vishal

instead of

c:>documents and users\vishu\desktop>

I know we do have lots of expert on dos.

I hope I will get the answer.

And I also  want to save my output file on the network.


Thanks and regards

VishuYou still haven't posted the error message.

If you want to put the batch file output on the network, you can you use this:

Code: [Select]echo %cust_name%,%ph_no%,%printer%,%st%,%lead%>>\\vishul\vishal\banner\track.csv

The banner directory must exist on the network drive.

OR

If you want to put the batch file output on the network, you can you use this:

Code: [Select]net use N: \\vishu\vishal
echo %cust_name%,%ph_no%,%printer%,%st%,%lead%>>n:\banner\track.csv

The banner directory must exist on the network drive.

You cannot use the UNC path as the current directory, but you can use a drive letter that has been mapped.

This could be a permissions problem but you need to be more responsive to my requests for information. 

 Sir, I am not able to get inside the path.

Actually it is

\\10.120.3.50

Getting error  System error 1909 has occurred

The referenced account is currently locked out and may not be logged on to.

So, I hope bad luck?


THANK you for the replie

vishu
The account you are trying to log in with is locked,  you will need to go to the machine authenticating users to \\10.120.3.50 and then unlock your user account.

Then go into the settings for the share you are trying to access and make sure that your account has permission to read and write to the share name (I''m guessing in your case it's called 'vishal'

Depending upon the OS of the machine, there maybe at least 2 spots you need to change. One is the 'share permissions' and the other is the 'folder/file' permissions.

I would suggest temporarily granting full access to everyone to the share until you get it working, then you can lock down the security to only your own account later.Thanks for the reply.

I have access to read and write.

As I can create any file on the network drive.

I can copy and paste anything.

Actually working on comp

Don't want to reveal the name completely and even network path name.

it's like

\\10.120.3.50\user mail\agent access\

It is not the correct path but it is like this only.

I can enter text word excel zip file in it. Can modify also. I have access.
But, I am not able to enter anything using DOS window.

I have this form that saves the file on my computer but not on path.

What can I do???

Thanks for the information.


echo off
color f0
echo **********this is a form for all the users*************

:1
Echo please enter the following details

set /p "cust_name= Pleaser enter customer name : "
set /p "ph_no= Pleaser enter Phone number     : "
set /p "printer= Pleaser enter Printer       : "
set /p "st= Pleaser enter Service ticket   : "
set /p "lead= Pleaser enter lead number       : "


echo %cust_name%
echo %ph_no%
echo %printer%
echo %st%
echo %lead%


cd\

echo %cust_name%,%ph_no%,%printer%,%st%,%lead%>>\\10.120.3.50\agent mail\agent access\track.csv

:mo
set /p "mo= Do you want to add more details? y or n"
if not defined mo goto :mo
if "%mo%"=="y" goto :1
else EOF:
Make sure you include your path name in quotes if the files have spaces

echo %cust_name%,%ph_no%,%printer%,%st%,%lead%>>"\\10.120.3.50\agent mail\agent access\track.csv"

or try

echo %cust_name%,%ph_no%,%printer%,%st%,%lead%>>%TEMP%\track.csv
copy %TEMP%\track.csv  "\\10.120.3.50\agent mail\agent access\track.csv" 


You are 


Thank you so much. I have also clicked on thanks to you.

you can see it increasing.


You are dude man!!!!!!!!!!!!

A thousand of raise to you.

Thank you so much.

I don't know how to thank you.

Really thank you.


Thank you thank you.
Thank you thank you.
Thank you thank you.
Thank you thank you.
Thank you thank you.
Thank you thank you.


I know we have masterminds on this forum.

And also thank you other dudes who given replies.

hat off
or
head off.



Thanks and regards
VishuYou're very welcomeThere is a little problem in excel format

I want to add the format like

Name then next cell phone no and next cell and id etc.
All I want to add it into next cell. But datas are entered in single cell. So, how can I avoid it?FIGURED it.

Tab will help.


Discussion

No Comment Found

Related InterviewSolutions