Go Back  Bike Forums > The Lounge > Foo
Reload this Page >

Database creation software gurus

Foo Off-Topic chit chat with no general subject.

Database creation software gurus

Old 11-08-11, 12:26 PM
  #1  
jsharr
You Know!? For Kids!
Thread Starter
 
jsharr's Avatar
 
Join Date: Apr 2005
Location: Just NW of Richardson Bike Mart
Posts: 6,163

Bikes: '05 Trek 1200 / '90 Trek 8000 / '? Falcon Europa

Mentioned: 8 Post(s)
Tagged: 0 Thread(s)
Quoted: 24 Post(s)
Liked 0 Times in 0 Posts
Database creation software gurus

We receive lists of names and addresses in various forms. Excel, word, pdf, etc.

Want a system to scan the documents and enter information into a database to create a mailing list.

Is there something like this on the market?
__________________
Are you a registered member? Why not? Click here to register. It's free and only takes 27 seconds! Help out the forums, abide by our community guidelines.
Originally Posted by colorider View Post
Phobias are for irrational fears. Fear of junk ripping badgers is perfectly rational. Those things are nasty.
jsharr is offline  
Old 11-08-11, 12:29 PM
  #2  
mikeybikes
Senior Member
 
mikeybikes's Avatar
 
Join Date: May 2009
Location: Edgewater, CO
Posts: 3,214

Bikes: Tons

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Did you check with Ruben's Lanlord?
mikeybikes is offline  
Old 11-08-11, 01:08 PM
  #3  
bigbenaugust 
always rides with luggage
 
bigbenaugust's Avatar
 
Join Date: Feb 2005
Location: KIGX
Posts: 2,106

Bikes: 2007 Trek SU100, 2009 Fantom CX, 2012 Fantom Cross Uno, Bakfiets

Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 245 Post(s)
Liked 1 Time in 1 Post
If you only wanted to keep it single-user on your desktop or one-person-at-a-time on a network share, it would be pretty straightforward to roll your own in Access or (heaven help us) FileMaker. If you want it viewable over the intranet, that's a little more complicated.

Basically, we're talking about a database system that would contain both the documents and some additional information, right?
__________________
--Ben
2006 Trek SU100, 2009 Motobecane Fantom CX, 2011 Motobecane Fantom Cross Uno, and a Bakfiets
Previously: 2000 Trek 4500 (2000-2003), 2003 Novara Randonee (2003-2006), 2003 Giant Rainier (2003-2008), 2005 Xootr Swift (2005-2007), 2007 Nashbar 1x9 (2007-2011), 2011 Windsor Shetland (2011-2014), 2008 Citizen Folder (2015)
Non-Bike hardware: MX Linux / BunsenLabs Linux / Raspbian / Mac OS 10.6 / Android 7
bigbenaugust is offline  
Old 11-08-11, 01:13 PM
  #4  
jsharr
You Know!? For Kids!
Thread Starter
 
jsharr's Avatar
 
Join Date: Apr 2005
Location: Just NW of Richardson Bike Mart
Posts: 6,163

Bikes: '05 Trek 1200 / '90 Trek 8000 / '? Falcon Europa

Mentioned: 8 Post(s)
Tagged: 0 Thread(s)
Quoted: 24 Post(s)
Liked 0 Times in 0 Posts
I want to extract the names and addresses use them to create a mailing list. If I could create a file that could be sent to a mailing house, that would be awesome. Wanting to do bulk mailings based on a list of names we receive from a customer.
__________________
Are you a registered member? Why not? Click here to register. It's free and only takes 27 seconds! Help out the forums, abide by our community guidelines.
Originally Posted by colorider View Post
Phobias are for irrational fears. Fear of junk ripping badgers is perfectly rational. Those things are nasty.
jsharr is offline  
Old 11-08-11, 01:46 PM
  #5  
chi-james 
Senior Member
 
chi-james's Avatar
 
Join Date: Sep 2009
Posts: 359

Bikes: team miyata, '73 p-14, MB-3, centurion lemans, Mystery TT, mongoose atb '85

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
not really a hard nut to crack, but there's no off the shelf solution that I know of. Hire a contractor or learn a scripting language like perl or python.
chi-james is offline  
Old 11-08-11, 01:50 PM
  #6  
