We have a UK customer with a live Pegasus Opera I accounts system.
Pegasus Opera I is written in FoxPro DOS, source code not available, runs on FoxPro database.
This project is to create a program that can import XML sales order files and insert Sales orders into Opera, also export Opera Products, Special prices and Discounts to XL files ready fro importing into the standalone Quotations program.
Sales orders can have multiple lines.
Inserting a Sales order can mean creating a record in the Sales orders table , inserting records in the Sales order lines table, updating the Customer record, updating the Product record.
Don't mind what langauge is used for the program - we will own copyright in the code and you wil provide full compilable source code. If the program requires it's own database as well as the Opera FoxPro fatabase, prefer that it is MS Access.
It will be an advantage if you understand the Pegagus Opera I database structure.
This project is No. 2b of 4 projects we have for the same customer - each one is a separate Scriptlance project - other projects are :
1) Synchronisation program to connect Pegasus Opera and osCommerce
2a) Standalone Quotations system - creates XML Sales orders files
3) Sales Returns system to link with Opera tables - create and process RMAs and insert Sales credit notes into Opera
4) Sales statistics reports - Customer has been re-keying Opera reports into existing Excel spreadsheets - replace keying-in with program reading data from Opera