| Author |
 Topic  |
|
|
Mr.Some0ne
Starting Member
Israel
3 Posts |
 Posted - 27 May 2010 : 03:40:30
|
Hello!
I have a problem with log data from PLC Data Tables.
Firstly, I defined the PC-PLC connection via the options located on the Connection menu. The connection is OK.
I add a new Table, and click on "Import Data Table Structure"
I name "myTest" the Data Table Structure, then click on "Read the structure from the PLC".
The "myTest" Data Table Structure listed in left-hand pane but there aren't Table names in the right hand pane. I get a message "This file contais no Data Tables".
I verify the Data Tables via VisiLogic and they are exists in PLC.
If I Import Data Table Structure from .upd file then there is no problem but I need a Data from PLC, not from saved .upd file.
Suggestion pleas... |
Regards,
Mr.$ome0ne |
|
|
Ofir
Moderator
Israel
316 Posts |
Posted - 14 Jun 2010 : 03:02:16
|
Hi,
Which DataXport version are you using?
Are you sure that the PLC contain a application with data tables?
Please try to download the application again to the PLC and test again.
You can also open a new project in Visilogic and try to read the structure of data tables from Data Tables window. (This is just to make sure the Data tables exist on the PLC)
Baiscally after you read the strucure and see in the left pane "My test" - click on "My test" and then you should see in the right pane the tables names.
|
 |
