{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["History","READ ME","Shortcuts","Ref. Data Files","Options","Custom Fields","User","Entries","Condition","Database","Currency"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":81,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"History","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Version","Date","Author","Comment"]
["0.1","2019-12-31","Alain LM","Creation from TS N-scale bulk entry v2.5.xlsm.\nDifferent formatting of data as inventory upload uses a CSV file instead of reading an input field in an HTML page."]
["1.0","2020-01-04","Alain LM","First release"]
["1.1","2020-01-13","Alain LM","- Added Roadname.\n- Removed Workbook protection."]
["1.2","2020-01-19","Alain LM","- Handles properly empty cells resulting from a formula (hidden value = 0).\n- Cells type is Standard instead of Text to allow for formulas to display content properly.\n- Option added: No warning for acquisition date, by default\n- Check of emuns is case insenstivite\n- New extensions for output file and log file\n- Added file information as first line of output file, for verification at upload"]
["2.0","2020-02-23","Alain LM","New Collection fields:\n- Location\n- Source\n- Condition\n- Custom Date 1 & 2\n- Custom Cost 1"]
["2.1","2020-04-09","Alain LM","- Reworked dialog boxes at first launch to make them more explicit regarding the required files.\n- Renamed 'Parameters' tab to 'Ref. Data Files' for improved clarity\n- More options in the input menu:\n  + Generate the Excel Data file\n  + Open the Excel Data on local computer\n- Filters on the Entries page"]
["2.2","2020-04-12","Alain LM","More options:\n- Check/Ignore warning on DCC address value\n- Log Fatal Errors and ignore row instead of aborting generation"]
[]
[]
["© 2018-2020 Alain LM and TroveStar"]
[]
["Current release:",{"$f":"A8","v":"2.2"}]

{"sheet":"READ ME","index":1,"n_rows":61,"n_cols":1,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
["Collection upload tool"]
[]
["Welcome to the TroveStar personal collection upload tool."]
[]
["First things to do! (in the indicated order)"]
["1. Select a Database"]
["Select the Dabase for which you want to create a collection. By default, this is the N Scale Model Trains database."]
["Click here to select a Database on the \"Ref. Data Files\" tab."]
[]
["2. Download a Reference Information file (aka Traverse)"]
["The Reference Information file (Traverse) is the one that contains all enumerations needed for this upload tool to work.\nWithout a valid Traverse file, you will not be able to create entries in a proper way.\nYou can generate and download this file, in XML format, from this page on the TroveStar website:"]
[{"$f":"HYPERLINK(TraverseFileURL & Database_ID, \"Click here to generate new Traverse file from website\")","v":"Click here to generate new Traverse file from website"}]
["Note that you can also find this link in the Excel \"Add-In\" menu, option \"Input\""]
["Then just re-open this upload tool file and select the XML Traverse file that you have downloaded on your computer, when prompted to do so.\nAfter selection of the XML file, this will launch selection of save path and name for the Excel Data file that will be then formatted from this XML file.\nPlease note that the formatting of the file could take a while, so be patient.\nThe file that will be used by the tool is the formatted Excel Data file; so in the end, all that you need is a valid Excel Data file (Traverse)."]
["You can also replace an existing Excel Data file by going on the \"Ref. Data Files\" tab and using the buttons on that tab (select Reference Information XML first, then generate Excel Data XLS)."]
["Note that you can also do this from the Excel \"Add-In\" menu, option \"Input\""]
[]
["3. Customize the labels of your custom fields"]
["Use the same labels that you use on the TroveStar website for the selected database. This is not mandatory and will not affect the generation of the file if you don't do it or if the labels in this Excel sheet to not match the ones on the website."]
["Click here to go to the \"Custom Field\" tab."]
[]
["Where are the commands?"]
["All the commands are available in the Excel \"Add-In\" menu on Excel top menu bar\n(you might need to activate it by right clicking on the menu bar, then 'Customize the Ribbon', and selecting 'Add-In' on the right-hand side of the dialog box that shows up).\nSome commands have a keyboard shortcut that is recalled on the main \"Entries\" tab (click on \"Show Instructions\" button)."]
[]
["How does it work?"]
["The main tab to work with is \"Entries\".\nFrom there, you can add, duplicate or delete entries.\nFor each entry, you create a new row/line. All fields that are available for a Collection member are present. Note that not all of the fields are mandatory."]
[]
["To create a new entry: \"Add a Line\", in the \"Edit\" menu (or use the shortcut indicated after clicking \"Show Instructions\" button).\nTo delete a row, just use the usual Excel way.\nMore edit commands are available in the \"Edit \"menu.\nFirst thing is to select the Brand from the drop-down menu. If you can't find your Brand, please contact a Curator (note that no Brand wil be available without a valid Traverse file).\nThen fill in all the required information for the entry. Some fields are constrained, so please use the dropdown list in this case."]
[]
["What information should I provide?"]
["Our upload procedure on the TroveStar website will try to identify existing items in the database matching each and every entry in your Excel file.\nWe use primarily 3 information: Brand, Stock Number and Road Number. If you really don't know the Brand you can use Road Name in addition, but we recommend using Road Name + Number as the last resort; otherwise don't even fill out the Road Name.\nThe best chance to get a match is to provide all 3. However, in many cases Brand and Stock Number can be enough. Some manufacturers have released several different Road Numbers of the same model, using the same Stock Number, hence the need for this 3rd information in certain cases. Note that we don't need the Road Name when you have provided these 3 information already.\nWhen uploading the file, you will get a full report of entries that have a match, those which cannot be found in the Database (hence not added to your collection) and those for which multiple matches have been found (in this case we use the first one, but this might require manual verification)."]
["For Stock Number (manufacturer's code), remove all prefixes that you may have used and keep only the significant numbers and letters. Though in some cases, we have entered in the database a manufacturer prefix when this prefix is part of the official stock number, for example ScaleTrains.com SXT10985, in most case there is no prefix; for instance, use 20010 instead of MTL-20010 for Micro-Trains 20010. Similarly if you are using Walthers SKUs, remove the manufacturer's number at the beginning: for instance, Micro-Trains 489-10100040 should be entered as 10100040 or 101 00 040 (spaces and hypthens will be ignored during the search)."]
["For road numbers, if you have a list, e.g. for a multi-packs, the search will be made on the last number. You can add a list separated by spaces, commas or semi-colons."]
["If you have a doubt or an error or multiple hits, you can check your item manually using our on-line train search page:"]
[{"$f":"HYPERLINK(\"https://trovestar.com/general/Search/callback.php?Action=TrainSearch&Collection=\" & Database_ID, \"Click here to search a train on website\")","v":"Click here to search a train on website"}]
[]
["How do I make the link with my existing inventory in Excel?"]
["The best would be to copy the worksheets of your existing inventory in this Excel file. From there you can make links between your data and the Entries tab of this file. By doing this, you can continue to use your own format as the reference, and then automatically generate a file to update your on-line inventory on TroveStar."]
["The only things that you will have to maybe modify in your original file are Brands and Couplers (and possibly Road Names if you use them) as you need to use the very exact terms as in the dropdowns from the Traverse file (depicted above). Note that for these fields, it is possible to create your own dropdowns using Excel Data Validation (use ‘List’ under ‘Allow’), using the following names =BrandsList (resp. =CouplerTypeList, =RoadnameList) as source. Meaning that you can also use these enums in your original file/worksheets by using this Excel feature. "]
[]
["How to I upload my list in the TroveStar database?"]
["Go to the Generate and Upload menus, where you'll find several options."]
[]
["Generate:\nCreates a text file (.txt) with all entries, in the same directory as this Excel file. The name of the file is the same as this Excel file, followed by -upload_data.txt\nThen upload this file - WITHOUT ALTERATION - from the TroveStar Upload page (link in Upload menu).\nWe strongly recommend that you do not alter the contents of the generated file, as you could introduce errors that could result in unpredictable results."]
[]
["Upload:\nIn the Upload menu, select the appropriate option:"]
["- Open Upload page: will give you all options\n- New Collection Upload: to create a new collection with the contents of this Excel sheet\n- Incremental Upload: to add the contents of this Excel sheet to an existing collection"]
[]
["The tool refuses to generate the data to upload!"]
["You have a serious error in your data. Please check the log file or read the error message in the checking area (menu Check or button Show Check Area). Mandatorily fix the issue(s) to be able to generate data to upload."]
[]
["There are warnings during generation!"]
["Warnings will not prevent upload of data, but it would be a good idea to check what they are, and clear them before uploading, otherwise you may create undesired information. Please check the log file or read the warning message for the indicated row in the checking area (menu Check or button Show Check Area)"]
[]
["Some recommendation before going for large uploads."]
["Before you start a large series, it is very recommended to process upload in simulation mode first and check the result on the TroveStar site before proceeding any further. This will show you errors, missing items, duplicates, etc. From there you can fix you own data and/or add missing items in TroveStar."]
["Remember that this tool allows you to easily create new collection members but not to delete them. However if you have made a mistake in one of the fields, you can update this Excel sheet, generate a new file and upload it. In the incremental upload form, there is a mode that will allow you to update the information without changing the quantities."]
[]
["Miscellaneous - Text fields and HTML"]
["Some text fields such as 'Notes' accept HTML tags.\nYou can use line breaks any Excel cell: they will be transformed automatically into a HTML line break when generating the file."]

{"sheet":"Shortcuts","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Instructions:"]
["Add a line","CTRL+M","Adds a line at the end of the list"]
["Add multiple lines","CTRL+SHIFT+M","Adds the number of specified lines at the end of the list (opens a dialog box)"]
["Remove lines",null,"Select the line(s) and delete them with regular Excel command"]
["Duplicate line","CTRL+SHIFT+D","Duplicates the line on which the selected cell is"]
["Duplicate line multiple","CTRL+SHIFT+F","Duplicates the line on which the selected cell is, the number of times specified (opens a dialog box)"]
["Generate Output File","CTRL+SHIFT+G","Generates the output file, in same directory as this Excel spreadsheet"]

{"sheet":"Ref. Data Files","index":3,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[{"$f":"HYPERLINK(TraverseFileURL & Database_ID, \"Click here to generate new Traverse file from website\")","v":"Click here to generate new Traverse file from website"},"Parameters"]
[]
["Reference Information file"]
["Path XML:"]
["Name XML:"]
["Excel Data file"]
["Path XLS:"]
["Name XLS:"]
[]
["Version/Last generated:",{"$f":"TraverseVersion","v":{"$error":"#REF!"}}]
[]
[]
[]
["Database:","N Scale"]
["Database ID:",{"$f":"VLOOKUP(B14, Database_table, 2)","v":4}]

{"sheet":"Options","index":4,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Upload Options"]
["Check Acquisition Date","No"]
["Check Cost/Prices","No"]
["Check DCC Address","No"]
["Abort Generation on Error","Yes"]
[]
[]
[null,"Yes"]
[null,"No"]

{"sheet":"Custom Fields","index":5,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[{"$f":"HYPERLINK(\"https://trovestar.com/general/cart/callback.php?Action=CartCustomize&Collection=\" & Database_ID, \"\")","v":""},{"$f":"HYPERLINK(\"https://trovestar.com/general/cart/callback.php?Action=CartCustomize&Collection=\" & Database_ID, \"Collection Upload Options\")","v":"Collection Upload Options"}]
["Custom Field 1 Label:","My Custom 1"]
["Custom Field 2 Label:","My Custom 2"]
["Custom Field 3 Label:","My Custom 3"]
["Custom Date 1 Label:","My Date 1"]
["Custom Date 2 Label:","My Date 2"]
["Custom Cost 1 Label:","My Cost 1"]

{"sheet":"User","index":6,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
["TroveStar Account email address:"]
["TroveStar Account Name:"]
["TroveStar ID:",null,"Click here to see your profile"]
[null,"Please fill in your TroveStar ID.\nNot required for this tool."]

{"sheet":"Entries","index":7,"n_rows":22,"n_cols":22,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,1,16,19]]}
[]
[{"$f":"Shortcuts!A1","v":"Instructions:"}]
[{"$f":"Shortcuts!A2","v":"Add a line"},{"$f":"Shortcuts!B2","v":"CTRL+M"},{"$f":"Shortcuts!C2","v":"Adds a line at the end of the list"}]
[{"$f":"Shortcuts!A3","v":"Add multiple lines"},{"$f":"Shortcuts!B3","v":"CTRL+SHIFT+M"},{"$f":"Shortcuts!C3","v":"Adds the number of specified lines at the end of the list (opens a dialog box)"}]
[{"$f":"Shortcuts!A4","v":"Remove lines"},{"$f":"Shortcuts!B4","v":0},{"$f":"Shortcuts!C4","v":"Select the line(s) and delete them with regular Excel command"}]
[{"$f":"Shortcuts!A5","v":"Duplicate line"},{"$f":"Shortcuts!B5","v":"CTRL+SHIFT+D"},{"$f":"Shortcuts!C5","v":"Duplicates the line on which the selected cell is"}]
[{"$f":"Shortcuts!A6","v":"Duplicate line multiple"},{"$f":"Shortcuts!B6","v":"CTRL+SHIFT+F"},{"$f":"Shortcuts!C6","v":"Duplicates the line on which the selected cell is, the number of times specified (opens a dialog box)"}]
[{"$f":"Shortcuts!A7","v":"Generate Output File"},{"$f":"Shortcuts!B7","v":"CTRL+SHIFT+G"},{"$f":"Shortcuts!C7","v":"Generates the output file, in same directory as this Excel spreadsheet"}]
[]
["Check","Note: to refresh, type another row number and then re-type the row number you want to check"]
["Row/Line to read:",22]
["Result string:",{"$f":"composeArguments(B11)","v":"#VALUE!"}]
["String length:",{"$f":"LEN(B12)","v":7},"Max:",{"$f":"975-LEN(\"DATA=\")-LEN(\"SubmitFlag=AUTO\")","v":955}]
["Error:",{"$f":"TestComposeError(B11)","v":true}]
["Error message:",{"$f":"TestComposeErrorMessage(B11)","v":"You must specify at least the following search terms:\n- either Stock Number,\n- either Brand with Road Name or Number,\n- either Road name and Number."}]
["Warning:",{"$f":"TestComposeWarning(B11)","v":false}]
["Warning message:",{"$f":"TestComposeWarningMessage(B11)","v":""}]
[null,null,null,null,1,0,0,0,null,"1900-01-01"]
[13,1,22,6]
["Brand","ProductCode","RoadName","RoadNumberText","quantity","value","cost","secondaryCost","customCost1","acquisitionDate","source","customDate1","customDate2","location","conditionState","CouplerType","DCCAddress","DCCDecoder","custom1","custom2","custom3","notes"]
["Brand","Stock Number","Road Name","Road Number","Quantity","Current Value","Purchase Price","Secondary Costs",{"$f":"CustomCost1_label","v":"My Cost 1"},"Acquisition Date","Source",{"$f":"CustomDate1_label","v":"My Date 1"},{"$f":"CustomDate2_label","v":"My Date 2"},"Location","Condition","Coupler Type","DCC Address","DCC Decoder",{"$f":"Custom1_label","v":"My Custom 1"},{"$f":"Custom2_label","v":"My Custom 2"},{"$f":"Custom3_label","v":"My Custom 3"},"Notes"]
[null,null,null,null,1,0,0,0,null,"1900-01-01"]

{"sheet":"Condition","index":8,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Condition"]
[]
["New"]
["New, Shrink Wrapped"]
["New, Unwrapped"]
["Mint"]
["Excellent"]
["Good"]
["Fair"]
["Poor"]
["Repair"]
["Incomplete Set"]
["Parts"]
["Built"]
["Partly Built"]
["Unbuilt"]

{"sheet":"Database","index":9,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Name","ID"]
["N Scale",4]
["Z Scale",42]
["HO Scale",34]

{"sheet":"Currency","index":10,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["RECORD","Collection","Attribute","name","id","longname","symbol","precision","symbol placement",null,"List name:","CurrencyList"]
["ENUM_VAL",4,42,"CAD",6,"Canadian Dollar","C$",2,0,null,"Table name:","CurrencyTable"]
["ENUM_VAL",4,42,"CHF",7,"Swiss Franc","CHF",2,1]
["ENUM_VAL",4,42,"EUR",2,"Euro","€",2,1]
["ENUM_VAL",4,42,"GBP",4,"British Pound","£",2,1]
["ENUM_VAL",4,42,"JYP",3,"Japanese Yen","¥",0,1]
["ENUM_VAL",4,42,"USD",1,"US Dollar","$",2,0]
["ENUM_VAL",4,42,"XXX",5,"Non Currency",null,2,0]