I'm testing out Automator before we make the switch from Data Pump. I'm having a few frustrations, and I would love to hear other's expereince.
I'm frustrated about the XPRJ editor as a windows program being missing. Since the file format is moving to dprj instead of xprj the files have changed from XML to a new format and can't easily be edited in a text editor. It seems the only way to edit these is by using the Project Editor in the web interface. The interface is clunky, as I have to first browse to the project that I want to edit, do the editing, and then download the project to where I had it stored in the first place.
The Open Project interface is quite a challenge. We have over 800 projects stored in a common directory, but each process (170) has it's own folder. I don't want to set up 170 named paths. When I view the root directory as a named path, then I have to scroll through all 800 projects to find the one I want to edit. Typing the full file path of the file isn't a great option either. I really wish there was a windows file browser interface implemented here.
Uploading to the web and storing within the Automator itself is an option, and with the search feature, that may work better. But really requires us to break the file structure we have used for saving projects and models over the last 10 years. It also prevents anyone other than a Automator user from seeing what a model or project does.
I'm finding it takes me 3-5 minutes just to edit an input file path. I used to be able to do this in less than 30 seconds. Multiple that for a large process change (some of ours have close to 100 projects), and it becomes an expense change. And I don't think this is just due to a learning curve.
Also frustrating that when I try to check an email while waiting for a page to load, most of the times the Automator times out. I set the Session Expiration Alert to 10 minutes, but that still isn't very long - especially if I have a phone call or someone asks me to look at something at their cubicle.
Has anyone encountered similar frustrations? Are there solutions, is this just something you're just trying to learn to live with? I welcome any and all input.