Host Engineering Forum

General Category => Do-more CPUs and Do-more Designer Software => Topic started by: CReese on September 09, 2013, 12:17:30 PM

Title: Data Import
Post by: CReese on September 09, 2013, 12:17:30 PM
Is there any way to import data? I see that I can import documentation, which is nice, but I don't see a way to do it with values. I have probably 3 x 100 data fields to enter. Spreadsheet/csv import would be great.
Title: Re: Data Import
Post by: Controls Guy on September 09, 2013, 12:30:37 PM
I don't think so.  I know you can save a copy of data, and even restore it selectively later.  I guess if the storage format is simple enough, you could build a save file and then restore, but that sounds fraught with danger and more work than just entering the data by hand, at least for 300 values.

The other approach (also more work for 300 values, but would be worthwhile for a couple thousand) would be to do an HMI script to read the values from CSV and write them to DL or MB memory (since most HMI's don't have native drivers yet), then MOVER to D/N/V memory unless DL/MB is where you wanted it.

**another case where the tabular memory view ("memory dump") with optimized data entry keystrokes will be a time saver**
Title: Re: Data Import
Post by: CReese on September 09, 2013, 12:35:54 PM
Of course. I should just write a Python script to read my csv file and write them over modbus TCP/IP. Why didn't I think of that?
Title: Re: Data Import
Post by: CReese on September 09, 2013, 12:36:42 PM
Crap. Except DoMores, as opposed to the DL205, don't expose everything over MB. I know this is a feature, but at the moment it's a bug.
Title: Re: Data Import
Post by: ATU on September 09, 2013, 01:05:11 PM
Would it be possible on the DoMore side to write an ftp protocol, read in the file and parse it as you wish?
Title: Re: Data Import
Post by: rlp122 on September 09, 2013, 01:19:53 PM
IIRC this was discussed a few weeks back and HOST said that they would look into it.
Title: Re: Data Import
Post by: BobO on September 09, 2013, 02:55:19 PM
So far, some of this is a bit rustic. We want to do better in time, but the problem becomes determining which issues get attention first. I've heard this a few times now and it seems like a memory content import/export/viewer/editor would be a welcome tool. A basic import/export of values would be far easier than the viewer/editor...since UI is always painful. We just need to see where the best release to do such things is and to set good priorities. I'm told that folks would really love to see Do-more on lower-end platforms...which might be a priority ;)...but it's hard to be three or four places at the same time.
Title: Re: Data Import
Post by: ATU on September 09, 2013, 08:28:48 PM
Oh come on Bob, we know you have at least 2 clones in your office closet and problem one at home. No one normal human could do all that you accomplish in one day.   ;)
Title: Re: Data Import
Post by: BobO on September 09, 2013, 10:17:11 PM
Oh come on Bob, we know you have at least 2 clones in your office closet and problem one at home. No one normal human could do all that you accomplish in one day.   ;)

I'm actually at my daughter and son-in-law's house, enjoying some time with my 10-day-old granddaughter. But fear not...I actually brought a laptop, a board development interface, and a piece of prototype hardware with me. Seriously...I really need to find a hobby...
Title: Re: Data Import
Post by: Controls Guy on September 10, 2013, 01:02:30 AM
Crap. Except DoMores, as opposed to the DL205, don't expose everything over MB. I know this is a feature, but at the moment it's a bug.

Well, like I was saying, transmit the data into MB memory and then MOVER it into regular memory.
Title: Re: Data Import
Post by: Controls Guy on September 10, 2013, 01:07:39 AM
So far, some of this is a bit rustic. We want to do better in time, but the problem becomes determining which issues get attention first. I've heard this a few times now and it seems like a memory content import/export/viewer/editor would be a welcome tool. A basic import/export of values would be far easier than the viewer/editor...since UI is always painful. We just need to see where the best release to do such things is and to set good priorities. I'm told that folks would really love to see Do-more on lower-end platforms...which might be a priority ;)...but it's hard to be three or four places at the same time.

BobO, just do an importer/exporter with minimal UI (probably a dialog), but use a well-defined and convenient ASCII file format, and you can leverage Excel, Access, etc., as the file building UIs.  Just make it read appropriately structured CSV's, for example, and make the structure definition convenient to look at in spreadsheet form, and your UI work is done.

If the file format were proprietary, you could only reload data files that were previously exported from a Do-More.
Title: Re: Data Import
Post by: Stephen on September 10, 2013, 11:04:08 AM
Oh come on Bob, we know you have at least 2 clones in your office closet and problem one at home. No one normal human could do all that you accomplish in one day.   ;)

We actually did try cloning Bob, but there were...issues: http://www.youtube.com/watch?v=_s1ERA8KRBU (http://www.youtube.com/watch?v=_s1ERA8KRBU).
Title: Re: Data Import
Post by: Controls Guy on September 10, 2013, 12:22:19 PM
We actually did try cloning Bob, but there were...issues: http://www.youtube.com/watch?v=_s1ERA8KRBU (http://www.youtube.com/watch?v=_s1ERA8KRBU)


