topic Re: Batch error ? in QlikView

Batch error ?

Wed, 14 Sep 2016 03:42:27 GMT

HI All,

I am getting this message in Batch log file..

Does E:\Qlikview\Sales specify a file name

or directory name on the target

(F = file, D = directory)?

Files are not copying..

Kindly help me on this..

Regards,

Helen

Re: Batch error ?

Anil_Babu_Samineni — Wed, 14 Sep 2016 04:14:29 GMT

Would you provide more information

Hope this helps

Batch file script to reload Qlikview Applications

Re: Batch error ?

Wed, 14 Sep 2016 04:44:01 GMT

Batch Script:

echo "--------------------" >> "D:\QV\Daily_Sales.txt"

Xcopy "D:\QV\Customer.qvd" "E:\QV\Sales" /s /i /y

Xcopy "D:\QV\Hier.qvd" "E:\QV\Sales" /s /i /y

nnn files added

nnn files replaced

no file added

no file replaced

this is my script.

Getting this message in Log file.

Does E:\Qlikview\Sales specify a file name

or directory name on the target

(F = file, D = directory)?

Regards,

Helen

Re: Batch error ?

trdandamudi — Wed, 14 Sep 2016 05:03:52 GMT

It looks like the destination folder "Sales" does not exist in 'E:\QV\' path. Can you confirm that ?

Also when you get that error your can just press 'D', so that it will automatically creates that folder for you. Hope this helps...

Re: Batch error ?

trdandamudi — Wed, 14 Sep 2016 05:12:53 GMT

The script you posted is the complete script ? because the line

"Does E:\Qlikview\Sales specify a file name " that you posted is not part of the script that I am seeing. This line is pointing to the 'Sales' folder under 'Qlikview' folder. So in this case either you do not have the folder 'Sales' or you do not have the folder 'Qlikview' and 'Sales'.

Re: Batch error ?

Anil_Babu_Samineni — Wed, 14 Sep 2016 05:15:03 GMT

Have you follow which i've sent it to you.

Re: Batch error ?

Wed, 14 Sep 2016 05:16:23 GMT

Batch Script:

echo "--------------------" >> "E:\QV\Sales\Daily_Sales.txt"

Xcopy "D:\QV\Customer.qvd" "E:\QV\Sales" /s /i /y

Xcopy "D:\QV\Hier.qvd" "E:\QV\Sales" /s /i /y

nnn files added

nnn files replaced

no file added

no file replaced

this is my script.

Getting this message in Log file.

Does E:\QV\Sales specify a file name

or directory name on the target

(F = file, D = directory)?

Regards,

Helen

Batch error ?

Re: Batch error ?

trdandamudi — Wed, 14 Sep 2016 05:20:59 GMT

Ok. Do you have a valid 'E:\QV\Sales' folder? I think that it what you are missing...

Note: How are you executing this script on DOS prompt or within Qlikview ?

Re: Batch error ?

Anil_Babu_Samineni — Wed, 14 Sep 2016 05:23:25 GMT

What is this Mean?

echo "--------------------" >> "E:\QV\Sales\Daily_Sales.txt"

SET vPath = 'E:\QV\Sales\Daily_Sales.txt'

TRACE "-----------"

TRACE >>

Trace $(vPath)

Re: Batch error ?

Wed, 14 Sep 2016 05:35:45 GMT

here my concern is to just copy qvds from one place to other..

Can you provide the script once you test in your system.

Because i am unable to copy the files..

Regards,

Helen

Re: Batch error ?

stabben23 — Wed, 14 Sep 2016 05:39:44 GMT

Hi Helen,

if E is a network disc use the Whole searchway like \\fileshare\QV\Sales\Daily_Sales.txt

Re: Batch error ?

sasikanth — Wed, 14 Sep 2016 06:26:12 GMT

HI,

Try this

@ ECHO OFF

SET IP_Path=D:\QV

SET OP_Path=E:\QV\Sales

SET date=%date:~10,4%-%date:~7,2%-%date:~4,2%

SET hr=%time:~0,2%.%time:~3,2%.%time:~6%

copy /v "%IP_Path%\Customer.qvd" "%OP_Path%\Customer_%date%_%hr%.qvd"

Hope it helps you..

Re: Batch error ?

marcus_sommer — Wed, 14 Sep 2016 06:34:07 GMT

Could it be that your statement is missing a specified filename like:

Xcopy "D:\QV\Customer.qvd" "E:\QV\Sales\Customer.qvd" /s /i /y

Xcopy "D:\QV\Hier.qvd" "E:\QV\Sales\Hier.qvd" /s /i /y

- Marcus

Re: Batch error ?

Wed, 14 Sep 2016 06:46:24 GMT

Thanks Sasi

Its working..but i need to create the log as well,

how many files are copied, on date & time

Regards,

Helen

Re: Batch error ?

sasikanth — Wed, 14 Sep 2016 06:53:54 GMT

hi,

You can check windows log files for this , please refer the below link

Create list/TEXT file of copied files after copying Batch Command - Stack Overflow

Log For xcopy batch file

Thanks,

Re: Batch error ?

marcus_sommer — Wed, 14 Sep 2016 06:59:01 GMT

I wouldn't use xcopy if I had to manage larger amounts of copying/moving/deleting tasks or to ensure a stable logging of them. I would use vbs-macros or Robocopy - Wikipedia, the free encyclopedia.

- Marcus

Re: Batch error ?

Wed, 14 Sep 2016 07:33:12 GMT

When i am using the above script am getting msg like this ?

Does D:\QV specify a file name

or directory name on the target

(F = file, D = directory)?

how to resolve this ?

Regards,

Helen

Re: Batch error ?

jonathandienst — Wed, 14 Sep 2016 07:46:03 GMT

This is a Windows batch message, not a QV message. I believe the earlier postings explain why - XCopy expects a file name or file mask and sees the path you supply as ambiguous. If you check out the xcopy help, you should be able to suppress this message. But I agree with Marcus about using Robocopy or script instead of xcopy.