Lazarus

Announcements => Third party => Topic started by: ecalogiuri on March 22, 2010, 11:00:48 am

Title: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: ecalogiuri on March 22, 2010, 11:00:48 am
Hi boys,
I just put online the site of my open source admin tool for dbase tables: MyDbfStudio.

It was entirely written under lazarus and the main features are:


In the program source code, you'll find everything you need to compile MyDbf Studio on your favorite OS.
MyDbf Studio is a project open to all those who want to participate in any way.

More information and download at:
http://mydbfstudio.altervista.org/ (http://mydbfstudio.altervista.org/)

I hope you enjoy my work :-[ :-[ :-[

ps. Sorry for my bad english    :(
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: JanRoza on March 22, 2010, 11:41:36 am
Looks great for a 0.1 version.
Hope the next version can also edit memo fields.
One thing you forgot to translate is the button in the Info screen, it still says 'Chiudi' instead of 'Close'.
But this is one more program to show what can be done with Lazarus and FPC, great job!

 :D
Jan
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: davesimplewear on March 22, 2010, 12:07:52 pm
Likewise as JanRosa said, good work, keep it up.  ;) ;D

Refards
Dave
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: motaz on March 22, 2010, 01:04:45 pm
Looks nice and complete project. You should increase the version number, like 0.9 for example instead of 0.1
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: ecalogiuri on March 22, 2010, 02:13:57 pm
Thanks to all :D :D :D :D

Within a few days I correct buttons that display text in Italian.
I am very pleased that my program you like, if you have any suggestions or criticisms, please let me know.

I've just finished of testing MyDbfStudio on a live slackware 32 bit, under KDE... I simply extract the zip file on desktop and launch the application and... It works perfectl !!!! In a few days I will insert the screenshot on site of MyDbfStudio...

Ciaooo  :D
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: fredycc on March 22, 2010, 04:10:35 pm
Thanks, works perfect ;D;
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: ecalogiuri on March 23, 2010, 09:11:04 am
Hello everyone,
I just released version 0.2 of MyDbf Studio with the corrections of the text of some buttons.

On the site I have also added new screenshot... :D :D

Thank you for your attention ...

Ciaoooo... 8-) 8-)
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: andtag on March 23, 2010, 03:37:11 pm
bel lavoro, complimenti.

great work, thank you.

Andy.

Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: Zoran on March 23, 2010, 08:49:19 pm
Very nice! Bravo!
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: xircon on March 24, 2010, 08:45:05 pm
I am having problems with 0.2 on Mandriva Cooker, when I click on the new table button I get an "Access Violation" message box.  Any ideas?
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: ecalogiuri on March 25, 2010, 08:48:54 am
The window does not appear to create a new table? Very strange, since "New Table" does not do anything special at startup. Mandriva uses KDE or gnome?

However I will do a test on this distribution today or tomorrow and I will correct, if found, the error.

Ciao...
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: xircon on March 25, 2010, 07:43:55 pm
Running KDE4.

Doesn't run on Gnome, just tried it.
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: ecalogiuri on March 26, 2010, 08:52:21 am
Hello everyone

@xircon
Last night I tried Mandriva 2009 32-bit, both live and installed in hd (in virtualized hardware); MyDbfStudio works perfectly  :o

I am attaching the link with screenshot of my test specific to the problem you've reported me:

http://mydbfstudio.altervista.org/scrshot.html (http://mydbfstudio.altervista.org/scrshot.html)

At the bottom you find the image you said.

Please send me a screenshot of the error and the exact version of your OS...

Ciaooo :D :D :D
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: xinyiman on March 26, 2010, 09:06:30 am
Grazie, un bel lavoro davvero!
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: xircon on March 26, 2010, 09:52:39 pm
See:
http://www.youtube.com/watch?v=sED6BzE6Ens

Mandriva Cooker 2010.1, latest everything, Acer 5735z 4gb memory T4200 processor, intel gma graphics.

Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: xircon on March 28, 2010, 12:58:57 pm
Cannot compile from source, have made a recording of the compile:

http://www.youtube.com/watch?v=DUXdcLUYbwY

It SIGSEGV on pressing the new file button / menu item.

Tried running original compiled binary from a terminal & got the following:
Code: [Select]
[steve@localhost mydbfstudio_linux_i386_0.2beta]$ ./DbfStudio
[WARNING] Out of OEM specific VK codes, changing to unassigned
[WARNING] Out of unassigned VK codes, assigning $FF
TApplication.HandleException Access violation
  Stack trace:
  $B73B3C3E
  $081D459D
  $08118B9B
  $08117DEA
  $080F0A98
  $080F0685
  $080F167A
  $080F0B75
  $08059A71
  $0805ED5C
  $0805FE19
  $080F0685
  $080EB9AA
  $0805F35D
  $080EF13D
  $080F252B
  $08221EA9
WARNING: TLCLComponent.Destroy with LCLRefCount>0. Hint: Maybe the component is processing an event?
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: davesimplewear on March 28, 2010, 01:21:21 pm
You need to change the permissions and make the file executable, then just double click to run, no need for the ./

Regards
Dave
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: ecalogiuri on March 29, 2010, 10:54:50 am
You need to change the permissions and make the file executable, then just double click to run, no need for the ./

Regards
Dave

Indeed ...
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: xircon on March 29, 2010, 07:06:54 pm
Errrr yes you do need the "./" when running from a terminal (which I did in the hope of getting the author some useful feedback).

Linux requires "./" to run a program from the current directory if not in path:

Code: [Select]
[steve@localhost mydbfstudio]$ ls
COPYING.GPL.txt  COPYING.LGPL.txt  DbfStudio*  html/  img/
[steve@localhost mydbfstudio]$ DbfStudio
bash: DbfStudio: command not found
[steve@localhost mydbfstudio]$ ./DbfStudio
[WARNING] Out of OEM specific VK codes, changing to unassigned

As you can see "DbfStudio" command not found, "./DbfStudio" - runs.

Of course the program is executable - how else could I (unsuccessfully) run it if it wasn't?
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: davesimplewear on March 30, 2010, 01:11:43 am
HMM I also use linux, I should have pointed out to use nautilus or konquerer instead of the terminal then you don't need the ./ command, double click the executable file to run it as in windows. it is designed to be run that way.

Regards
Dave
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: JimBeam on June 19, 2010, 07:04:22 am
PMFJI, I think Xircon is right: it really shouldn't make any difference whether you run it in a terminal window as long as it's in an X session or you have the display variable set.
If a program is designed to be run by pointing & clicking, please tell me how it differentiates between being started from a terminal window in an X session or a file manager in an X session (or even a menu entry in a window manager)...
I've never, ever, noticed any difference in app behaviour.

Shutting up now, as this discussion is about MyDbfStudio, not about how one should start programs... ;)
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: clauslack on August 28, 2012, 01:36:27 pm
Hello, Can update the binary with the last stable Lazarus/Fpc (the are bug fixed in fpc 2.6 for TDBF)

