I was thrown off by "I track crew manually" being checked by default on the Import sheet, as it never was before, and imported with that checked. Now the Crew sheet won't listen to my Import sheet. Is there anything I can do to resume using the Import sheet that doesn't involve copying my Notes column by hand into a new sheet?
I was thrown off by "I track crew manually" being checked by default on the Import sheet, as it never was before, and imported with that checked. Now the Crew sheet won't listen to my Import sheet. Is there anything I can do to resume using the Import sheet that doesn't involve copying my Notes column by hand into a new sheet?
I was thrown off by "I track crew manually" being checked by default on the Import sheet, as it never was before, and imported with that checked. Now the Crew sheet won't listen to my Import sheet. Is there anything I can do to resume using the Import sheet that doesn't involve copying my Notes column by hand into a new sheet?
Sorry about that. I must've accidentally left it "on".
The manual upgrade only affects 3 columns so here's what I would do:
1. Make a new copy of the fresh Google Sheet (meaning make a fresh copy of the link on page 1 of this thread).
2. If you haven't sorted the crew tab on your *original* copy, copy Cols B, E and F from the new copy to your original copy. That should copy over all of the formulas that use the Import sheet.
3. If you *have* sorted the crew tab on your original copy, you could either sort it back and follow step 2, or maybe just take your "new" copy and do the upgrade again, and use that one instead.
If you run into any problems, feel free to DM me for more help.
@cmdrworf I unchecked that checkbox on the Dev copy so that'll be the default for future releases.
When I import from 6.48 to 6.51 in the crew tab, row 1046 is blank, when I use the import tab.
I believe that is Marayana. I forgot to copy her into the crew tab. I've got her fixed in 6.52. if you want to fix 6.51 BEFORE SORTING the crew tab highlight the row above and drag the little square on the far right to copy the entire row above to that row. that will pull all the formulas down and fix her.
For everyone having odd problems that may or may not be related to Datacore exports, I'm working on some error-checking routines with cmdrworf for future releases to help detect those.
I also noticed a quirk/fix that may help with the freeze/unfreeze/etc. recommendations not working.
On your Crew tab, see if there's an error (it'll show "#REF!") in cell V4 (that column may be hidden). If there is, please delete all of the checkboxes (don't worry, it's cosmetic and you won't actually delete data). You should then see "True" and "False" instead of checkboxes.
Following the last two posts, I deleted the previous two lines of the import file, as they were blank.
Now for the quirk/fix, I see checkboxes but no #REF error in cell V4. I'm only seeing ArrayFormula for that cell.
=arrayformula(if(row(A4:A)=4,"Immortal",if(len(A4:A),if((left(E4:E,1)="∞")+
(upper(left(E4:E,1))="X")+
(($B4:$B=$D4:$D)*(upper(E4:E)="100 FE")),true,false))))
@FifaRules and others having "Range not found" errors when trying to use the upgrader.
It'll be fixed in the next release, but if you want to fix it yourself, it's pretty simple:
1. In your Google Sheet, go to the Extensions > Apps Script menu. It'll open a new tab/window showing you the scripts.
2. Go down to line 959 or 960 and make these changes:
2a. Change "A1:A" to "D1:D" here: standardHeadersArray = oldGsInfoSheet.getRange("A1:A" + oldGsInfoSheet.getLastRow()).getValues();
...so it looks like: standardHeadersArray = oldGsInfoSheet.getRange("D1:D" + oldGsInfoSheet.getLastRow()).getValues();
2b. And change "B" to "E" here: let rowCrewHeadersCell = "B" + (findSubstsringPosInArray_(standardHeadersArray, "crewHeaders") + 1);
...so it looks like: let rowCrewHeadersCell = "E" + (findSubstsringPosInArray_(standardHeadersArray, "crewHeaders") + 1);
3. Click the Save icon.
4. Everything should work when you re-run the script.
Following the last two posts, I deleted the previous two lines of the import file, as they were blank.
Now for the quirk/fix, I see checkboxes but no #REF error in cell V4. I'm only seeing ArrayFormula for that cell.
=arrayformula(if(row(A4:A)=4,"Immortal",if(len(A4:A),if((left(E4:E,1)="∞")+
(upper(left(E4:E,1))="X")+
(($B4:$B=$D4:$D)*(upper(E4:E)="100 FE")),true,false))))
@kauthor Are you still having problems with the Gauntlet tab? Or was this another problem? Either way, please feel free to DM me your Google Sheet (please set sharing to "anyone with the link can view") and I'll take a look.
Comments
I knew there would still be something...... dang it.
tagging @mr_sparky on this one.
Sorry about that. I must've accidentally left it "on".
The manual upgrade only affects 3 columns so here's what I would do:
1. Make a new copy of the fresh Google Sheet (meaning make a fresh copy of the link on page 1 of this thread).
2. If you haven't sorted the crew tab on your *original* copy, copy Cols B, E and F from the new copy to your original copy. That should copy over all of the formulas that use the Import sheet.
3. If you *have* sorted the crew tab on your original copy, you could either sort it back and follow step 2, or maybe just take your "new" copy and do the upgrade again, and use that one instead.
If you run into any problems, feel free to DM me for more help.
@cmdrworf I unchecked that checkbox on the Dev copy so that'll be the default for future releases.
Exception: Range not found
Tagging @mr_sparky
I believe that is Marayana. I forgot to copy her into the crew tab. I've got her fixed in 6.52. if you want to fix 6.51 BEFORE SORTING the crew tab highlight the row above and drag the little square on the far right to copy the entire row above to that row. that will pull all the formulas down and fix her.
Can you check what's showing in cell B1 on the UpgradeFromOldGs tab?
Is it showing the url for your old Google Sheet, or is it showing the *name* of your old GS?
If it's showing the *name*, please delete it, then copy-n-paste the url from your old GS and hit *return*. Make sure you don't hit Tab.
If that's not it, feel free to DM me the link to your new GS and I can take a closer look.
Same problem, but opposite. I've already unfrozen a few crew members, but they still show up as unfreeze after I post the .csv file.
It appears that the datacore crew export is not exporting all of the columns.
"You Loss, Their Gain" collection should be "Your Loss, Their Gain"
I also noticed a quirk/fix that may help with the freeze/unfreeze/etc. recommendations not working.
On your Crew tab, see if there's an error (it'll show "#REF!") in cell V4 (that column may be hidden). If there is, please delete all of the checkboxes (don't worry, it's cosmetic and you won't actually delete data). You should then see "True" and "False" instead of checkboxes.
Now for the quirk/fix, I see checkboxes but no #REF error in cell V4. I'm only seeing ArrayFormula for that cell.
=arrayformula(if(row(A4:A)=4,"Immortal",if(len(A4:A),if((left(E4:E,1)="∞")+
(upper(left(E4:E,1))="X")+
(($B4:$B=$D4:$D)*(upper(E4:E)="100 FE")),true,false))))
It'll be fixed in the next release, but if you want to fix it yourself, it's pretty simple:
1. In your Google Sheet, go to the Extensions > Apps Script menu. It'll open a new tab/window showing you the scripts.
2. Go down to line 959 or 960 and make these changes:
2a. Change "A1:A" to "D1:D" here:
standardHeadersArray = oldGsInfoSheet.getRange("A1:A" + oldGsInfoSheet.getLastRow()).getValues();
...so it looks like:
standardHeadersArray = oldGsInfoSheet.getRange("D1:D" + oldGsInfoSheet.getLastRow()).getValues();
2b. And change "B" to "E" here:
let rowCrewHeadersCell = "B" + (findSubstsringPosInArray_(standardHeadersArray, "crewHeaders") + 1);
...so it looks like:
let rowCrewHeadersCell = "E" + (findSubstsringPosInArray_(standardHeadersArray, "crewHeaders") + 1);
3. Click the Save icon.
4. Everything should work when you re-run the script.
@kauthor Are you still having problems with the Gauntlet tab? Or was this another problem? Either way, please feel free to DM me your Google Sheet (please set sharing to "anyone with the link can view") and I'll take a look.
Do you have any date for next release ?
Maybe could you release even with some minor quircks ?