473,324 Members | 2,356 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Looking for development advice

I have an accounting application written in BASIC. Needless to say I'm am losing customers to "windows" apps. Several years ago, we made the decision to rewrite all the modules to run as web apps. We did a lot of research, but ultimately ended up with php because the customer willing to fund the project had a relationship with a web development co and that's what they recommended. We hired a web programmer and entered into a joint venture to develop the new software. The idea was to remain platform independent, since our BASIC app runs on *nix or Windows.

The modules included in our BASIC app are fully integrated. They include Accounts Payable, Accounts Receivable, General Ledger, Payroll, Purchasing, Inventory Control, and Order Entry.

After nearly two years and no complete modules, the customer cancelled the contract and went with an off the shelf package. My developer went with the web development co. Subsequently my other two programmers went their own way. So I am left with these questions:

Was PHP/PostGreSQL a good choice?

Can this project ever be completed?

How do I know if the code I have is any good?

How long should it take for a good programmer to get to a beta level on a module?

Our current app includes record locking in a multi-user environment to prevent two users from updating the same record simultaneously. How possible is that with PostGres?

I have no experience with HTML, PHP or any of the modern languages. I have been fortunate enough to earn a living programming in the same language for 27 years. How long would it take me to become reasonably proficient?

Any advice/comments would be appreciated.
Nov 23 '06 #1
2 1176
drhowarddrfine
7,435 Expert 4TB
Was PHP/PostGreSQL a good choice?
Can this project ever be completed?
Yes and yes.
To become proficient in the other languages depends on you. HTML is easy. PHP is somewhat similar to C. If you know C, then it's easy, if you dive into it.

Two years to convert a BASIC program to PHP? Seems kind of long since you needed it quicker than that. They should have been able to produce something usable but it depends on how big the program is.
Nov 23 '06 #2
Thank you for your reply.

I do not know C. Really, the only language I have used professionally is BASIC. I have done some UNIX shell scripting. I have looked at the code these guys have written and can get around enough to make changes, but wonder if I could ever whip out a program as quickly as I do now. In BASIC, all the I/O, the display, the filehandling is in one "program". There seem to be an infinite number of "pages" to accomplish the same task in HTML/PHP.

We thought two years was a bit extreme, too. But really there were only two programmers working on it fulltime. I think they spent a good deal of time trying to create reusable code, but when they got ready to use it again, it needed a little tweaking to fit there, which broke the first program, etc, etc.

It is hard for me to guess how many actual BASIC programs are in the whole accounting application. The module that is closest to completion in PHP is the GL (General Ledger). Just to give you an idea of what we are up against, this is the menu from GL. Items 8 and 9 go to sub-menus, one with 7 items, one with 3. Each if the FILE MAINTENANCE programs includes a list option.


G E N E R A L L E D G E R M A I N M E N U

FILE MAINTENANCE
1. CHART OF ACCOUNTS
2. BUDGETS
3. FUND
4. FINANCIAL STATEMENTS FORMAT FILE
5. SET UP NEW FINANCIAL STATEMENTS
6. OBJECT CODE

DATA ENTRY
7. JOURNAL ENTRY
8. BUDGET PREPARATION
9. RECURRING JOURNALS

10. ACCOUNTS PAYABLE

PERIODIC PROCEDURES
11. JOURNAL PROOF
12. JOURNAL POSTING
13. G/L TRANSACTION VALIDATION
14. JOURNAL REVERSAL
15. OPEN NEW YEAR
16. YEAR-END CLOSING
17. JOURNAL RE-CREATION

REPORTING
18. DETAILED GENERAL LEDGER
19. SUMMARY VOUCHER
20. FINANCIAL STATEMENT PREPARATION
21. FINANCIAL STATEMENT PRINT
22. MANAGER'S REPORT
23. ACCOUNTS OVER BUDGET
24. ACCOUNT INQUIRY
25. AUDITOR'S WORKSHEET

SELECT (0=END) :


The biggest struggle we have had in the whole process has been printing. We discussed the whole browser vs thin client thing before we started since it so hard to control what the print from the browser will look like depending on user settings. That is bad enough on reports and lists, but what to do about forms - like checks, invoices, etc.? In our BASIC software, we address the printer directly; ie OPEN FILE (0),"\\server\printer", and I have designed forms in PCL code; or we can print on preprinted forms. We control paging, font, etc directly. The programmers we had seemed not to be able to directly access the printers. We found some pdf solutions, but most of them were either cumbersome or expensive. What I really want when we print is for the report to look as if it came from Crysal Reports, rather than like someone hit the "print" button on a web page.

Thanks for any insights anyone is willing to share.
Nov 25 '06 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

14
by: Jason Daly | last post by:
I'm a freshman at college as a computer science major. I'm not sure it has what I want. Does anyone know if a major commonly exists in web design (focusing in server side languages)? I want to...
4
by: pcunix | last post by:
I'm looking for general advice, pointers to web pages, books, whatever. I have a moderately successful web site. The major complaint that I get, time after time, is "It's UUUGLY" As I have...
4
by: Atlas | last post by:
I've almost completed a small project with MS SQL 2000 server in the BE and Access 2003 in the FE. 5 concurrent users, 30 tables, 35 forms and subforms, 13 reports. Not so happy in the beginning...
28
by: Jed | last post by:
Hello to all! I have a couple of projects I intend starting on, and was wondering if someone here could make a suggestion for a good compiler and development environment. My goals are as...
1
by: athos | last post by:
Hi all, Believe you have sound experience in development, however, if we look at the whole Software Development Life Cycle (SDLC) of the project, say, 1. Project Initiation, 2. Gathering...
13
by: Alan Silver | last post by:
Hello, MSDN (amongst other places) is full of helpful advice on ways to do data access, but they all seem geared to wards enterprise applications. Maybe I'm in a minority, but I don't have those...
1
by: ujang | last post by:
My friend and I are entrusted to develop a small web based application using ASP and SQL Server database. We are using IIS as the web server. My friend has some background in web programming and I...
12
by: amogan | last post by:
**If interested & qualified, please reply with your resume directly to amogan@google.com** Referrals are always welcome!! Network System Test Engineer - Mountain View This position is...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.