AutoCAD Electrical General Discussion

AutoCAD Electrical General Discussion

Reply
Contributor
jschauer
Posts: 22
Registered: ‎08-27-2003
Message 1 of 4 (93 Views)

AE2005 SS to PLC read problem

93 Views, 3 Replies
08-05-2004 03:09 PM
Could someone at Autodesk please try to import the attached test spreadsheet under AutoCAD Electrical 2005 using the SS --> PLC routine to see if you get the AutoCAD error mesage as follows:

Command:
Sheet: 'Governor DO$' record count: 93
Sheet: 'Gov DO Header (Hold)$' record count: 70
Sheet: 'Gov DO Header (Hold)$'_
Program error...bad argument type: fixnump: nil
Command:

This message appears after selecting the "Spreadsheet / Table Columns" button on "Settings" dialog.

We do not get this message when we tested it under AE 2004. Instead we get the normal "Table Insert" selection dialog box.

I've attached the test spreadsheet and a .doc file that further details the problem.

-JS
Distinguished Contributor
rstein
Posts: 143
Registered: ‎03-19-2004
Message 2 of 4 (93 Views)

Re: AE2005 SS to PLC read problem

08-05-2004 05:59 PM in reply to: jschauer
JS,
However I am not from Autodesk, I did indeed get the same error you were getting. I ran a few tests, all with the same results except for one. I was able to copy all the cells into a new excel file, then save it. At that point you can then use the SS>plc utility. I hope this helps.
*Nate Holt
Message 3 of 4 (93 Views)

Re: AE2005 SS to PLC read problem

08-06-2004 07:10 AM in reply to: jschauer
I don't know why it is choking on your spreadsheet. But the SS-->PLC I/O routine is provided in full-source format for users to customize. You can go into your copy of c:\program files\autodesk\acade 2004\support\wdio.lsp and make this change to try to bypass where the program is choking when it's reading your spreadsheet. Open with any ASCII text editor (ex: wordpad.exe). Look for this snippet of code in your copy of wdio.lsp and add in the one line as shown: (foreach tab tabnams (princ (strcat "\n" (c:wd_msg "SWAP030" nil "Sheet:") " ")) (princ tab) (setq x (wd_mdb_GetRecCount GBL_wdio_ff tab)) (if (not x)(setq x 0)) ;;; <<== add in this line (princ (c:wd_msg "SWAP031" nil ", record count=")) (princ x) (if (AND x (> x 2)) (progn (setq tabs_with_data (cons tab tabs_with_data)) ) ) ) See if this resolves the your problem with your spreadsheet. If it doesn't, flip your spreadsheet's column "I" from integer numbe format to "char text". "jschauer" wrote in message news:14529436.1091743803929.JavaMail.jive@jiveforum2.autodesk.com... > Could someone at Autodesk please try to import the attached test spreadsheet under AutoCAD Electrical 2005 using the SS --> PLC routine to see if you get the AutoCAD error mesage as follows: > > Command: > Sheet: 'Governor DO$' record count: 93 > Sheet: 'Gov DO Header (Hold)$' record count: 70 > Sheet: 'Gov DO Header (Hold)$'_ > Program error...bad argument type: fixnump: nil > Command: > > This message appears after selecting the "Spreadsheet / Table Columns" button on "Settings" dialog. > > We do not get this message when we tested it under AE 2004. Instead we get the normal "Table Insert" selection dialog box. > > I've attached the test spreadsheet and a .doc file that further details the problem. > > -JS
Contributor
jschauer
Posts: 22
Registered: ‎08-27-2003
Message 4 of 4 (93 Views)

Re: AE2005 SS to PLC read problem

08-10-2004 09:22 AM in reply to: jschauer
Thanks to both of you for your feedback on this topic.

Nate, I implemented the suggested code string and the glitch has been rectified as a result.

Rob, Thanks also for your input, that was a logical workaround as well.
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions to get help installing your software.

New AutoCAD Electrical Category!

The AutoCAD Electrical forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.

Announcements
Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.