Home Ready Room

Do Not Airlock Checklist Thread 4

1606162636466»

Comments

  • ÷ Brad [30]÷ Brad [30] ✭✭✭
    sorry, but Marayna is missing from crew tab... I noticed because immortal count was off by one
  • ShidoniShidoni ✭✭✭
    edited April 7
    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?
  • cmdrworfcmdrworf ✭✭✭✭✭
    sorry, but Marayna is missing from crew tab... I noticed because immortal count was off by one

    I knew there would still be something...... dang it.
    Sir, I protest! I am NOT a merry man!
  • cmdrworfcmdrworf ✭✭✭✭✭
    Shidoni wrote: »
    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?

    tagging @mr_sparky on this one.
    Sir, I protest! I am NOT a merry man!
  • mr_sparkymr_sparky ✭✭✭
    Shidoni wrote: »
    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.
  • ShidoniShidoni ✭✭✭
    Thank you very much! I don't know why I didn't think to just make a new sheet and import; it fixed everything perfectly.
  • Attempting to upgrade from 6.48 to 6.51 and get this error message on every attempt, including individual steps in For Troubleshooting:

    Exception: Range not found
  • kauthorkauthor ✭✭
    When I import from 6.48 to 6.51 in the crew tab, row 1046 is blank, when I use the import tab.
  • cmdrworfcmdrworf ✭✭✭✭✭
    Attempting to upgrade from 6.48 to 6.51 and get this error message on every attempt, including individual steps in For Troubleshooting:

    Exception: Range not found

    Tagging @mr_sparky
    Sir, I protest! I am NOT a merry man!
  • cmdrworfcmdrworf ✭✭✭✭✭
    kauthor wrote: »
    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.
    Sir, I protest! I am NOT a merry man!
  • mr_sparkymr_sparky ✭✭✭
    FifaRules wrote: »
    Attempting to upgrade from 6.48 to 6.51 and get this error message on every attempt, including individual steps in For Troubleshooting:

    Exception: Range not found

    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.
  • Sven LundgrenSven Lundgren ✭✭✭✭✭
    Something is not right, I am being told these are the only crew I have active that should be frozen. They are already frozen.

    7kxffb7j3jnc.png

  • Sven LundgrenSven Lundgren ✭✭✭✭✭
    It appears to be a problem with datacore, not the spreadsheet.
  • kauthorkauthor ✭✭
    Something is not right, I am being told these are the only crew I have active that should be frozen. They are already frozen.

    7kxffb7j3jnc.png

    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.
  • Sven LundgrenSven Lundgren ✭✭✭✭✭
    kauthor wrote: »
    Something is not right, I am being told these are the only crew I have active that should be frozen. They are already frozen.

    7kxffb7j3jnc.png

    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.
  • Sven LundgrenSven Lundgren ✭✭✭✭✭
    Actually the issue may also be the spreadsheet.

    xnn8ahrpkt3n.png
  • AdmiralMemoAdmiralMemo ✭✭✭
    Typo spotted

    "You Loss, Their Gain" collection should be "Your Loss, Their Gain"
  • Sven LundgrenSven Lundgren ✭✭✭✭✭
    My sheet is still telling me to freeze crew that are already frozen.
  • My sheet work fine, i use a fresh datacore import every time and not import from old sheet
  • Sven LundgrenSven Lundgren ✭✭✭✭✭
    I just noticed there is a blank line at the end of the import tab. Deleting those lines seems to have fixed the issue.
  • mr_sparkymr_sparky ✭✭✭
    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.
  • kauthorkauthor ✭✭
    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))))
  • mr_sparkymr_sparky ✭✭✭
    @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.
  • mr_sparkymr_sparky ✭✭✭
    kauthor wrote: »
    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.
  • MururoaMururoa ✭✭✭
    Hi there,
    Do you have any date for next release ?
    Maybe could you release even with some minor quircks ?
Sign In or Register to comment.