Regards
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: anis2505 on July 17, 2013, 07:09:31 pm
Hi,

Sorry to revive this topic,

First Excellent product that proves the power of lazarus.

My problem is when creating a new table I can't figure out how to fill the grid with the table fields. that seems not so obvious. SO PLEASE HELP ME I need to know as soon as possible.

EDITED
***************************
Stupid me I found it. for others just use the down arrow key.



regards
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: kodok.buncit on July 17, 2013, 09:13:02 pm
weird it doesn't work on my ubuntu
Code: [Select]
[WARNING] Out of OEM specific VK codes, changing to unassigned
[WARNING] Out of unassigned VK codes, assigning $FF
TApplication.HandleException Invalid floating point operation
  Stack trace:
  $B6556FDC
not even when i double click

anyone can run it on linux?
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: kodok.buncit on July 17, 2013, 09:30:24 pm
ok after downloading the source and compile it then i found error on unit DsDataExport
Code: [Select]
procedure TDsDataExport.SaveRecords;
 Var Bookmark : TBookmarkStr; //
     ACancel : Boolean;
begin
 FDataSet.DisableControls;

 Try
   If FPreserveBookmark Then
    Bookmark:=DataSet.Bookmark;// <-- expected AnsiString but get TByte
//omited for clarity...

then i change it to
Code: [Select]
procedure TDsDataExport.SaveRecords;
 Var Bookmark : TBookmark; // <-- change to TBookmark
     ACancel : Boolean;
