Print Page | Close Window

FPX Editor - Pasting Data in Multiple Columns

Printed From: PCB Libraries Forum
Category: PCB Footprint Expert
Forum Name: Questions & Answers
Forum Description: issues and technical support
URL: https://www.PCBLibraries.com/forum/forum_posts.asp?TID=591
Printed Date: 07 Oct 2024 at 9:35am


Topic: FPX Editor - Pasting Data in Multiple Columns
Posted By: Matthew Lamkin
Subject: FPX Editor - Pasting Data in Multiple Columns
Date Posted: 03 Oct 2012 at 4:32am

1)      When creating a new column in the list of parts, I am unable to select multiple cells and paste information in like I can do with a spread sheet.

I think it needs to be able to do this so a user can easily add similar data on the parts.


Replies:
Posted By: Tom H
Date Posted: 21 Oct 2012 at 8:59am
The workaround is to open your FPX file in M/S Excel and do all your automated text editing.
 
Then select all Cells by "Ctrl + A" (Select All) and then Copy - Ctrl + C into Notepad and then File Save_As your FPX file name.
 
I use Excel for performing mass editing of our FPX files. It's extremely productive.
 

Posted By: Tom H
Date Posted: 29 Oct 2012 at 6:16am
Open Excel > File > Import > All File Types > xxxx.fpx > Tab Delimiter > Separate (open) Columns
 
Edit all you want, but I would not change any info in Columns A or B. Column "A" is the Component Family which opens the correct Calculator menu. Column "B" is the Units, Family and Component Dimensions. I gues you could edit the Component Dimensions if you know what you're doing.
 
When Excel editing is completed, select all active cells (Ctrl + A) and Ctrl + C (Copy) and then open Notepad Text Editor and Ctrl + V (Paste) and "File Save As" xxxx.fpx.
 
Open the file in the PCB Footprint Expert and test it out. It may take some people a couple attempts to get it right, but I use Excel everyday for mass FPX file editing.
 

Posted By: Matthew Lamkin
Date Posted: 30 Oct 2012 at 6:53am
OK got that, I was trying to separate the data items, with them all in the same field its OK.

Posted By: Tom H
Date Posted: 26 Mar 2017 at 11:50am
You can now select any cell in Library Editor and RMB > Copy and then select multiple cells and RMB > Paste.



-------------
Stay connected - follow us! https://twitter.com/PCBLibraries" rel="nofollow - X - http://www.linkedin.com/company/pcb-libraries-inc-/" rel="nofollow - LinkedIn


Print Page | Close Window