When it comes to BOM (Bill of Material) Inventor play a good role, but unfortunately database are still use for keeping track of order, vender part number etc., plus the communication between the software are very minimal. Today I’ve decided that I would write a post or 2 a month on a great Add-on product for Inventor. This Add-on is a product offered by Netstream called iCenter. Quick description of iCenter, provide live control on iProperties for Inventor and more control on the BOM management. The subject that I am offering today is how to create a link of your vendor to a drop down menu captured from your database. For this example will use Microsoft Access database with a table of our entire vendor list.
As you can see iCenter offers multiple connections to different database. For this Tip ‘n Trick of iCenter I will show you how to connect a vendor list from Microsoft Access.
To begin you must log in to your iCenter, at the client or inventor level. Once log in, for inventor, go to the drop down menu of “iCenter” and select Administrative Setting, if you’re using the client version of iCenter go to the drop down menu “Tools” and select Administrative Setting.
In the iCenter administrative setting Select the Data Sources icon on the left hand side of the screen. Once there you will create a new connection. By default it will name it “Connection 1”, double click on “Connection 1” and rename it to Vendor.
On the right tab you will create a database connection type. At the connection string select the “…” icon. You will need to select the type of provider for you database, for Microsoft Access you would select “Microsoft Jet 4.0 OLE DB Provider”, select next. Under the connection tab, select the “…” icon and browse to your database. Once the database selected you will create a new data source. By default the data source will be named “DataSource 1” but again double click on the name and rename it to “List of Vendor”. You will need to select the table in your database that contains your vendor list, followed by the valued field and the display field. Once all those selected you should see a preview of your list at the bottom right corner.
After the data source is created you will move on to the properties Icon on the left, look under Property name, and select “Vendor”. Under Data Format, Type, you will select “Data Source”, and for the definition you will take your data source name that you created call “List of Vendor”. From now on your iProperties of Inventor will be containing a drop down list at the vendor property name.
This Tip ‘n Trick is just a small example of iCenter possibility toward linking to a database, I’ve used vendor as an example but we could be looking at Part number, Cost, Designer list and more… See the following video on the Netstream website "How to create Database connectivity"
Happy Linking,
CADgneto
I’ve never any pity for conceited people, because I think they carry their comfort about with them
Posted by: Air Jordans | November 01, 2010 at 03:15 AM
We wish you health, happiness, and prosperity!
In the name of God, That is it.
Posted by: Ugg Boots | November 03, 2010 at 05:18 AM
Truly impressed! Everything is open and clear. It genuinely includes information and facts. Thanks for the great content. I love Microsoft for the ease of everything relevant.
http://personal-loans-unsecured.info
Posted by: Kristie | January 12, 2011 at 03:28 PM
I have read your article, I love them so much I will put your webpage is saved, they are really very good.
Posted by: juicy couture outlet | September 22, 2011 at 09:16 PM
Your article is one of the most classical style, when I read once, I have been deeply in love with them, you look forward to more perfect work.
Posted by: Moncler outlet | September 22, 2011 at 09:22 PM
Thanks for the great article. So fun article is! I agree the idea! I have watched you articles for a long time, very like.
Posted by: Moncler outlet | September 22, 2011 at 09:27 PM
The discussion an on going discussion and analysis of the moral the fact that this is so ought to be an embarrassment to white liberals who are die. Thanks for sharing informative post. beautiful !!!
Posted by: Canada Goose Coats | September 24, 2011 at 04:31 AM
Recent articles. I think this is the most beautiful in the world the article, there must be many people like it your works will get everyone recognized you is the best I will always support you
Posted by: Moncler outlet | September 29, 2011 at 11:56 PM
I am appreciate your blog, is really very good good super endless good good love love super love I expect your good blog continues to attract me love love love....
Posted by: Moncler online shop | September 29, 2011 at 11:59 PM
Too good too cool when I read it really benefit, thank you for publishing works so well, I expect you to continue publishing more good articles.
Posted by: moncler jacken | September 30, 2011 at 12:00 AM
Very interested in your article, very useful to me the information I read it again and again with my many friends already on your blog, I show you recommend
Posted by: Moncler online shop | October 07, 2011 at 01:59 AM
A feeling of your web site do too well beyond my imagination website content is very rich and I love reading each article I will slowly appreciate them
Posted by: Moncler outlet | October 07, 2011 at 02:10 AM
Today is my first time here, I think your blog with new ideas, new information can make people have new feeling novel state, thank specially provided us with these readers very beautiful always keep you warm
Posted by: moncler jacken | October 13, 2011 at 11:30 PM
I accept this point I think with your website said. It is the great creation after reading the impression is very deep theme and content are consistent with the mainstream of the times support support support
Posted by: Moncler online shop | October 13, 2011 at 11:34 PM
Excellent blog have a feeling I have deeply fallen in love with it 's simple and decent concise permanentToo good a very trend benefited from I want to thank the publisher it is because of you, my world is wonderful because of you, I become more substantial!
Posted by: Moncler outlet | October 13, 2011 at 11:38 PM
I first came to visit your site, this article is worth people thinking about people watching, very pleased to meet you here! Thank you for sharing this with us win a good article..
Posted by: Cheap Christian Louboutin | October 21, 2011 at 10:48 PM
thanks for ur sharing,it is really interesting
Posted by: Moncler Sito Ufficiale | October 28, 2011 at 09:16 AM
This information has been made so clear there’s no way to misunderstand it. Thank you.
Posted by: moncler jackets on shop | November 15, 2011 at 01:25 AM
Super cute! My little man would look so stylin' in those!
Posted by: Classic Timberland Boots | November 20, 2011 at 08:19 AM
very pleased to meet you here! Thank you for sharing this with us win a good article..
Posted by: replica handbags | November 25, 2011 at 02:04 AM
These literati, or cognoscenti, are confident that the world must of necessity improve from the study of their works, the result of their labours
Posted by: burberry outlet | November 29, 2011 at 01:24 AM
— over which they have wasted the midnight oil, — for which their brains have suffered all the throes of child-birth
Posted by: michael kors outlet | November 29, 2011 at 01:28 AM
their heads received many a scratch—and their nails many a bite, yea, even to the very quick!Saepe caput scaberet, vivos et roderet ungues.
Posted by: Christian Louboutin Outlet | November 29, 2011 at 01:31 AM
peregrinantur; rusticantur." Peregrinantur; scilicet, who has lately favoured us with;rusticantur; scilicet
Posted by: belstaff | November 30, 2011 at 10:19 PM
ycleped the CockneyPoet, who resides in retirement at , far from the busy scenes of the metropolis: nor need he exclaim, like the drudging Grub
Posted by: coach outlets | November 30, 2011 at 10:23 PM