Altium make integrated library with random components

[MtS11]

Hello to everyone,

In these days i'm fighting with Altium (from AD16 to AD18) to find a way to create a schematic library or a integrated library from my Altium projet that has all the components placed from a mini MySQL database that I've done for this test.

The problem is this:

When I'm placing the component from the database to the schematic doc there's no problem, all the field are updated and the "Design Item Id" Field is the part number of the component, as my setting on the database.

The database was created from a single SchLib and a single PcbLib, where I collect all the symbols and footprints that are linked in the database.
Eg: to create a 10K 0603 and a 47K 0603 i use the same symbol ( eg:  "res") and the same footprint (eg: "0603N"). The rest of the parameters are update in the database.

If I decide to create a integrated library or a schematic library from my project with the components from the database, by clicking the "tool/make integrated library" or "tool/make schematic library" there will be create a schematic library with some of the components that are present in the project.

For example: if in my project are present some res 10K 0603, a 470K 0603, a 0R 0805, a 100K 0805 and a 470R 0402, in the new schematic library there will be only the 10K 0603, the 0R 0805 and the 470R 0402.
 
The 470K 0603 and the 100K 0805 won't be created because "i think" these components have the same library ref and the same footprint of the 10K 0603 ( for the 470K 0603) or the 0R 0805 (for the 100K 0805).

This is the behavior that i've seen if I set the option "Process all the components, giving them unique names" when I generate the sch/integrated library.


The goal is to create a schlib from my project that contains a component for type, sorted by P/N, Description, Comment, or some other parameter that will differs a 10K 0603 from a 470K 0603.

What can I do to reach this goal?

Thanks for everyone for the help. Any suggestions will be appreciated.
Cheers.

[ddavidebor]

You could try the offline library creation wizard https://www.altium.com/documentation/1.1/display/NEXUS/WorkspaceManager_Dlg-IntLibMakerForm((Offline+Integrated+Library+Maker+Wizard))_AD

then:

1. select al components with sch filter using "isComponent" query
2. edit the library field
3. answer "no" when it asks if you want to update the component id
4. tools > update components from library. Verify all components are found correctly
5. profit!

[MtS11]

Hi ddavidebor,

First of all, thanks for your replies!

And yes, it's work, and the goal is what i'm searching for!

But, when I create a offline integrated library of the DB, Altium creates one intlib per tables that i have in the DB, if I select it, obviously. Maybe is the correct and only way, I don't know, but I will try some different approach...

However, this is a big step forward.
Thanks so much for the help!!

[ddavidebor]

I would recommend you use only one table, Altium has some good group and filter capabilities

[twistedresistor]

If someone has a better solution, I would be very interested.

I'm having the same problem. In my job we often have to provide also a library with the used parts to our customers, and as MtS11 stated the normal Project Library is a mess if your library is a DBlib.

Thanks!