Solved

Printing data to a CSV file

Posted on 2013-12-16
6
630 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 32

Expert Comment

by:Daniel Wilson
ID: 39722319
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
ID: 39722703
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
ID: 39722775
Have you tried to run an OCR software on the PDF to get the text out of the PDF?
0
Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

 
LVL 14

Accepted Solution

by:
Kutyi earned 500 total points
ID: 39722871
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
ID: 39725100
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
ID: 39725478
Glad to hear it worked!
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
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…

751 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