User Panel
User Panel
User Panel
|
Posted: 11/26/2011 11:47:02 AM EDT
[#1]
Page two placeholder.
|
|
|
|
Posted: 11/26/2011 2:25:51 PM EDT
[#2]
Here's a screenshot of the ammo data entry window:
|
|
|
|
Posted: 11/28/2011 10:18:12 PM EDT
[#4]
Re-worked the accessories selection system and added a miscellaneous type.
As always, it won't work without the instructions. Notes on ATF compliance. gun-0.9.8.zip I've added an accessory "miscellaneous" to capture perhaps less common accessories. Ideally, though, each category of accessory should have its own specialized data entry page. Suggestions are welcome! Here are some screen shots:   
Just a reminder, please test things out, but don't go adding large amounts of legitimate data until version 1.0! |
|
|
|
Posted: 11/29/2011 8:39:26 AM EDT
[#5]
Bump for the midday crew.
Posted Via AR15.Com Mobile |
|
|
|
Posted: 11/30/2011 12:45:12 PM EDT
[#6]
Update! As always, it won't work without the instructions. Notes on ATF compliance.
gun-0.9.9.zip You can now dynamically add sub-categories of the "All Miscellaneous" category. When you open up the MISC form (or click on "Manage" while viewing All Miscellaneous or a sub-category of it), entering your own category is mandatory so items will show up in lists. My next project will be to automatically reduce all caps to lowercase, except for commonly recognized abbreviations.
Just kidding. That'd be way too much work. Anyhow, give it a run, and let me know what you think! Enable macros per the instructions if you want all the accessory stuff to work. Otherwise, version 0.9.5 doesn't have any macros. |
|
|
|
Posted: 12/1/2011 8:19:25 PM EDT
[#7]
First release candidate!
gun-1.0-RC1.zip I've greatly simplified the process for printing ATF reports per regulation. Just go to the ATF_REPORT form, enter the start date and end date of the date range you need to print, and click the button! I've left the bogus testing data in there for now, but will remove it for the next release candidate (RC2). I hope for/expect RC3 to be the first *actual* release. 
As always, it won't work without the instructions. Notes on ATF compliance. I've polished up the different "categories" that can be associated with each gun to include Events and Maintenance events. Please check it out and let me know what you think! Also, if you frequent any other gun forums, please let others know this is available! Gratuitous screen shot: 
|
|
|
|
Posted: 12/1/2011 8:39:34 PM EDT
[#8]
And a screen shot of the Maintenance window:
|
|
|
|
Posted: 12/2/2011 12:07:58 PM EDT
[#9]
Comments! Please!
Surely this isn't a flawless piece of work. 
|
|
|
|
Posted: 12/2/2011 9:20:32 PM EDT
[#10]
Release candidate 2 is up! You have to enable macros to take advantage of a lot of the features.
I realized that the database has to be manually registered in order for everything to work properly. To register the database, go to Tools > Options > LibreOffice Base > Databases > New > Browse > Open gun.odb and save the settings. The registered name must be gun. If it wasn't working for you before, this might have been why. 
If you have any trouble with things, let me know! |
|
|
|
Posted: 12/3/2011 8:42:05 AM EDT
[#11]
Bump.
|
|
|
|
Posted: 12/3/2011 2:12:07 PM EDT
[#12]
I want this to be ready to go once I get my C&R!
Please! Let me know what you think! This database is free and will remain free. See the license included with the zip archive for more details. 
|
|
|
|
Posted: 12/4/2011 6:56:52 AM EDT
[#13]
RC3 is here!
This should end up being the 1.0 release, unless someone finds a major bug or flaw. Let me know what you think, or if you find a problem! |
|
|
|
Posted: 12/4/2011 6:57:41 AM EDT
[#14]
Thanks for that. Should come in handy.
|
|
|
|
Posted: 12/4/2011 5:09:34 PM EDT
[#15]
The release of 1.0 will have a minor update.
I've added a button for each place there's a picture box. Clicking on this button will open the current picture in your default image program. Since this minor update doesn't affect the underlying database structure, you can extract the files gun.script, gun.properties, and gun.data from your backup (which will be called gun-*.tar.gz, where * is the timestamp of the backup) and replace these files in the gun folder with the files from your backup. 7-zip can be used to extract the tar.gz files. |
|
|
|
Posted: 12/5/2011 6:59:25 AM EDT
[#16]
OK. Update. RC6. I wouldn't have done this, but I started a project page for this over at Sourceforge: https://sourceforge.net/projects/gun/
The download link is at the project page. This is a minor update. Just has the "open image" button added. To restore a backup from an earlier version, extract the three files from your gun-*.tar.gz backup file, and overwrite the files by the same name in the gun folder with the files from your backup. |
|
|
|
Posted: 12/5/2011 11:42:51 AM EDT
[#17]
bump
Posted Via AR15.Com Mobile |
|
|
|
Posted: 12/6/2011 6:10:41 AM EDT
[#18]
Poll added.
|
|
|
|
Posted: 12/6/2011 11:00:52 AM EDT
[#19]
Seriously people.
This is going to remain free. 
|
|
|
|
Posted: 12/6/2011 12:39:55 PM EDT
[#20]
Quoted:
Seriously people. This is going to remain free. This is GD. They're jerking your chain. |
|
|
|
Posted: 12/7/2011 8:56:06 AM EDT
[#21]
bump
|
|
|
|
Posted: 12/9/2011 11:49:38 AM EDT
[#22]
Quoted:
Quoted:
Seriously people. This is going to remain free. This is GD. They're jerking your chain. Eh, I should've figured that.
|
|
|
|
Posted: 12/9/2011 12:00:49 PM EDT
[#23]
I kind of wish you had written it in C#, so that it could also run cross platform via Mono (to include iOS and Android, if you you happen to have Xamarin)
It also helps that I know C#, and could collaborate/contribute to the project.
|
|
|
|
Posted: 12/9/2011 12:30:12 PM EDT
[#24]
Quoted:
I kind of wish you had written it in C#, so that it could also run cross platform via Mono (to include iOS and Android, if you you happen to have Xamarin) It also helps that I know C#, and could collaborate/contribute to the project. Hmmm... It's been a while since I've messed around with C#. All I've really done here is make a SQL (hsqldb) database using LibreOffice as a front-end/host for Basic macros. Almost all of the key features are actually in SQL. Are there any SQL database engines that can run on Android?
ETA: In other words, I'm open to suggestions/proposals for design and implementation.
|
|
|
|
Posted: 12/9/2011 12:34:44 PM EDT
[#25]
Quoted: Quoted: I kind of wish you had written it in C#, so that it could also run cross platform via Mono (to include iOS and Android, if you you happen to have Xamarin) It also helps that I know C#, and could collaborate/contribute to the project. Hmmm... It's been a while since I've messed around with C#. All I've really done here is make a SQL (hsqldb) database using LibreOffice as a front-end/host for Basic macros. Almost all of the key features are actually in SQL. Are there any SQL database engines that can run on Android? SQLite is included on every Android device. |
|
|
|
Posted: 12/9/2011 12:36:57 PM EDT
[#26]
Quoted:
Quoted:
Quoted:
I kind of wish you had written it in C#, so that it could also run cross platform via Mono (to include iOS and Android, if you you happen to have Xamarin) It also helps that I know C#, and could collaborate/contribute to the project. Hmmm... It's been a while since I've messed around with C#. All I've really done here is make a SQL (hsqldb) database using LibreOffice as a front-end/host for Basic macros. Almost all of the key features are actually in SQL. Are there any SQL database engines that can run on Android?
SQLite is included on every Android device. Eeeeeeeiiiiinteresting. Does SQLite support triggers? |
|
|
|
Posted: 12/9/2011 12:42:38 PM EDT
[#27]
Quoted: Eeeeeeeiiiiinteresting. Does SQLite support triggers? Partially. FOR EACH ROW triggers are supported, but not FOR EACH STATEMENT. Basically, almost all of SQL92 is implemented.
|
|
|
|
Posted: 12/9/2011 12:55:03 PM EDT
[#28]
Quoted:
Quoted:
Eeeeeeeiiiiinteresting. Does SQLite support triggers? Partially. FOR EACH ROW triggers are supported, but not FOR EACH STATEMENT. Basically, almost all of SQL92 is implemented. Hmmm, I don't think I used any of the latter. Looking here, I think the triggers would work. If almost all of SQL92 is implemented, then everything else should probably work, too. Is MonoDevelop an appropriate IDE for Ubuntu? |
|
|
|
Posted: 12/9/2011 1:15:52 PM EDT
[#29]
Quoted: I've not used it personally, but it seems to be held in high regard. Quoted: Quoted: Eeeeeeeiiiiinteresting. Does SQLite support triggers? Partially. FOR EACH ROW triggers are supported, but not FOR EACH STATEMENT. Basically, almost all of SQL92 is implemented. Hmmm, I don't think I used any of the latter. Looking here, I think the triggers would work. If almost all of SQL92 is implemented, then everything else should probably work, too. Is MonoDevelop an appropriate IDE for Ubuntu? |
|
|
|
Posted: 12/9/2011 6:19:47 PM EDT
[#30]
Seems SQLite doesn't do variables very well.
|
|
|
|
Posted: 12/9/2011 7:50:48 PM EDT
[#31]
Quoted: Seems SQLite doesn't do variables very well. I wouldn't know. I've yet to use it for other than trivial things. |
|
|
|
Posted: 12/9/2011 9:16:33 PM EDT
[#32]
Version 1.0 is up!
It's exactly the same as RC6, so if you're using that, then no need to upgrade. As always, let me know if there are any bugs. |
|
|
|
Posted: 12/10/2011 4:46:54 PM EDT
[#33]
Quoted:
Quoted:
Seems SQLite doesn't do variables very well. I wouldn't know. I've yet to use it for other than trivial things. Do you know Java? |
|
|
|
Posted: 12/10/2011 4:48:50 PM EDT
[#34]
Quoted: Quoted: Quoted: Seems SQLite doesn't do variables very well. I wouldn't know. I've yet to use it for other than trivial things. Do you know Java? Enough to be dangerous, not enough to EVER get hired as a Java developer. Hell, not enough to do anything other than trivial things. I'll just say "no".
|
|
|
|
Posted: 12/14/2011 4:42:00 AM EDT
[#35]
Quoted:
Quoted:
Quoted:
Quoted:
Seems SQLite doesn't do variables very well. I wouldn't know. I've yet to use it for other than trivial things. Do you know Java? Enough to be dangerous, not enough to EVER get hired as a Java developer. Hell, not enough to do anything other than trivial things. I'll just say "no". Heh, that's about where I'm at with all programming languages.
In any event, I think I'll mostly focus on maintaining this LibreOffice database. My main reason for making this was to make a reasonably useful system to satisfy all of the ATF requirements for a C&R (and potentially other FFLs) license. LibreOffice has the reports system and layout already programmed and integrated, and really, this does everything I need it to do, and I now that I have the framework in place, I can easily add stuff to it as necessary. I just wish more people would critique it in detail!
|
|
|
|
Posted: 12/14/2011 8:54:43 AM EDT
[#36]
Added the bound book templates, just for kicks.
|
|
|
|
Posted: 12/16/2011 4:13:45 AM EDT
[#37]
Is anyone using this?
Posted Via AR15.Com Mobile |
|
|
|
Posted: 12/16/2011 4:46:02 AM EDT
[#38]
Quoted: Is anyone using this? Posted Via AR15.Com Mobile I have no need for it, or I would. There's another dude on here that has a pretty nice one (lots of arfcommers using it, as far as I know), though it's not open source. It uses Adobe Air, to achieve it's cross platform ability. I'm guessing that's why there's not much interest in your project, but I don't really know.
|
|
|
|
Posted: 12/17/2011 4:30:58 PM EDT
[#39]
Not working for me. IM inbound.
|
|
|
|
Posted: 12/17/2011 5:26:47 PM EDT
[#40]
Thanks for pointing out this bug! Probably the easiest way to go about fixing this, since it sounds like you already have things set up correctly, or else you wouldn't have made it this far, is to enter a simple database command. If you've already entered data into the database, this command doesn't change or delete any data, it just sets the properties of the ANT and CR columns in the log table to accept null values (which are passed to those columns whenever a change has not been made to that column in the GUN table...). First, click on Tools > SQL: 
Then copy the following two lines of code: ALTER TABLE GUN_LOG ALTER COLUMN ANT SET NULL ...and paste them into the Command to execute box, and click Execute: 
After clicking Execute, a message indicating successful execution of the command should show up in the Status window. And that's it. Fixed! Just to be sure, you can completely exit the database and LibreOffice, then re-open it. |
|
|
|
Posted: 12/17/2011 5:37:10 PM EDT
[#41]
Updated release with the bug fix is added to the OP.
|
|
|
|
Posted: 12/20/2011 6:07:05 PM EDT
[#42]
Bump for those who may not have caught the bug fix.
|
|
|
|
Posted: 12/22/2011 7:34:17 AM EDT
[#43]
tc2k11, I'm having a problem with your database. When I try to open the gun form it says it can't find the table GUN. When I go to tables there's nothing there and hitting refresh does nothing. What am I doing wrong?
|
|
|
|
Posted: 12/22/2011 9:21:24 AM EDT
[#44]
Quoted:
tc2k11, I'm having a problem with your database. When I try to open the gun form it says it can't find the table GUN. When I go to tables there's nothing there and hitting refresh does nothing. What am I doing wrong? You just have to change the path to the gun.odb file and gun folder. Here are the detailed instructions: https://sourceforge.net/p/gun/wiki/Instructions/ |
|
|
|
Posted: 12/22/2011 9:41:59 AM EDT
[#45]
I think I did that, it's supposed to look like this right?
Or do I need to point something else at the gun.odb file? 
Thanks for your fast reply |
|
|
|
Posted: 12/22/2011 9:55:03 AM EDT
[#46]
Quoted:
I think I did that, it's supposed to look like this right? Or do I need to point something else at the gun.odb file? http://i43.tinypic.com/156cznr.gif Thanks for your fast reply That is the correct line to change, but it should be <snip>\Desktop\gundb\gun\gun;<snip> ETA: No problem, I'm just on vacation, nothing to do, and loving it.
|
|
|
|
Posted: 12/22/2011 9:57:15 AM EDT
[#47]
Worked! Thanks
|
|
|
|
Posted: 12/22/2011 2:48:20 PM EDT
[#48]
Quoted:
Worked! Thanks Let me know how it's working for you! |
|
|
|
Posted: 12/26/2011 2:44:28 PM EDT
[#49]
Bump for prime time.
|
|
|
|
Posted: 12/26/2011 5:34:28 PM EDT
[#50]
Bump.
|
|
|
Win a FREE Membership!
Sign up for the ARFCOM weekly newsletter and be entered to win a free ARFCOM membership. One new winner* is announced every week!
You will receive an email every Friday morning featuring the latest chatter from the hottest topics, breaking news surrounding legislation, as well as exclusive deals only available to ARFCOM email subscribers.
AR15.COM is the world's largest firearm community and is a gathering place for firearm enthusiasts of all types.
From hunters and military members, to competition shooters and general firearm enthusiasts, we welcome anyone who values and respects the way of the firearm.
Subscribe to our monthly Newsletter to receive firearm news, product discounts from your favorite Industry Partners, and more.
Copyright © 1996-2024 AR15.COM LLC. All Rights Reserved.
Any use of this content without express written consent is prohibited.
AR15.Com reserves the right to overwrite or replace any affiliate, commercial, or monetizable links, posted by users, with our own.
