I'm new to Altium and definitely NOT a database designer, but I found this way easier to understand than anything Altium was showing. I had to make some modifications to our company's existing parts database, but this was straight-forward and pretty simple! Thanks!

The earlier,the better,the later,the bitter...

Thank you very much!

Great Video! Thank you for sharing.

please how to add library to program in altuim 19 and how to download library

The best and great Altium library pars-project.com/

how do we use the internal /built in svn of altium and do version control. i am using altium version 17. I am facing problems and am unable to perform it. Kindly help.

Hello can someone do an update to this video to the new Altium please. the Design repositories have change.

Thanks, rigid-flex pcb offer www.raypcb.com/rigid-flex-pcb/

Thank you for explaining this. Very helpful.

Thank you so much for sharing this knowledge.

thanks!!!

on MY AD16 file , I cant found CIS file... so how I do ?

I know this is late, but you're a gem! thanks for this tutorial, not even Altium documentation is as comprehensive and intuitive as you described here! kudos to you ;)

Show in the video, the 3 flex part is white in 3D mode.

i want to know how to use different colors in rigid and flex part. Make it easy to see which part is flex and which is rigid. When i use 3D, there is the same color, i don't know how to change the color.

how can ı download the Miscellaneous Device librarry for my Altium?

good job!

gracias, tenia buen aporte, saludos.

Hello, thanks for providing the information related to the DBLibrary. I have one question though, in our Altium environment we have one librarian and we want only that individual to have full access for the MS Access DB file. Somehow I am not able to achieve this. As soon as I chance access to read for other users Altium throws them an error that users with read can no more read the DB Library file. I would really appreciate if you can provide your input on this.

thank you man, really appreciate this :)

Nice video. We haven't used SVN yet but are definitely going to start using repositories. We use a lot of git repositories which don't appear to be natively supported in Altium and are debating which to go with. This video shows some great features built into SVN that are definitely worth while.

How do I do the same thing with Excel? Altium just can't connect to my hand made Excel database file, and I can't find an example Excel file anywhere.

Thanks for the tutorial, even though the camera focus popped.

Fantastic Tutorial. Thank you.

really great! it helps a lot!

Very good, nice Job...

Good Video! we use it in pretty mucht the same way. but we get the following problem. when we create a new part in de ms database and save it. we can see it in latium when we go in the component placement but it will not place it since it seems not to know the parameters. this is fixed by closing altium and just restarting. but that takes a lot of time.. is there any way for altium not to lets call it "pre load" the database?

I missed the part where you explained how to select only resistors and not capacitors.

Hey, just a tip for yawls: If you don't have Access, you can import XLS files, which are easily created with OpenOffice or what have you. Because after you've paid for Altium (~10K about, as of now), you won't have any money left for the Office Suite. I just pulled a CSV from Digikey with all the 0603 1% Panasonic ERJ resistors in it, converted to XLS, created a schlib for a resistor part, Added Library Path and Library Ref to the spreadsheet, connected to the spreadsheet from the DbLib configuration, and added it to my active part libraries. No more adding parts by hand!

Is it also possible to add link to different 3D step-file models?

Very useful tutorial! Thanks!

Thank you very much. I appreciate for this video because it helped me a lot. Thanks.

Mea Culpa - At around 11:28, I called the project "pcbdoc." It should have been mentioned as "PCB project"

thank a lot, but my altium is Altium 10, so it isn't has SOIC footprint. How can I do this work ? pls tell me.

how to find amplifier altium??

The latest version of WEBENCH Altium Connector is 1.0.0.37. Apart from the isspice.enl stuff, you can export power as well as filter designs and simulate it in Altium.

On AD14, you can use Excel database and AD both open at the same time without any problem, you just need to open your Excel spreadsheet before starting AD14. You can even live update your excel spreadsheet and it gets propagated to AD14 after you click on Refresh Libraries. The drawback I have found using Excel is that it might be slower than Access DB.

Nice demo, thanks!

Have you seen our new tutorial video on simulating in Altium using Texas Instruments #webench kzbin.info/www/bejne/ZqfWZoGVi62hac0

hi guys, any of you interested to share your Altium Designer integrated libraries?

