Forums.MrPLC.com: Opening .mdb files with Datalogviewer 2.0 - Forums.MrPLC.com

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Opening .mdb files with Datalogviewer 2.0 can someone upload a example .mdb file Rate Topic: -----

#1
User is offline   Tony 

  • Sparky
  • PipPipPip
  • Group: MrPLC Member
  • Posts: 25
  • Joined: 23-December 04
Hi, I am playing around with the new datalogviewer in CXS 3.0

I am not experienced with databases and can't seem to create a readable file.
either I don't get to select any traces at all or when I do get selectable traces I
get an error : Unhandeld exception (Specified cast is not valid)

Can someone upload an example .mdb file which I can open with Datalog viewer 2.0 and MS Acces,
to help figure out what I am doing wrong? I have loads of csv log files which I would like to be able
to view with the new datalogviewer. I have attached one of these.

Attached File  08010109.rar (7.19K)
Number of downloads: 220

Any help is very much apreciated.

Greetz Tony
0

#2
User is offline   Tony 

  • Sparky
  • PipPipPip
  • Group: MrPLC Member
  • Posts: 25
  • Joined: 23-December 04
I figured it out,

The Milliseconds column has to be "long integer" and not "integer" otherwise the logviewer wont show any items at all to open.
Also all fields have to be filled with data, or you wil get the .net error as described above.

The new Data log viewer is awesome !! Outstanding thinking of the developers !!

grtz
0

#3
User is offline   tashinz 

  • Sparky
  • PipPipPip
  • Group: MrPLC Member
  • Posts: 314
  • Joined: 06-December 05
  • Country:Yugoslavia
    Yugoslavia
can you upload a mdb database which can be opened by datalog 2.0? I am playing here and can not open any mdb. thanx
0

#4
User is offline   Tony 

  • Sparky
  • PipPipPip
  • Group: MrPLC Member
  • Posts: 25
  • Joined: 23-December 04
Attached .mdb file can be opened,

maybe some indexing changes can be done but I haven't tried that yet,
I was already happy that it worked this way.

Grtz

Tony

Attached File  08010110.rar (36.7K)
Number of downloads: 217
0

#5
User is offline   tashinz 

  • Sparky
  • PipPipPip
  • Group: MrPLC Member
  • Posts: 314
  • Joined: 06-December 05
  • Country:Yugoslavia
    Yugoslavia
well, can you tell me please what's wrong with this database of mine? I put everything as in your database, and I can't open it. But your database I can open. Can you open mine?

thanx

Attached File(s)


0

#6
User is offline   PdL 

  • Got Joy in life
  • Group: MrPLC Admin
  • Posts: 2,997
  • Joined: 03-August 04
  • Gender:Male
  • Location:Naarden, NL
  • Interests:Too many...
  • Country:Netherlands
    Netherlands

View Posttashinz, on May 12 2010, 10:58 AM, said:

well, can you tell me please what's wrong with this database of mine? I put everything as in your database, and I can't open it. But your database I can open. Can you open mine?

thanx


Hey Tashinz, could it be the regional settings of your Win install be the problem?

Nevermind, a little too fast on the trigger :-)
Posted Image MrPLC Omron FAQ : websites, manuals, cables software & more Posted Image
*update 06/02/2010 - Added link to Routing table instruction video


check out www.myomron.com - our knowledge at your fingertips
0

#7
User is offline   Tony 

  • Sparky
  • PipPipPip
  • Group: MrPLC Member
  • Posts: 25
  • Joined: 23-December 04

View Posttashinz, on May 12 2010, 10:58 AM, said:

well, can you tell me please what's wrong with this database of mine? I put everything as in your database, and I can't open it. But your database I can open. Can you open mine?

thanx


Yes, your columnheader of Milliseconds is spelled with one l instead of two ll's. :-)

Attached File  Database1_Milliseconds_ok.rar (20.41K)
Number of downloads: 222

Grtz Tony
0

#8
User is offline   tashinz 

  • Sparky
  • PipPipPip
  • Group: MrPLC Member
  • Posts: 314
  • Joined: 06-December 05
  • Country:Yugoslavia
    Yugoslavia
Man, you're a genius. thanx a lot, work here now. was getting out of my mind already.
0

#9
User is offline   tashinz 

  • Sparky
  • PipPipPip
  • Group: MrPLC Member
  • Posts: 314
  • Joined: 06-December 05
  • Country:Yugoslavia
    Yugoslavia
Yeah, well, i tried to export existing data log to csv and in that way you don't have an option to export milliseconds unless you check the option one file for each item. but, of course, it this second case the column for milliseconds is called Millisecs, which makes the mdb file created out of this csv not working. whey you rename it to Milliseconds, it works.

god job again, tony!
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users