<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Part List - Change Values in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/part-list-change-values/m-p/7908521#M82936</link>
    <description>&lt;P&gt;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....&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;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.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 621px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/484394i06F76C29099383A3/image-size/large?v=v2&amp;amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
    <pubDate>Wed, 04 Apr 2018 17:53:27 GMT</pubDate>
    <dc:creator>MechMachineMan</dc:creator>
    <dc:date>2018-04-04T17:53:27Z</dc:date>
    <item>
      <title>Part List - Change Values</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/part-list-change-values/m-p/7908380#M82935</link>
      <description>&lt;P&gt;Hi guys,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I want to know if it's possible to copy the values in the QTY. Field to the ITEM QTY field. (Image 1)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;Thanks for the help.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Ricardo&lt;/P&gt;</description>
      <pubDate>Wed, 04 Apr 2018 17:04:35 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/part-list-change-values/m-p/7908380#M82935</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-04-04T17:04:35Z</dc:date>
    </item>
    <item>
      <title>Re: Part List - Change Values</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/part-list-change-values/m-p/7908521#M82936</link>
      <description>&lt;P&gt;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....&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;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.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 621px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/484394i06F76C29099383A3/image-size/large?v=v2&amp;amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 04 Apr 2018 17:53:27 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/part-list-change-values/m-p/7908521#M82936</guid>
      <dc:creator>MechMachineMan</dc:creator>
      <dc:date>2018-04-04T17:53:27Z</dc:date>
    </item>
    <item>
      <title>Re: Part List - Change Values</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/part-list-change-values/m-p/7909954#M82950</link>
      <description>&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I tried your solution but doesn't work like i show on the image 1.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Is there any other solution?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thank you.&lt;/P&gt;</description>
      <pubDate>Thu, 05 Apr 2018 08:05:56 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/part-list-change-values/m-p/7909954#M82950</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-04-05T08:05:56Z</dc:date>
    </item>
    <item>
      <title>Re: Part List - Change Values</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/part-list-change-values/m-p/7909962#M82952</link>
      <description>&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Image 1.png" style="width: 315px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/484603i037D3C589601E675/image-size/large?v=v2&amp;amp;px=999" role="button" title="Image 1.png" alt="Image 1.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 05 Apr 2018 08:05:36 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/part-list-change-values/m-p/7909962#M82952</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-04-05T08:05:36Z</dc:date>
    </item>
    <item>
      <title>Re: Part List - Change Values</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/part-list-change-values/m-p/7911057#M82967</link>
      <description>&lt;P&gt;Something like this should accomplish what you want...&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;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&lt;/PRE&gt;</description>
      <pubDate>Thu, 05 Apr 2018 14:10:01 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/part-list-change-values/m-p/7911057#M82967</guid>
      <dc:creator>MechMachineMan</dc:creator>
      <dc:date>2018-04-05T14:10:01Z</dc:date>
    </item>
  </channel>
</rss>

