Message Boards

Schedule CIM Load and retrieve status of load by non Progress application

Tiran Irani, modified 3 Years ago.

Schedule CIM Load and retrieve status of load by non Progress application

Post Date: 2/5/13 (Bronze, 0 Posts) Recent Posts
I am developing a custom application (non Progress) that will be generating down time transactions and want to CIM load these into MFG (eB2.1 SP5 on Linux) automatically and get the status of the loads back to my application. I will be creating the CIM Load file in code and intend to push the file to the MFG server for processing. I read another posting on this forum called 'Continuous CIM Load' (which I didn't have the option to reply to for some reason) which is close to what I am trying to achieve - the post by Paul Pellegrini of American Trim sounds an interesting option but would prefer to avoid custom Progress/database development if possible. I have also investigated QXtend which appears to be the preferred solution for this type of work but I don't have this available to me at the moment. 

I am ok with the option of a schedule running on the server to scan a folder for CIM load files (we'll only be generating 3 load files per day at present). My main issue is getting back to my application status, and thus to the user, information on whether a load was successful. I can obviously scan the output files for specific text and have also looked at the option of reading the bdl_mstr and bdld_det tables via odbc to check the load result. The table via odbc option seems to be the easier and potentially more reliable way to deal with this but would only have the date & time to go on to try and match the results to a submitted load.

Has anyone done this and used any different techniques or 3rd party software to achieve this?

Thanks
Tiran Irani
thumbnail
Richard Day, modified 13 Years ago.

Re: Schedule CIM Load and retrieve status of load by non Progress applicati

Post Date: 2/5/13 (Platinum, 333 Posts) Recent Posts
Hi Tiran,

I know that this not what you want to hear but you are running into the inherent limitations of the CIM Load process. I would strongly recommend looking more closely at QXtend as it does provide immediate feedback on whether or not transactions have been processed and details of any errors that occurred.

Richard
Tiran Irani, modified 13 Years ago.

Re: Schedule CIM Load and retrieve status of load by non Progress applicati

Post Date: 2/6/13 (Bronze, 0 Posts) Recent Posts
Thanks Richard - I had a feeling that might be the case but thought it worth investigating other options.

Message place holder