ModoVincere
Riding Heaven's Highways on the grand tour
 
ModoVincere's Avatar
 
Join Date: Aug 2006
Posts: 1,675
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by chi-james View Post
not really a hard nut to crack, but there's no off the shelf solution that I know of. Hire a contractor or learn a scripting language like perl or python.
Access....vba.
Learn to open files and scan them...then determine the import routine.
__________________
1 bronze, 0 silver, 1 gold
ModoVincere is offline  
Old 11-08-11, 01:55 PM
  #7  
bigbenaugust 
always rides with luggage
 
bigbenaugust's Avatar
 
Join Date: Feb 2005
Location: KIGX
Posts: 2,106

Bikes: 2007 Trek SU100, 2009 Fantom CX, 2012 Fantom Cross Uno, Bakfiets

Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 245 Post(s)
Liked 1 Time in 1 Post
Yeah, some OCR software and Access would do the trick if you want to keep it Windows.
Otherwise, perl and python would probably do it, along with the appropriate scanner setup.
__________________
--Ben
2006 Trek SU100, 2009 Motobecane Fantom CX, 2011 Motobecane Fantom Cross Uno, and a Bakfiets
Previously: 2000 Trek 4500 (2000-2003), 2003 Novara Randonee (2003-2006), 2003 Giant Rainier (2003-2008), 2005 Xootr Swift (2005-2007), 2007 Nashbar 1x9 (2007-2011), 2011 Windsor Shetland (2011-2014), 2008 Citizen Folder (2015)
Non-Bike hardware: MX Linux / BunsenLabs Linux / Raspbian / Mac OS 10.6 / Android 7
bigbenaugust is offline  
Old 11-08-11, 02:20 PM
  #8  
pgoat
BatŁwŁ Griekgriek
 
pgoat's Avatar
 
Join Date: May 2005
Location: NYC - for the moment...
Posts: 2,908

Bikes: 1985 Trek 500, 1986 Trek 500 Tri Series, 2005 Cannondale R1000

Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Quoted: 22 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
another vote for Access, esp. if you already have it. If not you might look into other options to save $
__________________
Originally Posted by jsharr View Post
People whose sig line does not include a jsharr quote annoy me.
pgoat is offline  
Old 11-08-11, 02:36 PM
  #9  
bigbenaugust 
always rides with luggage
 
bigbenaugust's Avatar
 
Join Date: Feb 2005
Location: KIGX
Posts: 2,106

Bikes: 2007 Trek SU100, 2009 Fantom CX, 2012 Fantom Cross Uno, Bakfiets

Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 245 Post(s)
Liked 1 Time in 1 Post
Originally Posted by x136 View Post
Unfortunately, Filemaker would still probably work over the network.

[dry heaves at the thought]
It totally would, and we're still doing it EVERY DAY here... so I dry heave at it EVERY DAY! The important stuff went to a real web app platform years ago, but there are still a few FileMaker 5/6/8 hangers on.
__________________
--Ben
2006 Trek SU100, 2009 Motobecane Fantom CX, 2011 Motobecane Fantom Cross Uno, and a Bakfiets
Previously: 2000 Trek 4500 (2000-2003), 2003 Novara Randonee (2003-2006), 2003 Giant Rainier (2003-2008), 2005 Xootr Swift (2005-2007), 2007 Nashbar 1x9 (2007-2011), 2011 Windsor Shetland (2011-2014), 2008 Citizen Folder (2015)
Non-Bike hardware: MX Linux / BunsenLabs Linux / Raspbian / Mac OS 10.6 / Android 7
bigbenaugust is offline  
Old 11-08-11, 02:48 PM
  #10  
bigbenaugust 
always rides with luggage
 
bigbenaugust's Avatar
 
Join Date: Feb 2005
Location: KIGX
Posts: 2,106

