Gobilda streamlines the process of managing your bill of materials (BOMs). Uploading a CSV (Comma Separated Values) file is a quick and efficient way to import your part list directly into the platform. This guide will walk you through the steps, ensuring a smooth and successful upload.
Understanding Your CSV File
Before you begin, it's crucial to understand how Gobilda expects your CSV to be formatted. Proper formatting is key to a successful import. The following columns are typically required (check Gobilda's documentation for the most up-to-date requirements):
- Part Number: This is the unique identifier for each part in your list. This is usually a crucial field that Gobilda will use to match against their database, therefore ensuring accuracy. Make sure this is consistent with your existing part numbering system.
- Description: A brief description of the part. This field enhances readability and organization within Gobilda.
- Quantity: The number of each part needed. This is fundamental for accurate BOM calculations.
- Unit Cost: The cost of each individual part. This is essential for cost estimations and analysis.
- Supplier: The name of the supplier providing the part. This helps with traceability and inventory management. This is optional but highly recommended.
Important Note: Gobilda might accept additional columns depending on your specific needs and project setup. Refer to Gobilda's official documentation for a definitive list of accepted columns and their data types.
Preparing Your CSV File
-
Use a Spreadsheet Program: Create your part list using a spreadsheet program like Microsoft Excel, Google Sheets, or LibreOffice Calc. This will help you maintain the correct formatting and easily manage your data.
-
Correct Formatting: Ensure your data is neatly organized in columns, with each column header clearly matching the required fields in Gobilda (Part Number, Description, Quantity, Unit Cost, Supplier etc). Avoid extra spaces or inconsistent formatting that might cause import errors.
-
CSV File Type: Save your spreadsheet as a CSV file (.csv). Ensure that the file is properly saved and not corrupted.
Uploading Your CSV in Gobilda
The exact steps might vary slightly based on your Gobilda version, but generally follow these guidelines:
-
Login to Gobilda: Access your Gobilda account.
-
Navigate to Part List Import: Find the section related to importing or managing your part list. This is usually within the BOM or Project management section. The exact location may vary; check Gobilda's help documentation if needed.
-
Select CSV File: Choose the "Import CSV" or equivalent option, and then browse your computer to select the CSV file you prepared.
-
Review and Upload: Gobilda might provide a review screen to verify the data before uploading. Carefully check that the data is correctly parsed and mapped to the relevant fields. Once verified, click the "Upload" button.
-
Verification and Troubleshooting: After uploading, Gobilda will likely display a confirmation message, or may list any errors encountered during the import process. If you experience errors, review your CSV file for formatting inconsistencies or data errors. Refer to Gobilda's help resources or support for assistance.
Optimizing Your CSV Upload Process
- Regularly Update Your CSV: Maintain an updated CSV file to reflect changes in your BOM. This will make future updates much easier.
- Automate the Process: For large projects, consider automating the CSV creation and upload process using scripts or integrations with your existing data management systems.
- Data Validation: Before uploading, validate your CSV data to identify and correct any errors. This will prevent import issues and ensure data accuracy.
By following these steps, you can efficiently upload your CSV part list into Gobilda, significantly accelerating your project management workflow. Remember to always consult Gobilda’s official documentation for the most accurate and up-to-date information on importing data.