begin
 FDataSet.DisableControls;

 Try
   If FPreserveBookmark Then
    Bookmark:=DataSet.Bookmark;
//omited for clarity...

finally it works  O:-)

environtment :
OS : Linux Ubuntu
fpc : 2.7.1
laz : 1.1.x
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: Gustavo 'Gus' Carreno on March 16, 2021, 11:34:32 pm
Hey All,

I'm wondering if this tool's source can be obtained somewhere else than from the http://mydbfstudio.altervista.org , since the page mentioned above is archived.

Has anyone saved the source code in a dark corner of your HDD and could share?

Many thanks in advance!

Cheers,
Gus
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: wp on March 17, 2021, 01:16:29 am
The site is in the wayback machine (https://web.archive.org/web/20180423093628/http://mydbfstudio.altervista.org/index.html), the downloads, however, seem to be missing.
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: Gustavo 'Gus' Carreno on March 17, 2021, 01:48:31 am
Hey WP,

The site is in the wayback machine (https://web.archive.org/web/20180423093628/http://mydbfstudio.altervista.org/index.html), the downloads, however, seem to be missing.

Awww, crap!!

Well, many thanks for the effort in getting the link to the wayback machine!!

Cheers,
Gus
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: paweld on March 17, 2021, 06:27:00 am
https://paweld.ovh/mydbfstudio_source_0.4beta.zip (https://paweld.ovh/mydbfstudio_source_0.4beta.zip)
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: cdbc on March 17, 2021, 06:39:03 pm
Hi
@paweld: Thank you  :)
Regards Benny
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: Gustavo 'Gus' Carreno on March 17, 2021, 07:02:46 pm
Hey paweld,

That's awesome, thank you so very much!!

Cheers,
Gus
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: wp on March 18, 2021, 01:09:27 am
Looks like an intersting small application. Couldn't resist to modify some things:
The modified version is on my github: https://github.com/wp-xyz/MyDBFStudio
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: Gustavo 'Gus' Carreno on March 18, 2021, 01:23:20 am
Hey wp,

After looking at the structure of your GitHub repo I felt a pinch of pride that you chose to use the stuff I told you about.

The only thing that's missing is a README.md, some topics and your on :D

And thank you, so very much, for taking the time to upgrade the source.

I've contacted the author via PM here, but I haven't had any answer yet. His last message was in Jan 2021, so he's still kinda active, so there's hope!
I wanted to ask him if he would be willing to post the source either on SF or GitHub. Looks like you got there first :)

Cheers,
Gus
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: ecalogiuri on May 18, 2021, 09:56:51 am
I'm glad someone still cares about my MyDbfStudio... I am attaching the latest source version, never released, of the program (0.5). It is no longer in MDI mode and uses new, more modern graphics. Obviously the source is released as is without any guarantee. I hope this little gift of mine will be useful to you.

http://fog76.altervista.org/MyDbfStudio_0_5.rar (http://fog76.altervista.org/MyDbfStudio_0_5.rar)

Greetings to all!
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: Handoko on May 18, 2021, 12:43:10 pm
I care. I have been using it for years for managing the dbf files of my personal projects.

