Warning

 

Close

Confirm Action

Are you sure you wish to do this?

Confirm Cancel
BCM
Durkin Tactical Franklin Armory
User Panel

Site Notices
Page / 3
Link Posted: 11/26/2011 11:47:02 AM EDT
[#1]
Page two placeholder.

Link Posted: 11/26/2011 2:25:51 PM EDT
[#2]
Here's a screenshot of the ammo data entry window:

Link Posted: 11/26/2011 3:51:37 PM EDT
[#3]
Here's a screenshot of the latest main data entry page:

Link 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!
Link Posted: 11/29/2011 8:39:26 AM EDT
[#5]
Bump for the midday crew.

Posted Via AR15.Com Mobile
Link 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.
Link 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:

Link Posted: 12/1/2011 8:39:34 PM EDT
[#8]
And a screen shot of the Maintenance window:

Link Posted: 12/2/2011 12:07:58 PM EDT
[#9]
Comments! Please!

Surely this isn't a flawless piece of work.
Link 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!
Link Posted: 12/3/2011 8:42:05 AM EDT
[#11]
Bump.
Link 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.
Link 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!
Link Posted: 12/4/2011 6:57:41 AM EDT
[#14]
Thanks for that. Should come in handy.
Link 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.
Link 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.
Link Posted: 12/5/2011 11:42:51 AM EDT
[#17]
bump

Posted Via AR15.Com Mobile
Link Posted: 12/6/2011 6:10:41 AM EDT
[#18]
Poll added.
Link Posted: 12/6/2011 11:00:52 AM EDT
[#19]
Seriously people.

This is going to remain free.
Link 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.
Link Posted: 12/7/2011 8:56:06 AM EDT
[#21]
bump
Link 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.
Link 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.
Link 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.
Link 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.

 
Link 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?
Link 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.
Link 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?
Link Posted: 12/9/2011 1:15:52 PM EDT
[#29]



Quoted:



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?
I've not used it personally, but it seems to be held in high regard.





 
Link Posted: 12/9/2011 6:19:47 PM EDT
[#30]
Seems SQLite doesn't do variables very well.
Link 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.

 
Link 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.
Link 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?
Link 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".
Link 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!
Link Posted: 12/14/2011 8:54:43 AM EDT
[#36]
Added the bound book templates, just for kicks.
Link Posted: 12/16/2011 4:13:45 AM EDT
[#37]
Is anyone using this?

Posted Via AR15.Com Mobile
Link 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.
Link Posted: 12/17/2011 4:30:58 PM EDT
[#39]
Not working for me.  IM inbound.

Link Posted: 12/17/2011 5:26:47 PM EDT
[#40]
Quoted:
Not working for me.  IM inbound.

http://img.photobucket.com/albums/v501/defender3va/DB.jpg

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

ALTER TABLE GUN_LOG ALTER COLUMN CR 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.
Link Posted: 12/17/2011 5:37:10 PM EDT
[#41]
Updated release with the bug fix is added to the OP.
Link Posted: 12/20/2011 6:07:05 PM EDT
[#42]
Bump for those who may not have caught the bug fix.
Link 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?
Link 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/
Link 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
Link 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.
Link Posted: 12/22/2011 9:57:15 AM EDT
[#47]
Worked! Thanks
Link Posted: 12/22/2011 2:48:20 PM EDT
[#48]
Quoted:
Worked! Thanks

Let me know how it's working for you!
Link Posted: 12/26/2011 2:44:28 PM EDT
[#49]
Bump for prime time.
Link Posted: 12/26/2011 5:34:28 PM EDT
[#50]
Bump.
Page / 3
Close Join Our Mail List to Stay Up To Date! 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.


By signing up you agree to our User Agreement. *Must have a registered ARFCOM account to win.
Top Top