Hi, i'm searching information about this API, but the only thing I have found it's the CHM file (XMLAPI.chm) in documentation folder. Where else could I found
more information, examples, etc. ?
Thanks in advance
A co-worker and I have been working with the Contract Manager API extensively. There is a zip file or group of files availble with the API help files. The help files pretty much provide exactly what you need to get started. That's how I learned to use the API.
What exactly are you trying to do with it? If you would like to, feel free to contact me directly at my email and we can chat. firstname.lastname@example.org.
Edited by: Chrispy_BMCD on Oct 15, 2009 6:41 AM
Many thanks for your help, I'm not doing nothing specific, just probing examples.
But i was wondering, it's possible to change data directly in the BD instead of using the API ?
(with possible I mean technically, legally, etc). Because if this is possible, I imagine that this way will be much faster than using the API (when working with lots of data).
There are several points against:
1. You might cause problems if you don't know what is really going on where and all the triggers inside. For some tables it looks safe for some I would never try...
2. You will brake your maintenance contract, and if something goes wrong due to modifications you've done - you are on your own, and if I would be Oracle I would charge a lot for fixing system after manual manipulations.
Using API puts you in a safe position... tough then you need some programming knowledge to use it...
I have to agree about back end changes. I am a heavy user as well. We are working with hundreds of thousands of records at thispoint in CM. I reserve backend changes for the very last possible solution and with the OK of Oracle through tech support only. As for the API we have been using this for mass updates and adds. I find that when I have to add many records it usually makes sense to import first since that is faster then use the update to fill in the additional fields. Really figuring out how to use it have empowered me ten fold on our projects. Many things I would not have tried before are within reach now.
I totally agree - lack of Import Export is one of the most important negatives about CM...
but - lets get specific:
What you want to import - what kind of documents?
what are the changes you want to make to the database?
Everything can be done on database level, I just don't think there will ever be GO from Oracle support.
We have developed a much more intelligent import/export with our new product CMPlus. Currently we have an extremely easy export utility for all the cost related modules with a column picker and filtering system. Exports can also be saved as a template for re-use. We currently only import to the cost modules but are expanding this list all the time. CMPlus includes many other utilities as well. We use the API for the transactions so not to bypass the business rules of CM. It is web-based and uses the security of a CM login. Link:[www.allthingscm.com]
Hi again, I have two questions
1.- How can I retrieve Line Items from Change Order using the API? wich request type?
2.- It's possible to add new Line Items using the API?
If you don't have or don't want to post your code, hints are also welcome :)
The greatest source of information I have found has been the API Help File provided with CM. XMLAPI.hlp This provides a lot of could direction including a summary list of what modules can be updated through the API.