Anyone want to help test a firearm inventory app I've developing? - Page 5
Firearm & Gun Forum - FireArmsTalk.com > General Discussion Forums > The Club House > Anyone want to help test a firearm inventory app I've developing?

Reply
 
LinkBack Thread Tools Display Modes
Old 07-10-2011, 11:41 AM   #41
FTF_SUPPORTER.png
Feedback Score: 0 reviews
 
Join Date: Feb 2011
Location: Hillsboro,MO
Posts: 100
Liked 1 Times on 1 Posts
Likes Given: 2

Default

Wolfrage, I figured out what was going on, apparently Office for MAC 2011 has its own proprietary CSV setting, you have to make sure you save it in Windows CSV compatible mode and then it imports it fine.

Only problem for me is it appends all the items to the current database. So I have around 50 items now instead of 25

Do you know where the main database file would be stored on a OSX system? Or is there a way to do a mass delete or records?

Also, when exporting to CSV, could the field labels be exported too?

Sorry for being a pain..LOL I am really digging the concept though

__________________

Stag1

Endowment Lifetime NRA Member, Certified CCW/Pistol instructor.

"To preserve liberty, it is essential that the whole body of the people always possess arms, and be taught alike, especially when young, how to use them". – Richard Henry Lee 1788

stag1 is offline  
 
Reply With Quote
Old 07-10-2011, 11:54 AM   #42
FTF_SUPPORTER.png
Feedback Score: 0 reviews
 
Join Date: Feb 2011
Location: Hillsboro,MO
Posts: 100
Liked 1 Times on 1 Posts
Likes Given: 2

Default

I also just sent you a small donation for you hard work!

__________________

Stag1

Endowment Lifetime NRA Member, Certified CCW/Pistol instructor.

"To preserve liberty, it is essential that the whole body of the people always possess arms, and be taught alike, especially when young, how to use them". – Richard Henry Lee 1788

stag1 is offline  
 
Reply With Quote
Old 07-11-2011, 04:07 AM   #43
Vendor
FTF_SPONSOR.png
Feedback Score: 0 reviews
 
Join Date: May 2011
Location: Derry,NH
Posts: 155
Liked 11 Times on 8 Posts
Likes Given: 10

Default

Quote:
Originally Posted by Yunus View Post
I have to deal with that issue every day at work. Our solution, use | delimited files instead of , because | is very rare in our data. However our current reporting tool only outputs to one format and we have a few legacy systems that require , separated. Every try to do a find and replace on 200,000+ rows of data with 30-40 , per row. It doesn't work well

Stag1, if you do remove commas also make sure you don't have double quotes at the start or end of a field, that can cause problems as well.
And newlines in the description field in the CSV messed things up too when exporting. Meh. I hate CSV
__________________
Wolfrage is offline  
 
Reply With Quote
Old 07-11-2011, 04:15 AM   #44
Vendor
FTF_SPONSOR.png
Feedback Score: 0 reviews
 
Join Date: May 2011
Location: Derry,NH
Posts: 155
Liked 11 Times on 8 Posts
Likes Given: 10

Default

Quote:
Originally Posted by stag1 View Post
Wolfrage, I figured out what was going on, apparently Office for MAC 2011 has its own proprietary CSV setting, you have to make sure you save it in Windows CSV compatible mode and then it imports it fine.
Quote:
Only problem for me is it appends all the items to the current database. So I have around 50 items now instead of 25
Ah yes, it's an import, not an overwrite. I should have it prompt for which you want. Hmm.

Quote:
Do you know where the main database file would be stored on a OSX system? Or is there a way to do a mass delete or records?
Er. /Users/user name/Library/Preferences/Com.CreativeMindsCoding.IFS/Local Store I believe. I'm not on a mac right at home.

Quote:
Also, when exporting to CSV, could the field labels be exported too?
Working on that.

Quote:
Sorry for being a pain..LOL I am really digging the concept though
Your feedback is great, keep it coming!
__________________
Wolfrage is offline  
 
Reply With Quote
Old 07-11-2011, 04:16 AM   #45
Vendor
FTF_SPONSOR.png
Feedback Score: 0 reviews
 
Join Date: May 2011
Location: Derry,NH
Posts: 155
Liked 11 Times on 8 Posts
Likes Given: 10

Default

1.0 is out! Woohoo!

* Delete button for accessories picture works
* Export to .CSV now handles fields with newline chars in it.
* CR box on search page displays No as default.

__________________
Wolfrage is offline  
 
Reply With Quote
Old 07-11-2011, 05:40 AM   #46
Feedback Score: 1 reviews
 
Join Date: Feb 2011
Location: Reno,Texas
Posts: 10,211
Liked 6576 Times on 3639 Posts
Likes Given: 27929

Default

Quote:
Originally Posted by lonyaeger View Post
Sounds great but, unfortunately, all of my firearms are now at the bottom of the Mediterranean after our tragic boating accident. My hard drive, too.
How did everyone's guns manage to end up at the bottom of the sea?
__________________
texaswoodworker is offline  
 
Reply With Quote
Old 07-11-2011, 12:20 PM   #47
Vendor
FTF_SPONSOR.png
Feedback Score: 0 reviews
 
Join Date: May 2011
Location: Derry,NH
Posts: 155
Liked 11 Times on 8 Posts
Likes Given: 10

Default

Quote:
Originally Posted by texaswoodworker View Post
How did everyone's guns manage to end up at the bottom of the sea?
Everyone was too busy denying having firearms that they weren't paying attention to their surroundings and they all ran into each other, sinking their boats
__________________
Wolfrage is offline  
 
Reply With Quote
Old 07-11-2011, 12:37 PM   #48
Feedback Score: 0 reviews
 
Yunus's Avatar
 
Join Date: Jan 2009
Location: |,Maryland
Posts: 4,910
Liked 1195 Times on 713 Posts
Likes Given: 381

Default

Is there a flag to identify an old collection that you used to have before the boating accident? For sentimental purposes

__________________

"Good people drink good beer."
Hunter S. Thompson

Yunus is offline  
 
Reply With Quote
Old 07-11-2011, 12:41 PM   #49
Vendor
FTF_SPONSOR.png
Feedback Score: 0 reviews
 
Join Date: May 2011
Location: Derry,NH
Posts: 155
Liked 11 Times on 8 Posts
Likes Given: 10

Default

Haha yeah, also known as "The anchor flag"

__________________
Wolfrage is offline  
 
Reply With Quote
Old 07-11-2011, 05:45 PM   #50
Feedback Score: 1 reviews
 
Join Date: Feb 2011
Location: Reno,Texas
Posts: 10,211
Liked 6576 Times on 3639 Posts
Likes Given: 27929

Default

Quote:
Originally Posted by Wolfrage View Post
Everyone was too busy denying having firearms that they weren't paying attention to their surroundings and they all ran into each other, sinking their boats
So where exactly did they sink...
__________________
texaswoodworker is offline  
 
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Firearms Forum Replies Last Post
Good Inventory jeepcreep927 General Rifle Discussion 4 05-17-2012 10:20 PM
Firearms Inventory danf_fl The Club House 10 04-23-2011 04:23 PM
Burglar shot dead... developing Overkill0084 The Club House 7 11-09-2010 11:50 PM
VLTOR developing an all new Bren Ten. Bighead Semi-Auto Handguns 1 03-10-2009 11:28 PM
Our inventory... illusion11 General Rifle Discussion 2 04-22-2007 04:24 PM