| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 113958 | 2010-11-12 02:17:00 | Hyperterminal DDE Server? | NZMacka (11756) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1152196 | 2010-11-12 02:17:00 | Hi Guys, We have just bought a new premises for work and it has a DSC alarm system with a COM port interface card on it. Being in the trade, we hooked up the laptop and fired up good old hyperterminal.... We were pleased to see that we could receive codes such as this: 00332 0032A 00130 00128 00231 00229 and so on..... The codes effectively show the zones openiong and closing when the PIR's are triggered.... also other time stamp and arm/disarm codes come up. What we would like to do is take the data from Hyperterminal and export it in realtime to Excel to show how many times the zones opened closed and when. When the system armed/disarmed, went into alarm etc... We are electricians/comms techs, so software is not really a strong point. The alarm company can sell us a software app, but it is ludicrously expensive and we don't need it htat badly. But do you think the other idea is possible? Is there a cheap way to get the live hyperterminal data into excel or something similar? Appreciate any help - in the meantime we will keep googling... |
NZMacka (11756) | ||
| 1152197 | 2010-11-12 02:29:00 | I see a demarcation dispute arising here ... I shall have to consult with the komittee :D | SP8's (9836) | ||
| 1152198 | 2010-11-12 02:43:00 | :) Spose there could be! Have Hyperterminal saving the alarm output to a TXT file on the Workshop Lab desktop now, we can export this manually into Excel 2010, but this is far from realtime... There must be another way... :badpc: |
NZMacka (11756) | ||
| 1152199 | 2010-11-12 02:57:00 | Something like this ? (www.mrexcel.com) | Speedy Gonzales (78) | ||
| 1152200 | 2010-11-12 03:03:00 | Hiya Speedy, that certainly looks interesting..... However, we are sparkies... with limited software know how! How do we make that code work? Does it run in Excel or another app? Your advice is greatly appreciated :) |
NZMacka (11756) | ||
| 1152201 | 2010-11-12 03:13:00 | Err pass, I'm no excel expert. I dont know use Excel let alone VB What version of Office is installed? |
Speedy Gonzales (78) | ||
| 1152202 | 2010-11-12 03:41:00 | This (dev.emcelettronica.com) may help | Speedy Gonzales (78) | ||
| 1 | |||||