great work , many thanks

Very good video ! Thanks you a lot !

this was great help!! Thanks!!

Hello all, we've’ve received few questions from KZbin users in regards to database library tutorial video, and we wanted to share with you! Our apologies in advance for our lack of response. We are 2 ex-Altium engineers who still use the tool in our day to day engineering jobs. We try to pull together a video ever so often as time permits. 1) How big is the team using your DBLIB? Most of the work we do is contracting which involves the setup of a component library. One of the larger setups involved 15 engineers. The database was on the network and was shared between 2 groups. The database was MS Access. We could not use the existing PLM due to its age (20 years old) 2) Have you tried to port the mdb file to a real database server running PostgreSQL or MySQL? I have not done it; however, most of these tools have the ability to do so given that this is a saturated market. I recommend that you look into it if you believe that it provides a benefit. Keep in mind that these larger systems are made for purchasing departments. 3) Where do you keep the PCBLib and SchLib files? Alternatively, where would you keep them if the library would be hosted on a database server.? This is a good question since there was much discussion about it when we were developing the centralized library. There are 2 libraries kept on the network. The first is a "Master copy" which is in a restricted directory that requires permission from IT to be able to work in this particular directory. In fact, it is hidden to all other employees. Those who create components add to the database and the graphics to the .schlib and .pcblib. In addition, all of this is kept under SVN version control. A copy of the database, .schlib, and .pcblib are placed in another directory that can be accessed by all other engineers. These are updated daily, usually at night. We manually did the update; however, someone savvy with a scrip could automate this process. Not to go too far on a tangent; however, this does have its limitations. Namely, the librarian has to inform or broadcast an e-mail to all engineers as to which components had been updated. Keep in mind that once you put a component on your design, it will remain that way unless you specifically tell Altium to update from the library. This issue is one of the reasons why Altium created the Vault concept. 4) How did you solve the "problem" of common elements like resistors and capacitors? Do you have just one entry in the database for - for example - a 1206 resistor and a 0805 resistor and then you change the required resistance value on the schematic or do you have a separate entry for each size/value/voltage/wattage? If you have separate entries does the schematic design speed decrease noticeably due to the fact that designers have to click through the library for a different resistor value? Every component has its own record. It may point to the same graphic (ie symbol or footprint), but the "intelligent data" like the mfg. part number or Manufacturer's name is specific to that component. For example, if you have 1000 resistors, you can use the same graphic for the symbol; however, there needs to be 1000 records. As for searching, Altium allows the user to "cascade the search" in the libraries panel. If you have columns of data like Tolerance, Power, Temperature and Value, the user can narrow the search base on those parameters. This is a powerful way of finding things quickly in the Libraries panel and it only works for the database. HOWEVER, it also assumes that you have robust database that contains this data. Look at the CIS database example that Altium provides in the example folder (or check live.altium.com). 5) How did you solve the issue of the whole design team wanting to add their elements to the library? After all the library admin has to be notified in some way that an inspection of newly added elements is needed. First, that was one of the reasons for restricting the area were the library was being maintained and built. Second, when we wrote our procedures, we agreed that there has to be an individual who is dedicated as the librarian. If everyone contributes, you will have a disaster for a library. Too many different graphics, too many different parameters and even if everyone uses the correct parameter name, the format will be different! Again, not to push a product on you, but this is another reason why Altium created the vault. This allows some tracking as to who done what. 6) Do you by any chance know if there is a way to put a resistor on the schematic with its' value set to - for example - 10k, change it (on schematic not by selecting a new one from the database) to 22k and execute some procedure in altium to search the database library for a record with the value 22k so that the rest of the parameters in the originally 10k resistor get updated to the ones being proper for the 22k one? I suppose you can through the supplier search panel; however, this gets ugly. You are introducing a component that does not exist in the library and this has repercussions when the component is handed off to the purchasing group. The larger the company, the more scrutiny each new part is going to undergo. All parts need to start in the library.

