How to Store Datalogs in FactoryTalkView SE and Resolve DBF File Issues

Question:

I recently upgraded an application from RSView32 to FactoryTalkView SE, which led to a change in how datalogs are stored. Previously, the datalog was saved in a *.DBF file in RSView32 and a software generated reports in Excel from that file. However, in FactoryTalkView SE, datalogs are now saved in a *.DAT format, no longer supporting *.DBF files. I came across a solution in Rockwell's KnowledgeBase but am having difficulty implementing it. Has anyone encountered and successfully addressed this issue before? Visit the link for more details: https://rockwellautomation.custhelp.com/app/answers/answer_view/a_id/69931/loc/en_US

Top Replies

The ODBC dBASE drivers are believed to originate from Office, particularly the "Jet Engine" on which MS Access is built. The Jet Engine used to be freely available for separate installation, and it still appears to be so. You can download the Microsoft Access Database Engine 2016 Redistributable from the Official Microsoft Download Center. To check if the dBASE driver is installed, use the ODBC Administration Tool. Remember that a .DBF "database" is essentially a directory, with the tables being files within it.

The instructions provided were adequate, but there were a few details missing. I followed the steps on a single computer, avoiding the need to transfer files between machines. One key action I took was creating a dedicated "database" folder to keep all files organized in one place, which proved essential for step #7 when saving DBF files in a specific location for easy access. Additionally, my version of Access no longer automatically generates .MDB files, so I had to utilize the "Save As" function and select the MDB format, opting for the 2002 version. In step #10, it is crucial to click the browse button next to each table to choose the DBF versions. Once I sorted out these details, I successfully logged into the DBF database.

I recently faced the same issue when transitioning from RSView32 to FactoryTalk View SE. The problem lies in the different formats of datalogs in RSView32 (*.DBF) and FactoryTalk View SE (*.DAT). As you pointed out, FT View SE doesn't support *.DBF files, so the traditional approach to generating Excel reports won't work. What worked for me was using a third-party tool like Kepware's DataLogger, which reads the *.DAT file from the FT View SE and converts the data into a format that can be easily assimilated into Excel. It might take a bit to set up, but once done, it's a fairly smooth process. I'd highly recommend starting with their trial version to see if it meets your needs before making any investment.

I’ve faced a similar transition when upgrading to FactoryTalkView SE, and it can be quite the hassle with the datalog format change. One thing that helped me was using a third-party tool to convert the *.DAT files back into a more familiar format, which made it easier to integrate with Excel for reporting. Another approach I found useful was reaching out to Rockwell's support team directly; they were really responsive and walked me through a few specific steps that weren't covered in the KnowledgeBase article you mentioned. If you haven't tried that yet, it might be worth a shot!

I've been through a similar transition recently, and I found that using the built-in data export options in FactoryTalkView SE really helped bridge the gap. Have you tried exporting the DAT files to a format that Excel can read, like CSV? It might require some extra steps, but it could save you the hassle of dealing directly with the DAT format. Also, I'd recommend reaching out to Rockwell support if you're still stuck; they can offer specific advice tailored to your setup. Hope that helps!

More Replies →

Streamline Your Asset Management
See How Oxmaint Works!!

✅   Work Order Management

✅   Asset Tracking

✅   Preventive Maintenance

✅   Inspection Report

We have received your information. We will share Schedule Demo details on your Mail Id.

To add a comment, please sign in or register if you haven't already..   

Frequently Asked Questions (FAQ)

FAQ: FAQs:

Answer: 1. What is the difference in how datalogs are stored between RSView32 and FactoryTalkView SE? - In RSView32, datalogs were saved in a .DBF file, while in FactoryTalkView SE, datalogs are saved in a .DAT format. 2. How can I resolve the issue of transitioning from .DBF files to .DAT files in FactoryTalkView SE? - You can refer to the solution provided in Rockwell's KnowledgeBase for guidance. Visit the link for more details: https://rockwellautomation.custhelp.com/app/answers/answer_view/a_id/69931/loc/en_US

FAQ: 3. Has anyone successfully addressed the issue of storing datalogs in FactoryTalkView SE after upgrading from RSView32?

Answer: - The thread discusses the challenges faced in implementing the solution provided by Rockwell. It might be helpful to seek advice from others who have encountered and resolved this issue before.

Ready to Simplify Maintenance?

Join hundreds of satisfied customers who have transformed their maintenance processes.
Sign up today and start optimizing your workflow.

Request Demo  â†’