How to place parts using spread sheet

On 5/27/2010 6:18 PM, Greg Erskine wrote:

"Jorge Garcia"<jorge@cadsoftusa.com>  wrote in message

news:htmju0$tga$2@cheetah.cadsoft.de...

On 5/26/2010 11:01 AM, Dang Tran wrote:

I want to import a spread sheet with the location of where I want the

parts

to be layout on my PCB. Is that possible? How would one do that?

 

Hi Dang,

 

The example illustrates how you can use a spreadsheet to move the

components on a board. This was sent to a support customer and I thought

it would be good to post.

 

The first thing to do was to obtain the part numbers and values from the

board. For this I used the bom.ulp and exported from it a text file.

This file is originally tab delimited, however it's not organized well

enough so I had to go in and add one more delimiter in order for the

data to import correctly into OpenOffice. I included both files so you

could see what I did.

 

I then imported the data into OpenOffice, using the open command. Now

things get interesting if you look on sheet 2, I created two columns

with the x, y locations for the components and I transferred the part

name to sheet 2 below it I setup the syntax for a script file and then

had OpenOffice reference the values I inputed for x and y ( As shown it

places all of the components in a diagonal line, if you have the free or

standard version you might not be able to execute all of the moves since

the last part would be placed at 6,6 (I set my grid to inches).

 

With the syntax up, I open Notepad(Or equivalent text editor) and simply

copy paste the syntax from the spreadsheet into the Notepad. Save the

text file with the extension .scr(Script file).

 

If you run the script in EAGLE you'll get the results shown in the

included board file.

 

Hope this gives you some cool ideas.

 

Regards,

Jorge Garcia

 

Please post your examples. I am interested in a similar process. I would

like to see a ulp/scr that places the components within the PCB with

positioning relative to positions in the schematic. I think this would be a

nice starting point for the PCB.

 

BTW: By coincident I modified bom_w_attr_v1.03.ulp last night to have

selectable delimiters for CSV output because it wouldn't open cleanly in

excel.

 

regards

Greg

 

 

Hi Greg,

Let me try to post the example again. I don't know how I would post the

results, the server tells me the files are too big.

Any suggestions?

Regards,

Jorge Garcia

On 5/27/2010 6:18 PM, Greg Erskine wrote:

"Jorge Garcia"<jorge@cadsoftusa.com>  wrote in message

news:htmju0$tga$2@cheetah.cadsoft.de...

On 5/26/2010 11:01 AM, Dang Tran wrote:

I want to import a spread sheet with the location of where I want the

parts

to be layout on my PCB. Is that possible? How would one do that?

 

Hi Dang,

 

The example illustrates how you can use a spreadsheet to move the

components on a board. This was sent to a support customer and I thought

it would be good to post.

 

The first thing to do was to obtain the part numbers and values from the

board. For this I used the bom.ulp and exported from it a text file.

This file is originally tab delimited, however it's not organized well

enough so I had to go in and add one more delimiter in order for the

data to import correctly into OpenOffice. I included both files so you

could see what I did.

 

I then imported the data into OpenOffice, using the open command. Now

things get interesting if you look on sheet 2, I created two columns

with the x, y locations for the components and I transferred the part

name to sheet 2 below it I setup the syntax for a script file and then

had OpenOffice reference the values I inputed for x and y ( As shown it

places all of the components in a diagonal line, if you have the free or

standard version you might not be able to execute all of the moves since

the last part would be placed at 6,6 (I set my grid to inches).

 

With the syntax up, I open Notepad(Or equivalent text editor) and simply

copy paste the syntax from the spreadsheet into the Notepad. Save the

text file with the extension .scr(Script file).

 

If you run the script in EAGLE you'll get the results shown in the

included board file.

 

Hope this gives you some cool ideas.

 

Regards,

Jorge Garcia

 

Please post your examples. I am interested in a similar process. I would

like to see a ulp/scr that places the components within the PCB with

positioning relative to positions in the schematic. I think this would be a

nice starting point for the PCB.

 

BTW: By coincident I modified bom_w_attr_v1.03.ulp last night to have

selectable delimiters for CSV output because it wouldn't open cleanly in

excel.

 

regards

Greg

 

 

Hi Greg,

Let me try to post the example again. I don't know how I would post the

results, the server tells me the files are too big.

Any suggestions?

Regards,

Jorge Garcia