Project Free HRD & Payroll Application

You can share your experience with HMG. Share with some screenshots/project details so that others will also be benefited.

Moderator: Rathinagiri

User avatar
Agil Abdullah
Posts: 204
Joined: Mon Aug 25, 2014 11:57 am
Location: Jakarta, Indonesia
Contact:

Re: Project Free HRD & Payroll Application

Post by Agil Abdullah »

Rathinagiri wrote:
I also wish to state the following points that come to my mind to be considered by the developers/contributers (including me):

Let the software be a modular, layered model. By saying layered, I want to separate the backend data interface layer from the user interface layer. This will help to accommodate any type of database (be it dbf, sqlite, mysql etc).

The software be extensible. For example, if the user wants to add a field to a table, there shall be a provision to do so.
I agree with you. That's why I need your help to make it happend.

Regards,
Agil Abdullah Albatati (just call me Agil)
Programmer Never Surrender
User avatar
serge_girard
Posts: 3167
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: Project Free HRD & Payroll Application

Post by serge_girard »

Agil,

Indexing error occured:

Date:10/03/14 Time: 15:11:27
Error DBFNTX/1201 Workarea not indexed

Called from DBSEEK(0)
Called from MAN01SAVEDATAENTRY(152)
Called from (b)MAN01DATAENTRY(101)
Called from ABM2EDITARGUARDAR(1288)
Called from (b)ABM2EDITAR(985)
Called from _DOCONTROLEVENTPROCEDURE(5656)
Called from EVENTS(1635)
Called from DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(5324)
Called from ABM2EDITAR(1131)
Called from (b)ABM2(670)
Called from _DOCONTROLEVENTPROCEDURE(5656)
Called from EVENTS(1635)
Called from DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(5324)
Called from ABM2(761)
Called from MAN01DATAENTRY(111)
Called from (b)MAIN(217)
Called from _DOCONTROLEVENTPROCEDURE(5656)
Called from EVENTS(1673)
Called from DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(5324)
Called from MAIN(338)

Serge
There's nothing you can do that can't be done...
User avatar
Agil Abdullah
Posts: 204
Joined: Mon Aug 25, 2014 11:57 am
Location: Jakarta, Indonesia
Contact:

Re: Project Free HRD & Payroll Application

Post by Agil Abdullah »

Serge wrote:

To my opinion it is very important that you first have a system with:

1) access-management : users login-logout-password etc. etc.
2) Data-integrity (see http://en.wikipedia.org/wiki/Data_integrity" onclick="window.open(this.href);return false;" onclick="window.open(this.href);return false; )
3) Referential-integrity (I just entered a double Empidnum 0019820402 to the database without any objection).
4) Multi-user?
5) Local database or remote-access database (in the 'cloud' as they say today). I say I prefer remote-access database.

I strongly suggest MySQL (or any other SQL database) because :
- you define once the indexes
- you don't have to worry about them (no reindex)
- if well-define you CANNOT insert duplicates

Do you have the possibility for SQL database (even local via XAMPP is well)
It's true what you said.

I forgot to mensioned that the apps HAS NOT BEEN tested yet. Because it's only the beginning. What I have in my mind is to post it as soon as possible. That improvement follows.
Agil,

I just edited (double) Empidnum 0019820402 and changed field name and now both entries are changed. This is what meant in my earlier post.

Serge
Sure, control of index has not been set. So duplicates can happend easily.

Next, I will overcome that matter with attachment. So, do not take it too serious with errors. :)
Remember that is just beginning.

Regards,
Agil Abdullah Albatati (just call me Agil)
Programmer Never Surrender
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: Project Free HRD & Payroll Application

Post by Rathinagiri »

As Serge suggests, if it is decided to go for a SQL based database, I can help with many modules which I had already used in many of my projects.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Agil Abdullah
Posts: 204
Joined: Mon Aug 25, 2014 11:57 am
Location: Jakarta, Indonesia
Contact:

Re: Project Free HRD & Payroll Application

Post by Agil Abdullah »

Believe me,

Next week some unforced errors dispapper.
I will work on it with help and input from friends in this forum.

Multiuser? Yes, I will make it.

Cheers.
Agil Abdullah Albatati (just call me Agil)
Programmer Never Surrender
User avatar
Agil Abdullah
Posts: 204
Joined: Mon Aug 25, 2014 11:57 am
Location: Jakarta, Indonesia
Contact:

Re: Project Free HRD & Payroll Application

Post by Agil Abdullah »

Rathinagiri wrote:

As Serge suggests, if it is decided to go for a SQL based database, I can help with many modules which I had already used in many of my projects.
Oke. Agree.

Awaiting for your attachment. Thanks.
Agil Abdullah Albatati (just call me Agil)
Programmer Never Surrender
User avatar
serge_girard
Posts: 3167
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: Project Free HRD & Payroll Application

Post by serge_girard »

Agil,

What possible SQL database you have in mind? In order to work in the 'cloud' you will have a host which has remote-access.
Like Rathi I have also many SQL-modules, for what concerns data-entry, login, lost passwords, ...
Let me know all access-information by private email.

Greetings and nice weekend!

Serge
There's nothing you can do that can't be done...
User avatar
Agil Abdullah
Posts: 204
Joined: Mon Aug 25, 2014 11:57 am
Location: Jakarta, Indonesia
Contact:

Re: Project Free HRD & Payroll Application

Post by Agil Abdullah »

As mentioned before, this is to provide exercises to, especially beginners to learn from the very beginning and developing apps from the very simply one. To make them easy to understand and implement. So do not jump to fast.

Let's encounter trials and errors ( and its terror and its horror :lol: )

Thanks Serge for kind attention.

"Salam Hangat" from Jakarta.
Agil Abdullah Albatati (just call me Agil)
Programmer Never Surrender
Javier Tovar
Posts: 1275
Joined: Tue Sep 03, 2013 4:22 am
Location: Tecámac, México

Re: Project Free HRD & Payroll Application

Post by Javier Tovar »

Hola Agil,

Buena idea, creo que todos necesitamos algo como eso!; aunque no se SQL tendré que empezar a investigar ese paquete de programación!.

Saludos
User avatar
Agil Abdullah
Posts: 204
Joined: Mon Aug 25, 2014 11:57 am
Location: Jakarta, Indonesia
Contact:

Re: Project Free HRD & Payroll Application

Post by Agil Abdullah »

Javier Tovar wrote:

GoogleTranslate:

Good idea, I think we all need something like that !; SQL although I do not have to start researching this programming package!
Yes, we all. From very simple version to very complicated version.

Saludos.
Agil Abdullah Albatati (just call me Agil)
Programmer Never Surrender
Post Reply