Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an application that for some reason, anytime I open it and try to reload data, ask me to save as a new file.
Even if I save in the original name, it asks me again the next time I open it.
For this reason, my automatic reloading is not working.
Any idea why is this happening?
rcandeo wrote:
Yes, I use reduction. And why is not reloading automatically with my publisher?<div></div>
Are you using Section Access? In the Section Access line that contains the Publisher Account, do you have any value in the reduction field? You cannot have any value in this field, even "*'.
-Rob
If you use Reduction Qv will always force a "save as". If that not the case i dont know.
Edit:
And with reduction and mean data reduction in the qlikview document togheter with some opOpen, as other users has asked about (and not Publisher reduction).
Yes, I use reduction. And why is not reloading automatically with my publisher?
Do you have any macros that are running (such as OnOpen) that are changing any attributes of the document?
These are the macros that I have:
Sub LimparSimulacao
set c = ActiveDocument.GetVariable("Aumento_Custo")
c.SetContent 0,true
set p = ActiveDocument.GetVariable("Aumento_Preco")
p.SetContent 0,true
End Sub
Sub SelecaoInicial
ActiveDocument.GetField("Empresa").Select "00100"
ActiveDocument.GetField("Grupo_Principal").Select "CELULOSE"
ActiveDocument.Fields("Grupo_Principal").SelectExcluded
ActiveDocument.GetField("Familia").Select "CELULOSE"
ActiveDocument.Fields("Familia").SelectExcluded
ActiveDocument.GetField("Mes").Select ActiveDocument.Evaluate("date(addmonths(monthstart(today(1)),-1),'MM')")
ActiveDocument.GetField("Ano").Select ActiveDocument.Evaluate("date(addmonths(monthstart(today(1)),-1),'YYYY')")
ActiveDocument.GetField("Cobranca").Select "Com Débito"
ActiveDocument.GetField("Tipo_Faturamento").Select "Faturado"
End Sub
Sub ExportaXLS
set obj = ActiveDocument.GetSheetObject("CH60")
obj.ExportBiff "C:\test.xls"
End Sub
sub ShowFilters
set f = ActiveDocument.GetVariable("vShowFilters")
if f.GetContent.String = "1" then
f.SetContent "0", true
else
f.SetContent "1", true
end if
end sub
sub AutoHideFilters
set f = ActiveDocument.GetVariable("vShowFilters")
f.SetContent "0", true
end sub
sub CurrentSelections
set s = ActiveDocument.GetVariable("vSelections")
if s.GetContent.String = "1" then
s.SetContent "0", true
else
s.SetContent "1", true
end if
end sub
You dont mention when the macros are fired but I would suspect .SetContent would cause a 'save changed' situation.
Regards,
Gordon
The macros are fired only in the oppening of the document, but they are not the problem, since I commented everything and the problem continues.
rcandeo wrote:
Yes, I use reduction. And why is not reloading automatically with my publisher?<div></div>
Are you using Section Access? In the Section Access line that contains the Publisher Account, do you have any value in the reduction field? You cannot have any value in this field, even "*'.
-Rob
After taking out the information for the publisher account, it doesn't ask me to save it anytime, But it gaves error in my publisher yet. Do You have any idea why?
531091 2009-04-17 09:09:18NormalInformation<div>
Loading document "E:\QVW_Publicados\ADMV_Demonstrativo_de_Vendas com Carteira.qvw" (23.18 Mb) </div>
531092 2009-04-17 09:09:18NormalError<div>
The document failed to open. </div>
531097 2009-04-17 09:09:18NormalInformation<div>
Closed the QlikView Engine successfully. ProcessID=4680 </div>
531099 2009-04-17 09:09:18NormalInformation<div>
Performance data (Load): Initializing load (0), Checking read (0), Creating QlikView Engine (0), Checking Size (31), Load (47), Load Completed (203) </div>
531101 2009-04-17 09:09:18NormalInformation<div>
Performance data (Checkout): Initializing Checkout (0), Loading document (281), Load completed (828), Document not found (828) </div>
531104 2009-04-17 09:09:18NormalInformation<div>
Performance data (Checkin): Initializing (0), Finished (0) </div>
531107 2009-04-17 09:09:18NormalError<div>
Reload failed because the document could not be opened successfully. DocumentState=DocumentNotFound </div>
531108 2009-04-17 09:09:18NormalInformation<div>
Checkin </div>
531109 2009-04-17 09:09:18NormalInformation<div>
Performance data (Checkin): Initializing (0), Finished (0) </div>
531110 2009-04-17 09:09:18NormalWarning<div>
Reload skipped for document "E:\QVW_Publicados\ADMV_Demonstrativo_de_Vendas com Carteira.qvw" because document "E:\QVW_Publicados\FIN_Dados_de_Clientes_Credito_e_Contas_a_Receber.qvw" failed to reload.
I can't see what the error message is from the posting. Looks like your paste got truncated (new forum growing pains).
Take a look at the document log (ADMV_Demonstration_de_Vendcom_Carteria.qvw.log) to see what the specifics of the error may be. If you're not generating a document log, open the Document Properties and check "Generate logfile" on the General tab.
-Rob