Import CSV and spreadsheet data

Work through the import wizard

Import a file, check the preview and verify the added records.

Open File → Import. Choose the text/spreadsheet file type, select your file and open it.
The tabular import wizard opens.
On the profile page, select a matching saved profile, or Other for a new format. Click Next.
Reuse a profile only when the column order, units and separators match the new file.
An import profile remembers separators, units, column meanings and assignments. You can create one at the end of this import; none is required beforehand.
On the file-format page, choose pieces, stock, material groups or edge bands.
Set the source unit and, for pieces, Gross or Net. For a spreadsheet, also select its worksheet tab.
For CSV/text, select encoding, field separator and text delimiter. Check that the preview has separate columns and readable letters.
Spreadsheets do not use separator controls.
Set the first and last data rows. Start at row 2 if row 1 contains headings.
For the first trial, leave Ignore rows with errors unchecked, then click Next.
This requires errors to be corrected before the import can proceed.
Use the selectors above the preview to match each column to its contents, such as identifier, length, width, quantity or description.
For pieces/stock without a material column, choose the default material group in Materials. Check type and thickness.
Click Next.
On the following pages, match each source material and edge-band code to its TonCut entry.
The pages depend on the imported data type.
For pieces using projects, choose the destination project or match the source project names. Use Back to correct earlier choices.
On the final page, choose whether to save a new profile, update the selected profile or leave the profile unchanged.
If saving a new profile, enter an unused, nonempty name. For any of the three choices, click Finish.
If the skipped-rows window appears after Finish, compare its list of errors and source row numbers with your file. Use Copy to clipboard to keep the list for checking.
This window appears when Ignore rows with errors is enabled and errors were found.
Use Back to return to the first cell with an error without importing, or Continue to proceed with the remaining rows.
Continue leaves out the listed rows. Check the missing records and quantities before using the imported data for a calculation.
If another import confirmation appears, check its categories and destination before confirming.
In the destination list, compare records, dimensions and total quantities with the source file.
Resolve import errors and skipped rows before accepting the totals or calculating.

TonCut screenshot: Work through the import wizard — Work through the import wizard

Fields that require extra care

A 2D piece or stock item needs a width. Check thickness and material mapping as well as the visible material name.
Surface-structure values need mapping to the expected orientation. Edge-band codes and miter angles also require the correct interpretation.
Stock trimming values must leave usable material.
Continuing past the skipped-rows list gives a partial import. Compare the imported records and total quantities with the source file, and account for every omitted row before calculating.
Save a profile for recurring files only after checking the mapping. A supplier changing column order or units can invalidate an otherwise familiar profile.

Small CSV exercise

This illustrative file uses millimetres, a semicolon separator and a heading row. Map the columns explicitly and choose an existing material group as the default; the column headings are examples, not reserved TonCut keywords.

CSV

identifier;length;width;quantity;description
P01;600;400;2;Side
P02;800;400;1;Shelf

Copy all three lines of the CSV block into a plain-text editor.
Save the file as sample-pieces.csv with UTF-8 encoding.
Open sample-pieces.csv through File → Import.
Choose Other on the profile page and click Next. Select pieces, millimetres, Gross and UTF-8.
Enable only the semicolon separator. Set the first row to 2 and the last to 3, then click Next.
Map the five columns in order: identifier, length, width, quantity, description.
Select an existing 2D material group as the default and, if projects are used, the destination project. Finish the wizard.
Open Options → Configuration → Dimensions. Set millimetres and Gross dimensions in lists, then click OK.
The source unit chosen during import does not set the list display unit.
In the destination piece list, check that there are 2 records containing 3 pieces in total.
Before repeating an import to fix mapping, inspect the records already added to avoid duplicates.
Expected: P01 is 600 × 400, quantity 2; P02 is 800 × 400, quantity 1. Both widths are 400 mm. If P01 and P02 are not visible, reopen configuration from the options menu. On the general page, use the piece identification settings to show identifiers with descriptions. Save with OK and return to the piece list.

KDMax: group and material mapping

Open a supported KDMax export through the KDMax importer. Its wizard presents groups, material and edge-band assignments, and project details. Review the groups to import, match the listed materials and bands to TonCut definitions, then enter the project name and due date. Automatic assignment is a starting point: check thickness and material identity before finishing. The plugin stores material and band mappings for reuse, so review remembered assignments when the source catalogue changes.

Open File → Import, choose the KDMax type and open a supported KDMax export.
In the wizard, mark the piece groups to import and click Next.
On the materials page, assign each source material its TonCut material group and edge band. Check thickness and color, then click Next.
Enter the project name and due date. Use Import on the final page, then check the project and piece quantities in the main window.

Import profiles and tabular export choices

To reuse a checked setup, open the next file with File → Import, select the profile by name on the first wizard page and click Next. Still inspect row range, units, columns and assignments: a profile does not prove that a supplier kept the file format unchanged.

To create a profile, complete the format and column-mapping pages. On the final page, choose to save a new profile and enter a unique name. Check the preview and click Finish. To update an existing profile, select it at the start and choose to update it on the final page. For a one-off change, choose to leave the profile unchanged.

Open Profile Manager from the first or final wizard page. Select the profile, then use its rename or delete action; deletion asks for confirmation. Close the manager to return to the wizard.

Tabular input-data export lets you choose pieces, stock or both; at least one must be selected. Result and batch exports have their own category dialogs.
Do not assume that an import profile also defines the export layout or delimiter. Open a file you have exported in the receiving program and check its headings, units, separators and character encoding.
If a source file changes its format or columns, configure and verify the import preview again before updating the shared profile.