Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Part List - Change Values

Anonymous

Part List - Change Values

Anonymous
Not applicable

Hi guys,

 

I want to know if it's possible to copy the values in the QTY. Field to the ITEM QTY field. (Image 1)

 

I already try is the second image method but didn't work because I didn't find the name of the QTY Field to put here.

Thanks for the help.

 

Regards,

 

Ricardo

0 Likes
Reply
373 Views
4 Replies
Replies (4)

MechMachineMan
Advisor
Advisor

Information duplication is almost always unnecessary and just adds to the complexity of the problem and increases maintenance required in the future.... I hope you have a good reason for wanting 2 columns of the same information....

 

 

Anyways, did you BROWSER PROPERTIES then go to PARTSLIST then use that in the column you want the values in? (ie; as per your first post, you should be right clicking on your ITEM QTY field and finding the "Item qty" property likely.

 

Capture.PNG


--------------------------------------
Did you find this reply helpful ? If so please use the 'Accept as Solution' or 'Like' button below.

Justin K
Inventor 2018.2.3, Build 227 | Excel 2013+ VBA
ERP/CAD Communication | Custom Scripting
Machine Design | Process Optimization


iLogic/Inventor API: Autodesk Online Help | API Shortcut In Google Chrome | iLogic API Documentation
Vb.Net/VBA Programming: MSDN | Stackoverflow | Excel Object Model
Inventor API/VBA/Vb.Net Learning Resources: Forum Thread

Sample Solutions:Debugging in iLogic ( and Batch PDF Export Sample ) | API HasSaveCopyAs Issues |
BOM Export & Column Reorder | Reorient Skewed Part | Add Internal Profile Dogbones |
Run iLogic From VBA | Batch File Renaming| Continuous Pick/Rename Objects

Local Help: %PUBLIC%\Documents\Autodesk\Inventor 2018\Local Help

Ideas: Dockable/Customizable Property Browser | Section Line API/Thread Feature in Assembly/PartsList API Static Cells | Fourth BOM Type
0 Likes

Anonymous
Not applicable

My idea is to have a colunm with the original quantity in the model, and have another colunm with the quantity multiply by a factor that i want to send to the factory.

 

I tried your solution but doesn't work like i show on the image 1.

 

Is there any other solution?

 

Thank you.

0 Likes

Anonymous
Not applicable

Image 1.png

0 Likes

MechMachineMan
Advisor
Advisor

Something like this should accomplish what you want...

 

Sub Main()
    Dim oDoc As Document
    oDoc = ThisDoc.Document

    BatchQTY = InputBox("Enter Batch QTY", "Batch QTY", 10)

    oBatchQTYCol = 5
    oCurrentQTYCol = 4

    For Each oSheet in oDoc.Sheets
        For Each oPL in oSheet.PartsLists
            Call ClearPLCol(oPL, oBatchQTYCol)
            Call BatchPL(oPL, oCurrentQTYCol, oBatchQTYCol, BatchQTY)
        Next
    Next
    MsgBox("Done")
End Sub

Sub ClearPLCol(oPL As PartsList, oCol As Integer)
    For Each oRow in oPL.PartsListRows
        oRow.Item(oCol).Value = ""
    Next
End Sub

Sub BatchPL(oPL As PartsList, oCurrentQTYCol As Integer, oBatchQTYCol As Integer, oBatchQTY As String)

  On Error GoTo ErrHandler
    For Each oRow in oPL.PartsListRows
        oCurQTY = CINT(oRow.Item(oCurrentQTYCol))
        oRow.Item(oBatchQTYCol).value = oCurQTY*oBatchQTY
    Next


  On Error GoTo 0
  Exit Sub

  ErrHandler:
    MsgBox("Cannot convert row qty into an integer. This rule is not valid with 
        non integer quantities")
    On Error GoTo 0

End SUb

--------------------------------------
Did you find this reply helpful ? If so please use the 'Accept as Solution' or 'Like' button below.

Justin K
Inventor 2018.2.3, Build 227 | Excel 2013+ VBA
ERP/CAD Communication | Custom Scripting
Machine Design | Process Optimization


iLogic/Inventor API: Autodesk Online Help | API Shortcut In Google Chrome | iLogic API Documentation
Vb.Net/VBA Programming: MSDN | Stackoverflow | Excel Object Model
Inventor API/VBA/Vb.Net Learning Resources: Forum Thread

Sample Solutions:Debugging in iLogic ( and Batch PDF Export Sample ) | API HasSaveCopyAs Issues |
BOM Export & Column Reorder | Reorient Skewed Part | Add Internal Profile Dogbones |
Run iLogic From VBA | Batch File Renaming| Continuous Pick/Rename Objects

Local Help: %PUBLIC%\Documents\Autodesk\Inventor 2018\Local Help

Ideas: Dockable/Customizable Property Browser | Section Line API/Thread Feature in Assembly/PartsList API Static Cells | Fourth BOM Type
0 Likes