07-15-2014, 05:16 PM
Update to the Input page. I tried to make the spreadsheet import function a little more stable and less error prone. So the following changes have been implemented.
First and foremost the first three lines of the import still have to be player id, 1st line, Player name, 2nd line, turn number 3rd line. All have to be in the first column. Extra columns in each row are now ignored.
Second the import now ignores headers AFTER THE FIRST THREE LINES meaning that you don't have to remove the headers before you import the sheet. So headers that you use in your sheet for ease of readability and making sure you get the right numbers in the right columns can be exported with the sheet.
Third the import now looks at each ACTION NUMBER and sends it to the appropriate line number on the sheet. So for instance if you happen to have actions out of order on your sheet they will be imported in Action Number order. However word of caution. Duplicate numbers will be a problem. If you have two action 10's for instance for some reason only the last one will be imported. The first one will be overwritten by the second one. Sorry until I get some time to check for duplicates before the import you'll have to make sure you don't have duplicates in your sheet.
Fourth the import now ignores blank lines no matter where they occur in the sheet.
Fifth the import now ignores extra columns or missing columns at the end of all lines. So you could have 20 extra columns on one line or just have 2 or 3 columns total on a line.
Sixth you'll notice a button that now has some ship builds in it. Work in progress but thought you'd like to see what's coming up.
First and foremost the first three lines of the import still have to be player id, 1st line, Player name, 2nd line, turn number 3rd line. All have to be in the first column. Extra columns in each row are now ignored.
Second the import now ignores headers AFTER THE FIRST THREE LINES meaning that you don't have to remove the headers before you import the sheet. So headers that you use in your sheet for ease of readability and making sure you get the right numbers in the right columns can be exported with the sheet.
Third the import now looks at each ACTION NUMBER and sends it to the appropriate line number on the sheet. So for instance if you happen to have actions out of order on your sheet they will be imported in Action Number order. However word of caution. Duplicate numbers will be a problem. If you have two action 10's for instance for some reason only the last one will be imported. The first one will be overwritten by the second one. Sorry until I get some time to check for duplicates before the import you'll have to make sure you don't have duplicates in your sheet.
Fourth the import now ignores blank lines no matter where they occur in the sheet.
Fifth the import now ignores extra columns or missing columns at the end of all lines. So you could have 20 extra columns on one line or just have 2 or 3 columns total on a line.
Sixth you'll notice a button that now has some ship builds in it. Work in progress but thought you'd like to see what's coming up.