.CSV File Creation - YY1
The Neoden machine works with Comma Separated Value (.csv) project files, which require specific formatting for data entry. This import file is utilized to incorporate the component information into the YY1 machine for operation purposes.
Understanding Your Project Files: A Checklist for Success
Please read through the text boxes below where you will find descriptions for the three files referred to in this guide. This is to help you better understand the difference between each file and what purpose they serve during this process.
Export File
This file contains the component information for your project. It provides the data needed to create your .CSV Import File.
Import File
This is the .CSV Import file you create using the data from your Export File (see Figure 2). It contains the component information necessary for the machine's operation in the proper Neoden syntax and is loaded onto the SD card for import into the machine.
Working File
This is the converted .CSV file that is modified after being loaded into the machine and setting your fiducial. Once you complete the steps to select your fiducial, the Import File you created using the .CSV Import File Example Template will be overwritten and replaced by this altered working file.
Please refer to the outline below for rules regarding the creation of your .CSV file. An example template is included below in Figure 2, which demonstrates the correct formatting of an import .CSV file used with Neoden's pick and place machines.
- Text and Headings
- There are 11 columns in total used with the .CSV file.
- When inputting data, there are no commas allowed within the text fields.
- The order, spelling, capitalization, and other formatting styles of the headers found in the provided template must be replicated exactly.
- Numerical Values
- Coordinate values must be in millimeters.
- All numerical values must be positive, except for the rotation values.
- Any rotation value past 180 degrees is automatically translated to the corresponding negative number.
Formatting your .CSV File: Example Template
Each of the header labels are listed below with their descriptions. These headers will populate the 11 columns in the file you create.
- Designator: The component's label / name.
- Footprint: The component's package size.
- The footprint label is used to distinguish unique components and should match similar unique components.
- Mid X-Y, Ref X-Y, and Pad X-Y: Mid X-Y references the center of the component.
- Use the Mid X-Y coordinate for all three sets of values.
- These values are repeated 3 times and must populate 6 columns out of the 11 total.
- Layer: A capital "T" or "B" is used to indicate Top or Bottom component placement. The machine will ignore components on the bottom of the board.
- Rotation: The rotational orientation of the component.
- Comment: The component's value.
- The comment label is used as a descriptor and should be the same for all like parts.
Creating your .CSV File: Steps for Success
- Create a New File: With a computer or other device, create a file containing 11 columns.
- Label the Columns: Label the 11 columns according to the formatting rules outlined in the .CSV Import File Example Template.
- Input Data: With the component information supplied in your Exported File, arrange this data in your new Import File.
- Verify Formatting: Once you have input all component information, refer back to the formatting rules and ensure all columns contain the correct information in the correct format.
- Upload to SD Card: Upload the file onto the SD card once you have finished creating your .CSV file. The SD card is now ready to be loaded into your machine where it will be converted into a Working File.