Advertise on Bikeforums.net



User Tag List

Results 1 to 20 of 20
  1. #1
    You Know!? For Kids! jsharr's Avatar
    Join Date
    Apr 2005
    Location
    Just NW of Richardson Bike Mart
    My Bikes
    '05 Trek 1200 / '90 Trek 8000 / '? Falcon Europa
    Posts
    6,064
    Mentioned
    11 Post(s)
    Tagged
    3 Thread(s)

    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.
    Quote Originally Posted by colorider View Post
    Phobias are for irrational fears. Fear of junk ripping badgers is perfectly rational. Those things are nasty.

  2. #2
    Senior Member mikeybikes's Avatar
    Join Date
    May 2009
    Location
    Edgewater, CO
    My Bikes
    Tons
    Posts
    2,873
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Did you check with Ruben's Lanlord?
    My Bikes: 2009 Breezer Uptown EX | 1980 Miyata Six Ten | 1970 Hercules Three-Two-Speed
    Wife's Bikes: 2008 Globe City 7 | 1972ish Peugeot UO-18 (in progress)

  3. #3
    derailleurs are overrated bigbenaugust's Avatar
    Join Date
    Feb 2005
    Location
    KIGX
    My Bikes
    2009 Motobecane Fantom CX, 2011 Windsor Shetland mini-velo, 2012 Motobecane Fantom Cross Uno SSCX
    Posts
    1,691
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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
    Carrboro Bike Coalition - putting the "bike" in "CARrboro" :)
    2011 Motobecane Fantom Cross Uno, 2009 Motobecane Fantom CX, 2011 Windsor Shetland
    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)
    Current Linux Usage (by machine): Arch: I Debian: II openSUSE: I

  4. #4
    You Know!? For Kids! jsharr's Avatar
    Join Date
    Apr 2005
    Location
    Just NW of Richardson Bike Mart
    My Bikes
    '05 Trek 1200 / '90 Trek 8000 / '? Falcon Europa
    Posts
    6,064
    Mentioned
    11 Post(s)
    Tagged
    3 Thread(s)
    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.
    Quote Originally Posted by colorider View Post
    Phobias are for irrational fears. Fear of junk ripping badgers is perfectly rational. Those things are nasty.

  5. #5
    Senior Member chi-james's Avatar
    Join Date
    Sep 2009
    My Bikes
    team miyata, '73 p-14, MB-3, centurion lemans, Mystery TT, mongoose atb '85
    Posts
    336
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  6. #6
    Banned. ModoVincere's Avatar
    Join Date
    Aug 2006
    Posts
    1,626
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote 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.

  7. #7
    derailleurs are overrated bigbenaugust's Avatar
    Join Date
    Feb 2005
    Location
    KIGX
    My Bikes
    2009 Motobecane Fantom CX, 2011 Windsor Shetland mini-velo, 2012 Motobecane Fantom Cross Uno SSCX
    Posts
    1,691
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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
    Carrboro Bike Coalition - putting the "bike" in "CARrboro" :)
    2011 Motobecane Fantom Cross Uno, 2009 Motobecane Fantom CX, 2011 Windsor Shetland
    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)
    Current Linux Usage (by machine): Arch: I Debian: II openSUSE: I

  8. #8
    Ogr8nwmypstmksnosnse pgoat's Avatar
    Join Date
    May 2005
    My Bikes
    1986 Trek 500, 2003 Orbea Team Euskaltel, 2005 Cannondale R1000
    Posts
    2,787
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    another vote for Access, esp. if you already have it. If not you might look into other options to save $
    Quote Originally Posted by jsharr View Post
    People whose sig line does not include a jsharr quote annoy me.

  9. #9
    derailleurs are overrated bigbenaugust's Avatar
    Join Date
    Feb 2005
    Location
    KIGX
    My Bikes
    2009 Motobecane Fantom CX, 2011 Windsor Shetland mini-velo, 2012 Motobecane Fantom Cross Uno SSCX
    Posts
    1,691
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote 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
    Carrboro Bike Coalition - putting the "bike" in "CARrboro" :)
    2011 Motobecane Fantom Cross Uno, 2009 Motobecane Fantom CX, 2011 Windsor Shetland
    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)
    Current Linux Usage (by machine): Arch: I Debian: II openSUSE: I

  10. #10
    derailleurs are overrated bigbenaugust's Avatar
    Join Date
    Feb 2005
    Location
    KIGX
    My Bikes
    2009 Motobecane Fantom CX, 2011 Windsor Shetland mini-velo, 2012 Motobecane Fantom Cross Uno SSCX
    Posts
    1,691
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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
    Carrboro Bike Coalition - putting the "bike" in "CARrboro" :)
    2011 Motobecane Fantom Cross Uno, 2009 Motobecane Fantom CX, 2011 Windsor Shetland
    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)
    Current Linux Usage (by machine): Arch: I Debian: II openSUSE: I

  11. #11
    Banned. ModoVincere's Avatar
    Join Date
    Aug 2006
    Posts
    1,626
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote 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.

  12. #12
    Chepooka StupidlyBrave's Avatar
    Join Date
    Sep 2006
    Location
    South Central PA
    My Bikes
    1990 Trek 1400 7spd; 2001 Litespeed Arenberg 10 speed
    Posts
    1,155
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  13. #13
    derailleurs are overrated bigbenaugust's Avatar
    Join Date
    Feb 2005
    Location
    KIGX
    My Bikes
    2009 Motobecane Fantom CX, 2011 Windsor Shetland mini-velo, 2012 Motobecane Fantom Cross Uno SSCX
    Posts
    1,691
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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
    Carrboro Bike Coalition - putting the "bike" in "CARrboro" :)
    2011 Motobecane Fantom Cross Uno, 2009 Motobecane Fantom CX, 2011 Windsor Shetland
    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)
    Current Linux Usage (by machine): Arch: I Debian: II openSUSE: I

  14. #14
    WTF is that smell? crackerjab's Avatar
    Join Date
    Dec 2005
    Location
    Charlotte, NC
    Posts
    449
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.
    Your turtle skirt is exposing your FUPA.

  15. #15
    Senior Member
    Join Date
    Sep 2007
    Posts
    835
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    SQL Server 2008 R2 Express.

    Free & powerful as hell.

  16. #16
    Look! My Spine! RubenX's Avatar
    Join Date
    Apr 2008
    Location
    Winter Springs, FL
    Posts
    539
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    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

  17. #17
    2 Fat 2 Furious contango's Avatar
    Join Date
    Nov 2010
    Location
    England
    My Bikes
    2009 Specialized Rockhopper Comp Disc, 2009 Specialized Tricross Sport
    Posts
    3,966
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote 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.

  18. #18
    You Know!? For Kids! jsharr's Avatar
    Join Date
    Apr 2005
    Location
    Just NW of Richardson Bike Mart
    My Bikes
    '05 Trek 1200 / '90 Trek 8000 / '? Falcon Europa
    Posts
    6,064
    Mentioned
    11 Post(s)
    Tagged
    3 Thread(s)
    Quote 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.
    Quote Originally Posted by colorider View Post
    Phobias are for irrational fears. Fear of junk ripping badgers is perfectly rational. Those things are nasty.

  19. #19
    Peddler Seamless's Avatar
    Join Date
    Nov 2004
    My Bikes
    Cannondale Road Warrior 800 & H400
    Posts
    337
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote 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.
    `,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,
    2005 Cannondale Road Warrior 800

  20. #20
    Look! My Spine! RubenX's Avatar
    Join Date
    Apr 2008
    Location
    Winter Springs, FL
    Posts
    539
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    ^ oh yeah.. can't forget the data validation steps.
    "Hoy es un dia normal, pero yo voy a hacerlo intenso" ~ Juanes

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •