Fedena OS - A school management system (ERP)

What is Project Fedena?

Project Fedena is the open source school management system based on Ruby on Rails. It was initially developed by a team of developers at Foradian Technologies. The project was made open source by Foradian, and is now maintained by the open source community.


How can I see how Fedena works?A demo website for Fedena has been set up at demo.projectfedena.org. You can log in with following usernames and passwords:

• As admin -- username - admin, password - admin123
• As student -- username - 1, password - 1123
• As Employee -- username - E1, password - E1123

What is the license for Fedena?

Fedena is released under the Apache License 2.0. You can read the details regarding the license here.

Evolution of Fedena

Project Fedena started off as an application called Fedena at Foradian Technologies to develop a student information system for some schools who approached the team for the same. Later, the team decided to make the code open source so that anyone can customize Fedena and use it for their educational institution.

Who is Fedena for?

Fedena is the ideal solution for schools and campuses that want an easy means to manage all campus records.

CV601-02022011

Muhammad Ilyas

Address: House No 102, Banaras Colony, SITE Town. Karachi-Pakistan.

Mobile: +92 333 3227872 Email: muhammad.ilyas.pk@gmail.com Blog: http://www.ilyas-pk.blogspot.com

Professional Experience

Assistant Manager Software at Thal Engineering (1^st July, 2010 – Present)
Responsibilities:

• Project Management
• Project Development,Testing and Implementation
• User Trainings and Evaluation
• SAP Development, Implementation & Integration with other applications
  
• Web Development, Mastering and SEO
• Applications Maintenance & Support

Past Positions:

• Software Engineer at Thal Engineering (1^st Jul, 2009 - 31^th Jun, 2010)
• Programmer at Thal Engineering (1^st Feb, 2009 - 31^th Jun, 2009)
• Trainee Programmer at Thal Engineering (14^th Feb, 2008 - 31^th Jan, 2009)

Technical Skills

1. Microsoft Development
   
• Windows/Web Applications, C#.NET, ASP.NET, ASP.NET AJAX, Windows/Web/WCF Services
2. Web Development
• XML/HTML, AJAX, JavaScript, JQuery, Dojo, DNN 5, Kooboo CMS
  
3. SAP Development
   
• SAP ABAP, SAP Script, SAP Functional Modules Development, SAP Integration with other applications
  
4. Databases
•  MSSQL 2000/2005/2008, MYSQL, MS Access, PostgreSQL, MS Excel
5. Reports
• Crystal Reports, MS Access, Excel
6. Other
• OOP, SDLC, SOA, SEO, ORM, Web Mastering, Google Apps Deployment, Batch Processing, Import/Export Business Process
  
7. IDEs
• VS 2003/05/08/10, SAP ABAP Workbench
  

SAP Experience

1. *CS module configuration & implementation
2. *Gate pass configuration and implementation in SAP with barcode
   
3. ABAP simple and ALV reports development
4. Brief knowledge of logistics and cross-application components

Workshops, Trainings & Seminars Attended

1. Web Application Security – Organized by HRM Solutions @ Regend Plaza – 7th Mar-09
2. Communication Skills – Organized by Thal Engineering @ Thal Engineering – 30th Dec-09
3. Problem Solving - Organized by Thal Engineering @ Thal Engineering - 15th April-10

Academy

BE Software Engineering (2008)

Mehran University of Engineering and Technology Jamshoro

Projects Delivered

1. Thal BCP (Business Continuity Plan Implementation) - Online
• This application runs on daily basis on application server and updates its local database on incremental basis from SAP. After successful update, application than pushed database file to ftp site and sending confirmation email to administrator.
• The application has a MS Access Application with the very latest data fetched from SAP and provides alternate solution to business critical processes.
• Technical Information:
• Console Application,C#, SAP Functional Modules, MS Access
2. IS Helpdesk (A mini web-based CRM for IS Dept.)
   
