Raw Data

Hi,

Does anyone have a document or link explaining what the FoxPro tables are and contain?

Many thanks,

NEIL

Comments
RogerNeale's picture

Pegasus Opera II data

RogerNeale | | Permalink

Hi Neil,

The information you are looking for is contained in two files. 
These are:  "field.dbf"  and  "table.dbf"

They are located in the DataDict folder, which is a sub-folder of your Pegasus Opera II system folder.

If you have it, you can open these tables with VisualFoxPro or you can import them into Excel.

Alternatively, you could consider purchasing the Pegasus RL module which has all the information you might need to get access to the data, if that's what you need.

If you need any further help with this please let me know.

Roger Neale
Business Systems Consultant

Tel 07714 670789

PegasusExpert's picture

Data Structure

PegasusExpert | | Permalink

There is a logic built in to the table/fields in the Opera II data:

Firstly, all tables are prefixed with a single character + an underscore character, e.g. "Z_", the character is the company ID, so all tables for company "Z" have their names begining with "Z_".  Then character number 3 in the table name usually indicates the module, so all sales tables for company 'Z' begin with "Z_S", e.g. the customer masterfile is "Z_SNAME", the sales transaction table is "Z_STRAN" etc.  Once you look at the table names their meaning should become understood.  Other 3rd characters are P for Purchases, N for Nominal, C for Stock, I for Invoicing/SOP, D for Purchase Orders etc.

Within tables, the first 3 characters of a field name (when viewing without captions) usually reflects the table name as well, e.g. in STRAN (sales transactions) all field names begin with "ST_".

All of the tables are part of a VFP container, named as "COMP_Z.*".

The data dictionary should give you data on what to expect in each table.

Be VERY slow to go editing tables, always take a backup first and be sure you know what you are doing.

Diarmaid
http://www.onesys.ie/pegasusopera

 

Thanks

ngjarman | | Permalink

Thank you for the information, which is extremly useful.

Best wishes, NEIL

RichardWhight's picture

One last thing

RichardWhight | | Permalink

You might also find that the data has been split into different folders or might be all in one folder. You can see where the data is by looking at the company set up information from within Opera itself.

Add comment
Log in or register to post comments
Group: Pegasus Opera II discussion group
An online meeting place for Opera II users and resellers to share ideas, tips and gripes