 |
|
07-10-2011, 10:41 AM
|
#41
|
|
Feedback Score: 0 reviews
Join Date: Feb 2011
Location: Hillsboro,MO
Posts: 100
Likes Given: 2
|
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
|
|
|
|
07-10-2011, 10:54 AM
|
#42
|
|
Feedback Score: 0 reviews
Join Date: Feb 2011
Location: Hillsboro,MO
Posts: 100
Likes Given: 2
|
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
|
|
|
|
|
07-11-2011, 03:07 AM
|
#43
|
|
Vendor
Feedback Score: 0 reviews
Join Date: May 2011
Location: Derry,NH
Posts: 138
Liked 6 Times on 4 Posts
Likes Given: 8
|
Quote:
Originally Posted by Yunus
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 
|
|
|
|
|
07-11-2011, 03:15 AM
|
#44
|
|
Vendor
Feedback Score: 0 reviews
Join Date: May 2011
Location: Derry,NH
Posts: 138
Liked 6 Times on 4 Posts
Likes Given: 8
|
Quote:
Originally Posted by stag1
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!
|
|
|
|
|
07-11-2011, 03:16 AM
|
#45
|
|
Vendor
Feedback Score: 0 reviews
Join Date: May 2011
Location: Derry,NH
Posts: 138
Liked 6 Times on 4 Posts
Likes Given: 8
|
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.
|
|
|
|
|
07-11-2011, 04:40 AM
|
#46
|
|
Feedback Score: 0 reviews
Join Date: Feb 2011
Location: Reno,Texas
Posts: 6,327
Liked 2269 Times on 1342 Posts
Likes Given: 9828
|
Quote:
Originally Posted by lonyaeger
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? 
__________________
Aaron
"The greatest danger to American freedom is a government that ignores the Constitution."
Thomas Jefferson
|
|
|
|
07-11-2011, 11:20 AM
|
#47
|
|
Vendor
Feedback Score: 0 reviews
Join Date: May 2011
Location: Derry,NH
Posts: 138
Liked 6 Times on 4 Posts
Likes Given: 8
|
Quote:
Originally Posted by texaswoodworker
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
|
|
|
|
|
07-11-2011, 11:37 AM
|
#48
|
|
Feedback Score: 0 reviews
Join Date: Jan 2009
Location: |,Maryland
Posts: 3,895
Liked 437 Times on 269 Posts
Likes Given: 145
|
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
|
|
|
|
|
07-11-2011, 11:41 AM
|
#49
|
|
Vendor
Feedback Score: 0 reviews
Join Date: May 2011
Location: Derry,NH
Posts: 138
Liked 6 Times on 4 Posts
Likes Given: 8
|
Haha yeah, also known as "The anchor flag"
|
|
|
|
|
07-11-2011, 04:45 PM
|
#50
|
|
Feedback Score: 0 reviews
Join Date: Feb 2011
Location: Reno,Texas
Posts: 6,327
Liked 2269 Times on 1342 Posts
Likes Given: 9828
|
Quote:
Originally Posted by Wolfrage
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...
__________________
Aaron
"The greatest danger to American freedom is a government that ignores the Constitution."
Thomas Jefferson
|
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
|
|
|
