FAQ: Is it possible to transfer cam data from Mircosoft Excel to an MP controller?
Breadcrumb
Contact Us
contactUsAction
Yes. The following steps describe the process.
1) Save the file as *.CSV
2) Open Yaskawa's 'Cam Tool' software, select 'Import' under the 'File' menu and open the CSV file.
3) Enter the 'Max Phase Value' (master cycle) and 'Max Position Value' (slave cycle) suitable for the data, and select OK for 'Set Style' and 'Set Parameter' windows.
4) Save file as *.CDD.
5) Log online to the MP controller with MotionWorks Software.
6) Select 'File Transfer' under 'File' menu in 'Cam Tool' software.
7) Choose the CDD file for source, Double-Length for data type, and first register address, then select OK.
Attached is an example documenting the transfer of a cam table created in Excel.
When creating the cam table in Excel, the following rules should be taken into account:
a. The master data must start at 0.
b. There must not be repeated master entries. Ex: 1, 2, 3, 3, 4,etc.
c. The master points must be in increasing sequence. Ex: 1, 2, 3, 2, 5,etc.
d. Gaps in between data points are allowed. Ex: 1, 2, 4, 5, 8,etc.
The CSV file will fail to import if these guidelines are not kept.
Another way to transfer a CSV file to an MP controller is possible using CSVTool, a VB applet.
Attached below are the CSVTool VB exe file and CSVTool users manual.
View other ways to transfer registers.
SAFETY PRECAUTIONS AND INSTRUCTIONS FOR USE OF FAQ INFORMATION!
Please read and understand the product instruction manual before installing, servicing or operating Yaskawa products. FAQ content and illustrations are provided as technical advice to augment the information in manual, not supersede it. It is not possible to give detailed instructions for all types of installation or support activities. The information described in the FAQs are subject to change without notice to improve the product or FAQ. Yaskawa assumes no responsibility for errors or omissions or damages resulting from the use of the information contained in any FAQ. All warnings, cautions and product instruction for product use must be followed. Installation, operation and maintenance should be carried out by qualified personnel. Failure to observe these and other precautions highlighted in the product manuals will expose the user to high voltages resulting in, serious injury or death. Qualified personnel are defined as individuals who are familiar with the installation, starting, operation and maintenance of Yaskawa products of the type described and have proper qualifications to perform the work.
Phone
If you have an urgent request, please call: 1-800-YASKAWA (927-5292) or 1-847-887-7000.Electronically
To contact us electronically, please select your type of request and complete the form.Yaskawa America, Inc. - Drives & Motion Division
2121 Norman Drive South
Waukegan, IL 60085