|
|
Harry
Starting Member
USA
6 Posts |
Posted - 15 Jun 2010 : 10:05:23
|
Hi Mr. SomeOne
Last week I was fighting with the same situation;
1) Check if your boud rate is the same in the PLC operating system ( Connection, Comm&OS ), the DataXport ( Connection, Comm-PC Settings and the Desing, PC ports.)
2)When you add the table structure, click read from the PLC on the 2 windows ( Data Table Structure and Table Name ) click the name ( My Test ) on the Data Table Structure, and select the table name you do want to read from the Table Name window.
3) You have to create an Excel file folder in ( Project, Define Excel file at the box go to Program Files, Unitronics, Dataxport, Excel Templates and create a folder for your data table.
Hope this take you out of the problem, good luck
|
Edited by - Harry on 15 Jun 2010 19:03:04 |
|
|
|
some0ne
Starting Member
Israel
3 Posts |
Posted - 19 Jul 2010 : 08:21:05
|
I still solve the problem... meanwhile without success...
Little Bit about PLC Hardware:
The PLC (V570) => V570-57-T20B
Snap In I/O => V200-18-X3EB
TCP/IP Card => V200-19-ET1
The PLC is connected to LAN via Main Switch.
Little Bit about PLC Programm:
I use a VisiLogix 8.6.0
The next logic implemented at the beginning of Main Routine:
************************************************************
NET 1
On the raising of SB2 =>
=> Set PLC Name =>
=> TCP/IP Com Init
IP Address: xxx.xxx.103.125
Subnet Mask: 255.255.0.0
Default Gateway: xxx.xxx.0.1 =>
=> MODBUS IP Configuration [Name MODBUS IP_1]
Socket: Socket 2 Default TCP (502), MODBUS slave
Network ID: Network ID 255
Time out (units of 10 msec): #100
Retries: #3 =>
=> MODBUS IP Configuration [Name MODBUS IP_2]
Socket: Socket 0 Default: UDP (20000), PLC MODBUS Network
Network ID: Network ID 255
Time out (units of 10 msec): #2
Retries: #3
************************************************************
NET 2
On the raising of SB142 and SB145 =>
=> MODBUS IP ScanEX: MODBUS IP_1
On the raising of SB142 and SB143 =>
=> MODBUS IP ScanEX: MODBUS IP_2
************************************************************
- The Application realy contain Two Data Tables.
- I can also WRITE AND READ DATA of Tables via VisiLogix On-Line connection.
- In VisiLogix Communication - PC settings are next:
Select Connetion Type: TCP/IP (Call)
Favorites: [Name Of PLC] (connection=TCP,port=20256)
TimeUot: 1 sec.
Retries: 3.
Communication with OPLC: Direct Connection
When I press a "Get OPLC Information" button the correct data showed in OPLC Information fields. Generally there is no problem to programm/download/upload the programm via TCP/IP connection.
The Problem is in Read Data Tables from DataExport...
************************************************************
DataExport:
The Same Connection I use in DataExport, and same OPLC Information obtained by pressing "Get OPLC Information" button.
The PC Ports Configuration is next:
ETHERNET: Ethernet (Call)
TimeOut: 1.
Retries: 3.
************************************************************
Anyway I still have a problem with Reading Data From Data Tables via DataExport Programm...
I nearly to be without hope... (to many time for one problem)
Maximum - I will write the little programm in VB.Net.
It will be more simple and faster for me...
Thanks For Everyone... |
|
|
|
Saragani
Administrator
359 Posts |
Posted - 20 Jul 2010 : 00:10:32
|
Can you please post the structure of your data tables? (Tables, The type of each column in each table, length of fields, for each column if its part of project and number of rows in each table)
What version of Visilogic and Data Export you use? |
Capitalization is the difference between "I had to help my uncle Jack off a horse.." and "I had to help my uncle jack off a horse.." |
|
|
|
some0ne
Starting Member
Israel
3 Posts |
Posted - 26 Jul 2010 : 01:52:51
|
Dear Saragani,
I use VisiLogic 7.0.1 and DataXport 2.5.0 (DB 107)
- First Data Table -
Data Table - Table Structure:
Table: Calibration
Number of columns: 12
Number of rows: 15
Data Table - Column Structure:
********************************
Column: Date
Type: Integer
Part of project: not selected
Read-only: not selected
Min: -32768
Max: 32767
Format view: Decimal
Number of elements: 1
********************************
Column: Year
Type: Integer
Part of project: not selected
Read-only: not selected
Min: -32768
Max: 32767
Format view: Decimal
Number of elements: 1
********************************
Column: Next date
Type: Integer
Part of project: not selected
Read-only: not selected
Min: -32768
Max: 32767
Format view: Decimal
Number of elements: 1
********************************
Column: Next Year
Type: Integer
Part of project: not selected
Read-only: not selected
Min: -32768
Max: 32767
Format view: Decimal
Number of elements: 1
********************************
Column: Name
Type: String
Part of project: selected
Read-only: selected
String length: 6
********************************
Column: Sensor type
Type: String
Part of project: selected
Read-only: selected
String length: 21
********************************
Column: Set value (bar)
Type: String
Part of project: selected
Read-only: selected
String length: 4
********************************
Column: Real value (bar)
Type: Float
Part of project: not selected
Read-only: not selected
Number of elements: 1
********************************
Column: Set error (%)
Type: String
Part of project: selected
Read-only: selected
String length: 10
********************************
Column: Real error (%)
Type: Float
Part of project: not selected
Read-only: not selected
Number of elements: 1
********************************
Column: Press Gaug
Type: String
Part of project: selected
Read-only: selected
String length: 10
********************************
Column: ????? [name in hebrew)
Type: String
Part of project: not selected
Read-only: not selected
String length: 20
********************************
- Second Data Table -
Data Table - Table Structure:
Table: Check Value
Number of columns: 6
Number of rows: 50
Data Table - Column Structure:
********************************
Column: Date
Type: String
Part of project: not selected
Read-only: not selected
String length: 8
********************************
Column: Time
Type: String
Part of project: not selected
Read-only: not selected
String length: 5
********************************
Column: Barcode
Type: String
Part of project: not selected
Read-only: not selected
String length: 10
********************************
Column: First opened
Type: Float
Part of project: not selected
Read-only: not selected
Number of elements: 1
********************************
Column: Last opened
Type: Float
Part of project: not selected
Read-only: not selected
Number of elements: 1
********************************
Column: Last closed
Type: Float
Part of project: not selected
Read-only: not selected
Number of elements: 1
********************************
How know what meaning of "Part of project" check box?
Regards. |
|
|
|
Saragani
Administrator
359 Posts |
Posted - 26 Jul 2010 : 06:23:28
|
Part of project means that the data of the table is written into flash and that it is read only.
Unlike Columns that are Read only (and not Part Of Project), the data will not get lost when you remove the battery.
(It usually used for Consts, strings etc).
You are experiencing this problem because you use Visilogic 7.0.1
This bug was fixed on Version 8.6 as much as I know off (I don't know if the most updated DataXport version contains the fix. You should try it), but there is a workaround...
The problem occurs when you have an odd number of bytes in the Part Of Project data (Calcualted on all the tables).
On the first table you have 51 Part of project bytes and you have 15 rows, which means that it takes 765 bytes.
Your second table contain 0 Part of project bytes.
0 + 765 = 765 which is an Odd number (unlike 764 or 766).
Easy solution would be altering your Data Table structure so it will contain an even number of bytes in the Part Of Project data. You can achieve that by either making each row contain an Even number of Part Of Project bytes, or by having an Even number of rows. |
Capitalization is the difference between "I had to help my uncle Jack off a horse.." and "I had to help my uncle jack off a horse.." |
|
|
|
some0ne
Starting Member
Israel
3 Posts |
Posted - 01 Aug 2010 : 09:39:29
|
Dear Saragani,
The problem was solved  . As you said, the problem was in Odd number of bytes.
Thank you very much for support !!!
Best Regards. |
|
|
| |
Topic |
|
DataExport - Can't Import Data Table Structure
Forum Locked
