File format and samples wanted

[mucek]

So like this should work? (can't try at home, but I am courious )

Code: Select all

"No","Value","Package","X","Y","Rotation",Side,"Part"
""
"1","100nF","0805","36.83","80.64","90.0",Top,"C1"
"2","100nF","0805","9.53","46.99","0.0",Top,"C2"
"3","10uF","0805","9.53","56.52","0.0",Top,"C3"
"4","100nF","0805","9.53","36.83","0.0",Top,"C4"
"5","100µF","SMD_R7X7_ELKO","7.62","64.14","90.0",Top,"C5"
"6","100µF","SMD_R7X7_ELKO","43.18","80.33","0.0",Top,"C6"
"7","100µF","SMD_R7X7_ELKO","51.44","80.33","0.0",Top,"C7"
"8","22pF","0805","130.81","10.79","270.0",Top,"C8"
"9","22pF","0805","130.81","17.78","90.0",Top,"C9"
"10","22uF","0805","93.98","10.16","270.0",Top,"C10"

Regards,
Gregor

[mrandt]

Seems correct to me.

LitePlacer software loads your CSV data:

job.png (8.98 KiB) Viewed 6403 times

[mucek]

Great, thx!!!

[Danal]

I use DesignSpark for all PCB work.

I used Eagle quite a bit in the past. I moved to DS because of Eagle's licensing and board size limitations, plus, quite frankly, because Eagle's "non standard" GUI drove me nuts, no matter how much I used it. DesignSpark was much easier to learn, works very well, and has continued to work as I've moved into selling some of my work. It is not perfect, but it is free, it allows commercial products to be produced on any sized board, and the built in parts libraries are useful. It also has the best library editor I've ever used, in terms of making it easy to build a new schematic/package/component.

I have developed a custom report for DesignSpark to directly feed Liteplacer. I HAVE NOT YET TESTED THIS, other than it loads into the Liteplacer software. In particular, there may be some work yet to do getting "value" properly set.


Anyway, here is a start.

In directory: C:\Users\Public\Documents\DesignSpark PCB 7.0\Report Templates
Make a file with the name you desire for the report, extension ".rft". For example "For Liteplacer.rft"
Inside that file, place the text below.

In DesignSpark, open a PCB and use menu command "Output...Report..." and then your custom report name. It will drop the CSV in the same directory with the project, schematic, and PCB files (not, the plots directory), and open it in Excel. You should be able to directly open the .csv file in LitePlacer.


Danal





(ReportTemplate
(Header
(Version 2)
(Context 1)
)
(Variants
(VariantMode 0)
(VariantName "")
)
(CompList
(SETTINGS
(CSV TRUE)
(CSVQUOTED TRUE)
(CSVSEPARATOR ",")
(HEADERCAPTIONS TRUE)
(HEADERUNDERLINE FALSE)
(KEEPREPEATS TRUE)
(GRANDTOTAL FALSE)
(REVERSECOORDS FALSE)
(REVERSEROTATION FALSE)
(SELECTIONMODE 0)
(IGNORESUPPRESSION TRUE)
)
(SELECTION
(FIELDTYPE SIDE)
(ATTRNAME "")
(INTVALUE 0)
(STRVALUE "")
(OPERATOR 0)
)
(SELECTION
(FIELDTYPE COMPTYPE)
(ATTRNAME "")
(INTVALUE 1)
(STRVALUE "")
(OPERATOR 0)
)
(COLUMN
(FIELD COMPNAME) (ALIGN LEFT)
(CAPTION "Designator")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD PACKAGE) (ALIGN LEFT)
(CAPTION "Footprint")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD POSITIONX) (ALIGN LEFT)
(CAPTION "Ref X")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD POSITIONY) (ALIGN LEFT)
(CAPTION "Ref Y")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD SIDE) (ALIGN LEFT)
(CAPTION "Layer")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD ROTATION) (ALIGN LEFT)
(CAPTION "Rotation")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD FOOTPRINT) (ALIGN LEFT)
(CAPTION "Comment")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
)
)

[fcawth]

I use Cadence PCB tools (Orcad and Allegro). I have to take the data from the BOM and the placement file in order to generate liteplacer data, but it is not really that difficult.

[MPaulHolmes]

I use DesignSpark for all PCB work.

I used Eagle quite a bit in the past. I moved to DS because of Eagle's licensing and board size limitations, plus, quite frankly, because Eagle's "non standard" GUI drove me nuts, no matter how much I used it. DesignSpark was much easier to learn, works very well, and has continued to work as I've moved into selling some of my work. It is not perfect, but it is free, it allows commercial products to be produced on any sized board, and the built in parts libraries are useful. It also has the best library editor I've ever used, in terms of making it easy to build a new schematic/package/component.

I have developed a custom report for DesignSpark to directly feed Liteplacer. I HAVE NOT YET TESTED THIS, other than it loads into the Liteplacer software. In particular, there may be some work yet to do getting "value" properly set.


Anyway, here is a start.

In directory: C:\Users\Public\Documents\DesignSpark PCB 7.0\Report Templates
Make a file with the name you desire for the report, extension ".rft". For example "For Liteplacer.rft"
Inside that file, place the text below.

In DesignSpark, open a PCB and use menu command "Output...Report..." and then your custom report name. It will drop the CSV in the same directory with the project, schematic, and PCB files (not, the plots directory), and open it in Excel. You should be able to directly open the .csv file in LitePlacer.


Danal





(ReportTemplate
(Header
(Version 2)
(Context 1)
)
(Variants
(VariantMode 0)
(VariantName "")
)
(CompList
(SETTINGS
(CSV TRUE)
(CSVQUOTED TRUE)
(CSVSEPARATOR ",")
(HEADERCAPTIONS TRUE)
(HEADERUNDERLINE FALSE)
(KEEPREPEATS TRUE)
(GRANDTOTAL FALSE)
(REVERSECOORDS FALSE)
(REVERSEROTATION FALSE)
(SELECTIONMODE 0)
(IGNORESUPPRESSION TRUE)
)
(SELECTION
(FIELDTYPE SIDE)
(ATTRNAME "")
(INTVALUE 0)
(STRVALUE "")
(OPERATOR 0)
)
(SELECTION
(FIELDTYPE COMPTYPE)
(ATTRNAME "")
(INTVALUE 1)
(STRVALUE "")
(OPERATOR 0)
)
(COLUMN
(FIELD COMPNAME) (ALIGN LEFT)
(CAPTION "Designator")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD PACKAGE) (ALIGN LEFT)
(CAPTION "Footprint")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD POSITIONX) (ALIGN LEFT)
(CAPTION "Ref X")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD POSITIONY) (ALIGN LEFT)
(CAPTION "Ref Y")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD SIDE) (ALIGN LEFT)
(CAPTION "Layer")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD ROTATION) (ALIGN LEFT)
(CAPTION "Rotation")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
(COLUMN
(FIELD FOOTPRINT) (ALIGN LEFT)
(CAPTION "Comment")
(COLLATE FALSE)
(COLLATESEPARATOR "")
(WIDTH 10)
(SUM FALSE)
(PRECISION 0)
(VISIBLE TRUE)
(TEXT "")
(JOINCOLUMNS FALSE)
(JOINSEPARATOR "")
(NEWLINE FALSE)
)
)
)

Thank you so much for doing that, Danal. I use DesignSpark for the reasons you listed, and I'm going to try this once I get the liteplacer working.