For the mega probably. It is small letters not capital.
Almost done. Should be publishing all the updates in the morning. Still not sure on the import issues that were reported though as I can't recreate it.
Not just the #REF's, but also Alandra La Forge is nowhere in Import tab. And she's just one many that appear in Crew, but not in Import. My most recent example of that is Dress Uniform La'an, that's correctly shown in Crew as 4/4 level 96. I just froze her, but can't update that info in Checklist, as she's not found in Import.
I think some, or all, of these issues are related. I've held on to my 6.35, that at least doesn't yet have the #REF issue. Thankfully there's the wiki, that helps especially with Skirmish events, to check which crew repair hull and which give good damage bonus.
I'm pretty sure the #REF problem is because there's "static" data somewhere in those columns.
If you hover over the #REF, you should see a message pop up, like this...
Go to the cell that it's complaining about and hit delete. If that doesn't do it, you can go back and hover again to see if there's another cell that you need to delete.
Or, the nuclear option is to select all cells from row 5 to the bottom.
e.g. if the problem is in Col M, select M5 to M999 (whatever the last row is) and hit delete. The column should auto-re-populate itself and the #REF should be gone.
Another issue, that's been there over a few versions now (having ADD haven't gotten around to report it before), is that even though I use Datacore and import my crew info on every Checklist update, sometimes even in between, much of my crew info doesn't get through. Like just now I was freezing my Scuba Scotty, whom I've had for a while, but my Checklist showed I didn't even have him. (Though that made it easy to update him in import, just switching FALSE to TRUE and Immortal 0 to 1. Still, Crew tab shows him as level 99 FE Active)
I run into this sometimes. My guess is this is a Datacore problem. The website aggressively caches stuff. To make sure you get the absolute most current data when you're download the CSV from Datacore, I do this:
1. clear my browser cache before doing anything
2. load my user data into Datacore
3. *before* Exporting the CSV or Copy to Clipboard, refresh the Datacore page by clicking the refresh button on your browser
*Now* you can Export CSV or Copy to Clipboard and it *should* have the most up-to-the-minute info.
Instead of clearing your entire browser cache, you can also just manually reload the page that shows all of the raw data once or twice. That seems to work for me.
With the latest version of the sheet, I keep getting errors that the script exceeded the maximum time.
I don't think All-In-One is going to work anymore. I'm trying each upgrade script individually.
Edit: Actually, I'm getting the error for every script, not just the All-In-One. Don't know what to tell you about that.
With the latest version of the sheet, I keep getting errors that the script exceeded the maximum time.
I don't think All-In-One is going to work anymore. I'm trying each upgrade script individually.
Edit: Actually, I'm getting the error for every script, not just the All-In-One. Don't know what to tell you about that.
Releasing a new one today. Try clearing your cache before doing the upgrade to this one. I Know for both this one and the previous, I was still able to use the all in one. Tagging @mr_sparky to see if he has any other insight into it as well.
Arissa is not on crew tab, but is on import
Column BM and beyond is blank on Stats tab
Arissa I missed adding to the Crew tab. I've got her fixed for the next release. For BM and Beyond, check to the see if the "Dev Mode" is checked on the stats tab at the top in E3. It sounds like that didn't reset from the import for some reason. if it is, just uncheck it and everything should populate for you. Tagging @mr_sparky as this is the 2nd report of an import issue but I've been unable to recreate any myself at the moment, but he is the master at these.
Also, I did a stealth update on 6.43 to fix Arissa so if you pull a new copy she will be there in that one as well.
With the latest version of the sheet, I keep getting errors that the script exceeded the maximum time.
I don't think All-In-One is going to work anymore. I'm trying each upgrade script individually.
Edit: Actually, I'm getting the error for every script, not just the All-In-One. Don't know what to tell you about that.
Releasing a new one today. Try clearing your cache before doing the upgrade to this one. I Know for both this one and the previous, I was still able to use the all in one. Tagging @mr_sparky to see if he has any other insight into it as well.
With the latest version of the sheet, I keep getting errors that the script exceeded the maximum time.
I don't think All-In-One is going to work anymore. I'm trying each upgrade script individually.
Edit: Actually, I'm getting the error for every script, not just the All-In-One. Don't know what to tell you about that.
Releasing a new one today. Try clearing your cache before doing the upgrade to this one. I Know for both this one and the previous, I was still able to use the all in one. Tagging @mr_sparky to see if he has any other insight into it as well.
Still having issues. DMing you my sheet.
My Sparky was going to look at this. I believe he sent you a request so he could view it as I forwarded it to him.
"Fixed Arissa - Missing from Crew Tab
Added new Crew: Seven, Son of K'Vok, Ensign Arav, Buckley, Legaran Delegate Sarek, Victorious AGIMUS, Toreth, T'Ana in the Box, Possessed Felisa Howard"
With the latest version of the sheet, I keep getting errors that the script exceeded the maximum time.
I don't think All-In-One is going to work anymore. I'm trying each upgrade script individually.
Edit: Actually, I'm getting the error for every script, not just the All-In-One. Don't know what to tell you about that.
Releasing a new one today. Try clearing your cache before doing the upgrade to this one. I Know for both this one and the previous, I was still able to use the all in one. Tagging @mr_sparky to see if he has any other insight into it as well.
Still having issues. DMing you my sheet.
My Sparky was going to look at this. I believe he sent you a request so he could view it as I forwarded it to him.
Shared with him. I'm upgrading to the new sheet, though. I'll let him know if it continues happening with the new sheet.
Update: Individual updates went off without a hitch. I haven't tried All-in-One, though. Issue is probably resolved. I'll let @mr_sparky know if I have any future problems. It seems to have just been a singular anomaly.
Or, the nuclear option is to select all cells from row 5 to the bottom.
ADD and all, only just got this done. Went with the nuclear option, which did the trick. And, going forward, seems like when uploading my data to -core, F5 once or twice at the raw data. Not pretty, but works.
Also, after doing this, the Import tab is now arranged alphabetically. Before it was everything but. Thanks a bunch mr_sparky!
@AdmiralMemo and others, regarding the upgrade scripts:
First, Google's had a problem since around Sept where scripts that used to run fine for years now timeout, and of course it's random. I've actually clocked copying a single cell that used to take under a second now taking 30-40+ seconds(!).
Second, I'm not sure if this is new or if I've just never noticed it before...you know how when you run something from the menu for the first time on a new GS, you're supposed to authorize it, then do it *again*? Well it seems like you only need to do it once. The script *does* run, but there's no visible indication that it's running.
So after a lot of testing, here's what seems to work:
Option 1: Run the all-in-one (authorize first, of course), and let it finish. If you happen to get lucky and there're no errors, you're good. Otherwise, wait about minute and run it again. It seems to run successfully for me on the 2nd or 3rd try *somewhat* consistently.
Option 2: Run each task one at a time, *except* for Import/overwrite Crew info.
Run Import/overwrite Missions & Settings
Run Copy over custom tabs if applicable
Run Import Crew column widths/visibility if applicable
Then run the 3 tasks under the For troubleshooting submenu:
Import/overwrite Crew (manual Fused / Level / Active cols)
Import/overwrite Crew (Import tab)
Import/overwrite Crew Notes/Keep/Cite cols
(The Import/overwrite Crew info task does all 3 of those in one go, but seems to be prone to erroring out these days)
(And for FWIW, when starting from a brand new copy of the GS, doing the All-in-one for the very first time failed around the same place (when copying over the import tab) over 10 out of 10 times 😓)
Just figured out a small tweak that seems to help with the All-in-one upgrade script. It'll be in future updates, but if you want to manually do it for the current GS:
Make this change first, then run the upgrade script.
On the hidden ImportData tab, change the formula in cell A3.
From...
=query(IDU!A2:O,"select A,B,C,D,E,F,G,H,I,J,K,L where A > ' ' order by A,C desc,F desc,H desc,G desc,I,J desc")
...to...
=if(isDevMode,"Dev Mode On",query(IDU!A2:O,"select A,B,C,D,E,F,G,H,I,J,K,L where A > ' ' order by A,C desc,F desc,H desc,G desc,I,J desc"))
@AdmiralMemo and others, regarding the upgrade scripts:
First, Google's had a problem since around Sept where scripts that used to run fine for years now timeout, and of course it's random. I've actually clocked copying a single cell that used to take under a second now taking 30-40+ seconds(!).
Second, I'm not sure if this is new or if I've just never noticed it before...you know how when you run something from the menu for the first time on a new GS, you're supposed to authorize it, then do it *again*? Well it seems like you only need to do it once. The script *does* run, but there's no visible indication that it's running.
So after a lot of testing, here's what seems to work:
Option 1: Run the all-in-one (authorize first, of course), and let it finish. If you happen to get lucky and there're no errors, you're good. Otherwise, wait about minute and run it again. It seems to run successfully for me on the 2nd or 3rd try *somewhat* consistently.
Option 2: Run each task one at a time, *except* for Import/overwrite Crew info.
Run Import/overwrite Missions & Settings
Run Copy over custom tabs if applicable
Run Import Crew column widths/visibility if applicable
Then run the 3 tasks under the For troubleshooting submenu:
Import/overwrite Crew (manual Fused / Level / Active cols)
Import/overwrite Crew (Import tab)
Import/overwrite Crew Notes/Keep/Cite cols
(The Import/overwrite Crew info task does all 3 of those in one go, but seems to be prone to erroring out these days)
I know it's a pain. Sorry about that.
What would be nice, I think, is an option to run everything WITHOUT the Import tab. I'm almost always overriding that anyway with a fresh Import right after I upgrade, so it's wasted processing.
"Added new crew: Orion Hurricane Spock, T'Pel, Ensign Peanut Hamper, Bold Boimler, Reflective Jake Sisko, Q'Mau Burnham, Investigator Tuvok, Away Team Batel, Moll, Hy'Rell, EV Suit Rhys
Added New Collection: Deep Cover"
For me, all of these new crew are showing ??? instead of a level and a blank on the stars. The only ones I have are Peanut, Rhys, Moll, and Tuvok, so those are the ones I'm mainly concerned about.
"Added new crew: Orion Hurricane Spock, T'Pel, Ensign Peanut Hamper, Bold Boimler, Reflective Jake Sisko, Q'Mau Burnham, Investigator Tuvok, Away Team Batel, Moll, Hy'Rell, EV Suit Rhys
Added New Collection: Deep Cover"
For me, all of these new crew are showing ??? instead of a level and a blank on the stars. The only ones I have are Peanut, Rhys, Moll, and Tuvok, so those are the ones I'm mainly concerned about.
Comments
Almost done. Should be publishing all the updates in the morning. Still not sure on the import issues that were reported though as I can't recreate it.
"Expanded Elysian Kingdom to 10
Added new trait, Compromised to many cards
Added new crew: Assimilated Sidney La Forge, Henoch Spock, Surak Archer, Minooki Freeman, Ambassador Saru, T'Les, Bridge Beverly Crusher, Lt. JG Scott"
Only remaining issue is to look into the reported import issue from datacore as I am still researching that.
I'm pretty sure the #REF problem is because there's "static" data somewhere in those columns.
If you hover over the #REF, you should see a message pop up, like this...
Go to the cell that it's complaining about and hit delete. If that doesn't do it, you can go back and hover again to see if there's another cell that you need to delete.
Or, the nuclear option is to select all cells from row 5 to the bottom.
e.g. if the problem is in Col M, select M5 to M999 (whatever the last row is) and hit delete. The column should auto-re-populate itself and the #REF should be gone.
I run into this sometimes. My guess is this is a Datacore problem. The website aggressively caches stuff. To make sure you get the absolute most current data when you're download the CSV from Datacore, I do this:
1. clear my browser cache before doing anything
2. load my user data into Datacore
3. *before* Exporting the CSV or Copy to Clipboard, refresh the Datacore page by clicking the refresh button on your browser
*Now* you can Export CSV or Copy to Clipboard and it *should* have the most up-to-the-minute info.
I don't think All-In-One is going to work anymore. I'm trying each upgrade script individually.
Edit: Actually, I'm getting the error for every script, not just the All-In-One. Don't know what to tell you about that.
Releasing a new one today. Try clearing your cache before doing the upgrade to this one. I Know for both this one and the previous, I was still able to use the all in one. Tagging @mr_sparky to see if he has any other insight into it as well.
6.43
"Added New Crew: Dolorex, Ux-Mal O'Brien, Pah-Wraith Jake Sisko, Arissa
Added New Collection: The Shadow Within"
Column BM and beyond is blank on Stats tab
Arissa I missed adding to the Crew tab. I've got her fixed for the next release. For BM and Beyond, check to the see if the "Dev Mode" is checked on the stats tab at the top in E3. It sounds like that didn't reset from the import for some reason. if it is, just uncheck it and everything should populate for you. Tagging @mr_sparky as this is the 2nd report of an import issue but I've been unable to recreate any myself at the moment, but he is the master at these.
Also, I did a stealth update on 6.43 to fix Arissa so if you pull a new copy she will be there in that one as well.
I'm not good at the quote thing
all is good now, BM and beyond are populated now, Thank you.
My Sparky was going to look at this. I believe he sent you a request so he could view it as I forwarded it to him.
"Fixed Arissa - Missing from Crew Tab
Added new Crew: Seven, Son of K'Vok, Ensign Arav, Buckley, Legaran Delegate Sarek, Victorious AGIMUS, Toreth, T'Ana in the Box, Possessed Felisa Howard"
Update: Individual updates went off without a hitch. I haven't tried All-in-One, though. Issue is probably resolved. I'll let @mr_sparky know if I have any future problems. It seems to have just been a singular anomaly.
ADD and all, only just got this done. Went with the nuclear option, which did the trick. And, going forward, seems like when uploading my data to -core, F5 once or twice at the raw data. Not pretty, but works.
Also, after doing this, the Import tab is now arranged alphabetically. Before it was everything but. Thanks a bunch mr_sparky!
"Added new crew: Orion Hurrican Spock, T'Pel, Ensign Peanut Hamper, Bold Boimler, Reflective Jake Sisko, Q'Mau Burnham, Investigator Tuvok, Away Team Batel, Moll, Hy'Rell, EV Suit Rhys
Added New Collection: Deep Cover"
@AdmiralMemo and others, regarding the upgrade scripts:
First, Google's had a problem since around Sept where scripts that used to run fine for years now timeout, and of course it's random. I've actually clocked copying a single cell that used to take under a second now taking 30-40+ seconds(!).
Second, I'm not sure if this is new or if I've just never noticed it before...you know how when you run something from the menu for the first time on a new GS, you're supposed to authorize it, then do it *again*? Well it seems like you only need to do it once. The script *does* run, but there's no visible indication that it's running.
So after a lot of testing, here's what seems to work:
Option 1: Run the all-in-one (authorize first, of course), and let it finish. If you happen to get lucky and there're no errors, you're good. Otherwise, wait about minute and run it again. It seems to run successfully for me on the 2nd or 3rd try *somewhat* consistently.
Option 2: Run each task one at a time, *except* for Import/overwrite Crew info.
Run Import/overwrite Missions & Settings
Run Copy over custom tabs if applicable
Run Import Crew column widths/visibility if applicable
Then run the 3 tasks under the For troubleshooting submenu:
Import/overwrite Crew (manual Fused / Level / Active cols)
Import/overwrite Crew (Import tab)
Import/overwrite Crew Notes/Keep/Cite cols
(The Import/overwrite Crew info task does all 3 of those in one go, but seems to be prone to erroring out these days)
I know it's a pain. Sorry about that.
Make this change first, then run the upgrade script.
On the hidden ImportData tab, change the formula in cell A3.
From...
=query(IDU!A2:O,"select A,B,C,D,E,F,G,H,I,J,K,L where A > ' ' order by A,C desc,F desc,H desc,G desc,I,J desc")
...to...
=if(isDevMode,"Dev Mode On",query(IDU!A2:O,"select A,B,C,D,E,F,G,H,I,J,K,L where A > ' ' order by A,C desc,F desc,H desc,G desc,I,J desc"))
I requested access to your sheet....
"Added new Crew: Returning Kirk, Quimp, Jinaal Culber, Hacking Tilly, Dr. Adam Soong, Aurelio, V'Shal T'Pring, Primarch Ruhn, Guardian Gray, Bjayzl, l'ak, Detective Mariner, Officiant Picard, Major J. Hayes, Moll & L'ak, Lieutenant Marseilles
Added new trait ""Festive"" to all appropriate crew.
Added new collection: Joyful Times"