Thank you.
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: wp on May 18, 2021, 01:27:59 pm
Nice! Would you mind if I merge it with my port of your previous v0.4-beta (ttps://github.com/wp-xyz/MyDBFStudio)?
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: ecalogiuri on May 19, 2021, 08:54:30 am
I care. I have been using it for years for managing the dbf files of my personal projects.

Thank you.

I'm glad my work has served you!
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: ecalogiuri on May 19, 2021, 08:56:10 am
Nice! Would you mind if I merge it with my port of your previous v0.4-beta (ttps://github.com/wp-xyz/MyDBFStudio)?

Of course, you can do anything you want, as long as you mention me as the original developer (a little advertising never hurts)
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: wp on May 27, 2021, 11:07:48 pm
Merged your version into my fork (https://github.com/wp-xyz/MyDBFStudio) and added some new features:

*  Display memo fields
*  Display ansi characters from the table's code page correctly as utf-8.
*  Store user settings and the names of recently loaded files in an ini file in the the user's home directory.
*  Layout of the controls is determined by anchoring and autosizing and thus should work out in all operating systems supported.
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: avra on May 28, 2021, 12:49:02 am
Merged your version into my fork (https://github.com/wp-xyz/MyDBFStudio) and added some new features:
It would be nice to have at least a windows release.
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: wp on May 28, 2021, 12:53:02 am
Merged your version into my fork (https://github.com/wp-xyz/MyDBFStudio) and added some new features:
It would be nice to have at least a windows release.
Why? Everybody reading this can compile it, it has no special requirements other than Laz 2.0+
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: sstvmaster on May 28, 2021, 08:30:13 am
Hi wp,

please set the "Position" property for the Main Form to "poScreenCenter". And the other Forms too.
I have 2 monitors and the programm starts in the center of these.

greetings Maik
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: Zvoni on May 28, 2021, 08:49:36 am
Or since you use an INI-File to store User-Settings anyway, save the last Position there, or offer the User a Config-Dialogue

I wouldn't change the Position in a hardcoded way, just because there are Users with a Multi-Monitor-Setup

EDIT: Or set it yourself in the Source, and compile yourself
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: avra on May 28, 2021, 05:46:33 pm
Merged your version into my fork (https://github.com/wp-xyz/MyDBFStudio) and added some new features:
It would be nice to have at least a windows release.
Why? Everybody reading this can compile it, it has no special requirements other than Laz 2.0+
Without binary release I can not in the middle of the conversation simply point someone to download link, and the promotion moment is lost. Most of the people I talk to do not have Lazarus IDE, and having me to build it for them whenever there is a new release does not sound tempting. Never mind, it's not a big deal. I'll keep quiet.
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: wp on May 28, 2021, 06:03:55 pm
Ok, this makes sense. I'll prepare binaries when the sources have stabilized (there's still the form position issue mentioned above by others), but I will not keep the releases up-to-date with every change in sources. And BTW, I feel a bit guilty towards Enzo - it's "his baby" after all.
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: wp on May 29, 2021, 12:37:36 am
Form positions and sizes stored in ini file.
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: xos on May 31, 2021, 03:02:43 pm
I am trying to compile the MyDbfStudio project (lazarzs 2.0.12/3.2.0 i386-win32-win32/win64).
But in the procedure TDbfTable.RestoreColWidths(ATable: TDbf); the error message follows,
that ColumnByFieldName is not defined. -> col := DBGrid.Columns.ColumnByFieldName(ATable.Fields[ i ].FieldName);

In Lazarus help the procedure is listed, but not in the installed DBGrids.pas unit.
What am I doing wrong?

Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: wp on May 31, 2021, 05:41:12 pm
What am I doing wrong?
Nothing - my fault, sorry (using laz trunk normally, and ColumnByFieldName is in trunk only).
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: wp on June 18, 2021, 12:59:04 am
Merged your version into my fork (https://github.com/wp-xyz/MyDBFStudio) and added some new features:
It would be nice to have at least a windows release.
Released a new version 0.6.0 with binaries for win32, win64, i386_linux-gtk2, i386_linux-qt, x86_64-linux-gtk2, x86_64-linux_qt5. (did not create binaries for gtk3 and cocoa since they have issues): https://github.com/wp-xyz/MyDBFStudio/releases/tag/v0.6.0
Title: Re: MyDbfStudio - New Admin tool to manage your dbase tables
Post by: avra on June 18, 2021, 01:42:13 am
Released a new version 0.6.0 with binaries
Thanks!  ;)
TinyPortal © 2005-2018