News:

  • June 28, 2026, 09:39:49 PM

Login with username, password and session length

« previous next »
Pages: [1] 2 3

Author Topic: Data Import  (Read 52711 times)

CReese

  • Hero Member
  • *****
  • Posts: 184
Data Import
« 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.
Logged

Controls Guy

  • Internal Dev
  • Hero Member
  • ****
  • Posts: 3612
  • Darth Ladder
Re: Data Import
« Reply #1 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**
Logged
I retract my earlier statement that half of all politicians are crooks.  Half of all politicians are NOT crooks.  There.

CReese

  • Hero Member
  • *****
  • Posts: 184
Re: Data Import
« Reply #2 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?
Logged

CReese

  • Hero Member
  • *****
  • Posts: 184
Re: Data Import
« Reply #3 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.
Logged

ATU

  • Internal Dev
  • Hero Member
  • ****
  • Posts: 2126
  • YKPAIHA
    • ATU, Inc.
Re: Data Import
« Reply #4 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?
Logged

rlp122

  • Sr. Member
  • ****
  • Posts: 91
Re: Data Import
« Reply #5 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.
Logged

BobO

  • Host Moderator
  • Hero Member
  • *****
  • Posts: 6164
  • Yes Pinky, Do-more will control the world!
Re: Data Import
« Reply #6 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.
Logged
"It has recently come to our attention that users spend 95% of their time using 5% of the available features. That might be relevant." -BobO

ATU

  • Internal Dev
  • Hero Member
  • ****
  • Posts: 2126
  • YKPAIHA
    • ATU, Inc.
Re: Data Import
« Reply #7 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.   ;)
Logged

BobO

  • Host Moderator
  • Hero Member
  • *****
  • Posts: 6164
  • Yes Pinky, Do-more will control the world!
Re: Data Import
« Reply #8 on: September 09, 2013, 10:17:11 PM »
Quote from: 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.   ;)

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...
Logged
"It has recently come to our attention that users spend 95% of their time using 5% of the available features. That might be relevant." -BobO

Controls Guy

  • Internal Dev
  • Hero Member
  • ****
  • Posts: 3612
  • Darth Ladder
Re: Data Import
« Reply #9 on: September 10, 2013, 01:02:30 AM »
Quote from: 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.

Well, like I was saying, transmit the data into MB memory and then MOVER it into regular memory.
Logged
I retract my earlier statement that half of all politicians are crooks.  Half of all politicians are NOT crooks.  There.

Controls Guy

  • Internal Dev
  • Hero Member
  • ****
  • Posts: 3612
  • Darth Ladder
Re: Data Import
« Reply #10 on: September 10, 2013, 01:07:39 AM »
Quote from: 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.

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.
Logged
I retract my earlier statement that half of all politicians are crooks.  Half of all politicians are NOT crooks.  There.

Stephen

  • Limited Software Resource
  • Jr. Member
  • **
  • Posts: 13
Re: Data Import
« Reply #11 on: September 10, 2013, 11:04:08 AM »
Quote from: 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.   ;)

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

Controls Guy

  • Internal Dev
  • Hero Member
  • ****
  • Posts: 3612
  • Darth Ladder
Re: Data Import
« Reply #12 on: September 10, 2013, 12:22:19 PM »
Quote from: Stephen on September 10, 2013, 11:04:08 AM
We actually did try cloning Bob, but there were...issues: 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
Logged
I retract my earlier statement that half of all politicians are crooks.  Half of all politicians are NOT crooks.  There.

Controls Guy

  • Internal Dev
  • Hero Member
  • ****
  • Posts: 3612
  • Darth Ladder
Re: Data Import
« Reply #13 on: September 10, 2013, 12:24:59 PM »
Course this sheds a whole new light on "Franj1"...
Logged
I retract my earlier statement that half of all politicians are crooks.  Half of all politicians are NOT crooks.  There.

franji1

  • Bit Weenie
  • Host Moderator
  • Hero Member
  • *****
  • Posts: 3827
    • Host Engineering
Re: Data Import
« Reply #14 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
Logged
Pages: [1] 2 3
« previous next »