Lazarus
Announcements => Third party => Topic started 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:
- You can work with multiple tables at once, in mdi forms.
- You can directly add, modify or delete data.
- You can view deleted data.
- You can create, empty, delete, change or restructure a table.
- You can create, delete or modify any index on table.
- You can add or substract two tables.
- You can directly export data in the following formats: CSV, HTML, XLS, DBF or XML.
- It works on Windows, Linux and all platforms capable of running Lazarus.
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 :(
-
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
-
Likewise as JanRosa said, good work, keep it up. ;) ;D
Refards
Dave
-
Looks nice and complete project. You should increase the version number, like 0.9 for example instead of 0.1
-
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
-
Thanks, works perfect ;D;
-
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-)
-
bel lavoro, complimenti.
great work, thank you.
Andy.
-
Very nice! Bravo!
-
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?
-
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...
-
Running KDE4.
Doesn't run on Gnome, just tried it.
-
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
-
Grazie, un bel lavoro davvero!
-
See:
http://www.youtube.com/watch?v=sED6BzE6Ens
Mandriva Cooker 2010.1, latest everything, Acer 5735z 4gb memory T4200 processor, intel gma graphics.
-
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:
[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?
-
You need to change the permissions and make the file executable, then just double click to run, no need for the ./
Regards
Dave
-
You need to change the permissions and make the file executable, then just double click to run, no need for the ./
Regards
Dave
Indeed ...
-
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:
[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?
-
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
-
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... ;)
-
Hello, Can update the binary with the last stable Lazarus/Fpc (the are bug fixed in fpc 2.6 for TDBF)
Regards
-
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
-
weird it doesn't work on my ubuntu
[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?
-
ok after downloading the source and compile it then i found error on unit DsDataExport
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
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
-
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
-
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.
-
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
-
https://paweld.ovh/mydbfstudio_source_0.4beta.zip (https://paweld.ovh/mydbfstudio_source_0.4beta.zip)
-
Hi
@paweld: Thank you :)
Regards Benny
-
Hey paweld,
That's awesome, thank you so very much!!
Cheers,
Gus
-
Looks like an intersting small application. Couldn't resist to modify some things:
- Use third-party components (LMDI and multidoc) at runtime only to avoid having to install these packages.
- Avoid having the binary and compiled units inside the source folder.
- Added the images at designtime avoiding to have the images in the exe folder (if images are found here they will replace the built-in images).
- Avoid calling ChDir before files are accessed (there are still some...).
The modified version is on my github: https://github.com/wp-xyz/MyDBFStudio
-
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
-
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!
-
I care. I have been using it for years for managing the dbf files of my personal projects.
Thank you.
-
Nice! Would you mind if I merge it with my port of your previous v0.4-beta (ttps://github.com/wp-xyz/MyDBFStudio)?
-
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!
-
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)
-
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.
-
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.
-
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+
-
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
-
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
-
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.
-
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.
-
Form positions and sizes stored in ini file.
-
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?
-
What am I doing wrong?
Nothing - my fault, sorry (using laz trunk normally, and ColumnByFieldName is in trunk only).
-
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
-
Released a new version 0.6.0 with binaries
Thanks! ;)
-
Hello Nice great job...
i would like to open some Dbase iV file with index with date format, i have an error message syaing that only string or float format are supported... is it a MyDBF limitation ?
-
I don't know. Can you upload the dBase files?
-
Yes i could. Send me in pv the method..
-
What do you mean with "method"? The method how to upload the dbase files here? Pack them together into a zip which you can upload under "Attachment and other options" here, if the size of the zip is less than 500 KB. If it is larger, upload the file to some cloud server (google drive, dropbox, onedrive, or so) and post the link. If you do not want to publish the file send me a PM with the link.
-
Il will send you thé exemple file in pv... in few minutes
-
What do you mean with "method"? The method how to upload the dbase files here? Pack them together into a zip which you can upload under "Attachment and other options" here, if the size of the zip is less than 500 KB. If it is larger, upload the file to some cloud server (google drive, dropbox, onedrive, or so) and post the link. If you do not want to publish the file send me a PM with the link.
I'm sorry wp but i could find how to send you a message in pv :-( neewbe here ... send file here no personnal data...
-
Here the file can be opened without any issues, both in MyDbfStudio and in the little project attached (Win 11, Laz/main+FPC3.2.2(32-bit), Laz2.2.4+FPC3.2.2(64-bit), Laz1.8.4.+FPC3.04(32-bit)).
-
Yes files can be open but when hi try to restructure or packtable there is the error message ... see error.jpg
windows 10 22h2
mydbf studio binaries 0.6.0
-
You did not mention this...
Found that the issue is in the TDbf component of FPC. Replaced it in MyDbfStudio by the sourceforge version of the original authors, and now the issue is gone.
Committed everything to the github repository. Give me some time to prepare the release versions.
-
Tanks à lot ;-) u r great
,-)
-
Released binaries for Win 32/64bit and Linux gtk2 (32/64bit) and Linux qt (32bit): https://github.com/wp-xyz/MyDBFStudio/releases/tag/v0.6.1
-
Thanks wp for this news version but steal have the same error :-( :-(
test also on a personnal computer W11 21H2 same pb ...
-
Did you use the win64-bit version? I think I forgot to adjust the path to the newly used tdbf units here (I had tested the 32-bit version). Please try again, I replaced the file https://github.com/wp-xyz/MyDBFStudio/releases/download/v0.6.1/mydbfstudio-v0.6.1-x86_64-win64.zip. Please report back if this fixes the issue before I have a look at the other release files.
-
yes uses 64 bits version ... try this new one .. and report
-
GREAT thats seems to work ;-) Thnaks a lot
-
Noticed that there is a memory leak in the table restructuring code. Attempted to fix it and it seems to solve it, but I would like to hear your feedback since you seem to be a user of this feature. Please test the new release at https://github.com/wp-xyz/MyDBFStudio/releases/tag/v0.6.2.
-
0.6.2 works Nice... more used the week to Côme
-
@wp ... i have some question. About csv export.
In fact i will try t'y convertir réal numérique but i have trouble with décimal séparation is it possible to add and option tu chose the décimal séparation. In fact i m In.france id would like to spécifique, ratier than ,
Could you add this option?
-
I added an option to select the decimal separator for csv export. Moreover I added a context menu to all export dialogs allowing to check/uncheck all fields (exporting a single field in your previously uploaded file with many fields was a pain...). And fixed a few bugs in relation to import/export.
Please note that I do plan to prepare the a new release for these changes. Simply download the current code as a zip file (behind the green button on https://github.com/wp-xyz/MyDBFStudio) or by means of git, and compile your version yourself.
-
Tanks à lot... i will try for the forst time to install lazarus and compliqué the apps ....
( i m à Newbie...)
Il will give you some feedback..
-
@wp.. i would have some advice. I try to convert delphi with BDE use to lazarus. I have dbicopytable. In it. What is for u thé Best way to copy a dbf table to another in lazarus..