Hello all, we've received a few questions from KZbin users in regards to database library tutorial video, and we wanted to share with you! Our apologies in advance for our lack of response. We are 2 ex-Altium engineers who still use the tool in our day to day engineering jobs. We try to pull together a video ever so often as time permits. 1) How big is the team using your DBLIB? Most of the work we do is contracting which involves the setup of a component library. One of the larger setups involved 15 engineers. The database was on the network and was shared between 2 groups. The database was MS Access. We could not use the existing PLM due to its age (20 years old) 2) Have you tried to port the mdb file to a real database server running PostgreSQL or MySQL? I have not done it; however, most of these tools have the ability to do so given that this is a saturated market. I recommend that you look into it if you believe that it provides a benefit. Keep in mind that these larger systems are made for purchasing departments. 3) Where do you keep the PCBLib and SchLib files? Alternatively, where would you keep them if the library would be hosted on a database server.? This is a good question since there was much discussion about it when we were developing the centralized library. There are 2 libraries kept on the network. The first is a "Master copy" which is in a restricted directory that requires permission from IT to be able to work in this particular directory. In fact, it is hidden to all other employees. Those who create components add to the database and the graphics to the .schlib and .pcblib. In addition, all of this is kept under SVN version control. A copy of the database, .schlib, and .pcblib are placed in another directory that can be accessed by all other engineers. These are updated daily, usually at night. We manually did the update; however, someone savvy with a scrip could automate this process. Not to go too far on a tangent; however, this does have its limitations. Namely, the librarian has to inform or broadcast an e-mail to all engineers as to which components had been updated. Keep in mind that once you put a component on your design, it will remain that way unless you specifically tell Altium to update from the library. This issue is one of the reasons why Altium created the Vault concept. 4) How did you solve the "problem" of common elements like resistors and capacitors? Do you have just one entry in the database for - for example - a 1206 resistor and a 0805 resistor and then you change the required resistance value on the schematic or do you have a separate entry for each size/value/voltage/wattage? If you have separate entries does the schematic design speed decrease noticeably due to the fact that designers have to click through the library for a different resistor value? Every component has its own record. It may point to the same graphic (ie symbol or footprint), but the "intelligent data" like the mfg. part number or Manufacturer's name is specific to that component. For example, if you have 1000 resistors, you can use the same graphic for the symbol; however, there needs to be 1000 records. As for searching, Altium allows the user to "cascade the search" in the libraries panel. If you have columns of data like Tolerance, Power, Temperature and Value, the user can narrow the search base on those parameters. This is a powerful way of finding things quickly in the Libraries panel and it only works for the database. HOWEVER, it also assumes that you have robust database that contains this data. Look at the CIS database example that Altium provides in the example folder (or check live.altium.com). 5) How did you solve the issue of the whole design team wanting to add their elements to the library? After all the library admin has to be notified in some way that an inspection of newly added elements is needed. First, that was one of the reasons for restricting the area were the library was being maintained and built. Second, when we wrote our procedures, we agreed that there has to be an individual who is dedicated as the librarian. If everyone contributes, you will have a disaster for a library. Too many different graphics, too many different parameters and even if everyone uses the correct parameter name, the format will be different! Again, not to push a product on you, but this is another reason why Altium created the vault. This allows some tracking as to who done what. 6) Do you by any chance know if there is a way to put a resistor on the schematic with its' value set to - for example - 10k, change it (on schematic not by selecting a new one from the database) to 22k and execute some procedure in altium to search the database library for a record with the value 22k so that the rest of the parameters in the originally 10k resistor get updated to the ones being proper for the 22k one? I suppose you can through the supplier search panel; however, this gets ugly. You are introducing a component that does not exist in the library and this has repercussions when the component is handed off to the purchasing group. The larger the company, the more scrutiny each new part is going to undergo. All parts need to start in the library. we hope this was helpful

Excellent illustration of the exhaustive available descriptive mechanical parameters Altium provides.

Good job!

Wow, this was great! Thanks a lot!

The biggest advantage that one would get from the Vaults is the ability for the user to determine if a component has been used on any of the projects in the vault and it could be useful for end-of-life for substitution of components. However if you already have a good purchasing database and using SVN, you should be able to accomplish the same thing. The Vaults would be useful for a company that has multiple divisions with many engineers working on the same projects.