ICE

TCP/IP Products => TCP-PLUS => Topic started by: daniel27 on April 14, 2022, 10:37:51 am

Title: DejaWin - Export Data to CSV, Excel or other
Post by: daniel27 on April 14, 2022, 10:37:51 am
We have a DejaWin system acting as an ERP of sorts. It covers all our accounting, billing, payroll and other associated bookkeeping. It's been in use for over 30 years. We are seeking a way to export data to a format that we can use/manipulate. This could be in CSV, excel, access or some other format. For example, we have monthly financials for our business, we would seek to export those financials so that we can use the data.

Can someone assist?

Thank you
Dan
Title: Re: DejaWin - Export Data to CSV, Excel or other
Post by: Bob on April 14, 2022, 12:19:18 pm
We have a DejaWin system acting as an ERP of sorts. It covers all our accounting, billing, payroll and other associated bookkeeping. It's been in use for over 30 years. We are seeking a way to export data to a format that we can use/manipulate. This could be in CSV, excel, access or some other format. For example, we have monthly financials for our business, we would seek to export those financials so that we can use the data.

Can someone assist?

Thank you
Dan
DejaWin provides a window into your server where the actual application is running.
Data export would need to be done on the server within the application itself or with a helper program for that if one exists.

The most you might be able to do with Dejawin is start a capture, run a report to the screen, then stop the capture and try to parse it somehow.
In Deja32 that's under File->Capture to File. You give it a full path to a file name to start with, ie
C:\Users\Bob\Documents\Capture.txt
It will then capture everything going to the screen (run your report to the screen now) until you go back to File->Capture to file and close the file.

In the TelnetPro client, you get that option by Right-clicking in the main part of the emulation screen. Capture to File. Choose Visible characters, pick a file name and location, run your report, then go back to the same right click option and close the file.