Solved

Printing data to a CSV file

Posted on 2013-12-16
6
594 Views
Last Modified: 2013-12-17
Hello,

We are using an old program called "Patterson - Eaglesoft" and have recently switched to a newer program that uses SQL and C#; but we need some of the old data.

Eaglesoft has proprietary databases and the only way to export data is to print it.  In short we need a list of "Referrals" that has slowly been entered in one by one over many years.  This list is roughly 75 pages and each row has 5 columns of data (Name, Address, Specialty, Phone, Email)

I have tried to print the list (as there is no export function), and was able to create a PDF and an XPS document but I need to import this data into a SQL database.

The Database will have several more columns however.

Is there anyway to print to a CSV file or a way to print to a PDF and then convert to a CSV?

Please let me know I am lost in this legacy software!
0
Comment
Question by:PDGPA
6 Comments
 
LVL 32

Expert Comment

by:Daniel Wilson
Comment Utility
If your legacy software doesn't offer an export to CSV, then we'll guess at some workarounds.

Do you know what the underlying DB is for Eaglesoft?  If it's something relatively standard, we might find you a way to directly export from the DB to CSV.

Alternatively, you might take another look at the PDF that it prints.  Is it pretty clean w/o extra stuff?  If so, you might use PDFBox to extract the text.  If that extracts pretty well into columns, you could them import the text in Excel and output a clean CSV from there.
0
 
LVL 28

Expert Comment

by:Bill Bach
Comment Utility
If it is a Windows application, then try printing to a text-only printer.  You probably don't have one yet, but go into Windows to create a new printer, select LPT1:, then select "Generic" Manufacturer, and then "Generic/Text Only" printer.  This will print text cleanly with no extra codes, and may just yield acceptable results.

Otherwise, I agree with DanielWilson -- try to find out what database it uses.  If you cannot tell, post a sample file (if you can) and we can look at it here.
0
 
LVL 14

Expert Comment

by:Kutyi
Comment Utility
Have you tried to run an OCR software on the PDF to get the text out of the PDF?
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 14

Accepted Solution

by:
Kutyi earned 500 total points
Comment Utility
Not sure, but is this the same software and could you follow Patterson's solution? https://pattersonsupport.custhelp.com/app/answers/detail/a_id/11259/kw/export%20data
0
 

Author Closing Comment

by:PDGPA
Comment Utility
Thanks everyone for your help - Who knew the only way to export data was to run a report and then right click!  

Very excited to update this data and upgrade to our new system!

Thanks again!
0
 
LVL 14

Expert Comment

by:Kutyi
Comment Utility
Glad to hear it worked!
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now