Go Back  FlyerTalk Forums > Miles&Points > Airlines and Mileage Programs > Air Canada | Aeroplan
Reload this Page >

Unofficial AC PNR Viewing Tool (aka cowtool)

Unofficial AC PNR Viewing Tool (aka cowtool)

Old Feb 14, 20, 2:51 pm
  #136  
FlyerTalk Evangelist
Original Poster
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, Accor Plat, Bonvoy Gold, HH Diamond
Posts: 31,714
Originally Posted by King Chung Huang View Post
I checked in for the IAH-YYC flight this morning, and found that I’d lost my seat assignment. But, I was able to select 12D myself without issues, this time. Cow’s tool shows my status is back to E50K.

This does seem to match others’ observation that perhaps AC did something. It’s also looking like our statuses can now be updated without removing/re-adding FF numbers.
Interesting. It's almost like new res systems are smarter than old ones
D582 and xanderz like this.
canadiancow is offline  
Old Feb 14, 20, 3:36 pm
  #137  
 
Join Date: Aug 2019
Location: YVR
Programs: Marriot Gold, Hilton Gold, Aeroplan Black
Posts: 32
Cow, as a web developer who also likes to explore/playing w/ open API like this,

I just want to say this tool is super simple but incredibly useful to check all our upcoming flights need (especially mRTW).
All our bookings & seats also immediately show up in your tool!

Big Kudos & Thank you very much for doing this!
xanderz is offline  
Old Feb 14, 20, 5:09 pm
  #138  
 
Join Date: May 2014
Posts: 147
I am not a web developer, but I can appreciate the simplicity yet usefulness of this tool. Thank you from our family as well, Cow. Your elegant tool has cleared up some annoying items on our mRTW itineraries, which would otherwise have been more difficult to see at AC.com and in our PDF Aeroplan itineraries. More free time for us on this Family Day long weekend!
canadiancow and TechnoTourist like this.
WKnight is offline  
Old Feb 14, 20, 5:59 pm
  #139  
FlyerTalk Evangelist
 
Join Date: Jun 2003
Location: YYC
Posts: 22,038
Originally Posted by canadiancow View Post

There are a lot of things that can happen that are less common that I realize I don't handle. Multiple ticket numbers for one PNR is certainly one of them.

There's also the ability to have a different FQTV for each segment.
Now checked in. As I half expected, ticket numbers shown on the boarding pass are the original 014, i.e. not the ticket numbers that the tool (and aircanada.com) were showing.
canadiancow likes this.
Stranger is online now  
Old Feb 16, 20, 3:20 pm
  #140  
 
Join Date: Sep 2017
Programs: AC E50K (MM) FB (Silver)
Posts: 82
So, a further DP. Ms SWMBO Stanbury just attempted web check in for her flight to CDG tomorrow, which had 2 TK and 2 HK status flights. I advised her that this would almost certainly be a fruitless exercise, and we would have to either call AC or wait until she is at YWG tomorrow.

Result: the check-in worked like a charm! She now has BP's both printed and in her iPhone wallet - the latter obtained through the app.

Cow's tool still shows the 2 TK's.

I don't begin to understand this, but "ours not to reason why" I guess.
Stanbury is offline  
Old Feb 17, 20, 12:16 am
  #141  
 
Join Date: Feb 2006
Programs: AC50 MM
Posts: 777
Late to the party but this is so great. Thanks Cow
canadiancow likes this.
tomvancouver is offline  
Old Yesterday, 12:03 am
  #142  
FlyerTalk Evangelist
Original Poster
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, Accor Plat, Bonvoy Gold, HH Diamond
Posts: 31,714
Well now that the thread title has changed, I guess that name is stuck

I've added a couple new columns. Distance, base fare, and surcharges.

Distance is based on some "old" data pulled from Adam Smith 's spreadsheet (along with a Haversine calculator). I'll update it at some point if things look good.

The fare/surcharges fields are the pro-rated amounts based on distance, calculated from the information I can find. I have some PNRs with YQ and YR, but I don't have one with Y to test, but it should be fine.

This does not yet calculate your earnings, since I have not stolen Adam's list of *A airlines or bonus calculations. Though since I know whether it's an AC ticket and I know your status, it should be a bit simpler to determine everything.

I hope this is a useful addition, and I'd love to see any PNRs this doesn't work with.

