Jump to content
Ketarin forum

Comparing two columns


Myky777
 Share

Recommended Posts

Ketarin is the program I have been dreaming about! But I'm definitely not a programmer and need some help, please ;)

 

There are a handful of apps where I, either choose or have to, manually update an app and afterward I then manually change the version number in my column "Appver" by hand. I compare the two columns "Appver" & "version" to see which apps need to be updated. However as the list grows, it's becoming tedious. I am looking to create an additional column called "Update", where I guess, it would be a PS script run like every time you check for updates. The script would compare the columns "Appver" & "version" and if they were different, the script would then in the "Update" column place an X or the word Update or something there. So then all I would have to do to see which apps need to be updated is to check that column. Sort of like an if statement,

 

if "Appver" = "version" then "Update" = ""

 

otherwise "Update" = "X"

 

I have attached a small xml with the app SyMenu for reference.

Example_SyMenu.xml

Link to comment
Share on other sites

What I did was follow the link on the originating site to download the exe version, then CTRL+J to open the downloads pane, then copied the download URL. It's clear from that URL that the file path is going to be consistent between builds.

 

I pasted that URL into the {url} variable then on the "Advanced settings" tab of the app profile I set the variable change indicator/"use the following variable as indicator for changes" to the {version} variable. It will now properly update itself by running Ketarin updates.

 

Unless you need it exploring the download folder, you could remove that post-update command, too.

Link to comment
Share on other sites

I will work on that. I was just updating the entry and saw I wasn't using SyMenu's website to look for the version. (I would have pasted the link, but I am unable to paste anything. Is that turned off?) :wacko: Anyway, there webpages are all aspx and I get an error trying to load them in Ketarin. Is there a way to deal with aspx webpages?

 

Edit: Wow! I hadn't seen the pre-update commands. Those will be great when I get that to work. I added

 

if "{appver}"=="{version}" exit 2

 

in the pre-update settings, however when I click the update button nothing happens to the icon with an app who's "appver" is different from the variable "version".

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.