YAY! Works now! Thanks for the reminder to update. -----Original Message----- From: Asiri Wanigarathne [mailto:waas...@gmail.com] Sent: Thursday, April 22, 2010 7:21 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Execute a script
same here on every tuesday I update to the latest weekly build. try build 1616. that works fine for me. creates SQL database runs scrips and also modifies the the App.config file which is a XML file. Regards, Asiri Wanigarathne http://www.asiri.name On 23 April 2010 02:26, Will Sullivan <wsulli...@softdocs.com> wrote: > 1602. I usually install the latest weekly release, but didn't do the > last one. I don't see any movement on the bug. What version are you > having success with? > > -----Original Message----- > From: Asiri Wanigarathne [mailto:waas...@gmail.com] > Sent: Wednesday, April 21, 2010 8:54 PM > To: General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] Execute a script > > Hi > > What is the WiX build you are using to build the MSI ? > > I got a WiX project with one database creation and multiple XML file > modifications and that works fine. But I had issues creating the > database in MSI built with WiX 3.5 Build 1602. > > Regards, > Asiri Wanigarathne > > http://www.asiri.name > > > On 21 April 2010 22:23, Will Sullivan <wsulli...@softdocs.com> wrote: > > > XmlFile breaks SqlDatabase. > > > > See > > > http://stackoverflow.com/questions/2602950/wix-xmlfile-is-keeping-sqld > atabase-from-creating-databasesand > > > https://sourceforge.net/tracker/?func=detail&aid=2986062&group_id=1059 > 70&atid=642714 > > > > -----Original Message----- > > From: Carolina Zuqueto Amaral [mailto:carolina.ama...@conv.com.br] > > Sent: Friday, April 16, 2010 8:21 AM > > To: 'General discussion for Windows Installer XML toolset.' > > Subject: [WiX-users] Execute a script > > > > Hi, > > > > I created a path for to do the following changes: > > > > > > - Remove a file > > > > - Update some files > > > > - Execute a script > > > > But, the third option did not work. > > > > > > Setup Commands: > > > > <?xml version="1.0" encoding="UTF-8"?> <Wix > > xmlns="http://schemas.microsoft.com/wix/2006/wi"; > > xmlns:Util="http://schemas.microsoft.com/wix/UtilExtension"; > > xmlns:Sql="http://schemas.microsoft.com/wix/SqlExtension";> > > <Product Id="{F57E0806-B8E9-4e4b-A4B7-83797657175E}" > > Name="WiX Patch Example Product" > > Language="1064" > > Version="1.0.0" > > Manufacturer="Convergencia" > > UpgradeCode="{71C36DBF-DED5-4367-8D27-ED1D438AADC6}"> > > <Package Description="Installs a file that will be patched." > > Comments="This Product does not install any executables" > > InstallerVersion="200" > > Compressed="yes" /> > > <Media Id="1" /> > > <?define path = > > "C:\Dev\usr\carolina.amaral\PatchCreation\Product\Product"?> > > <?define Version = "1.1"?> > > <?define RTMProductVersion="0.0.0" ?> > > <?define ProductVersion="1.0.0" ?> > > <?define UpgradeCode="{F57E0806-B8E9-4e4b-A4B7-83797657175E}"?> > > <Property Id="ALLUSERS">1</Property> > > <Property Id="ProductID">none</Property> > > <Property Id="DBNAME">ConvergenciaAHClientCFG</Property> > > <Property Id="SQLSN">(local)\CONVERGENCIA</Property> > > <Property Id="WIXUI_INSTALLDIR" Value="INSTALLLOCATION" /> > > <Property Id="WIXUI_DATA" Value="DATA" /> > > > > <Directory Id="TARGETDIR" Name="SourceDir"> > > <Directory Id="ProgramFilesFolder" Name="PFiles"> > > <Directory Id="INSTALLLOCATION" Name="Patch Sample Directory"> > > <Component Id="SampleComponent" > > Guid="{C28843DA-EF08-41CC-BA75-D2B99D8A1983}" DiskId="1"> > > <File Id="SampleFile" Name="Sample.txt" > > Source="$(var.path)\1.1\Sample.txt" Compressed="no" /> > > <File Id="ConvergenciaAHAppexeCONFIG" > > Name="Convergencia.AH.App.exe.config" > > Source="$(var.path)\$(var.Version)\Convergencia.AH.App.exe.config" > > Compressed="no" /> > > <File Id="WpfControlLibraryDLL" Name="WpfControlLibrary.dll" > > Source="$(var.path)\$(var.Version)\WpfControlLibrary.dll" Compressed="no" > > /> > > <File Id="WpfUpdatableAppEXE" Name="WpfUpdatableApp.exe" > > Source="$(var.path)\$(var.Version)\WpfUpdatableApp.exe" Compressed="no" > /> > > </Component> > > > > <Directory Id="DataFolder" Name="DATA"> > > <Component Id="DataFolderComp" > > Guid="{C0054A15-8E33-49a6-B13A-8FD0743C328D}"> > > <CreateFolder Directory="DataFolder"/> > > </Component> > > </Directory> > > > > <Component Id="DatabaseComp" > > Guid="{FA1987E8-EBB6-4886-B2C0-C92CAACF8C84}"> > > <CreateFolder/> > > <Sql:SqlDatabase Id="DropDatabase" Database="[DBNAME]" > > Server="[SQLSN]" DropOnInstall="yes" > > ContinueOnError="yes" /> > > > > <Sql:SqlDatabase Id="CreateDatabase" Database="[DBNAME]" > > Server="[SQLSN]" DropOnUninstall="yes" > > ContinueOnError="no" > > > > > <Sql:SqlScript Id="BinarySql" ExecuteOnInstall="yes" > > ExecuteOnUninstall="no" BinaryKey="ScriptDB" > > ContinueOnError="no" Sequence="1"/> > > </Sql:SqlDatabase> > > </Component> > > > > </Directory> > > </Directory> > > </Directory> > > > > <Upgrade Id="$(var.UpgradeCode)"> > > <UpgradeVersion Minimum="$(var.ProductVersion)" > > IncludeMinimum="no" > > Language="1046" > > OnlyDetect="yes" > > Property="NEWPRODUCTFOUND" /> > > <UpgradeVersion Minimum="$(var.RTMProductVersion)" > > IncludeMinimum="yes" > > Language="1046" > > Maximum="$(var.ProductVersion)" > > IncludeMaximum="no" > > Property="UPGRADEFOUND" /> > > </Upgrade> > > > > <CustomAction Id ="SAVETARGETDIR" Property="ARPINSTALLLOCATION" > > Value="INSTALLLOCATION"/> > > > > <Binary Id="ScriptDB" > > SourceFile=".\sources\FACTConfigurationScript.sql"/> > > <Binary Id="InsertDB" SourceFile=".\sources\FactInsert.sql" /> > > > > <InstallExecuteSequence> > > <Custom Action="SAVETARGETDIR" After="InstallValidate"/> > > <RemoveExistingProducts After="InstallInitialize" /> > > </InstallExecuteSequence> > > > > <Feature Id="SampleProductFeature" Title="Sample Product Feature" > > Level="1"> > > <ComponentRef Id="SampleComponent" /> > > <ComponentRef Id="DatabaseComp"/> > > <ComponentRef Id="DataFolderComp"/> > > </Feature> > > </Product> > > </Wix> > > > > > > Upgrade Commands: > > > > <?xml version="1.0" encoding="UTF-8"?> <Wix > > xmlns="http://schemas.microsoft.com/wix/2006/wi"; > > xmlns:Util="http://schemas.microsoft.com/wix/UtilExtension"; > > xmlns:Sql="http://schemas.microsoft.com/wix/SqlExtension";> > > <Product Id="{F57E0806-B8E9-4e4b-A4B7-83797657175E}" > > Name="WiX Patch Example Product" > > Language="1064" > > Version="1.0.1" > > Manufacturer="Convergencia" > > UpgradeCode="{71C36DBF-DED5-4367-8D27-ED1D438AADC6}"> > > <Package Description="Installs a file that will be patched." > > Comments="This Product does not install any executables" > > InstallerVersion="200" > > Compressed="yes" /> > > <Media Id="1" /> > > <?define path = > > "C:\Dev\usr\carolina.amaral\PatchCreation\Product\Product"?> > > <?define Version = "1.1"?> > > <?define RTMProductVersion="1.0.0" ?> > > <?define ProductVersion="1.0.1" ?> > > <?define UpgradeCode="{F57E0806-B8E9-4e4b-A4B7-83797657175E}"?> > > <Property Id="ALLUSERS">1</Property> > > <Property Id="ProductID">none</Property> > > <Property Id="DBNAME">ConvergenciaAHClientCFG</Property> > > <Property Id="SQLSN">(local)\CONVERGENCIA</Property> > > <Property Id="WIXUI_INSTALLDIR" Value="INSTALLLOCATION" /> > > <Property Id="WIXUI_DATA" Value="DATA" /> > > > > <Directory Id="TARGETDIR" Name="SourceDir"> > > <Directory Id="ProgramFilesFolder" Name="PFiles"> > > <Directory Id="INSTALLLOCATION" Name="Patch Sample Directory"> > > <Component Id="SampleComponent" > > Guid="{C28843DA-EF08-41CC-BA75-D2B99D8A1983}" DiskId="1"> > > <File Id="ConvergenciaAHAppexeCONFIG" > > Name="Convergencia.AH.App.exe.config" > > Source="$(var.path)\$(var.Version)\Convergencia.AH.App.exe.config" > > Compressed="no" /> > > <File Id="WpfControlLibraryDLL" Name="WpfControlLibrary.dll" > > Source="$(var.path)\$(var.Version)\WpfControlLibrary.dll" Compressed="no" > > /> > > <File Id="WpfUpdatableAppEXE" Name="WpfUpdatableApp.exe" > > Source="$(var.path)\$(var.Version)\WpfUpdatableApp.exe" Compressed="no" > /> > > <RemoveFile Id="RemoveTXT" Name="Sample.txt" On="install"/> > > </Component> > > > > <Directory Id="DataFolder" Name="DATA"> > > <Component Id="DataFolderComp" > > Guid="{C0054A15-8E33-49a6-B13A-8FD0743C328D}"> > > <CreateFolder Directory="DataFolder"/> > > </Component> > > </Directory> > > > > <Component Id="DatabaseComp" > > Guid="{FA1987E8-EBB6-4886-B2C0-C92CAACF8C84}"> > > <CreateFolder/> > > > > <Sql:SqlDatabase Id="FACT4SQLDatabase" Database="[DBNAME]" > > Server="[SQLSN]" ContinueOnError="no" > > CreateOnInstall="no" CreateOnReinstall="yes"> > > > > <Sql:SqlScript Id="scriptInsert" BinaryKey ="InsertDB" > ContinueOnError="no" > > ExecuteOnInstall="yes" Sequence="1"/> > > </Sql:SqlDatabase> > > </Component> > > > > </Directory> > > </Directory> > > </Directory> > > > > <Upgrade Id="$(var.UpgradeCode)"> > > <UpgradeVersion Minimum="$(var.ProductVersion)" > > IncludeMinimum="no" > > Language="1046" > > OnlyDetect="yes" > > Property="NEWPRODUCTFOUND" /> > > <UpgradeVersion Minimum="$(var.RTMProductVersion)" > > IncludeMinimum="yes" > > Language="1046" > > Maximum="$(var.ProductVersion)" > > IncludeMaximum="no" > > Property="UPGRADEFOUND" /> > > </Upgrade> > > > > <CustomAction Id ="SAVETARGETDIR" Property="ARPINSTALLLOCATION" > > Value="INSTALLLOCATION"/> > > > > <Binary Id="ScriptDB" > > SourceFile=".\sources\FACTConfigurationScript.sql"/> > > <Binary Id="InsertDB" SourceFile=".\sources\FactInsert.sql" /> > > > > <InstallExecuteSequence> > > <Custom Action="SAVETARGETDIR" After="InstallValidate"/> > > <RemoveExistingProducts After="InstallInitialize" /> > > </InstallExecuteSequence> > > > > <Feature Id="SampleProductFeature" Title="Sample Product Feature" > > Level="1"> > > <ComponentRef Id="SampleComponent" /> > > <ComponentRef Id="DatabaseComp"/> > > <ComponentRef Id="DataFolderComp"/> > > </Feature> > > </Product> > > </Wix> > > > > > > > > Patch Commands: > > > > > > <?xml version="1.0" encoding="utf-8"?> <Wix > > xmlns="http://schemas.microsoft.com/wix/2006/wi";> > > <PatchCreation > > Id="{BE9AB67E-7226-4ef0-8F0A-D68183543979}" > > CleanWorkingFolder="yes" > > OutputPath="patch.pcp" > > WholeFilesOnly="yes" > > > > > > > <PatchInformation > > Description="Small Update Patch" > > Comments="Small Update Patch" > > ShortNames="no" > > Languages="1064" > > Compressed="yes" > > Manufacturer="Dynamo Corp"/> > > > > <PatchMetadata > > AllowRemoval="yes" > > Description="Small Update Patch" > > ManufacturerName="Dynamo Corp" > > TargetProductName="Sample" > > MoreInfoURL="http://www.dynamocorp.com/"; > > Classification="Update" > > DisplayName="Sample Patch"/> > > > > <Family DiskId="5000" > > MediaSrcProp="Sample" > > Name="Sample" > > SequenceStart="5000"> > > <UpgradeImage SourceFile="C:\Teste\Upgrade\Product.msi" > Id="Upgrade"> > > <TargetImage SourceFile="C:\Teste\Setup\Product.msi" Order="2" > > Id="Target" IgnoreMissingFiles="no" /> > > </UpgradeImage> > > </Family> > > > > <TargetProductCode Id="{F57E0806-B8E9-4e4b-A4B7-83797657175E}"/> > > > > <PatchSequence PatchFamily="SamplePatchFamily" > > Sequence="1.0.0.0" > > Supersede="yes" /> > > > > </PatchCreation> > > </Wix> > > > > > > How do I execute a script using a patch? > > > > > > Thanks, > > > > Carolina Zuqueto Amaral > > carolina.ama...@conv.com.br<mailto:carolina.ama...@conv.com.br> > > tel +55 21 2494-5476 > > cel +55 21 9524-7186 > > > > > > ________________________________ > > Confidencialidade: A informa??o contida nesta mensagem de e-mail, > incluindo > > quaisquer anexos, ? confidencial e est? reservada apenas ? pessoa ou > > entidade para a qual foi endere?ada. Se voc? n?o ? o destinat?rio ou > > a pessoa respons?vel por encaminhar esta mensagem ao destinat?rio, voc? > est?, > > por meio desta, notificado que n?o dever? rever, retransmitir, > > imprimir, copiar, usar ou distribuir esta mensagem de e-mail ou quaisquer > > anexos. > Caso > > voc? tenha recebido esta mensagem por engano, por favor, contate o > remetente > > imediatamente e apague esta mensagem de seu computador ou de > > qualquer > outro > > banco de dados. Grato. > > > > Confidentiality Notice: The information contained in this email > > message, including any attachment, is confidential and is intended > > only for the person or entity to which it is addressed. If you are > > neither the > intended > > recipient nor the employee or agent responsible for delivering this > message > > to the intended recipient, you are hereby notified that you may not > review, > > retransmit, convert to hard copy, copy, use or distribute this email > message > > or any attachments to it. If you have received this email in error, > please > > contact the sender immediately and delete this message from any > > computer > or > > other data bank. Thank you. > > > > > ---------------------------------------------------------------------- > -------- > > Download Intel® Parallel Studio Eval Try the new software tools > > for yourself. Speed compiling, find bugs proactively, and fine-tune > applications > > for parallel performance. > > See why Intel Parallel Studio got high marks during beta. > > http://p.sf.net/sfu/intel-sw-dev > > _______________________________________________ > > WiX-users mailing list > > WiX-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > > > > ---------------------------------------------------------------------- > -------- > > _______________________________________________ > > WiX-users mailing list > > WiX-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > ---------------------------------------------------------------------- > -------- _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > > ---------------------------------------------------------------------- > -------- _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------------ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
