Custom exports module allows you to define and run your own custom exports. ("File > Custom exports" or Ctrl+E)
Export name: Name of export. If some exports have same name, and one of them is run, all will run.
Run type values:
•Manual
•Manual in menu > Export will be accessible also via menu "File > Exports".
•Auto after plan optim > Export will run automatically after plan is optimized.
•Auto after plan close > Export will run automatically after plan is closed.
•Auto after plan open > Export will run automatically after plan is opened.
Format values:
•xml (plan) > Export of cutting plan including cutting layouts into XML file.
•csv > Export to CSV file using custom SQL query.
Output file: Name of export file.
File write values:
•Rewrite > Output file is rewritten by export data.
•Append > Export data are appended to output file.
•Append with empty line > One empty line and export data are appended to output file.
•Rewrite with empty line > If multi-selected data are exported, each data block will be followed by empty line.
Private: If multiple users share same database over LAN, each can make his exports private, non-visible to other users.
Options (for csv exports):
•Delimiter > Field delimiter.
•Quote > Quotation mark used to quote fields which include delimiter. To quote each field, double the quotation mark, for example Quote="".
•Header > 0 - export will not include field names, 1 - field names will be included once, 2 - field names will be included for each block appended
SQL: Here you can define your SQL query.
Masks you can use in output file name:
•%expspath% > Represents standard CutLogic folder C:\ProgramData\TMachines\CL2D\Exps\.
•COM > Output will be sent to (virtual) serial port. You can set serial port properties at "Tools > Options > Serial port".
Masks you can use in output file name and SQL query:
•ActPlanID > ID of selected plan.
•ActPlanSouID > ID of selected stock in selected plan.
•ActPlanPartID
•ActMatID
•ActMatSouID
•ActMatPartID
•ActMatSettID
•ActStorID
•ActStorSouID
•ActAssemID
•ActAssemPartID
•ActRepID
•ActPlanNum > Number (#) of selected plan.
•ActMatNum
•ActStorNum
•ActAssemNum
•ActRepNum
•ActPlanDes1 > Description of selected plan.
•ActMatDes1
•ActStorDes1
•ActAssemDes1
•ActRepDes1
Masks you can use for field names in SQL queries:
• _l > Transforms length value from database internal format to format set in CutLogic, for example select Len * 10 Length_l from Parts.
• _a > Transforms area value from database internal format to format set in CutLogic, for example select Len * Wid Area_a from Parts.
Press button Run to run selected export. (F3 or Ctrl+Enter)
Press button Insert to enter mask into SQL query.
Press button Copy to copy result of export into clipboard.
Custom exports support multi-selected data. For example if you multi-select 5 plans, and then run export in Custom export form, all 5 plans will be exported.