topic Re: Get Current Cell Value in iPart and Set name to Part Number in Inventor Forum

Get Current Cell Value in iPart and Set name to Part Number

ngdnam88 — Thu, 18 Jun 2020 11:03:20 GMT

Hi all,

Can you help me about problem. I'm working on iLogic Rules: I wanna get value in Column "Version" and with each of them the Part Number can set automatic? Ex. with Version 001 the Part Number will be set: ../001. Please see the picture that I attached. Thanks,

Re: Get Current Cell Value in iPart and Set name to Part Number

johnsonshiue — Thu, 18 Jun 2020 23:36:26 GMT

Hi! If I understood your request correctly, you should be able to use CONCATENATE() function in Excel to populate the Part Number cell values. You don't need to use iLogic here. iPart was designed to create library components, totally driven by the author table. iLogic rule within iPart factory may interfere the process of driving members.

Many thanks!

Re: Get Current Cell Value in iPart and Set name to Part Number

ngdnam88 — Fri, 19 Jun 2020 01:17:59 GMT

Thanks you very much!

Exactly I wanna get the current cell value at "Version" Column and add a new Value to Cell in another Column after that. Is there any iLogic Rule can do it?. I can't find any topic talking about it. Thanks for your reply,

Re: Get Current Cell Value in iPart and Set name to Part Number

mikejones — Fri, 19 Jun 2020 06:49:56 GMT

Are you able to share the file with the ipart table in it?

Mike

Re: Get Current Cell Value in iPart and Set name to Part Number

ngdnam88 — Fri, 19 Jun 2020 07:24:29 GMT

Yes, of course.

Here's the file that I'm working for iLogic Testing. I'm using the Inventor 2018. Thanks,

Re: Get Current Cell Value in iPart and Set name to Part Number

johnsonshiue — Sat, 20 Jun 2020 18:14:20 GMT

Hi! Please take a look at attached part. Edit the table in Excel and see how Part Number column is formulated.

Many thanks!

Re: Get Current Cell Value in iPart and Set name to Part Number

ngdnam88 — Sun, 21 Jun 2020 04:29:44 GMT

Thanks for your time that you spent for my question.

Thanks for your .ipt file that you reply.

There're some way can do accomplish my intent but I really wanna done it by iLogic. Is it possible by iLogic Rules? The file is an example for my question: "I wanna get the current cell value at "Version" Column and add a new Value to Cell in another Column after that. Is there any iLogic Rule can do it?." If iLogic can't do it I'll closed this post. I think it can be: iPart.CurrentRowValue("columName"), I read some post talked about it but I don't understand how can make it run in the correct way. Thanks for your supporting.

Re: Get Current Cell Value in iPart and Set name to Part Number

johnsonshiue — Sun, 21 Jun 2020 16:46:20 GMT

Hi! It can be done via iLogic. But, I do not suggest you do that using iLogic. Like I mentioned before, iPart/iAssembly was designed to create library components. These components should be totally driven by the table, not by other means. Once the member files are created, they should be stored in a library folder without constant change.

You are trying to use iLogic to drive iPart factory, which violates the assumption. I suspect you are trying to do configuration workflow. I think you should simply use iLogic without using iPart. You can focus on making one configuration via iLogic rule. Then you use iLogic Design Copy to create another version.

Many thanks!

Re: Get Current Cell Value in iPart and Set name to Part Number

ngdnam88 — Sun, 21 Jun 2020 17:14:10 GMT

Thanks Johnson,

Yes, I’m trying creating the configuration workflow. I’ll try to find some similar topics talked about iLogic for iPart/iAssembly. I’ll be happy if you can help me if it’s not to much difficult. Thanks,