Your Universal Remote Control Center
RemoteCentral.com
RTI Control Systems Forum - View Post
Previous section Next section Up level
Up level
The following page was printed from RemoteCentral.com:

Login:
Pass:
 
 

Topic:
Interesting blip about the 232 library.
This thread has 6 replies. Displaying all posts.
Post 1 made on Monday February 11, 2008 at 21:48
AndyM
Founding Member
Joined:
Posts:
March 2002
1,470
Sent an email to Brett in a panic the other night... only to realize it was a big brain fart on my end. Brett responded back with a helpful little tidbit that I was unaware of.

"you can copy and paste into the rs232 library from excel

- Create a two column excel spreadsheet – column 1 contains string names, column 2 is the strings
- Copy cells from the two columns of excel spreadsheet
- Open rs232 library mgr, add a new device
- Click on Edit>Paste"

I don't have anything set up that way at the moment, but I know some manufacturers do their 232 documentation in Excel (Marantz?). Makes for easy transfer.
Post 2 made on Tuesday February 12, 2008 at 18:59
cassidycaid
Founding Member
Joined:
Posts:
October 2001
256
Ver noice...
Scientific method refers to the body of techniques for investigating phenomena, acquiring new knowledge, or correcting and integrating previous knowledge.
OP | Post 3 made on Wednesday February 13, 2008 at 17:43
AndyM
Founding Member
Joined:
Posts:
March 2002
1,470
I had a chance to try this today and it works great. As long as you have your ducks in a row, it makes it very easy.






*edit for typo

Last edited by AndyM on February 14, 2008 15:26.
Post 4 made on Friday February 22, 2008 at 11:23
estech
Active Member
Joined:
Posts:
August 2002
584
Well, I must be missing something obvious, because I can't paste anything using "paste/edit" in the RS232 Manager. Paste is grayed out.

If I Add String, and then click the function name I can only "right-click/paste" a name into the field, not Ctrl-V. But, I can easily paste into the string field, one string at a time.

RS232 Library Manager version is 1.0.0.218


On February 13, 2008 at 17:43, AndyM said...
I had a chance to try this today and it works great. As
long as you have your ducks in a row, it makes it very
easy.

Are you pasting one command at a time, or the entire library from the excel spreadsheet? From the post above it sounds like you're pasting both columns at once.

I would really like to make this work, as the spreadsheet I'm copying from has over 370 strings.

Last edited by estech on February 22, 2008 11:37.
Pay no attention to that man behind the curtain.
OP | Post 5 made on Sunday February 24, 2008 at 00:35
AndyM
Founding Member
Joined:
Posts:
March 2002
1,470
I can't remember... and I don't have my work laptop in font of me.

I think I did each column separately.
Post 6 made on Sunday February 24, 2008 at 14:10
ErikS
Active Member
Joined:
Posts:
July 2003
699
On February 22, 2008 at 11:23, estech said...
Well, I must be missing something obvious, because I can't
paste anything using "paste/edit" in the RS232 Manager.
Paste is grayed out.

If you have a two column sheet in excel and column A is your Function and B is the hex or ascii string, you highlight all commands and copy. Then in the RS232 library manager, select edit at top and paste. It will only do it if you copy both the function and string columns.

You do not have to "add string" to paste. The editor automatically creates new ones to paste into. This helps so if you already have 10 commands and add they won't be erased.
Post 7 made on Monday February 25, 2008 at 13:54
estech
Active Member
Joined:
Posts:
August 2002
584
My bad...
I've been using OpenOffice's Calc to view excel spreadsheets on one computer, and it's been on this PC for so long, that I forgot it wasn't Excel.

Thinking that might be my problem, I installed Microsofts free Excel Viewer, and Copy/Paste worked perfectly.

What a time saver!!! (After wasting a bunch of time) :)
Pay no attention to that man behind the curtain.


Jump to


Protected Feature Before you can reply to a message...
You must first register for a Remote Central user account - it's fast and free! Or, if you already have an account, please login now.

Please read the following: Unsolicited commercial advertisements are absolutely not permitted on this forum. Other private buy & sell messages should be posted to our Marketplace. For information on how to advertise your service or product click here. Remote Central reserves the right to remove or modify any post that is deemed inappropriate.

Hosting Services by ipHouse