SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

SiePortalDeutsch

Home
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menu temporary not available
- Menue temporary not available
- {{item.title}}

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

Drilling depths according to an external csv file

Created by: m_morgan at: 10/2/2012 3:05 PM (2 Replies)

Rating (0)

Thanks 1

3 Entries

10/2/2012 3:05 PM	Rate (0)
m_morgan Posts: 3 Rating: (0)	Hi - I've hit a brick wall on this problem so I need some help! I have an external .csv text file called DEPTHDAT which contains two columns: ID and OFFSET. ID begins at 0001 and ends at 9999 and offset can be anything from +0.999mm to -0.999mm. The drilling program uses a CYCLE81 to drill to a nominal depth of 50mm, but I want to be able to read through each ID and apply the corresponding offset. So if my file looks like this: TITLE/INFORMATION ID,OFFSET 0001,0.100 0002,-0.200 0003,-0.500 0004,0.300 ... 5000,-0.200 then the output in the program would be the following depths: 1st hole = 50.100mm 2nd hole = 49.800mm 3rd hole = 49.500mm 4th hole = 50.300mm ... 5000th hole = 49.800mm The program runs to around 400 holes, so for the next program, the depths need to be read from 0401 (for example) onwards. I know I need to: 1. Ask the operator to input the ID for the first hole (e.g. 0401); (no idea how to prompt for this input) 2. Read the offset for that line; (using READ function) 3. Add it to the depth parameter for the CYCLE81 drilling depth; 4. Execute the drilling cycle; (using variable as part of CYCLE81 function?) 5. Read the next ID number; 6. Repeat from #2. What is the best way of doing this - can anyone show me an example? I have a little experience in using variables, but not in reading external files. Thanks in advance! Michael Morgan
m_morgan Posts: 3 Rating: (0)
Suggestion To thank Quote Answer

10/2/2012 9:44 PM	Rate (0)
MBA Posts: 594 Rating: (79)	https://www.automation.siemens.com/doconweb/showpdf.asp?item=2419&cd=sinumerik_sinamics_04_2010_e&scope=all&ResultSet=2482&CurrentItem=2482&ResultType=content
MBA Posts: 594 Rating: (79)
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users Pee El Sea

10/29/2012 3:25 PM	Rate (0)
m_morgan Posts: 3 Rating: (0)	I've had a read through the manual and I still can't figure out how to pull the information out of the external csv file according to the operator input. Does anyone have an example of reading an external csv file? Thanks, Michael
m_morgan Posts: 3 Rating: (0)
Suggestion To thank Quote Answer

Share this page:

Share this page on...

SiePortal

Drilling depths according to an external csv file

Created by: m_morgan at: 10/2/2012 3:05 PM (2 Replies)

Rating (0) Thanks 1

3 Entries

m_morgan

MBA

This contribution was helpful to

m_morgan

3 Entries

Follow us on

Rating (0)

Thanks 1