0 Replies Latest reply: Jan 31, 2012 6:39 AM by Jorge Torraorebocho RSS

    Traffic lights not rendered in PDF



      I'm facing an issue with the rendering of traffic lights in a PDF file: they are not displayed.


      I'm running QV 9 SR4 64bit and I put together the following process:

      - windows task scheduler runs below batch file weekly on the server:

      "C:\Program Files\QlikView\Qv.exe" /l /NoSecurity "D:\QlikView\src\dev\ppm\qvw\ISE PMO Project Status PDF v_1.0.qvw"

      - this QVW has post reload trigger which runs below macro


      Sub Create_PMO_PDF


      set V=ActiveDocument.Fields("PROJECTNAME").GetPossibleValues
      set V2=ActiveDocument.Fields("SENDEMAILCMD").GetPossibleValues

      sFile = "D:\QlikView\src\dev\PPM\cmd\PMOSendEmail.bat"


      Set oFSO = CreateObject("Scripting.FileSystemObject")


      If oFSO.FileExists (sFile) Then oFSO.deletefile (sFile) End If
      Set oFile = oFSO.CreateTextFile(sFile)



      For i=0 to V.count-1
      n = V.Item(i).Text
      n2 = V2.Item(i).Text


      ActiveDocument.Fields("PROJECTNAME").Select n
      ActiveDocument.Fields("SENDEMAILCMD").Select n2

      fln= n
      fln2= n2


      sFile2 = "D:\QlikView\src\dev\PPM\pdf\"& n &".pdf"
      Set oFSO2 = CreateObject("Scripting.FileSystemObject")
          If oFSO2.FileExists (sFile2) Then oFSO2.deletefile (sFile2) End If


      Set oFile = oFSO.OpenTextFile(sFile,8,true)
      oFile.WriteLicreatne n2


      Set WSHShell = CreateObject("WScript.Shell")
      RegKey = "HKEY_CURRENT_USER\Software\PDFCreator\Program\"
      WSHShell.RegWrite RegKey & "UseAutosave", 1
      WSHShell.RegWrite RegKey & "AutosaveDirectory","D:\QlikView\src\dev\PPM\pdf\"
      WSHShell.RegWrite RegKey & "AutosaveFilename", fln
      ActiveDocument.GetApplication.Sleep 30000
      Set WSHShell = nothing

      set wshShell = CreateObject("Shell.Application")

      wshShell.ShellExecute "D:\QlikView\src\dev\PPM\cmd\PMOSendEmail.bat","","","open",1
      ActiveDocument.GetApplication.Sleep 15000
      end sub


      - This macro creates a pdf file per selected dimension value (in this case PROJECTNAME) and afterwards sends it by email to the relevant person.


      This process has been running without any issue for 1 year but since today the traffic lights are not rendered anymore in the pdf files while all other charts (bars, lines, bubbles, etc) are correctly displayed.


      Additional information: if I manually open the QVW on the server and reload it traffic lights are then correctly rendered in the pdf's. The only difference here with the windows task scheduler way is that QVW runs on the foreground while it runs on the background with the bat file execution.


      Any help is welcome.