• This is a very simple CRM Website, which logs activities of IS dept. This application supports Auto/Manual Assigment of Job, Auto/Manual Reminders to concern parties, Auto/Manual Daily Report, A special view for GMIS and many other options.
• Technical Information:
• ASP.net web application, jQuery
3. SAP Exchange Rate Up loader 
• Update daily exchange rates in SAP from a internet webpage - absolutely free and automated
• Technical Information:
• Console Application, C#, SAP Functional Module
4. ESS (Employee Self Service for staff)
• This application (asp.net) provides all employees access to their employment information which is dynamically fetched from SAP. This application is playing core role in the organization and every minute found using by employee(s). This application has multiple showcases of information i.e. Personal, Family, Provident Fund, Salary, Org Assignment, and many other.
• Technical Information:
• ASP.net web application, C#, SAP Functional Module, ASP.net AJAX, jQuery, WCF Services
5. Online Leave Request - AddIn for ESS and Thal Admin
• OLR is the mixture of complex workflows which made me crazy after implementing real workflow into logics. This application supports simple approval hierarchy upto 5 layers along with boss of the boss and ultimate boss approval rights.
• This system is added to ESS.
6. Thal Admin (SAP Integrated complete Time Management System)
• Thal Admin is a full featured time management system integrated with SAP Payroll. The system design is very complex with Leave Balances and Employee Master Data maintained in SAP while the rest of information objects are stored in sql server.
• Main features:
• Weekly Work Schedules
• Calendar
• Auto/Manual Work Scheduling 
• Two layer Overtime processing
• Sandwitch & 3 Lates Policy Processing
• MTX-2000 Machine Raw Data Processing
• Single/Bulk Data Processing forms for all type of information i.e. In/Out, Overtime, Leaves, Late, Work Schedule, and Calendar adjustment
• Auto/Manual Roosters generation
• Auto/Manual Report Alerts
• More than 45 crystal reports with dynamic selection of data
• Integration with ESS, ESS Kiosk and OLR.
• Payroll Processor and SAP Payroll Data Uploader
• Leave Reminders and Daily, Weekly, Monthly Auto Reports
• Technical Information:
• Windows application, web application, console applications, C#, ASP.net, Crystal Reports, SAP Functional Module, MS Excel, SQL Server
7. Thal Admin Web Module
• Thal Admin Web Module is a sub project of Thal Admin Time Management System. Thal Admin provides two layered overtime processing options i.e. Department Overtime and System Calculated Overtime. The employee is paid only minimum of both overtime to enforce administrative policy and minimize the overtime. Thal Admin Web Module facilitates individual department to upload their overtime data sheet and confirm the system calculated (on the basis of system and department overtime data) before payroll period end. 
• Main features:
• A simple web application with capabilities to handle excel data sheets with elegant way and prompt human errors. 
• Can generate pre-filled excel data sheet with name of employee and number of days and dates
• Overtime reports
• Daily In/Out Report
• Technical Information:
• ASP.net web application, dojo javascript, javascript, CSS, SAP Functional Modules, WCF ajax services, AJAX
8. Computer Based Wiring Harness Testing System (OHMI 2)
• This application works with custom designed hardware via Serial Port and provides fully logged wire harness testing environment.
• Main features:
• Can log detailed information of wire harness tested
• Can log operator information
• Can log errors data which ultimately delay the testing process
• Crystal Reports
• Auto sending reports for daily and monthly usage
• Administrator control panel for shop floor.
• Technical Information:
• Windows application, C#, Crystal Reports, Console Applications for sending crystal reports via email
9. ESS Kiosk (Employee Self Service for workers)
• This application serves the majority of Thal Engineering Junior Team Members. ESS Kiosk provides very ease of access to all JTMs and has a simple numpad for interaction with the system. This application has a special Kiosk chases specially designed on order with cost effectiveness. 
• Main features:
• Integrated with Time Management System (Thal Admin) and SAP
• Daily IN/OUT, Leave Balances, and many other information showcases
• Fully controlled via 0-9 keys of numpad
• 3 type of Survey can be conducted via ESS Kiosk from JTMs
• Technical Information:
• Full Screen Windows Application with all type of Exceptions handling, C#, SQL Server, SAP Function Modules
10. TE Portal – DotNetNuke Implementation (5.2 upgraded to 5.5)
• This is a web based solution to company data sharing issues. TE Portal has been customized to meet company requirements i.e. all the users are synchronized with SAP employee master data. All employees are marked inactive on leaving the company and updated their profile information as updated in SAP. Currently, we are using Event, Documents, Blogs, Forum and a few others Modules in TE Portal.
• Main Features:
• A scheduled task for Synchronizing User data with SAP Employee Master data
• Base for OpenId for the rest of custom applications.
11. Data Backing Up at Google's Server (100% free)
• This is would be very interesting to all, I've a developed a console email utility which can send as max attachments of any size depending on the service provider i.e. Google Supports sending/receiving emails upto 25MB.
• Main Features:
• Batch Processing 
• Sending emails in console 
• Winrar 
• Technical Information:
• C#, Console Application
12. CRM for Thal Engineering Customer Center - DNN Module
• CRM Module serves Thal Engineering Customer Center with data and service management. This application has achieved its ROI with service reminders and result in business growth.
• Main Features:
• Minimized the data entry time upto 5 minutes
• Membership Data Management and Service History tracking options
• Full featured DNN Module using Settings, Multiple Edit and View Controls
• Email alerts for service feedback, service checkup and service due reminders to management and staff.
• Integrated to SAP for material description and invoice details
• Technical Information:
• ASP.net, DNN 5.5, SAP Functional Modules, SQL Server
13. OPEN ID
• User account management like creating, blocking, deleting in multiple custom applications wastes precious time of developers and application supporters. Open Id at Thal Engineering is a bit different than usual meaning of Open ID. In Thal Engineering Open ID is implemented with SAP Employee Master Data. As all the services are for employees only, each employee has his account in Open Id which is created and marked blocked automatically as hiring or leaving of any employee occurred in the company. Open Id carries employee information and update it as any change occurred to employee data in SAP. Open Id uses user application registeration pattern to authentication to a user for a specific application.
• Main features:
• Auto Create/Delete/Update of Employee Master Data
• Logging
• Single password for all registered application for a user
• Technical Information:
• Dotnet Library, DNN Module, C#, SAP Functional Modules, SQL Server, ASP.net
14. Helpdesk DNN Module - Online
• Helpdesk DNN Module, is a highly flexible, configurable CRM system which can be extended to any level. Helpdesk is designed to carry additional info pattern which is Microsoft membership pattern for maintaining profile information. 
• Main features:
• Configurable Three layered (TechGroup, Category, Sub Category) job/case/token classification
• Additional Info Types:
• Text
• Number
• RichText
• TechTeam
• File
• Job/Case/Token Id
• Configurable Case Status 
• Configurable Actions and its Behaviors
• Auto Reminders
• Auto Closing job/case/token after specified number of customer reminders
• Three layered action authorization pattern
• Configurable Additional Info with category, sub category and action.
• Technical Information:
• ASP.net, C#, DNN 5.5, SQL Server, Crystal Reports, CSS
15. Windows Application Framework (waapf)
• Application framework to quickly built multi form application with lesser headache of maintaining form lifecycle events and properties. With minimum and very simple guidelines developers can built multi form windows applications using vs 2008 or 2010. This framework is still under beta and hosted at http://waapf.codeplex.com.
16. SMS Server using GSM Modems
    
