How to place parts using spread sheet

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?

in the end you need to issue 'move partname (x y)' commands in the

board context for each part you want to place.

How you get that commands generated from your speadsheet is up to you

8-)

either let the speadsheet application generate it,

or export the the data to a text file, then write an ULP that parses

the text file and generates the commands.

--

Lorenz

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

"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

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

Hi Greg

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.

Have you tried the place50.ulp that is available in the ULP downloads

area of the Cadsoft website?  My recollection is that it does this type

of initial placement.

Regards,

Neil

"Neil Allison" <neil@avon-tech-solutions.co.nz> wrote in message

news:htq9ts$c9v$1@cheetah.cadsoft.de...

Hi Greg

 

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.

 

Have you tried the place50.ulp that is available in the ULP downloads area

of the Cadsoft website?  My recollection is that it does this type of

initial placement.

 

Regards,

Neil

Hi Neil,

That does exactly what I want. Thanks. I spent a couple of hours half doing

it last night. I even downloaded all the ULPs from CADsoft this mornong.

Thanks for the heads up, this one works well.

regards

Greg

Lorenz wrote on Thu, 27 May 2010 01:37

in the end you need to issue 'move partname (x y)' commands in the

board context for each part you want to place.

That gets the location correct, but will use the default orientation.

--

Web access to CadSoft support forums at www.eaglecentral.ca.  Where the CadSoft EAGLE community meets.