Inventory Import (v3.7.0 - MAY 2024)
Inventory Import - Bring along your Inventory records from your Excel or other sources
[non-English articles provided by machine translation of the English original]
Do you have a big portion of your boat’s inventory already in some
digital form? This is great since TheBoatApp provides you with the
ability to import all your Inventory records in bulk. No need to
manually enter each item. Simply follow a few easy steps to curate your
digital data and then import them as your boat’s Inventory. Following
this, you will be able to get all the advantages of tracking your
Inventory’s costs, expirations, maintenance tasks & logs, etc.
How to Access the Inventory Import
Access the respective module where you want to import your data, click
the three-dots menu button on the right-side and select the “Import”
option.
How to Curate your Data for Import
Selecting “Import” will prompt you to use a Coma-Separated-Values (CSV) template
Download here the CSV template. You may use a text-editor to edit the CSV template, but you are advised to better use Excel or some spreadsheet app to be able to better and easier work with your data in a tabular form (table)
Open your Excel/CSV data (if you have your data in some other app/format, export/convert them in Excel/CSV)
Open the provided CSV template
Start migrating data from your CSV/Excel to the provided CSV by using the column-headers to add the data where they belong: e.g. the inventory name, quantity, expiration date, reminder date, etc. Especially for the DATES, make sure that you use in CSV the same date-format you have in your TheBoatApp settings.
When done, save the file as CSV (UTF encoding)
How to Import your Data
Select CSV file to be imported
Select the boat where the records will be imported
Change the separator if it is needed.
Select date format that matches you records date format
Click import and wait until the file is uploaded and processed.
If there are errors during validation you will see the list of the errors.
Check the Inventory table-view to confirm that your data are properly imported
Troubleshooting
If you have any data discrepancies, you need to re-check your source (CSV file):
for a few/light discrepancies, simply edit the already imported records directly in TheBoatApp
for many problematic records is better to go back to your source data (CSV file):
delete the problematic records in TheBoatApp
make a copy of your CSV, keeping ONLY the problematic records you have removed in TheBoatApp
Edit the new-CSV and re-check carefully the problematic records
Save as CSV (UTF encoding)
Import anew
Re-check
Related Articles
Why not use my paper or even electronic spreadsheet (Excel) tables?
[non-English articles provided by machine translation of the English original] About tables and spreadsheets, we have all started with Excel (…or even Lotus 1-2-3 back in the ’80s for some old-timers!). Spreadsheets have the huge advantage of being ...
Inventory (v2.13.0 - APR 2023)
See also the Inventory (v2.13.0) video tutorial. Inventory - Catalogue your equipment, tools, consumables, etc. [non-English articles provided by machine translation of the English original] TheBoatApp includes an Inventory module for the full ...
Alerts
See also the Alerts video tutorial. Alerts - View your alerts, be reminded and act in time [non-English articles provided by machine translation of the English original] TheBoatApp includes an Alerts module providing a central view of all configured ...
Operations Log (v2.13.0 - APR 2023)
See also the Operations Log (v2.13.0) video tutorial. Operations Log - Document all information about your maintenance, tasks and costs. [non-English articles provided by machine translation of the English original] TheBoatApp includes an Operations ...
Costs (v2.13.0 - APR 2023)
See also the Costs (v2.13.0) video tutorial. [to-be-released] Costs - Book and track the costs of your operations, inventory, maintenance, tasks, etc. [non-English articles provided by machine translation of the English original] TheBoatApp includes ...