Bikes: 2007 Trek SU100, 2009 Fantom CX, 2012 Fantom Cross Uno, Bakfiets

Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 245 Post(s)
Liked 1 Time in 1 Post
I am planning a 10th anniversary party for FileMaker Server 5 in 2012. It could also turn out to be a wake for the platform, as we might actually have dumped it by then.
__________________
--Ben
2006 Trek SU100, 2009 Motobecane Fantom CX, 2011 Motobecane Fantom Cross Uno, and a Bakfiets
Previously: 2000 Trek 4500 (2000-2003), 2003 Novara Randonee (2003-2006), 2003 Giant Rainier (2003-2008), 2005 Xootr Swift (2005-2007), 2007 Nashbar 1x9 (2007-2011), 2011 Windsor Shetland (2011-2014), 2008 Citizen Folder (2015)
Non-Bike hardware: MX Linux / BunsenLabs Linux / Raspbian / Mac OS 10.6 / Android 7
bigbenaugust is offline  
Old 11-08-11, 03:02 PM
  #11  
ModoVincere
Riding Heaven's Highways on the grand tour
 
ModoVincere's Avatar
 
Join Date: Aug 2006
Posts: 1,675
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by x136 View Post
When I got laid off a few jobs ago, one of the thoughts I used to make myself feel better was "NO MORE FILEMAKER! YESSS!" That cheered me right up.
Hell...that should be enough to keep you happy till the day you die.
__________________
1 bronze, 0 silver, 1 gold
ModoVincere is offline  
Old 11-08-11, 03:03 PM
  #12  
StupidlyBrave 
Chepooka
 
StupidlyBrave's Avatar
 
Join Date: Sep 2006
Location: South Central PA
Posts: 1,167

Bikes: 1990 Trek 1400 7spd; 2001 Litespeed Arenberg 10 speed

Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 188 Post(s)
Liked 3 Times in 3 Posts
No love for the PostgresSQL, eh? It's a refreshing change of pace to the corporate-mandated behemoth that is named Oracle.

I would use Derby before Access...Heck, I'd use flat files/perl/awk/cut/sort/uniq/grep et cetera before access.
StupidlyBrave is offline  
Old 11-08-11, 03:38 PM
  #13  
bigbenaugust 
always rides with luggage
 
bigbenaugust's Avatar
 
Join Date: Feb 2005
Location: KIGX
Posts: 2,106

Bikes: 2007 Trek SU100, 2009 Fantom CX, 2012 Fantom Cross Uno, Bakfiets

Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 245 Post(s)
Liked 1 Time in 1 Post
Well, my preference would be MySQL (or MariaDB) over Oracle. I just don't have enough exposure to PgSQL... yet. After that, Access. Somewhere beneath the bottom, FileMaker.

SQLite might be an option, too.
__________________
--Ben
2006 Trek SU100, 2009 Motobecane Fantom CX, 2011 Motobecane Fantom Cross Uno, and a Bakfiets
Previously: 2000 Trek 4500 (2000-2003), 2003 Novara Randonee (2003-2006), 2003 Giant Rainier (2003-2008), 2005 Xootr Swift (2005-2007), 2007 Nashbar 1x9 (2007-2011), 2011 Windsor Shetland (2011-2014), 2008 Citizen Folder (2015)
Non-Bike hardware: MX Linux / BunsenLabs Linux / Raspbian / Mac OS 10.6 / Android 7
bigbenaugust is offline  
Old 11-08-11, 05:05 PM
  #14  
crackerjab
WTF is that smell?
 
Join Date: Dec 2005
Location: Charlotte, NC
Posts: 449
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
I would say Access because if you're in an office environment, you're probably using MS Office and it's included in the suite.
crackerjab is offline  
Old 11-08-11, 06:02 PM
  #15  
SPlKE 
Senior Member
 
Join Date: Sep 2007
Posts: 830
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 3 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
SQL Server 2008 R2 Express.

Free & powerful as hell.
SPlKE is offline  
Old 11-08-11, 10:19 PM
  #16  
RubenX 
Look! My Spine!
 
RubenX's Avatar
 
Join Date: Apr 2008
Location: Kissimmee, FL
Posts: 620
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Dear mail spammer,

