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?
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?
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.