Programmer4
Member
Does anyone know how to import an autocad electrical I/O spreadsheet into an RSLogix 500 project.
Autocad Electrical 2008 and RSLogix 500
- Thread starter Programmer4
- Start date
OkiePC
Lifetime Supporting Member
Open an existing RSLogix500 project, and go to Tools > Database > ASCII Export > then go to the CSV tab and create a csv file.
Then open the csv file with Excel, and you can see the structure that RSLogix 500 uses for import.
Open your autocad spreadsheet side by side, and copy and paste the portions you want into the csv file.
You can delete stuff that you don't need to mess with like the S status file comments and such.
When you have the file populated with the data you want, you can then import it back into RSLogix. It will replace the comments that you have edited with whatever is in your csv file.
Note that the comments database for address is broken into several fields. The first one is the symbol field. All symbols in RSLogix must be unique. The next 5 columns represent the 5 lines in the address comment. By default, RSLogix allows 20 characters per line, so you may need to edit the descriptions to conform to this limit, or they'll get truncated.
I like to display the entire worksheet with the font "Courier New" which is a fixed width font. You can then adjust the column width and easily see when you are running out of characters in a cell.
This should get you started...
Then open the csv file with Excel, and you can see the structure that RSLogix 500 uses for import.
Open your autocad spreadsheet side by side, and copy and paste the portions you want into the csv file.
You can delete stuff that you don't need to mess with like the S status file comments and such.
When you have the file populated with the data you want, you can then import it back into RSLogix. It will replace the comments that you have edited with whatever is in your csv file.
Note that the comments database for address is broken into several fields. The first one is the symbol field. All symbols in RSLogix must be unique. The next 5 columns represent the 5 lines in the address comment. By default, RSLogix allows 20 characters per line, so you may need to edit the descriptions to conform to this limit, or they'll get truncated.
I like to display the entire worksheet with the font "Courier New" which is a fixed width font. You can then adjust the column width and easily see when you are running out of characters in a cell.
This should get you started...
Paul B
Member
Good tip on the Courier New font. I'll remember that!
OkiePC
Lifetime Supporting Member
Yeah, any fixed width font will work. I like Courier New because its' a true type font that makes printing and sizing more user friendly.
Another thing I have learned, is that if your description line begins with a math operator, Excel will usually think its an invalid formula and replace it with #NAME? This happened to me the other day and I ended up with about a dozen comments like that for adresses that I did not edit. I didn't find a simple way to avoid that, I just put those back to normal manually.
A person could probably configure excel to imprt the csv file and treat all cells as text to avoid this.
Paul
Another thing I have learned, is that if your description line begins with a math operator, Excel will usually think its an invalid formula and replace it with #NAME? This happened to me the other day and I ended up with about a dozen comments like that for adresses that I did not edit. I didn't find a simple way to avoid that, I just put those back to normal manually.
A person could probably configure excel to imprt the csv file and treat all cells as text to avoid this.
Paul
Similar Topics
:banghead: can anybody help me out with the real concept of "Autocad Electrical 2008 location code".I am using it for a last couple of months but...
Greetings,
I use ACE 2008...Does anyone know how to install express tools with this product? It doesn't appear to be available....If I remember...
Why is my DIN rail not scaled to my drawing?
Hi Expert:
I have used EPlan at previous job, now in the new job they use AutoCAD Electrical, just finished one training at Udemy, it is not good...
Hi everyone,
this is a bit off topic and support has not gotten back with me.
I am using Autocad electrical and i need to do some mechanical...