CMMS | Computerized Maintenance Management System | DB Client library

I have to post a JSON Array of objects. The JSON sample is pasted below:

I am trying to access textfile present in the folder inside the solution.

I'm currently working on a CMMS software. Most of these packages have some way of managing your inventory, being able to create Purchase Orders to buy more stock, etc.

Part of our system works perfectly with Event Sourcing because there are clearly defined events. But there is also a bunch of attached data that are almost completely unrelated to that whole process and are just used by companies for reporting at a later date.

For example, a Purchase Order might have a department attached to it. We don't use this department in any stage of the Purchase Order, but a company might come along and want a report for 'How much money has each department spent'. On the other hand, another company might be so small/specialized they doesn't even have separate departments so it doesn't care about it.

That's just 1 example, but there can be a decent amount of fields like that (Think 5-10 per Entity). In this kind of situation, is it better to just have a 'PurchaseOrderUpdated' event that covers all these fields? Or is it considered better to have an individual update events like 'PurchaseOrderDepartmentChanged'?

I personally think there should be an event per property, but I think the rest of my team would complain about having to set up that many events.

I am creating a TDE document wherein I need to get data from the headers section of a harmonized document as well as to get values from the main section of the document (work order).

However, it seems that that my current tde context value is not displaying the expected value. Any thoughts on why is this happening in my current TDE code?

I tried many codes suchs as the one below:

//es:headers/ProjectSpecificData/WorkOrderStatusHistory/StatusHistory/StatusHistory

But it not gettng any data from the headers

Sample Harmonized Document in FINAL database

i'm using odoo 8 and i want to know how to add a page that contains list of product and theire quantity in a view, to mention in a request for intervention which products we are going to modify. In that way we can estimate how costs every intervention

view.xml

Hi All I am trying to get the last wostatus.changedate in a query and i have the following code for Maximo (CMMS):

I have Simple and stupid Question however I hope to find an answer that will make my mind clear about C# refrence objects and where is the best place to instantaite them. i have declared the openfile Varaible after Class Declaration so that i can refrence it from any other method inside the class.every thing works fine until i press the add photo button and choose a photo if i did press the button again and Canceled the show dialog the openfile.FileName does not save the file extension. to solve the problem i did move this line of code openfile = new OpenFileDialog(); to the class constructor.Is it wrong to instantaite the object in that way that it will hold aspace in RAM.or instantaite the object only in the place where you are going to use it.

I am trying to write a list to an excel column and encounter an error. I am attempting to write each value of matchingName to the worksheet aSheet in column V.

Traceback (most recent call last): File "C:/Users/PycharmProjects/smartCompare/excelmain.py", line 40, in aSheet[V] = matchingName[i3] File "C:\Users\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\worksheet\worksheet.py", line 380, in setitem self[key].value = value File "C:\Users\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\worksheet\worksheet.py", line 357, in getitem min_col, min_row, max_col, max_row = range_boundaries(key) File "C:\Users\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\utils\cell.py", line 129, in range_boundaries raise ValueError("{0} is not a valid coordinate or range") ValueError: {0} is not a valid coordinate or range

Process finished with exit code 1

This error seems to be occurring in the for loop. I checked the openpyxl documentation but no luck on solving it. Any advice?

I have the following code, and I am using to query a CMMS system database for reporting reasons. If I remove the Group by it will run, but it counts all runs returned by the Where statement. I'm guessing it's because I'm not using the Group By statement. When I add it in I get the following error:

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

If any body can point me in the right direction that would be great.