Ohh!  So that character at the end of his forum name is a zero....I thought it was "BobO" like a nickname....now I see you mean he's "Bob No. 0"....first unit....etc.   :D
Title: Re: Data Import
Post by: Controls Guy on September 10, 2013, 12:24:59 PM
Course this sheds a whole new light on "Franj1"...
Title: Re: Data Import
Post by: franji1 on September 10, 2013, 12:33:57 PM
Bob0 started on TISOFT at TI in the late 80's when Koyo PLCs were added.  Koyo data blocks started at 0 (X0, V0).

Franji1 started on TISOFT in the TI-560 days, mid 80's, where the TI data blocks started with a 1 (X1, V1).  ;D
Title: Re: Data Import
Post by: Controls Guy on September 10, 2013, 12:45:23 PM
Ah!  Knew there was an explanation!   ;D
Title: Re: Data Import
Post by: BobO on September 10, 2013, 01:20:35 PM
Oh come on Bob, we know you have at least 2 clones in your office closet and problem one at home. No one normal human could do all that you accomplish in one day.   ;)

We actually did try cloning Bob, but there were...issues: http://www.youtube.com/watch?v=_s1ERA8KRBU (http://www.youtube.com/watch?v=_s1ERA8KRBU).

Bob3: "Hey Thteeev-en"
Title: Re: Data Import
Post by: Controls Guy on September 10, 2013, 02:00:55 PM
You want some peet-tha?  I got thome in my wallet!   :D

Actually, Thteve quotes are a favorite at our house!
Title: Re: Data Import
Post by: BobO on September 10, 2013, 02:41:04 PM
Gotta love a guy who shaves his tongue!
Title: Re: Data Import
Post by: ATU on September 10, 2013, 06:51:45 PM

I'm actually at my daughter and son-in-law's house, enjoying some time with my 10-day-old granddaughter. But fear not...I actually brought a laptop, a board development interface, and a piece of prototype hardware with me.

Gosh, isn't she a little young for all that tech gear, come-on you have to give them a little time to grow up and play with blocks and stuff.
Title: Re: Data Import
Post by: Controls Guy on September 10, 2013, 09:20:53 PM
Ya gotta start em young these days, ATU.  If they haven't done their own website by 9 months, they'll never catch the pace.   :D
Title: Re: Data Import
Post by: CReese on September 19, 2013, 01:54:40 PM
Even the ability to text into Data Viewer edit fields would be great. Then I could at least paste in an array of values 100 at a time. As it is, I can paste exactly zero text into a string edit field.
Title: Re: Data Import
Post by: BobO on September 19, 2013, 02:14:37 PM
As it is, I can paste exactly zero text into a string edit field.

Yeah...that's a bug.

FWIW...we might actually be creating a memory import/export facility that may or may not show up in a release that might ship in the next couple of months. ::)
Title: Re: Data Import
Post by: CReese on September 19, 2013, 02:19:09 PM
I look forward to that. As it is, I'll describe my scenario:

1024 digital + 512 analog alarm/reads, each with 9 fields.

25-30 block reads, each with about 6 fields.

This boat goes in the water around the beginning of the year, so it will get done. I may hire a monkey to do it.
Title: Re: Data Import
Post by: BobO on September 19, 2013, 02:24:00 PM
I might could hook you up with a beta...
Title: Re: Data Import
Post by: CReese on September 19, 2013, 02:50:41 PM
might be a good idea. I guess I could think about a more intelligent way to do it as well. I'll have a linux box I can set up as a MB server, so I could keep the read map on the network and upload it periodically. This way administrators could modify it from a UI. Keep it in a database and have the MB server act as go-between.

If I'm going to go this far, however, I may as well just have the linux box do all of the read/logging. Ideas.
Title: Re: Data Import
Post by: CReese on October 17, 2013, 10:42:35 AM
Hey Bob,

We any closer to a beta on this? I'm finishing up my memory map. Total count is ~1500 items.

C
Title: Re: Data Import
Post by: BobO on October 17, 2013, 11:19:14 AM
Soon...
Title: Re: Data Import
Post by: CReese on October 17, 2013, 02:55:22 PM
This kind of soon?

(https://forum.hosteng.com/proxy.php?request=http%3A%2F%2Fi0.kym-cdn.com%2Fentries%2Ficons%2Foriginal%2F000%2F005%2F673%2Fsoon%2520%281%29.jpg&hash=81f3db71fa469a4efc3896de86652746d4bf5ae0)
Title: Re: Data Import
Post by: BobO on October 17, 2013, 03:04:38 PM
This kind of soon?

(https://forum.hosteng.com/proxy.php?request=http%3A%2F%2Fi0.kym-cdn.com%2Fentries%2Ficons%2Foriginal%2F000%2F005%2F673%2Fsoon%2520%281%29.jpg&hash=81f3db71fa469a4efc3896de86652746d4bf5ae0)

Probably sooner. Based on my knowledge of cats, that is the "I'll kill you someday because you offend me, but near-term I will drop a Baby Ruth in your water bowl" look, rather than an imminent death and dismemberment look.
Title: Re: Data Import NOW IN REL 1.2
Post by: franji1 on October 30, 2013, 11:18:00 AM
Soon is now NOW.  See Do-more 1.2 announcement at top of Do-more forum.