Setting up Inventor in-house procedures and templates, I encountered what I find to be a bug. Else I hope someone can explain this.
I want a second item number (For parts drawings with several parts) which I plan to assign as custom iProperty on each part, so I can use it for reference.
Problem is, if the Data Type for your custom property is "Text", you can't sort it as numbers. Numbers 1 through 14 would be sorted like this:
1
11
12
13
14
2
3
4..etc
I understand that this must be an Integer (number) insted of a String (text) in order to sort correctly, so off course i change the type to Number.
Now, when I input numbers into the cells in my BOM it forces a comma after every number, e.g:
1,
2,
3,
4,
Why are these commas forced? I get it on my custom parts list and my custom balloons.
The odd thing is, it only occurs when filled in from the BOM.
Upon opening the iProperty window of individual parts, I find that these Number type properties works fine. No forced comma here, and everything now works intentional, and show the correct numbers in BOM, Ballons and Parts List.
Check Attachments
Bonus question: You can filter a Parts List defined by View Representations, but I can't find anywhere to do this in the BOM, which make this filter kind of non-intuitive to use. Can someone tell me what I'm missing?
Solved! Go to Solution.
Solved by deehawk. Go to Solution.
First thing I'd look at is the format for that column in your style library..
Since the issue is related to Bill Of Materials, how can this be a style issue? I have no styles determining how BOM acts.
I've looked everywhere in the style libraries; can't find anything related to formatting of Custom properties with Data Type: "Numbers"
It only occurs when putting in data directly into the cell in the open BOM. When inputting from a parts properties dialog, it works fine.
-------------------------------------------------------------------------------------------------------------------------------------
By changing the formatting of balloon and parts list styles, the commas are no longer showing in these 2 instances, but they still exist in the property BOM, and thus in every string referring to that property. E.g:
=<DetaílDWG>(<CustomItemNo>) --> HAD40 020 (5,)
Is supposed to be HAD40 020 (5)
I was a little bit too fast there, you can't format the value in the balloons, only in the column of the parts list. So its still a big problem for my system.
------------------------------
Added info:
The issue seems to be a bug. It has now been logged at autodesk as a case.
It looks like Inventor inputs a Double-value into the property when filled in from the BOM, even for non-decimal numbers. (Then it should be an Integer)
Any progress with this??? I'm using Inventor 2017 and have the UK version of this issue. Entries I make to a numeric iProperty through the BOM turn "19" into "19.0", whereas if I enter them directly in the part iProperties they stay as "19".
And BTW, does it being logged as a BUG count as SOLVED?
It's not really solved, but this is as close as it gets. 'Bug' was my own definition, and not recognized by Autodesk.
I talked with our software supplier, who put me in contact with someone inside Autodesk. It turns out, our supplier could replicate the issue somewhat, but Autodesk couldn't. They said it was likely a system setup issue, or install issue.
Furthermore, I was told inputting your data via the cells in BOM is 'not correct workflow, for which the program was designed', and therefore not supported by Autodesk. Apparently, the BOM interface is more of a friendly extension, than an actual part of the Inventor workflow.
Nonetheless, it's one of the tools I use most often.
I'm still running 2015, But I'm sad to hear my coming update doesn't solve this problem.
I'm doing it the hard way now. Using text instead of numbers, and simply sorting then manually.
I'm having this same problem. Can somybody unsolve this thread so it can be really solved.
When you change the custom iProperty in the part file itself it works without the comma.
Please help.
Regards
Tobias
Hi Tobias
Is there an option to remove the solution? I would be happy to do this, since it's still an issue several releases later.
I think you would have to post a new thread though, and pray for a more cooperative agent.
I myself, accepted the issue as a minor nuisance, and simply use "Text" Type. I do have to manually sort parts list with over 9 items, but in return I can refer to several parts in the same cell, which is used often on our drawings. (i.e. "4, 5, 6")
Godspeed!
I've got the same issue, ridiculous that is not solved yet.
Hope there will be an update soon.
Hi! There is a bit of information missing in the thread. What was the case ID or defect ID? Does anybody have an example to show the behavior?
Many thanks!
When you make a custom iProperty in the BOM you can choose for Data Type: Number.
If you do this it works fine but, if you fill in this value it's adds a comma to the number like this: "3,".
This will also be visible on the drawings when you place this iProperty in a text or something similar.
Hi Johnson.
Thanks for taking time to look into this.
I found the case number: [Case 10589945]
The issue is permanent and not related to single files. It can easily be replicated, if the PC is prone to the issue. Every PC in our company have had this issue for years, even with change of computers and upgrading several releases. I suspect it being a failed translation of some regional settings in windows, but I've not been able to either prove or disprove what happens.
To replicate:
1. Open a non-empty assembly file, and open the Bill of Materials manager.
2. Click the button "Add custom iProperty columns'
3. Name a new column in the dialog and choose 'Number' as it's type and press ok
4. Enter digit in a cell of the new column you just added and press enter.
On our PCs, if you entered "5" it becomes "5," (Denmark)
Another user here seems to get "5.0" (UK)
Comma is the decimal-seperator in DK, while Period is in UK.
The differences with the trailing zeroes also gives a hint of the error behind it.
EDIT: I just noticed that in Inventor Pro 2017, once the cell has a value, it can no longer be left empty (You can't delete the entry)
Thank you guys for providing more information about this case. This issue has been logged into our internal system as Bug INVGEN-7710. Hopefully, Will fix it soon.
Maulik
Now 2 years more later, are there any news on this case?
Still running 2017, but want to upgrade if it solves the issue.
I'm using an updated version of Inventor 2019 Pro, and the issue is still there.. So I think the problem is there forever.
They spend their time on new icons or an another confusing dialog box instead of fixing the major bugs.
Thanks for your reply.
5+ critical bug reports (acknowledged reports even) through the years, and no feedback on any of them afterwards.
Hi Guys,
I checked the latest status of INVGEN-7710. The defect was closed as a limitation. The behavior has something to do with the custom UI control Inventor leverages from our vendor. Unfortunately, there is an option or setting for us to change it. I am sorry.
Many thanks!