One thing that's harder to see in this screenshot is that if you hover over an amount, it says "USD". Not super relevant since this isn't quite AQD, but I'm not sure a good way to figure out the exchange rate AC will use.

YYC3722, xanderz and jugaadkabaap like this.
canadiancow is offline  
Old Yesterday, 2:57 am
  #143  
 
Join Date: May 2013
Location: west coast best coast
Programs: TINDER GOLD, STARBUCKS GOLD, COSTCO EXECUTIVE!!
Posts: 3,368
Originally Posted by canadiancow View Post
Well now that the thread title has changed, I guess that name is stuck

I've added a couple new columns. Distance, base fare, and surcharges.

Distance is based on some "old" data pulled from Adam Smith 's spreadsheet (along with a Haversine calculator). I'll update it at some point if things look good.

The fare/surcharges fields are the pro-rated amounts based on distance, calculated from the information I can find. I have some PNRs with YQ and YR, but I don't have one with Y to test, but it should be fine.

This does not yet calculate your earnings, since I have not stolen Adam's list of *A airlines or bonus calculations. Though since I know whether it's an AC ticket and I know your status, it should be a bit simpler to determine everything.

I hope this is a useful addition, and I'd love to see any PNRs this doesn't work with.

One thing that's harder to see in this screenshot is that if you hover over an amount, it says "USD". Not super relevant since this isn't quite AQD, but I'm not sure a good way to figure out the exchange rate AC will use.

I wish your tool did this for other airlines. It would be immensely helpful -- it's essentially identical to what I have in my spreadsheet for all my flights, except I'm manually entering them
keitherson is offline  
Old Yesterday, 4:07 am
  #144  
 
Join Date: Jan 2009
Location: YOW
Programs: AC-SE100K, AC-2MM, Marriott- LT Titanium, SPG RIP
Posts: 2,596
Nice additions to the tool!! Thanks!

I have a 7 segment itinerary and am just over 50% done the flying... the tool shows negative AQD for under the “Base” column for the two TPAC segments... the other segments seem to have the correct “Base” amounts... any ideas on why a negative number would be there? (All YQ numbers are positive, albeit very small).
Plumber is offline  
Old Yesterday, 9:46 am
  #145  
FlyerTalk Evangelist
Original Poster
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, Accor Plat, Bonvoy Gold, HH Diamond
Posts: 31,714
Originally Posted by Plumber View Post
Nice additions to the tool!! Thanks!

I have a 7 segment itinerary and am just over 50% done the flying... the tool shows negative AQD for under the “Base” column for the two TPAC segments... the other segments seem to have the correct “Base” amounts... any ideas on why a negative number would be there? (All YQ numbers are positive, albeit very small).
Are the distances correct?
canadiancow is offline  
Old Yesterday, 12:14 pm
  #146  
 
Join Date: Apr 2011
Location: YYC
Programs: AC E50K, spouse E75K (MM), National Emerald, various hotel programs
Posts: 303
Originally Posted by canadiancow View Post
If it continues to do that, and you're willing to share it with me, PM me the information and I can take a look.
I'm getting the error message again, same PNR that I shared with you. Was trying to check out the new features.
YYC traveler is offline  
Old Yesterday, 12:32 pm
  #147  
FlyerTalk Evangelist
Original Poster
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, Accor Plat, Bonvoy Gold, HH Diamond
Posts: 31,714
Originally Posted by YYC traveler View Post
I'm getting the error message again, same PNR that I shared with you. Was trying to check out the new features.
I'm getting an error on everything now. I'll figure it out when I get home if it hasn't resolved itself by then.
canadiancow is offline  
Old Yesterday, 1:16 pm
  #148  
FlyerTalk Evangelist
Original Poster
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, Accor Plat, Bonvoy Gold, HH Diamond
Posts: 31,714
It's working again (and I specifically checked with your booking).
YYC traveler likes this.
canadiancow is offline  
Old Yesterday, 3:31 pm
  #149  
 
Join Date: Jan 2009
Location: YOW
Programs: AC-SE100K, AC-2MM, Marriott- LT Titanium, SPG RIP
Posts: 2,596
Originally Posted by canadiancow View Post
Are the distances correct?
Yes-- the distances are correct

Slightly edited to remove dates and unnecssary columns...


Last edited by Plumber; Yesterday at 7:35 pm
Plumber is offline  

Thread Tools
Search this Thread
Search Engine: