Re: [PEDA] Spread sheet woes

2001-05-07 Thread Mark E Witherite
 


Re: [PEDA] Spread sheet woes

2001-05-07 Thread Coleman, Tim

Why not export your spreadsheet as a csv file and then you can import it
into XL?

-Original Message-
From: Mark E Witherite [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 5:06 PM
To: Protel EDA Forum
Subject: [PEDA] Spread sheet woes


Hi Everyone,
 I've been working with the spread sheet server that came with 
Protel and it's been giving me a lot of grief .  I can't do a block 
copy.  The undo command causes an attempt to commit a rollback with no 
transaction  error .  Lastly when I deleted a block of cells, all the 
cells to the  right shifted over to the left. (now all my columns are 
misalignment.
 My question is, can I change the spreadsheet server to Excel?  And 
if so how do I do it?

 If I can't change over is there a possibly that My spreadsheet 
server is corrupted ?
Thanks in advance
Mark Witherite
Sr Research Technologist
Astronomy  Astrophysics
Penn State University
2565 Park Center Blvd
Suite 200
State College, PA.  16801
email [EMAIL PROTECTED]
telephone 814 865 9839
fax   814 865 9100
IPC PWB  Certified


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* To post a message: mailto:[EMAIL PROTECTED]
*
* To join or leave this list visit:
* http://www.techservinc.com/protelusers/subscrib.html
*  - or email -
* mailto:[EMAIL PROTECTED]?body=leave%20proteledaforum
*
* Contact the list manager:
* mailto:[EMAIL PROTECTED]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



Re: [PEDA] Spread sheet woes

2001-05-07 Thread Ian Wilson

John,

I just had a look at the Sch:ExportSchematicToDatabase and the matching 
import.  Didn't go into it much. How does the import match what component 
is to be updated?  Is it by designator? Or can you control it?

What if I was to try to say fatten up only some of the arcs in a design - 
how can you match up the arc in the database with that in the sch? (Not a 
good example as there are other ways of doing it but humour me please.)

The spreadsheet method exports the objecthandle so you are free to muck 
about with and change designators, and just change one arc out of 1000's of 
identical looking ones. (Dunno why one would wish to be it can be done, we 
have the technology.)

I also found, very easily, a method of corrupting the database fields list 
by simply removing a mapped attribute. Is this normal?

Looks to me like the issue you avoid (that is keeping the Sch or PCB open) 
is no more onerous than the difficulties in managing the import.  That 
said, I have learnt a new way that will be useful at times when I wish to 
do a large number of edits over a number of days (rare).

Also, export to database should not be confused with linking to a database 
(I can see you are not, John).

Thanks for the tip - I did not know the export to database processes 
existed and it may prove useful one day.

Ian

At 04:11 PM 15/03/2001 +1100, John Haddy wrote:
I avoid this whole issue by using the ExportToDatabase
and ImportFromDatabase processes.

i.e. export all the needed fields (in my case, part fields)
to a .DBF file, then open the .DBF with Excel and edit away.
I save my work as .XLS format, then export a new .DBF from
Excel when I'm ready (just remember to make the columns wide
before doing so, since the Excel export fixes the .DBF widths
automagically, based on the sheet columns.

You just need to be aware that the ImportFromDatabase process
takes forever and gives no status indication whatsoever.

Cheers,

John Haddy

  -Original Message-
  From: Ian Wilson [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, 15 March 2001 8:52 AM
  To: Protel EDA Forum
  Subject: Re: [PEDA] Spread sheet woes
 
 
  On 02:09 PM 14/03/2001 -0600, Mark E Witherite said:
 
  Hi Tim,
   I am using the spread sheet to edit my schematics and
  PCB.  I did
   an export to spread sheet.  I need to be able to upload back into the
   schematic and PCB.  Will I be able to?
  
  At 04:32 PM 3/14/01 +, you wrote:
  Why not export your spreadsheet as a csv file and then you can import it
  into XL?
 
 
  The trick here is to keep Protel (and the PCB/Sch design open)
  while you do
  the spreadsheet edits.  Protel keeps track of the changes using the
  all-important objectHandle.  This varies from session to session. If you
  close the SCH/PCB you will probably have problems merging changes
  from the
  spread back into the design.
 
..snip..

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* To post a message: mailto:[EMAIL PROTECTED]
*
* To join or leave this list visit:
* http://www.techservinc.com/protelusers/subscrib.html
*  - or email -
* mailto:[EMAIL PROTECTED]?body=leave%20proteledaforum
*
* Contact the list manager:
* mailto:[EMAIL PROTECTED]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



Re: [PEDA] Spread sheet woes

2001-05-07 Thread John Haddy

The import can match on _any_ field (which is why I use it in preference
to the database linking function).

As I mentioned, I usually use the functions to extract part information.
I then clean up the fields, making sure that all common parts have identical
information in the fields that we use for BOM generation (I use fields for
description, manufacturer, mfr part #, tolerance, component height, etc.) so
that I don't get discrete BOM entries because of a typo somewhere. Then I
reimport, usually keyed on the designator.

You mention that:

 Looks to me like the issue you avoid (that is keeping the Sch or PCB open)
 is no more onerous than the difficulties in managing the import.

The reasons I started doing exports and imports was due to:
a) repetitive Protel crashes (back when I was using a Win98 box)
b) a bug in Protel's spreadsheet exports that meant that a 12p capacitor
suddenly became 12:00pm!

a) is not so much a problem now that I'm on Win2k
b) was fixed in SP6 but I'm still avoiding that release since, when I did
try
to load it, I wasn't able to enter license codes without a system crash!)

As for the other exports possible (like arc primitive attributes), I haven't
played with them so I can't help much.

Cheers,

John Haddy

 -Original Message-
 From: Ian Wilson [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, 15 March 2001 5:01 PM
 To: Protel EDA Forum; Protel EDA Forum
 Subject: Re: [PEDA] Spread sheet woes


 John,

 I just had a look at the Sch:ExportSchematicToDatabase and the matching
 import.  Didn't go into it much. How does the import match what component
 is to be updated?  Is it by designator? Or can you control it?

 What if I was to try to say fatten up only some of the arcs in a design -
 how can you match up the arc in the database with that in the sch? (Not a
 good example as there are other ways of doing it but humour me please.)

 The spreadsheet method exports the objecthandle so you are free to muck
 about with and change designators, and just change one arc out of
 1000's of
 identical looking ones. (Dunno why one would wish to be it can be
 done, we
 have the technology.)

 I also found, very easily, a method of corrupting the database
 fields list
 by simply removing a mapped attribute. Is this normal?

 Looks to me like the issue you avoid (that is keeping the Sch or
 PCB open)
 is no more onerous than the difficulties in managing the import.  That
 said, I have learnt a new way that will be useful at times when I wish to
 do a large number of edits over a number of days (rare).

 Also, export to database should not be confused with linking to a
 database
 (I can see you are not, John).

 Thanks for the tip - I did not know the export to database processes
 existed and it may prove useful one day.

 Ian

 At 04:11 PM 15/03/2001 +1100, John Haddy wrote:
 I avoid this whole issue by using the ExportToDatabase
 and ImportFromDatabase processes.
 
 i.e. export all the needed fields (in my case, part fields)
 to a .DBF file, then open the .DBF with Excel and edit away.
 I save my work as .XLS format, then export a new .DBF from
 Excel when I'm ready (just remember to make the columns wide
 before doing so, since the Excel export fixes the .DBF widths
 automagically, based on the sheet columns.
 
 You just need to be aware that the ImportFromDatabase process
 takes forever and gives no status indication whatsoever.
 
 Cheers,
 
 John Haddy
 
   -Original Message-
   From: Ian Wilson [mailto:[EMAIL PROTECTED]]
   Sent: Thursday, 15 March 2001 8:52 AM
   To: Protel EDA Forum
   Subject: Re: [PEDA] Spread sheet woes
  
  
   On 02:09 PM 14/03/2001 -0600, Mark E Witherite said:
  
   Hi Tim,
I am using the spread sheet to edit my schematics and
   PCB.  I did
an export to spread sheet.  I need to be able to upload
 back into the
schematic and PCB.  Will I be able to?
   
   At 04:32 PM 3/14/01 +, you wrote:
   Why not export your spreadsheet as a csv file and then you
 can import it
   into XL?
  
  
   The trick here is to keep Protel (and the PCB/Sch design open)
   while you do
   the spreadsheet edits.  Protel keeps track of the changes using the
   all-important objectHandle.  This varies from session to
 session. If you
   close the SCH/PCB you will probably have problems merging changes
   from the
   spread back into the design.
  
 ..snip..



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* To post a message: mailto:[EMAIL PROTECTED]
*
* To join or leave this list visit:
* http://www.techservinc.com/protelusers/subscrib.html
*  - or email -
* mailto:[EMAIL PROTECTED]?body=leave%20proteledaforum
*
* Contact the list manager:
* mailto:[EMAIL PROTECTED]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



Re: [PEDA] Spread sheet woes

2001-05-07 Thread Mark E Witherite