Importing from clipboard

Importing from clipboard is very similar to importing from any text based files like *.txt, *.csv or *.*.

Before importing data from clipboard, it is necessary to prepare relevant data for import. In Excel, Notepad, Word, or any other editor (spreadsheet) choose the portion of data you want to import into CutLogic 2D. Then copy selected data to clipboard. Click the selected data with the right button of a computer mouse and choose "Copy" in popup menu or [Ctrl+C]. Data saved in this way is always at your disposal for import. 

 

Having prepared data in clipboard you can start with import by pressing keyboard shortcut [Ctrl+J]. Import mapping form in our case shows following:

First we have to setup options in order to format source data from the clipboard to the form suitable for the fields mapping. In our case we have activated option "First row is fields info" and we have set "Field delimiter char" on "TAB" value.

Now we can start to map the source fields to the destination fields. By left click on given "Source field" in the Field mapping table mapping list of available source fields opens.

Now we can pick one source field to map it on given destination field.

We continue until all mapping is finished.

Now we can click the [Import] button and after import is done we can start to work with imported data:

Importing from Access db file

Import from Access db files (*.mdb, *.accdb) is very similar to imports from any table based files like Microsoft Excel ( *.xls or *.xlsx ).

After defining the path to the import file and selecting of desired file following Import mapping form opens:

Now we can start mapping. In our case we have used "Default Value" feature for field "Qty" because of some source data in Access file have no values and "Multiply by" column has been set to 10 on "Qty".

Now we can click the [Import] button and we can start to work with imported data.

Importing via connection file

Import via connection files extremely extends importing capabilities of CutLogic 2D. Connection file is a file containing information how to connect to existing data source via specific ODBC or OLE DB driver installed on computer where CutLogic 2D runs. Connection file is simple text file with one line including connection definition, e.g. for MSSQL, file ThisSampleFile.connection would include:

       Provider=SQLOLEDB;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

For more information how to define connection string in your specific case see http://www.connectionstrings.com or other sources or contact your administrator.