Open and Reading the file

[srujana]

Delta,

 I have placed following files in C:\log

 123.xml
 123.pdf

The XML code is as below:

 <?xml version="1.0" encoding="utf-8" ?>
- <!--   Copyright (C) 2006 Cognos Incorporated.  All Rights Reserved.
  Cognos (R) is a trademark of Cognos Incorporated.

  -->
- <!--   Experimental.
  Product features described in this file may not be supported in future releases.

  -->
- <outputDescriptor xmlns="http://developer.cognos.com/schema/OutputDescriptor/1.0" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <asOfTime>2007-08-12T13:38:08.093Z</asOfTime>
  <burstKey />
  <contact />
  <defaultDescription />
  <defaultName>2007-08-12T13:38:09.078Z</defaultName>
  <fileName>1376_1186940289078.pdf</fileName>
  <locale>en-us</locale>
  <owner>rgajendra</owner>
  <ownerNamespace>COGNOS-DEV Team</ownerNamespace>
  <parameterValues />
  <reportSearchPath>/content/package[@name='Provider']/report[@name='PRV-INT-001:Provider NCPDP Interface Error Report']</reportSearchPath>
  <reportViewSearchPath>/content/folder[@name='COGNOS-DEV Team']/reportView[@name='Report View of PRV-INT-001:Provider NCPDP Interface Error Report']</reportViewSearchPath>
  </outputDescriptor>

The name the PDF is to be changed to is:

PRV-INT-001:Provider NCPDP Interface Error Report.

The ' ' on either side of the name would never change.

Thanks...

[DeltaSlaya]

Will the line always be on 21 or will it be the only line that has a @name OR 'reportsearchpath' on it, or both? And are there always FOUR ' on that line?

[srujana]

It will be the only line which has @name in it, which is second in the order.

[DeltaSlaya]

Ok will it also be the only line with "reportSearchPath" on it, because that would be easier to find.

[srujana]

Yes.

[DeltaSlaya]

Filenames cannot contain ":". Thats why the batch wasn't working.

[srujana]

Oh..k so is there no other alternative?

[DeltaSlaya]

Yes I can change the : to an alternative character before the file is renamed, what would you like unusable characters to be altered to? The unusable characters are: "\ / : ? " < > |" but "< > |" will cause the batch file to crash anyway.

[srujana]

Can you change the character to '-' (hiphen)

[DeltaSlaya]

Yes. What of those characters may be present? Just the :?

[DeltaSlaya]

@echo off

:: Change "C:\OUTPUT" to output directory with NO "\" at end.
set outdir=C:\OUTPUT
if not exist "%outdir%" (
   echo Output folder not exist.
   pause >nul
   exit
)

:: Change "C:\" to input directory with "\" at end.
cd C:\

cls

set input=

:: Check for xmls
if not exist "*.xml" (
   echo No .xml files.
   pause >nul
   exit
)

:: Set input to last modified .xml in dir
   for /f "usebackq delims=" %%I in (`dir /b /a:-d /o:-d *.xml`) do (
   set input=%%~nI
   goto out
)

:out

:: Grab 'actual' name of pdf from xml
set output=

for /f "usebackq tokens=4 delims='" %%I in (`findstr /i "reportSearchPath" "%input%.xml"`) do (
   set output=%%I
   goto copy
)

:copy
set output=%output::=-%
copy "%input%.pdf" "%outdir%\%output%.pdf"
pause

There you go.. Don't forget to change the input and output folders according to the information.

[srujana]

Hey! this is the output, it still seems to consider the XML name and not the name inside it...


C:\log>set input=

C:\log>if not exist "*.xml" (
echo No .xml files.
 pause  1>nul
 exit
)

C:\log>for /F "usebackq delims=" %I in (`dir /b /a:-d /o:-d *.xml`) do (
set input=%~nI
 goto out
)

C:\log>(
set input=123
 goto out
)

C:\log>set output=

C:\log>for /F "usebackq tokens=4 delims='" %I in (`findstr /i "reportSearchPath
 "123.xml"`) do (
set output=%I
 goto copy
)

C:\log>set output=:=-

C:\log>copy "123.pdf" "D:\:=-.pdf"
The filename, directory name, or volume label syntax is incorrect.
        0 file(s) copied.

C:\log>pause
Press any key to continue . . .

C:\log>

[DeltaSlaya]

Hmmm, that works for me, are you sure the line format is the same as this?

"<reportSearchPath>/content/package[@name='Provider']/report[@name='PRV-INT-001:Provider NCPDP Interface Error Report']</reportSearchPath>"

Try replacting the "reportSearchPath" for "@name" in the second for statement.

[srujana]

Hey! it still doesnt work

[ghostdog74]

Ghostdog, I made the modifications accordingly and only then tried executing the VBS file. But, nothing seems to be happening.

show me your version of the vb script. Also, don't just say not happening. describe in more detail. does it mean you did not see the changed file? or it does change but not to your specs?  for me it works.