[kicad-users] Re: Consolidated BOM
Hi Harold, By inverted do you mean a check mark means its not case sensitive? Exactly, when the tick-box is selected it is NOT case sensitive, and vice versa. Cheers, Heiko
[kicad-users] Re: Consolidated BOM
Hi Heiko, Yes it can be done in a few clicks. Cheers, Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.la...@... wrote: Hi Harold, By inverted do you mean a check mark means its not case sensitive? Exactly, when the tick-box is selected it is NOT case sensitive, and vice versa. Cheers, Heiko
[kicad-users] Re: Consolidated BOM
Hi Heiko, Done with the changes and labeled as RC2. Now the installation will default to case sensitivity being disabled. Cheers, Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.la...@... wrote: Hi Harold, By inverted do you mean a check mark means its not case sensitive? Exactly, when the tick-box is selected it is NOT case sensitive, and vice versa. Cheers, Heiko
[kicad-users] Re: Consolidated BOM
Hi All, Server is down but you may download the setup file on the mirror sites http://cybercircuits-lab.co.cc/blog/?p=13 or at SourceForge http://sourceforge.net/projects/kicadexceladdin/ Cheers, Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.la...@... wrote: Kicad always creates the BOM with one part per line only. A suggestion to add a function was aparently never implemented (I found some nice screenshots in the files area). So, what I need is a tool that creates out of this: R1 10K 0805 R2 10K 0805 R3 47K 0805 something like this: 2R1, R210K0805 1R347K0805 Does anyone have a solution how to create consolidated BOMs by using Openoffice (or MS-Office)? Thanks, Heiko
[kicad-users] Re: Consolidated BOM
--- In kicad-users@yahoogroups.com, Harold King Tarun haroldk...@... wrote: Hi Heiko, I have made some major changes and released a newer version of the program. New features includes: - user-friendly interface - menu-driven functions - supports 3 field separator types (TAB, comma and semicolon) - added case sensitivity option - better error handling - saving settings - small footprint installer http://cybercircuits.co.cc/blog/?p=13 Hope you like all the changes. Cheers, Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.lange@ wrote: Perfect! Many thanks again! Looks very interesting. Any chance of a version for Open Office Thanks
[kicad-users] Re: Consolidated BOM
Will make one as soon as I can. Cheers Looks very interesting. Any chance of a version for Open Office Thanks
[kicad-users] Re: Consolidated BOM
Hi Harold, Nice job, thanks. I can confirm that it also works under Excel 2007, just need to be enabled as an add-in. Could it be that the case-sensitive option works inverted? Cheers, Heiko --- In kicad-users@yahoogroups.com, Harold King Tarun haroldk...@... wrote: Hi Heiko, I have made some major changes and released a newer version of the program. New features includes: - user-friendly interface - menu-driven functions - supports 3 field separator types (TAB, comma and semicolon) - added case sensitivity option - better error handling - saving settings - small footprint installer http://cybercircuits.co.cc/blog/?p=13 Hope you like all the changes. Cheers, Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.lange@ wrote: Perfect! Many thanks again!
[kicad-users] Re: Consolidated BOM
Hi Heiko, Sweet! Haven't tried it Office 2007 I'm glad it works. I just have to update the ReadMe file for additional instructions. By inverted do you mean a check mark means its not case sensitive? Cheers, Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.la...@... wrote: Hi Harold, Nice job, thanks. I can confirm that it also works under Excel 2007, just need to be enabled as an add-in. Could it be that the case-sensitive option works inverted? Cheers, Heiko --- In kicad-users@yahoogroups.com, Harold King Tarun haroldking@ wrote: Hi Heiko, I have made some major changes and released a newer version of the program. New features includes: - user-friendly interface - menu-driven functions - supports 3 field separator types (TAB, comma and semicolon) - added case sensitivity option - better error handling - saving settings - small footprint installer http://cybercircuits.co.cc/blog/?p=13 Hope you like all the changes. Cheers, Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.lange@ wrote: Perfect! Many thanks again!
[kicad-users] Re: Consolidated BOM
Hi Heiko, Just to let you know that I have made some changes to the MS Excel file. It should now parse all the rows and columns (basically the entire file). Cheers, Harold P.S. Yes I live in NZ too, I'm in Auckland. Where abouts are you? :-) --- In kicad-users@yahoogroups.com, oecherexpat heiko.la...@... wrote: Hi Harold, Thanks, it's indeed including all my other data to the BOM. And I figured another challenge: The BOM has grown further because I added some more components. Means, I have some same components further down the list. Here's an example: R1 10K 0805 R2 10K 0805 R3 47K 0805 R4 10K 0805 Looks to me that the macro scan the next line but not the entire file, right? The result I see would be for the above example: 2R1, R210K0805 1R347K0805 1R410K0805 Cheers, Heiko P.S. Just saw that you live in NZ, too ;-) --- In kicad-users@yahoogroups.com, Harold King Tarun haroldking@ wrote: Hi Heiko, I have released an updated version. This includes processing of all used column even when you have manually inserted a column or not plus all the checked fields from Eeschema. Any features you want to include kindly drop me a line. Regards, Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.lange@ wrote: Hi Harold, Thanks a lot, it is in fact a real help in generating BOMs. However, I am squeezing everithing out of Kicad, that's - I guess - the reason why on my system it did only half the job by leaving quite some lines unconsilidated and only uses the first 3 columns. Let me explain: Instead of using simple names for schematic components like 10K I rather use long and complex names like 10K_1%_W125_0805. Reason is that I use the name as part identifier ans link these to a unique stock/order number and some other information within the extra fields. Means, I am using most of the remaining fields. I am also not sure, how compatible the different MS-Office versions are in terms of handling macros. I am currently using Office 2007. I'll run more tests and will try to impove the macro but unfortunately I am flat out with the job for the next few weeks :-( Cheers, Heiko --- In kicad-users@yahoogroups.com, Harold King Tarun haroldking@ wrote: Hi Heiko, Here's the MS Excel that you need to consolidate your BOM (including instructions on how to use it). Hope you find it useful. You can get the instructions here http://cybercircuits.co.cc/blog/?p=13 Any bug kindly let me know. Cheers Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.lange@ wrote: Kicad always creates the BOM with one part per line only. A suggestion to add a function was aparently never implemented (I found some nice screenshots in the files area). So, what I need is a tool that creates out of this: R1 10K 0805 R2 10K 0805 R3 47K 0805 something like this: 2R1, R210K0805 1R347K0805 Does anyone have a solution how to create consolidated BOMs by using Openoffice (or MS-Office)? Thanks, Heiko
[kicad-users] Re: Consolidated BOM
Hi Harold, Just tried V1.5.1 and found that at least with Excel 2007 it doesn't seem to recognise the macro any more: It's not using the *.lst filter when opening and starts the text import filter rather then the macro. On V1.5 all this was working fine. Cheers, Heiko P.S. I'm in Christchurch, today's miserable weather zone. --- In kicad-users@yahoogroups.com, Harold King Tarun haroldk...@... wrote: Hi Heiko, Just to let you know that I have made some changes to the MS Excel file. It should now parse all the rows and columns (basically the entire file). Cheers, Harold P.S. Yes I live in NZ too, I'm in Auckland. Where abouts are you? :-) --- In kicad-users@yahoogroups.com, oecherexpat heiko.lange@ wrote: Hi Harold, Thanks, it's indeed including all my other data to the BOM. And I figured another challenge: The BOM has grown further because I added some more components. Means, I have some same components further down the list. Here's an example: R1 10K 0805 R2 10K 0805 R3 47K 0805 R4 10K 0805 Looks to me that the macro scan the next line but not the entire file, right? The result I see would be for the above example: 2R1, R210K0805 1R347K0805 1R410K0805 Cheers, Heiko P.S. Just saw that you live in NZ, too ;-) --- In kicad-users@yahoogroups.com, Harold King Tarun haroldking@ wrote: Hi Heiko, I have released an updated version. This includes processing of all used column even when you have manually inserted a column or not plus all the checked fields from Eeschema. Any features you want to include kindly drop me a line. Regards, Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.lange@ wrote: Hi Harold, Thanks a lot, it is in fact a real help in generating BOMs. However, I am squeezing everithing out of Kicad, that's - I guess - the reason why on my system it did only half the job by leaving quite some lines unconsilidated and only uses the first 3 columns. Let me explain: Instead of using simple names for schematic components like 10K I rather use long and complex names like 10K_1%_W125_0805. Reason is that I use the name as part identifier ans link these to a unique stock/order number and some other information within the extra fields. Means, I am using most of the remaining fields. I am also not sure, how compatible the different MS-Office versions are in terms of handling macros. I am currently using Office 2007. I'll run more tests and will try to impove the macro but unfortunately I am flat out with the job for the next few weeks :-( Cheers, Heiko --- In kicad-users@yahoogroups.com, Harold King Tarun haroldking@ wrote: Hi Heiko, Here's the MS Excel that you need to consolidate your BOM (including instructions on how to use it). Hope you find it useful. You can get the instructions here http://cybercircuits.co.cc/blog/?p=13 Any bug kindly let me know. Cheers Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.lange@ wrote: Kicad always creates the BOM with one part per line only. A suggestion to add a function was aparently never implemented (I found some nice screenshots in the files area). So, what I need is a tool that creates out of this: R1 10K 0805 R2 10K 0805 R3 47K 0805 something like this: 2R1, R210K0805 1R347K0805 Does anyone have a solution how to create consolidated BOMs by using Openoffice (or MS-Office)? Thanks, Heiko
[kicad-users] Re: Consolidated BOM
Hi Heiko, Sorry I missed that part. I will upload the new file now. It will only take a minute or two. Cheers, Harold P.S. Todat's weather in Auckland is starting be miserable as well. --- In kicad-users@yahoogroups.com, oecherexpat heiko.la...@... wrote: Hi Harold, Just tried V1.5.1 and found that at least with Excel 2007 it doesn't seem to recognise the macro any more: It's not using the *.lst filter when opening and starts the text import filter rather then the macro. On V1.5 all this was working fine. Cheers, Heiko P.S. I'm in Christchurch, today's miserable weather zone.
[kicad-users] Re: Consolidated BOM
Perfect! Many thanks again! --- In kicad-users@yahoogroups.com, Harold King Tarun haroldk...@... wrote: Hi Heiko, Sorry I missed that part. I will upload the new file now. It will only take a minute or two. Cheers, Harold P.S. Todat's weather in Auckland is starting be miserable as well. --- In kicad-users@yahoogroups.com, oecherexpat heiko.lange@ wrote: Hi Harold, Just tried V1.5.1 and found that at least with Excel 2007 it doesn't seem to recognise the macro any more: It's not using the *.lst filter when opening and starts the text import filter rather then the macro. On V1.5 all this was working fine. Cheers, Heiko P.S. I'm in Christchurch, today's miserable weather zone.
[kicad-users] Re: Consolidated BOM
Hi Harold, Thanks, it's indeed including all my other data to the BOM. And I figured another challenge: The BOM has grown further because I added some more components. Means, I have some same components further down the list. Here's an example: R1 10K 0805 R2 10K 0805 R3 47K 0805 R4 10K 0805 Looks to me that the macro scan the next line but not the entire file, right? The result I see would be for the above example: 2R1, R210K0805 1R347K0805 1R410K0805 Cheers, Heiko P.S. Just saw that you live in NZ, too ;-) --- In kicad-users@yahoogroups.com, Harold King Tarun haroldk...@... wrote: Hi Heiko, I have released an updated version. This includes processing of all used column even when you have manually inserted a column or not plus all the checked fields from Eeschema. Any features you want to include kindly drop me a line. Regards, Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.lange@ wrote: Hi Harold, Thanks a lot, it is in fact a real help in generating BOMs. However, I am squeezing everithing out of Kicad, that's - I guess - the reason why on my system it did only half the job by leaving quite some lines unconsilidated and only uses the first 3 columns. Let me explain: Instead of using simple names for schematic components like 10K I rather use long and complex names like 10K_1%_W125_0805. Reason is that I use the name as part identifier ans link these to a unique stock/order number and some other information within the extra fields. Means, I am using most of the remaining fields. I am also not sure, how compatible the different MS-Office versions are in terms of handling macros. I am currently using Office 2007. I'll run more tests and will try to impove the macro but unfortunately I am flat out with the job for the next few weeks :-( Cheers, Heiko --- In kicad-users@yahoogroups.com, Harold King Tarun haroldking@ wrote: Hi Heiko, Here's the MS Excel that you need to consolidate your BOM (including instructions on how to use it). Hope you find it useful. You can get the instructions here http://cybercircuits.co.cc/blog/?p=13 Any bug kindly let me know. Cheers Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.lange@ wrote: Kicad always creates the BOM with one part per line only. A suggestion to add a function was aparently never implemented (I found some nice screenshots in the files area). So, what I need is a tool that creates out of this: R1 10K 0805 R2 10K 0805 R3 47K 0805 something like this: 2R1, R210K0805 1R347K0805 Does anyone have a solution how to create consolidated BOMs by using Openoffice (or MS-Office)? Thanks, Heiko
[kicad-users] Re: Consolidated BOM
Hi Heiko, I have released an updated version. This includes processing of all used column even when you have manually inserted a column or not plus all the checked fields from Eeschema. Any features you want to include kindly drop me a line. Regards, Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.la...@... wrote: Hi Harold, Thanks a lot, it is in fact a real help in generating BOMs. However, I am squeezing everithing out of Kicad, that's - I guess - the reason why on my system it did only half the job by leaving quite some lines unconsilidated and only uses the first 3 columns. Let me explain: Instead of using simple names for schematic components like 10K I rather use long and complex names like 10K_1%_W125_0805. Reason is that I use the name as part identifier ans link these to a unique stock/order number and some other information within the extra fields. Means, I am using most of the remaining fields. I am also not sure, how compatible the different MS-Office versions are in terms of handling macros. I am currently using Office 2007. I'll run more tests and will try to impove the macro but unfortunately I am flat out with the job for the next few weeks :-( Cheers, Heiko --- In kicad-users@yahoogroups.com, Harold King Tarun haroldking@ wrote: Hi Heiko, Here's the MS Excel that you need to consolidate your BOM (including instructions on how to use it). Hope you find it useful. You can get the instructions here http://cybercircuits.co.cc/blog/?p=13 Any bug kindly let me know. Cheers Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.lange@ wrote: Kicad always creates the BOM with one part per line only. A suggestion to add a function was aparently never implemented (I found some nice screenshots in the files area). So, what I need is a tool that creates out of this: R1 10K 0805 R2 10K 0805 R3 47K 0805 something like this: 2R1, R210K0805 1R347K0805 Does anyone have a solution how to create consolidated BOMs by using Openoffice (or MS-Office)? Thanks, Heiko
[kicad-users] Re: Consolidated BOM
Hi Harold, Thanks a lot, it is in fact a real help in generating BOMs. However, I am squeezing everithing out of Kicad, that's - I guess - the reason why on my system it did only half the job by leaving quite some lines unconsilidated and only uses the first 3 columns. Let me explain: Instead of using simple names for schematic components like 10K I rather use long and complex names like 10K_1%_W125_0805. Reason is that I use the name as part identifier ans link these to a unique stock/order number and some other information within the extra fields. Means, I am using most of the remaining fields. I am also not sure, how compatible the different MS-Office versions are in terms of handling macros. I am currently using Office 2007. I'll run more tests and will try to impove the macro but unfortunately I am flat out with the job for the next few weeks :-( Cheers, Heiko --- In kicad-users@yahoogroups.com, Harold King Tarun haroldk...@... wrote: Hi Heiko, Here's the MS Excel that you need to consolidate your BOM (including instructions on how to use it). Hope you find it useful. You can get the instructions here http://cybercircuits.co.cc/blog/?p=13 Any bug kindly let me know. Cheers Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.lange@ wrote: Kicad always creates the BOM with one part per line only. A suggestion to add a function was aparently never implemented (I found some nice screenshots in the files area). So, what I need is a tool that creates out of this: R1 10K 0805 R2 10K 0805 R3 47K 0805 something like this: 2R1, R210K0805 1R347K0805 Does anyone have a solution how to create consolidated BOMs by using Openoffice (or MS-Office)? Thanks, Heiko
[kicad-users] Re: Consolidated BOM
Hi Heiko, The release only considers 3 columns and ignores the remaining columns. The next release will be considering all columns regardless of how many custom fields you may have. If any of the field changes it will count as another component. By the way it was written on MS Office 2003 and should be compatible to any version of MS Office including MS Office 97. As for the OpenOffice compatibility I will try to check tonight. Cheers, Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.la...@... wrote: Hi Harold, Thanks a lot, it is in fact a real help in generating BOMs. However, I am squeezing everithing out of Kicad, that's - I guess - the reason why on my system it did only half the job by leaving quite some lines unconsilidated and only uses the first 3 columns. Let me explain: Instead of using simple names for schematic components like 10K I rather use long and complex names like 10K_1%_W125_0805. Reason is that I use the name as part identifier ans link these to a unique stock/order number and some other information within the extra fields. Means, I am using most of the remaining fields. I am also not sure, how compatible the different MS-Office versions are in terms of handling macros. I am currently using Office 2007. I'll run more tests and will try to impove the macro but unfortunately I am flat out with the job for the next few weeks :-( Cheers, Heiko --- In kicad-users@yahoogroups.com, Harold King Tarun haroldking@ wrote: Hi Heiko, Here's the MS Excel that you need to consolidate your BOM (including instructions on how to use it). Hope you find it useful. You can get the instructions here http://cybercircuits.co.cc/blog/?p=13 Any bug kindly let me know. Cheers Harold --- In kicad-users@yahoogroups.com, oecherexpat heiko.lange@ wrote: Kicad always creates the BOM with one part per line only. A suggestion to add a function was aparently never implemented (I found some nice screenshots in the files area). So, what I need is a tool that creates out of this: R1 10K 0805 R2 10K 0805 R3 47K 0805 something like this: 2R1, R210K0805 1R347K0805 Does anyone have a solution how to create consolidated BOMs by using Openoffice (or MS-Office)? Thanks, Heiko
[kicad-users] Re: Consolidated BOM
I believe it can be done in Spreadsheet (OpenOffice/MS Office) --- In kicad-users@yahoogroups.com, oecherexpat heiko.la...@... wrote: Kicad always creates the BOM with one part per line only. A suggestion to add a function was aparently never implemented (I found some nice screenshots in the files area). So, what I need is a tool that creates out of this: R1 10K 0805 R2 10K 0805 R3 47K 0805 something like this: 2R1, R210K0805 1R347K0805 Does anyone have a solution how to create consolidated BOMs by using Openoffice (or MS-Office)? Thanks, Heiko
[kicad-users] Re: Consolidated BOM
That's good. But how? I believe it can be done in Spreadsheet (OpenOffice/MS Office) --- In kicad-users@yahoogroups.com, oecherexpat heiko.lange@ wrote: Kicad always creates the BOM with one part per line only. A suggestion to add a function was aparently never implemented (I found some nice screenshots in the files area). So, what I need is a tool that creates out of this: R1 10K 0805 R2 10K 0805 R3 47K 0805 something like this: 2R1, R210K0805 1R347K0805 Does anyone have a solution how to create consolidated BOMs by using Openoffice (or MS-Office)? Thanks, Heiko
[kicad-users] Re: Consolidated BOM
It requires some programming script. I'll try to write one when I find time. --- In kicad-users@yahoogroups.com, oecherexpat heiko.la...@... wrote: That's good. But how? I believe it can be done in Spreadsheet (OpenOffice/MS Office) --- In kicad-users@yahoogroups.com, oecherexpat heiko.lange@ wrote: Kicad always creates the BOM with one part per line only. A suggestion to add a function was aparently never implemented (I found some nice screenshots in the files area). So, what I need is a tool that creates out of this: R1 10K 0805 R2 10K 0805 R3 47K 0805 something like this: 2R1, R210K0805 1R347K0805 Does anyone have a solution how to create consolidated BOMs by using Openoffice (or MS-Office)? Thanks, Heiko