Yogi Grantz
Home | Portfolio | Favorite Links | Exchange URL | EDI | Recommendations
thinker

 

Techie Stuff

EDI stands for Extreme Data Interface. It is a code generator program that was created to generate a web based application with mere table name and field names for the input. A single click of a button will generate the entire web application of our choice: php with MySQL, or n-tiered .NET 2.0 with SQL server. Both systems are XHTML compliant, CSS-controlled, and utilizes AJAX to transport data to and from the server for fastest response and best user experience.



Owning a copy of EDI is equivalent to hiring a programmer who is expert in php, AJAX, .net, SQL, css, javascript, and xhtml with incredible speed and accuracy.


The code generator program is a VB executable that runs on Windows. It produces web application that require Internet Server to host. The php/MySQL output option will run on Apache, which can run on both Windows or Linux. The .NET 2.0/SQL Server option will run on Internet Information Server with .NET 2.0 Framework, which is only available on Windows.

The generated code allows end users to search, add, update, delete, and list data, which are the five basic functionalities for data processing. The php/MySQL option has three additional features: upload a tab-delimited text file to mass-populate the table, upload an image for each record, and upload images to a separate, specially designated table. The .NET 2.0/SQL Server option has two additional features: accept data from PDF form, and generate triggers for SQL Server.

EDI covers both platforms: Windows and Linux. It is a very powerful generator because it can turn simple spreadsheets and small databases such as Microsoft Access or Filemaker pro into a full-blown web application with industry-standard database, accessible through Intranet or Internet, in a single-click of a button. A typical spreadsheet that contains fifteen fields would require at least one week worth of programming work to turn it into a web application that is css-controlled and xhtml-compliant. With EDI, the process takes a split-second. This code generator itself is almost equivalent to a programmer, except a million times faster.

Shown below is the screen-capture of EDI user interface. Note that it gives us an option whether to produce php/MySQL based application or .NET/SQL server based application. We can specify the output directory, or select and create a new directory by clicking on the [...] button.
edi

On the php/MYSQL option, it prompts the table name and field names. The mySQL database name, user id, and password are needed to create and access the table. This interface gives an option whether the application will run Windows or Linux. Additionally, it prompts whether or not the records will contain photos. Records such as "items for sale", "membership information", "inventory items", etc. usually have photos.
edi2

With one click of a button that says: "Generate PHP App + AJAX" the program will generate all the codes necessary to create the MySQL table, add, change, delete, list, search the new table, upload tab-delimited text file to populate the table, and allow uploads for the photos of the individual records. Below is a sample output of the generator that has been populated with three records and photos for illustration:
sample_pic

With the data entry page that is capable of importing tab-delimited text file, add, change, delete, and search records:

The output files are either already in the directory hosted by the server, or can be moved to the host server that has connection to the MySQL database. To test this demo page, go to:

http://www.yogigrantz.com/edi/list_items_for_sale_gen.php

for photo oriented websites, and

http://www.yogigrantz.com/tech_demo

for data oriented websites.

Additional screen captures from another application are shown below:



A list of technologies that I am expert in

  • RSS
  • AJAX
  • DOM
  • PHP
  • Javascript
  • MySQL
  • CSS
  • XHTML
  • ASP / C# .NET 2.0
  • ASP .NET 1.0
  • ASP Classic
  • SQL Server
  • DHTML
  • Dreamweaver CS4 & CS3
  • Visual Studio 2005
  • Visual Studio 2003
  • SQL Reporting Service
  • COBOL
  • COMTI
  • DMSii
  • IMS
  • TELON

Services that I am offering

  • Free business/technical analysis and recommendation
  • Platform preparation & EDI installation
  • Business application customization
  • Programming training for php, SQL, .net, AJAX, Dreamweaver CS4/CS3
  • End-user training

    Please contact me at m3@pilihhotel.com for more details
  • Yahoo! News: Internet News
    Internet News

    		•

    IT Solution Provider

     

    arch

    State of the Art IT Software Architecture developed with EDI N-Tiered ASP .NET 2.0 Code Generator,  EDI PHP Code Generator, and AJAX Technology connecting to MySQL and SQL Server Databases.

     

    pyramid