Tutorial: Import data from Pegasus Opera into Excel. By David Carter

This page is for readers of AccountingWEB who need to get reports out of Pegasus Opera and Opera II.

It’s not immediately obvious how to get data out of Opera and into Excel. You need an add-on module, either Reporter or (later and better) XRL Reporter.

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.

Comments

Pegasus Opera database schema\table information

broughty | | Permalink

Hello,

I am a software developer and this post has been very useful getting me started on extracting data from Opera. I basically need to write a program to extract all open items (invoices/credit notes/adjustments etc) and the Customer\Debtor they belong to.

Does anyone know if Pegasus publish the Opera database schema. You mention a few tables below (and sname looks like customer info table) but it isn't immediately obvious what the myriad of other tables do.

Cheers

Mat