Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do you query for File Properties in Windows?

mfanning2010Mar 30 2018 — edited Apr 3 2018

Hello,

We are trying to figure out a way of using an OS command within Oracle Data Integrator 12.2.1.3 to query an XML file attribute specifically the Date Modified.

We have an application that outputs an XML file with the same name so we are trying to build out an integration process to pull from the XML file when it is updated. The file exists on Windows Server 2012, but I am not finding much luck on a way of getting the Date Modified field of file properties.

The thought is we would load a variable with the initial date when executing for the first time (OldDate variable), then have a Package that checks the current date modified (loads to a variable CurDate), and if the CurDate > OldDate the integration process would take the XML file data and do a conversion to a SQL Server database for another application to read.

I know if the file included a date/timestamp we could us an ODI Variable to parse the file name as a string to derive the date/timestamp, but that isn't an option in this case.

Any ideas on this?

Thank you,

Matthew Fanning
This post has been answered by Adrian_Popescu-Oracle on Mar 30 2018
Jump to Answer

Comments

graeme-06501

That's interesting, I have a page with a master grid and detail grid and thought I'd check as this doesn't sound good.

When I navigate to a different master without saving the detail it doesn't ask me to save, is that a setting somewhere?  I can try it if you remind me how to set that up?

I can go to a different master record, create a detail record for it and not save, going back to my original master record the unsaved detail record correct for that master is still there.

When I save both detail records are saved to the correct master, it never asks me to save.

Does the detail grid have a column which is nominated as having a master column and that master column is definitely unique?

Not sure if it makes any difference, I'm using 20.1 and for processing my master grid is set to automatic row processing and the detail is set to PL/SQL

Andreas Wildmann

I had some progress since yesterday. Apparently, while the two grids followed a Master Detal structure, it wasn't set up as that. Now it is. The Interactive grid on the right side has the left grid as being the Master Detail, while it also has one of it's keys marked as a Master Column.

Saving it does work as well, but with a quirk. When I add new information into a row, then change it to another row, I still get the "You haven't saved" mesage. When I cancel, it still changes to the row that I just clicked, and if I save, it does save it to the previous row, not the current one. So far so good.

However, the information i saved isn't being shown. I checked the database and the saved information has been stored in the table, but it isn't being shown on the grid. At first I thought it had simply refreshed, and I rather needed to load the page again, but it still doesn't show the data. Kinda curious if this is a glitch or I'm making a mistake when it comes to understanding how these Master Detail Grids are set up.

Andreas Wildmann

Just another update, the data is now being shown in accord to the Master Column. Becaus there were a couple of unintuitive primary keys in that query, I mistook one of them. But as usual, there is another problem:

This the sequence of the issue:

1. When first selecting a row in the Master Detal, I can see the data on the Child Grid properly.

2. When then selecting another row in the Master Detail, the data from the currently selected row loads properly in the Child Grid.

3. Now I click again on the row from before in the Master Detail, and the Child Grid is empty.

Considering that the Child Grid depends on the Master Column, I don't think it is an issue regarding the assynchronous loading of that column.

Doing a quick debug also brings me some random results. At times, I get nothing but the foreign key inside the table (with the Grid also being empty) while at times I do get something in the console.log command, but the Grid is empty.

Andreas Wildmann
Answer

Feels like I'm flooding my own topic while also seeming like I'm talking to a mirror.

I solved the issue somewhat by accident. I suspected it could've been that but only now tested it properly.

I had a "where foreign_key = :FK" condition in the Child Grid, while also having the Foreign Key in it be the Master Column, and I imagine that was causing a conflict.

Now everything is working properly, the records aren't being saved in the wrong row,and the data in the Child Grid is being shown.

Marked as Answer by Andreas Wildmann · Sep 27 2020
1 person found this helpful
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 1 2018
Added on Mar 30 2018
#business-intelligence-applications, #data-integrator, #file, #system-management-and-integration, #xml
6 comments
342 views