We help IT Professionals succeed at work.

automating record copy from database to Excel

tech53
tech53 asked
on
87 Views
Last Modified: 2020-01-21
Folks,

I have a client who has migrated from one case management system to another.  The new software developers have converted the various databases across with the exception of one.  For whatever reason they can't do it. I have contacted the old system developers and they can't even export the data.  We have collectively tried everything.

I've been looking at a few possible ways to export the data, one of which is Ui Path Studio.  It basically can record your keystrokes, mouse clicks and field selections (amongst other very advanced features) but it didn't do what I needed (or I didn't know how to use it).  Its a bit like a word macro builder.

Does anyone know of something similar I could try? I'm trying to automate the process of opening a record, copying the 5 fields into a spreadsheet, moving to the next record and repeating.

Thanks
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
AutoIt could be the tool for this.

But what database is it that is so locked down? Some proprietary format?
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Your question title says I be thing but your question has another seemingly conflicting.

The difficulty with any export is the timeframe of changes and having to be represented.

It seems on your original package was a custom setup versus publicly available package?

Depending on the scenario it seems as though you are looking for a process that continuously looking at the source for changes that updates ......

But with that said it is likely I am injecting, extrapolating based on what I think the design is versus what it might actually be.

Given your description is rather vague.

You could as part of the excel pull data, the consideration is that if the data is large it would take time to refresh......
jstubingData / Reporting Analyst

Commented:
Wow, ghastly problem.  If you have access to anything with OCR, you could take screenshots of multiple rows of data and feed them to your OCR tool, although I'm not sure how easy it would be to consolidate that back into database format.
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION