leeoniya Posted May 19, 2011 Report Share Posted May 19, 2011 (edited) hi peeps, often i have to force-download HeidiSQL after it fails to get the exe file from the following url: http://www.heidisql.com/latest_build.php any ideas why? i have a {ver} and {build} variables set up for "Version" and "Build" display columns that get retrieved correctly from here: http://code.google.com/feeds/p/heidisql/svnchanges/basic http://www.heidisql.com/download.php i guess the alternative would be to grab the full url of the build from that download.php page: http://www.heidisql.com/builds/heidisql.r3834.exe just wondering why latest_build.php often fails to detect changes? thanks, leon Edited May 19, 2011 by Leeoniya Link to comment Share on other sites More sharing options...
Omniferum Posted May 19, 2011 Report Share Posted May 19, 2011 You have to set the 'variable for change' to actually use them, it's in the advanced tab of the application settings. You can only use one variable to detect for changes, i'd just stick with the revision value defined from the page http://www.heidisql.com/download.php Also that revision variable is really only for nightly builds, if that is what you want. Personally i'd just regex the dl link for the portable version from that dl page as I prefer stable builds. If ya want full blown help post your application xml and i'll poke it. The issue though is that it is not detecting any changes in the file to download. Link to comment Share on other sites More sharing options...
leeoniya Posted May 19, 2011 Report Share Posted May 19, 2011 thanks, i set 'build' to be used for change detection but it didn't seem to work. i have 2 apps, chromium canary and heidisql. when i press update all, the versions for everything get retrieved fine and the columns get updated. the chromium download begins, and the heidi download just sits with a fully green (100%) progress bar (without any % indicator) and after chrome finishes downloading and installing, the bar goes away and everything gets marked as up to date, but no download of heidi actually occurs. i'm gonna try it with another build and if that doesnt work, then just say screw it and use the full constructed latest build url from the download page parsing. still it seems like the sitting progress bar while chrome downloads is a bug of some sort. Link to comment Share on other sites More sharing options...
Omniferum Posted May 19, 2011 Report Share Posted May 19, 2011 I didn't have any difficulty, i'm not sure if ketarin build really has anything to do with it as I did nothing special. Here's the xml that worked for me. <?xml version='1.0' encoding='utf-8'?> <Jobs> <ApplicationJob xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Guid="b9b9d780-12d3-4aa1-b023-3b6f94f4bb52"> <Category>a</Category> <WebsiteUrl /> <UserAgent /> <UserNotes /> <LastFileSize>0</LastFileSize> <LastFileDate xsi:nil="true" /> <IgnoreFileInformation>false</IgnoreFileInformation> <DownloadBeta>Default</DownloadBeta> <DownloadDate xsi:nil="true" /> <CheckForUpdatesOnly>false</CheckForUpdatesOnly> <VariableChangeIndicator>version</VariableChangeIndicator> <CanBeShared>true</CanBeShared> <ShareApplication>false</ShareApplication> <ExclusiveDownload>false</ExclusiveDownload> <HttpReferer /> <SetupInstructions /> <Variables> <item> <key> <string>download</string> </key> <value> <UrlVariable> <RegexRightToLeft>false</RegexRightToLeft> <VariableType>RegularExpression</VariableType> <Regex>([^"'=]+[^"']+build(\.php))</Regex> <Url>http://www.heidisql.com/download.php</Url> <Name>download</Name> </UrlVariable> </value> </item> <item> <key> <string>version</string> </key> <value> <UrlVariable> <RegexRightToLeft>false</RegexRightToLeft> <VariableType>RegularExpression</VariableType> <Regex>Revision.*?>([\d]+)</Regex> <Url>http://www.heidisql.com/download.php</Url> <Name>version</Name> </UrlVariable> </value> </item> </Variables> <ExecuteCommand>/*This is a comment line, the line below is the C# script. It will run the instructions found in the Setup Tab*/ app.Install(null);</ExecuteCommand> <ExecutePreCommand /> <ExecuteCommandType>CS</ExecuteCommandType> <ExecutePreCommandType>Batch</ExecutePreCommandType> <SourceType>FixedUrl</SourceType> <DeletePreviousFile>true</DeletePreviousFile> <Enabled>true</Enabled> <FileHippoId /> <LastUpdated xsi:nil="true" /> <TargetPath>{downloadpath}{category}\</TargetPath> <FixedDownloadUrl>http://www.heidisql.com/{download}</FixedDownloadUrl> <Name>HeidiSQL</Name> </ApplicationJob> </Jobs> Link to comment Share on other sites More sharing options...
necrox Posted May 19, 2011 Report Share Posted May 19, 2011 Why not using regex (?<=class=\"rev\">.*?detail\?r=).+?(?=\") for variable {build} on http://www.heidisql.com/download.php to get the latest build number and use http://www.heidisql.com/builds/heidisql.r{build}.exe as download link? Works fine for me. Link to comment Share on other sites More sharing options...
necrox Posted May 26, 2011 Report Share Posted May 26, 2011 The /export=FILENAME command line argument does not work anymore... Link to comment Share on other sites More sharing options...
floele Posted May 28, 2011 Author Report Share Posted May 28, 2011 Works fine for me. Link to comment Share on other sites More sharing options...
necrox Posted May 30, 2011 Report Share Posted May 30, 2011 I've got it. Trying to export my job file from default path (C:\Users\usr\AppData\Roaming\Ketarin) works properly. Doing the same from memory stick with a job file located in the same directory as the ketarin.exe breaks up the whole export procedure. The content of my xml file is always the same. <?xml version='1.0' encoding='utf-8'?> <Jobs /> And here my export settings: File -> Settings -> Commands -> Before updating all applications -> REM setting up variables SET CURHOUR=%CURHOUR: =0% set year=%date:~6,4% set yr=%date:~8,2% set month=%date:~3,2% set day=%date:~0,2% set hour=%time:~0,2% set hour=%hour: =0% set min=%time:~3,2% set sec=%time:~6,2% REM exporting database START ketarin.exe /export=all-%year%%month%%day%-%hour%%min%%sec%.xml Link to comment Share on other sites More sharing options...
floele Posted May 30, 2011 Author Report Share Posted May 30, 2011 Depends a bit on the working directory. If you do not specify an absolute path, the working directory and not the loction of Ketarin.exe matters. Link to comment Share on other sites More sharing options...
shawn Posted May 30, 2011 Report Share Posted May 30, 2011 Necrox, have you opened a command prompt, switched to the Ketarin folder and run the command directly? I know on newer OSes (XP/Vista/7) the "start" command pushes the working directory to the default path - so that could be your issue. Just removing Start from your command could fix it. It could also be due to where it's happening (within a Ketarin event), but I would think that wouldn't be an issue with the SQLite locking fix implemented in the 1.6 branch. Link to comment Share on other sites More sharing options...
Tomorrow Posted May 30, 2011 Report Share Posted May 30, 2011 I noticed 1.6 is no longer Beta.It's was pushed as stable and both read 1.6.0.434 now Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now