How can I add a list of objects to newly created 'ROUTES' in Datastream 7i? It seems that Datastream 7i only allows for one object to be created at a time. Is there a workaround for adding multiple object data from an Excel spreadsheet?
Currently, we are utilizing Datastream 7i version 7.10. Whenever I establish a ROUTE, I must input the equipment individually. It seems that utilizing the Upload Utility for this task is not feasible, and loading values on the backend may pose safety risks. The database contains a chaotic mix of related and orphaned tables.
I used to believe I was making mistakes, but thanks to Smink's guidance, I now have a clearer understanding.
If you want to add equipment to a current route, go to the menu bar and choose work/work order planning/routes. Next, select the route and go to the equipment tab where you can input all the necessary equipment details. While the upload utility allows for adding new equipment, it cannot link equipment to routes. Feel free to reach out if you have any inquiries regarding routes or the import utility. Feel free to contact me for further assistance. Jennifer.
Hey Smink! In my opinion, there are two effective ways to create Routes and add equipment to them. The first method involves using the Infor EAM interface, following the guide provided by Jennifer. Alternatively, you can opt for the second approach by utilizing a database tool to bulk load data from an Excel file. This method is ideal for handling large amounts of data efficiently. You can achieve this by querying the r5routes and r5routobjects tables using a database tool like PLSQL. These tables contain crucial information about routes and their relationships with assets. To add more data, simply export the existing results to a .csv file and import additional rows. Use the Text Importer tool to reload the updated .csv file back into the database. This process can also be applied to other tables and types of data such as Objects, Classes, and Parts. Feel free to reach out to me at nguyenhuutrong@credent.com.vn for any inquiries regarding Infor EAM.
Are you exploring the benefits of utilizing dynamic routes in your workflow? By creating a route template and specifying the equipment required, you can streamline the process of creating work orders. If you need more details on how this feature works, feel free to reach out to me at s_schwabe@msn.com or 804-337-6464. Let's optimize your workflow together!
Yes, I faced the same issue initially. However, I found a workaround through scripting. In your case, you could create a script that reads data from Excel using a library like pandas in Python, and then generates a bunch of SQL insert statements. After that, you can execute these statements in Datastream. This way, you can bulk insert multiple objects in your ROUTES. Just remember to handle exceptions and commit your database transactions properly to avoid data inconsistency.
Sounds like you're trying to streamline your workload, good idea! You could potentially create a script using Python or another language to automate this process. The script would essentially act as a bridge, reading data from your Excel spreadsheet and then inputting that data into DataStream 7i. This kind of task is not uncommon, and you'll find plenty of resources online that could guide you on how to set this up. Remember to test it with a small amount of data first to iron out any potential issues before going full scale.
✅ Work Order Management
✅ Asset Tracking
✅ Preventive Maintenance
✅ Inspection Report
We have received your information. We will share Schedule Demo details on your Mail Id.
Answer: 1. Can Datastream 7i add multiple objects to newly created ROUTES at once? - No, Datastream 7i typically allows adding one object at a time to ROUTES.
Answer: - One workaround is to manually add each object from the Excel spreadsheet to the ROUTES in Datastream 7i.
Answer: - Some users have reported using scripts or macros to automate the process of adding multiple objects to ROUTES in Datastream 7i.
Answer: - Datastream 7i may not have a built-in bulk import feature for adding multiple objects to ROUTES, but users have found workarounds using external tools or scripts.
Join hundreds of satisfied customers who have transformed their maintenance processes.
Sign up today and start optimizing your workflow.