Nubuilder.. the bees knees ...

[ricklincs]

I have used nuBuilder over the past few years (with great success) to deliver small uncomplicated applications to clients (such as Gatein/out system for vehicle movements and a Bodyshop repair and estimation system)... I have had Great support from the community and the apps are still going strong after 16 months and 90000 records/movements.

I have now been asked to look at a project for cargo handling company that must record (the main ones):

1. Expected manifests approx 12 per month (data sent via shipper by EDI) which could for each manifest hold 2000 records/items (but also able to create/amend
manually).
2. Received manifests (manual input) which would also generate a received manifest EDI file to send back to the shipper.
3. Item qty available, item no, item pieces, item weight and item location once received.
4. Item Orders (data sent via shipper by EDI). approx 60 orders per week
5. Item Dispatch (manual input) which would generate a dispatch note and a despatch EDI file sent to the shipper. approx 60 per week
6. Item History (received date, dispatch date).

Has anyone had experience with EDI into mysql? Or Forms and subforms with potentially 000's of lines/records? I with past systems have only ever had a subform with up to 35 lines and I wonder what the limitations are?? As ever thank you for reading and any input into shortfalls or your experience is greatly appreciated.

[kev1n]

Hi,

I don't have any experience with EDI files processing. Maybe an EDI parser like https://github.com/php-edifact/edifact could be of help?
A subform's limit is 999 rows (if I'm not mistaken). The question is if an embedded browse form would do the job too (if no editing is required)

[apmuthu]

If you have already hammered out an ERD of the project with all relationships, you can use any of the auto script generators to do the job and then replace the forms as needed. PHPRunner, PHPMaker, ScriptCase, etc come to mind. DaDaBik does a good job although quite straight jacketed. AjaxCRUD may be used for all ordinary jobs. Formoid can generate the forms as needed and they can be stripped of any processing / branding and used too. CASE Studio and other such tools can be used to generate an ERD with Data Dictionary pseudo field types too.

SlimAPI can be used for RESTAPI based design for EDI.