So I’ve been playing around off and on trying to put together a build sheet using the addin and ran across a strange issue.
I got a list of my original BPOs with: =EVEONLINE.CHARACTER_BLUEPRINTS(,“Original”) this was put in column B.
I’m trying to break out the relevant build info (ME, time per job, etc) so I added another column to switch the above results to the BPs using: =EVEONLINE.BLUEPRINT(B2.type_id) (obviously my data is in col B)
now that worked for most of my BPs, but I found that many needed to be changed to: =B166.blueprint_data in order to get to the card with the build time data.
stranger still, I found two copies of the same BPO in column B. One used the =EVEONLINE.BLUEPRINT(B100.type_id) and the other needed the =B166.blueprint_data to get the same information. When I looked at the original data cards in column B (my original inventory dump) they have different item_ids?!?!?
I’m sure there’s probably a faster way to get to the data, but I’m not a programmer so I’m taking babysteps to try and learn.
So I ended up ‘fixing’ my problem by just using the iferror function to use whichever version worked but it doesn’t explain WHY it was necessary.
I’m assuming the different item_id values might be due to being a BPO so it can track research levels? Regardless, both BPOs were researched to the same level, the only difference I can think of was one had been used to produce and the other was fresh out of research.
Figured I’d just leave what info I had here in case anyone else runs across a similar quirk in the future.
This is most likely due to a difference in number of blueprints on the character holding them.
If they are above 500 blueprints on a character (If I remember correctly the number), we omit the rich data on them. And since the sample you show is the variation that pulls from all characters that’s most likely what’s happening. So the other blueprints with the data are from a character holding fewer blueprints.
This was needed since blueprints are usually all stored by the same character and some users have thousands of them, and the addin was hitting limits showing all that data in the same call, or processing for couple of minutes to connect all the data.
Thank you! yes this is probably what happened..I do seem to remember the 2 BPs in question were on different characters, my main indy toon and the other only has a couple BPs for dailies.