I'm sure there's something free out there. They key word to search is "OCR" (omnifont character recognition or something). The easiest database to work with would be access IMHO. But I often find excel powerful enough. Also, you might want to verify what's free for your smartphone (assuming you have one of those pesky things).
__________________
"Hoy es un dia normal, pero yo voy a hacerlo intenso" ~ Juanes
RubenX is offline  
Old 11-08-11, 10:27 PM
  #17  
contango 
2 Fat 2 Furious
 
contango's Avatar
 
Join Date: Nov 2010
Location: England
Posts: 3,996

Bikes: 2009 Specialized Rockhopper Comp Disc, 2009 Specialized Tricross Sport RIP

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 3 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by jsharr View Post
We receive lists of names and addresses in various forms. Excel, word, pdf, etc.

Want a system to scan the documents and enter information into a database to create a mailing list.

Is there something like this on the market?
Excel, Word etc can probably be processed with some software to read the relevant fields, especially if whoever created the files did so in a way that lends itself to automatic reading.

PDFs would most likely need to be scanned in an optical sense and then fed through software to turn it into text. Then you'd need to proofread them because OCR can be a bit hit and miss. From there you can process the text much like you would a spreadsheet, text file etc.
contango is offline  
Old 11-08-11, 10:30 PM
  #18  
jsharr
You Know!? For Kids!
Thread Starter
 
jsharr's Avatar
 
Join Date: Apr 2005
Location: Just NW of Richardson Bike Mart
Posts: 6,163

Bikes: '05 Trek 1200 / '90 Trek 8000 / '? Falcon Europa

Mentioned: 8 Post(s)
Tagged: 0 Thread(s)
Quoted: 24 Post(s)
Liked 0 Times in 0 Posts
Originally Posted by RubenX View Post
Dear mail spammer,

I'm sure there's something free out there. They key word to search is "OCR" (omnifont character recognition or something). The easiest database to work with would be access IMHO. But I often find excel powerful enough. Also, you might want to verify what's free for your smartphone (assuming you have one of those pesky things).
Not mail spamming. These are mailings to shareholders of companies we work for. Looking to reduce our overhead.
__________________
Are you a registered member? Why not? Click here to register. It's free and only takes 27 seconds! Help out the forums, abide by our community guidelines.
Originally Posted by colorider View Post
Phobias are for irrational fears. Fear of junk ripping badgers is perfectly rational. Those things are nasty.
jsharr is offline  
Old 11-09-11, 12:42 AM
  #19  
Seamless
Peddler
 
Seamless's Avatar
 
Join Date: Nov 2004
Posts: 337

Bikes: Cannondale Road Warrior 800 & H400

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by jsharr View Post
Not mail spamming. These are mailings to shareholders of companies we work for. Looking to reduce our overhead.
One of my database clients receives similar information for their custom system, from customers who allow entry via web and other means (including fax), in any possible format. It's insanely wasteful and inefficient, but the consciously-uninformed VP for the client doesn't want to impose order, so their staff swallow the cost of fixing data (yet complains how inefficient the customer ordering database is, and mutter when an address change is requested). One step involves running some digital files through a FMP utility, but the person who set it up died last year and never documented. I built some intelligence into the data import steps. Eventually UPS flags remaining address errors at shipping, but there's no effort to go back and edit the database records.

However, in your case, it seems rather likely shareholder addresses are already in digital form, in standardized field format (e.g., USPS or UPS-style) and maintained by third party mailing services; your customers have already paid a mailing service to massage the data and shouldn't have to pay again. If not, it may be cheaper to submit the a raw list to a shipper like UPS and pay for their address verification service (no charge if it's done one at a time during generation of a shipping label).

Alternatively you might save a great deal of time and resources by obtaining the files via the shareholder relations department or its communications fulfillment service.
Seamless is offline  
Old 11-09-11, 04:22 AM
  #20  
RubenX 
Look! My Spine!
 
RubenX's Avatar
 
Join Date: Apr 2008
Location: Kissimmee, FL
Posts: 620
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
^ oh yeah.. can't forget the data validation steps.
__________________
"Hoy es un dia normal, pero yo voy a hacerlo intenso" ~ Juanes
RubenX is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Thread Tools
Search this Thread

Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service

Copyright © 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.