• SMS server is a customized solution to enable business operations on sms. SMS server not only send sms notification but also support receiving commands and respectively to commands fetches data from SAP and other applications for response. SMS Server also has a DNN module for users to send bulk messages to employees of the company (TE).
  
17. Franchise (http://www.franchise-omni.blogspot.com)
    
• Franchise is a desktop application which is an IE automation project build on the top of UBL Omni. It serves UBL Omni agents with elegant interface and let them do transactions in minimum time as possible. Franchise also provide many reports on transactions perform via Franchise. Franchise is still in development and not yet delivered to agents for use. The project is closed source and may converted to open-source on completion.
  
• Franchise is built using waapf which provides SAP GUI like interface.
  

Please click here for projects documentations.

Learn Basics of Accounting in minutes

A few days back, I was looking for a brief introduction of accounting and basic principles of accounting. I' was looking  it on internet and found many reference books for accounting but there was only one which Im sharing here... Generally, internet search gives us maximum information and sometimes we don't need much. Today,  I found this great document which may help you in getting know-how of financial and cost accounting. 

https://docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=1pkSpinXWeUxgul4zSAOnk_PKxps8HrsU-BWt6hobnuzhrEQGzZkqJqlN3T_1&hl=en

Cheears,

Copy ALV Variants from one Program to another

Sometimes, ABAPers do not change program written by others if any changes to existing program requested to them. You can use the following program on production server to copy the ALV VARIANTS of one program to another program. The program is very useful because it will save your time of re-writing Variants.
 

*&---------------------------------------------------------------------*
*& Report  ZMI_ALV_LAYOUT_COPY                                         *
*&                                                                     *
*&---------------------------------------------------------------------*
*&                                                                     *
*&                                                                     *
*&---------------------------------------------------------------------*

REPORT  ZMI_ALV_LAYOUT_COPY                     .

* =====================================================================
* Data Declarations Section
* =====================================================================

* ---------------------------------------------------------------------
DATA : BEGIN OF MYLTDX OCCURS 0 .
INCLUDE STRUCTURE LTDX .
DATA : END OF MYLTDX .
* ---------------------------------------------------------------------
DATA : BEGIN OF MYLTDXT OCCURS 0 .
INCLUDE STRUCTURE LTDXT .
DATA : END OF MYLTDXT .
* ---------------------------------------------------------------------
DATA : BEGIN OF MYLTDXD OCCURS 0 .
INCLUDE STRUCTURE LTDXD .
DATA : END OF MYLTDXD .
* ---------------------------------------------------------------------

DATA : MANS(1) TYPE C .

DATA : PROGRAMM LIKE RS38M-PROGRAMM .
DATA : BEGIN OF MDYNPFIELDS OCCURS 1 .
INCLUDE STRUCTURE DYNPREAD .
DATA : END OF MDYNPFIELDS .
CONSTANTS BUTTONSELECTED(1) TYPE C VALUE 'X' .

* =====================================================================
* Macro for Inputing Filenames
* =====================================================================
DEFINE GET_FILENAME .
CALL FUNCTION 'WS_FILENAME_GET'
EXPORTING
* DEF_FILENAME = ' '
DEF_PATH = &1
MASK = ',*.*,*.*.'
MODE = '0'
* TITLE = ' '
IMPORTING
FILENAME = &2
* RC =
EXCEPTIONS
INV_WINSYS = 1
NO_BATCH = 2
SELECTION_CANCEL = 3
SELECTION_ERROR = 4
OTHERS = 5.

END-OF-DEFINITION .

* =====================================================================
* Macro for Downloading to ASCII Files
* =====================================================================
DEFINE DOWNLOAD_TO_ASCII .
CALL FUNCTION 'WS_DOWNLOAD'
EXPORTING
* BIN_FILESIZE = ' '
* CODEPAGE = ' '
FILENAME = &1
FILETYPE = 'DAT'
* MODE = ' '
* WK1_N_FORMAT = ' '
* WK1_N_SIZE = ' '
* WK1_T_FORMAT = ' '
* WK1_T_SIZE = ' '
* COL_SELECT = ' '
* COL_SELECTMASK = ' '
* NO_AUTH_CHECK = ' '
* IMPORTING
* FILELENGTH =
TABLES
DATA_TAB = &2
* FIELDNAMES =
EXCEPTIONS
FILE_OPEN_ERROR = 1
FILE_WRITE_ERROR = 2
INVALID_FILESIZE = 3
INVALID_TABLE_WIDTH = 4
INVALID_TYPE = 5
NO_BATCH = 6
UNKNOWN_ERROR = 7
GUI_REFUSE_FILETRANSFER = 8
OTHERS = 9.

END-OF-DEFINITION .

* =====================================================================
* Macro for uploading Data from ASCII files
* =====================================================================
DEFINE UPLOAD_FROM_ASCII .
CALL FUNCTION 'WS_UPLOAD'
EXPORTING
* CODEPAGE = ' '
FILENAME = &1
FILETYPE = 'DAT'
* HEADLEN = ' '
* LINE_EXIT = ' '
* TRUNCLEN = ' '
* USER_FORM = ' '
* USER_PROG = ' '
* IMPORTING
* FILELENGTH =
TABLES
DATA_TAB = &2
EXCEPTIONS
CONVERSION_ERROR = 1
FILE_OPEN_ERROR = 2
FILE_READ_ERROR = 3
INVALID_TABLE_WIDTH = 4
INVALID_TYPE = 5
NO_BATCH = 6
UNKNOWN_ERROR = 7
GUI_REFUSE_FILETRANSFER = 8
CUSTOMER_ERROR = 9
OTHERS = 10.
END-OF-DEFINITION .

* =====================================================================
* Selection Screen Default
* =====================================================================
PARAMETERS : P_FROM_P LIKE RS38M-PROGRAMM OBLIGATORY .
PARAMETERS : P_TO_P LIKE RS38M-PROGRAMM OBLIGATORY .
PARAMETERS : P_SAME_S RADIOBUTTON GROUP GRP1 DEFAULT 'X' .
PARAMETERS : P_DOWNLD RADIOBUTTON GROUP GRP1 .
PARAMETERS : P_UPLOAD RADIOBUTTON GROUP GRP1 .
PARAMETERS : P_FILE_x LIKE RLGRAP-FILENAME DEFAULT 'c:\LTDX.txt' .
PARAMETERS : P_FILE_t LIKE RLGRAP-FILENAME DEFAULT 'c:\LTDXT.txt' .
PARAMETERS : P_FILE_d LIKE RLGRAP-FILENAME DEFAULT 'c:\LTDXD.txt' .

* =====================================================================
* At Selection Screen Events
* =====================================================================
AT SELECTION-SCREEN .
PROGRAMM = P_FROM_P .

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILE_x .
GET_FILENAME 'c:\LTDX.txt' P_FILE_x .

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILE_t .
GET_FILENAME 'c:\LTDXT.txt' P_FILE_t .

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILE_d .
GET_FILENAME 'c:\LTDXD.txt' P_FILE_d .

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FROM_P .
CLEAR MDYNPFIELDS . REFRESH MDYNPFIELDS .
MDYNPFIELDS-FIELDNAME = 'P_FROM_P' .
APPEND MDYNPFIELDS .
CALL FUNCTION 'DYNP_VALUES_READ'
EXPORTING
DYNAME = SY-CPROG
DYNUMB = SY-DYNNR
TABLES
DYNPFIELDS = MDYNPFIELDS
EXCEPTIONS
INVALID_ABAPWORKAREA = 1
INVALID_DYNPROFIELD = 2
INVALID_DYNPRONAME = 3
INVALID_DYNPRONUMMER = 4
INVALID_REQUEST = 5
NO_FIELDDESCRIPTION = 6
INVALID_PARAMETER = 7
UNDEFIND_ERROR = 8
DOUBLE_CONVERSION = 9
STEPL_NOT_FOUND = 10
OTHERS = 11.

READ TABLE MDYNPFIELDS INDEX 1 .
PROGRAMM = MDYNPFIELDS-FIELDVALUE .
CALL FUNCTION 'REPOSITORY_INFO_SYSTEM_F4'
EXPORTING
OBJECT_TYPE = 'PROG'
OBJECT_NAME = PROGRAMM
IMPORTING
OBJECT_NAME_SELECTED = PROGRAMM
EXCEPTIONS
CANCEL = 1
WRONG_TYPE = 2
OTHERS = 3.
P_FROM_P = PROGRAMM .

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_TO_P .
CLEAR MDYNPFIELDS . REFRESH MDYNPFIELDS .
MDYNPFIELDS-FIELDNAME = 'P_TO_P' .
APPEND MDYNPFIELDS .
CALL FUNCTION 'DYNP_VALUES_READ'
EXPORTING
DYNAME = SY-CPROG
DYNUMB = SY-DYNNR
TABLES
DYNPFIELDS = MDYNPFIELDS
EXCEPTIONS
INVALID_ABAPWORKAREA = 1
INVALID_DYNPROFIELD = 2
INVALID_DYNPRONAME = 3
INVALID_DYNPRONUMMER = 4
INVALID_REQUEST = 5
NO_FIELDDESCRIPTION = 6
INVALID_PARAMETER = 7
UNDEFIND_ERROR = 8
DOUBLE_CONVERSION = 9
STEPL_NOT_FOUND = 10
OTHERS = 11.

READ TABLE MDYNPFIELDS INDEX 1 .
PROGRAMM = MDYNPFIELDS-FIELDVALUE .
CALL FUNCTION 'REPOSITORY_INFO_SYSTEM_F4'
EXPORTING
OBJECT_TYPE = 'PROG'
OBJECT_NAME = PROGRAMM
IMPORTING
OBJECT_NAME_SELECTED = PROGRAMM
EXCEPTIONS
CANCEL = 1
WRONG_TYPE = 2
OTHERS = 3.
P_TO_P = PROGRAMM .

* =====================================================================
* Start of Selection
* =====================================================================
START-OF-SELECTION .
CASE BUTTONSELECTED.
WHEN P_SAME_S .
PERFORM COPY_FROM_PROG_TO_PROG .
WHEN P_DOWNLD .
PERFORM VDOWNLOAD .
WHEN P_UPLOAD .
PERFORM VUPLOAD .
ENDCASE .

*&---------------------------------------------------------------------*
*& Form COPY_FROM_PROG_TO_PROG
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* --> p1 text
* <-- p2 text
*----------------------------------------------------------------------*
FORM COPY_FROM_PROG_TO_PROG.

CALL FUNCTION 'POPUP_TO_CONFIRM_STEP'
EXPORTING
* DEFAULTOPTION = 'Y'
TEXTLINE1 = 'Are you sure you want to copy Variants ? '
* TEXTLINE2 = ' '
TITEL = 'Confirmation '
* START_COLUMN = 25
* START_ROW = 6
* CANCEL_DISPLAY = 'X'
IMPORTING
ANSWER = MANS
EXCEPTIONS
OTHERS = 1.

IF MANS = 'J' .
* ---------------------------------------------------------------------
REFRESH MYLTDX . CLEAR MYLTDX .
SELECT * FROM LTDX INTO TABLE MYLTDX
WHERE REPORT = P_FROM_P.
LOOP AT MYLTDX .
MYLTDX-REPORT = P_TO_P .
MODIFY MYLTDX .
ENDLOOP .
IF SY-SUBRC = 0 .
DELETE FROM LTDX WHERE REPORT = P_TO_P .
INSERT LTDX FROM TABLE MYLTDX .
ENDIF .
* ---------------------------------------------------------------------
REFRESH MYLTDXT . CLEAR MYLTDXT .
SELECT * FROM LTDXT INTO TABLE MYLTDXT
WHERE REPORT = P_FROM_P.
LOOP AT MYLTDXT .
MYLTDXT-REPORT = P_TO_P .
MODIFY MYLTDXT .
ENDLOOP .
IF SY-SUBRC = 0 .
DELETE FROM LTDXT WHERE REPORT = P_TO_P .
INSERT LTDXT FROM TABLE MYLTDXT .
ENDIF .
* ---------------------------------------------------------------------
REFRESH MYLTDXT . CLEAR MYLTDXT .
SELECT * FROM LTDXT INTO TABLE MYLTDXT
WHERE REPORT = P_FROM_P.
LOOP AT MYLTDXT .
MYLTDXT-REPORT = P_TO_P .
MODIFY MYLTDXT .
ENDLOOP .
IF SY-SUBRC = 0 .
DELETE FROM LTDXT WHERE REPORT = P_TO_P .
INSERT LTDXT FROM TABLE MYLTDXT .
ENDIF .
* ---------------------------------------------------------------------
ENDIF .

ENDFORM. " COPY_FROM_PROG_TO_PROG

*&---------------------------------------------------------------------*
*& Form VDOWNLOAD
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* --> p1 text
* <-- p2 text
*----------------------------------------------------------------------*
FORM VDOWNLOAD.
REFRESH MYLTDX . CLEAR MYLTDX .
SELECT * FROM LTDX INTO TABLE MYLTDX
WHERE REPORT = P_FROM_p.
DOWNLOAD_TO_ASCII P_FILE_x MYLTDX .

* ---------------------------------------------------------------------
REFRESH MYLTDXT . CLEAR MYLTDXT .
SELECT * FROM LTDXT INTO TABLE MYLTDXT
WHERE REPORT = P_FROM_P.
DOWNLOAD_TO_ASCII P_FILE_t MYLTDXT .

* ---------------------------------------------------------------------
REFRESH MYLTDXT . CLEAR MYLTDXT .
SELECT * FROM LTDXD INTO TABLE MYLTDXT
WHERE REPORT = P_FROM_P.
DOWNLOAD_TO_ASCII P_FILE_d MYLTDXT .

* ---------------------------------------------------------------------

ENDFORM. " VDOWNLOAD

*&---------------------------------------------------------------------*
*& Form VUPLOAD
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* --> p1 text
* <-- p2 text
*----------------------------------------------------------------------*
FORM VUPLOAD.
CALL FUNCTION 'POPUP_TO_CONFIRM_STEP'
EXPORTING
* DEFAULTOPTION = 'Y'
TEXTLINE1 =
'Are you sure you want to upload Variants ? '
* TEXTLINE2 = ' '
TITEL = 'Confirmation '
* START_COLUMN = 25
* START_ROW = 6
* CANCEL_DISPLAY = 'X'
IMPORTING
ANSWER = MANS
EXCEPTIONS
OTHERS = 1.

IF MANS = 'J' .
* ---------------------------------------------------------------------
REFRESH MYLTDX . CLEAR MYLTDX .
UPLOAD_FROM_ASCII P_FILE_x MYLTDX .
LOOP AT MYLTDX .
MYLTDX-REPORT = P_TO_P .
MODIFY MYLTDX .
ENDLOOP .
IF SY-SUBRC = 0 .
DELETE FROM LTDX WHERE REPORT = P_TO_P .
INSERT LTDX FROM TABLE MYLTDX .
ENDIF .
* ---------------------------------------------------------------------
REFRESH MYLTDXT . CLEAR MYLTDXT .
UPLOAD_FROM_ASCII P_FILE_t MYLTDXT .
LOOP AT MYLTDXT .
MYLTDXT-REPORT = P_TO_P .
MODIFY MYLTDXT .
ENDLOOP .
IF SY-SUBRC = 0 .
DELETE FROM LTDXT WHERE REPORT = P_TO_P .
INSERT LTDXT FROM TABLE MYLTDXT .
ENDIF .
* ---------------------------------------------------------------------
REFRESH MYLTDXD . CLEAR MYLTDXD .
UPLOAD_FROM_ASCII P_FILE_d MYLTDXT .
LOOP AT MYLTDXT .
MYLTDXT-REPORT = P_TO_P .
MODIFY MYLTDXT .
ENDLOOP .
IF SY-SUBRC = 0 .
DELETE FROM LTDXT WHERE REPORT = P_TO_P .
INSERT LTDXT FROM TABLE MYLTDXT .
ENDIF .
* ---------------------------------------------------------------------
ENDIF .

ENDFORM. " VUPLOAD

Franchise Software Dedicated Blog Now Available

Dear readers and friends; I've started a dedicated blog for Franchise software. The upcoming updates of Franchise software will  be only available at the following blog

http://franchise-omni.blogspot.com/

Thank you for your time and attention...

Franchise Release 2

Please the following link to download the latest build of Franchise software. You must installed the prerequisites of Franchise for proper working.

 http://rapidshare.com/files/444585264/FranchiseSetup__2_.rar

This release includes:

New Features:

• btr1: Agent Fund Movement Transactions Report Added

Bugs addressed in this release:

1. Mobile Number were not changeable while paying bills
2. Agent Fund Movement remote transaction id were not recording
3. Utility Bill Master Form were not showing properly

Franchise Demo: Utility Bill Payment Procedure

Type: 201 in the top textbox and enter or navigate through menu as follows:
Utility Bills > Transactions > 201 Utility Bill Payment Direct


Select you omni account id and provide mobile number and click on Connect button.
System will ask for password. Provide your omni password and press enter and wait for system load your account details and balance.

Select Company from the list and provide consumer account number and press enter key. System will load utility bill data and ask wait for your action either cancel or pay it.

Now press space key or click on pay button. System will confirm your action and proceed to complete the transaction.