Sign up Calendar Latest Topics Donate
 
 
 


Reply
  Author   Comment   Page 2 of 2      Prev   1   2
fburgos

Sr. Member
Registered:
Posts: 670
Reply with quote  #16 
Quote:
Originally Posted by electricpete

2 - fburgos, you described running a report in the reporting tab, and then grabbing stuff into excel by using ODBC, are these two related?  (does running the report in AMS create another file / table that can be opened into excel using ODBC?).

 

3 - any other ideas? (how to get history of overalls for a given machine).



I don't use ODBC driver anymore, it's slow not well optimized for complex queries.

My suggestion is to import all tables and use excel functions to merge them

What I do is use the report tab every week and save to excel and use this excel file to feed a sheet with all the history and then report to managers using pivot tables
electricpete

Sr. Member
Registered:
Posts: 647
Reply with quote  #17 

Thanks.  I'd love to get the data into excel and manipulate it there. I'm not disciplined enough to export the data periodically to build an excel database (and there's a lot of old data I can't get to easily). And when poking around from excel to the mdb files all I can find is a sea of tables that don't seem to hold what I'm looking for.  That's why I was asking about the particular file and tables.

I did find on guardian site article NK-1400-0541 dated 1/2/19 titled "AMS Machinery Manager 5.XX ODBC Driver Setup Instruction and Data Extraction for MS Excel/Access 2007 or Newer".  In the document they show some tables I'd like to be able to get to.  The first few steps are all about setting up a driver. I can't do any of that with a locked down corporate computer and network installation. But I wasn't sure it's needed since I seem to be able to bring into excel a few of the CSI tables already (the list of users). So I skipped the driver installation and went to the part about creating ODBC data source. There I followed the instructions to add a data source based on CSIdefault. The next step asks for a driver to use to set up the data source. I'm supposed to select driver CSI REM 4.02 ODBC driver, but I don't have anything like that available... I guess that's the steps I skipped at the beginning. 

Seems like I'm dead in the water. I'm not expecting any help from our IT dept on this. I'm giving up (unless anyone has suggestions).

fburgos

Sr. Member
Registered:
Posts: 670
Reply with quote  #18 
You need admin privileges to install the driver.

I know because I tried what you said, even installed the driver without privileges but with a warning then uninstalled the driver but mhm crash at start... Then I have to call our IT guy who fixed the thing installing the driver as admin.

ssimmon1

Member
Registered:
Posts: 46
Reply with quote  #19 
Unfriggin' real!

A couple years ago we asked Emerson directly if there were any way to get our Equipment and Configuration information out of MHM and they swore up and down many times it was not possible.

We ended up discovering you can open up the .rbm files in Access and then combine them with the various warehouse files and build queries to get to the data, but it was very time consuming and not intuitive.

I need to look into this next week.
ssimmon1

Member
Registered:
Posts: 46
Reply with quote  #20 
For a network installation, do you do this on the Client, or on the Server (or both)?

For the Regedit, do you specify the local client file or the server path? (I don't see the mt40odbc.dll file on the server, only on my machine)

Also, I couldn't find this article in Guardian...

Quote:
Originally Posted by fburgos

inside the MHM CD theres a installer, Use administrator privilege

D:\Install\csiODBC\setup.exe

then open registry editor

regedit.png 

search for this folder

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\CSI RBM 4.02 ODBC Driver

inside edit the driver and setup key with your rmbsuite\sys\ directory (network or local)sys directory.png 
this is the end of the driver install, now you have to add the database to the windows ODBC data sources, click start/control panel/administrative tools/data sources, or if in windows 7 or up, just open start menu and search for ODBC and use 32bit version.

odbc data sources.png 


a new windows will open and click "Add..."

select CSI RMB 4.02 ODBC driver from list, new window setup window will open, fill with Data source name, database.rmb file and host (localhost for single user install, if network install ask your IT guy) click ok to save all changes and close odbc program.

odbc setup.png 

fburgos

Sr. Member
Registered:
Posts: 670
Reply with quote  #21 
This procedure is for the client install, if you have guardian access the article is "NK-1400-0541 and 5.xx ODBC driver setup instruction and data extraction" and there's other "AK-1800-0092 ODBC data extraction from ams"
ssimmon1

Member
Registered:
Posts: 46
Reply with quote  #22 
I go through the driver install and the registry edit....but when I go to add the connection, it's not in the Add list...


ssimmon1

Member
Registered:
Posts: 46
Reply with quote  #23 
Quote:
Originally Posted by fburgos
This procedure is for the client install, if you have guardian access the article is "NK-1400-0541 and 5.xx ODBC driver setup instruction and data extraction" and there's other "AK-1800-0092 ODBC data extraction from ams"


Interestingly enough, neither of those articles come up for me...

Capture.jpg 

There are only 2 that come up even searching "ODBC".


Capture.jpg 



fburgos

Sr. Member
Registered:
Posts: 670
Reply with quote  #24 
Try the full text search, you'll find a lot of stuff there
ssimmon1

Member
Registered:
Posts: 46
Reply with quote  #25 
Quote:
Originally Posted by fburgos
Try the full text search, you'll find a lot of stuff there


Bingo, got it! Weird it didn't show up in the other search.

Thanks!
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.