I'm involved with a project that involves a database of cooking ingredients. We have a great huge list of relevant nouns, so that's fine, but we're running into trouble with the differences in pluralizations of words. [more inside]
I'm in charge of a tuition reimbursement process in my company-- people give me their approved applications along with their grades and receipts and I calculate the reimbursement and send it along to accounting. Part of this process is keeping tabs on what's being spent on what. Right now, I'm using a massive Excel sheet to do this and it is messy
. [more inside]
Do we need another database in addition to the CMS to accomplish this? Can you help a non-developer understand. Can you help me explain it properly? [more inside]
I am making a transition from an Excel-based reporting analyst to a database-oriented role in which SQL will be the primary necessary skill. I have next to zero database experience. I'm looking for resources that would be effective at teaching me what I need to learn. More within… [more inside]
I have had experience with Salesforce and Microsoft CRM, I am now entering a position managing Oracle CRM what do I need to know? [more inside]
I want to get a Microsoft Database certification so I can become a database developer (I know some basic SQL using Postgres but I'd like to know more and get a certification). What's the best way to do this using a book instead of taking a class? [more inside]
I need a script for a MySQL table. The table has multiple fields but one ENDDATE will be populated as a Date/time value. When I am 90 days from that date, I need to update the field STATUS with the value of "email"
Work your magic hive!
I'm looking for general advice about how to bring a garage collection of many hundreds of valuable books to market. Part of this process will likely involve software choices. [more inside]
I maintain for my company a spreadsheet that contains a list of vendors and their associated information: address, contact(s), service area(s), service(s), website, and so on. It's becoming rather unwieldy as a vendor might have up to 5 different services, 2 addresses, 3 contacts each with their own email and phone number, etc. The information's all there, it's just very annoying to use.
I had the idea of creating an "intranet" type website that staff could use to filter vendors by name, service area, service type, and so on, with the results displaying in an easy-to-read format (easier than a mile-long Excel sheet, anyway). I am open to solutions like Wordpress and Joomla, just not sure how best to implement. Any ideas? [more inside]
My organization is currently using a very bloated Excel spreadsheet to track a bunch of data about our clients. I'd like to build us a really simple database with a nice form input to make it easier for staff to enter all of the information we need to track, but I'm not sure what my options are for software. [more inside]
We're going to have some folks filling out the same simple form on a regular basis. Is there an app-based solution where they can enter the data and upload it securely to a central repository at the end of the day?
A web solution may have been easier, but we're worried connectivity might be an issue during parts of the day. We want users to tap an app and be able to fill out a bunch of forms, then upload them all (securely) at the end of the day. A simple, elegant, fast interface would be a real plus. [more inside]
I am curious about the process of scaling a website from a small, shared hosting site all the way up to "one of the biggest 10 sites on the Internet" scale. I've heard terms like "dedicated hosting," "sharding the database" etc., but I'm sure there's a lot more that I haven't heard about. What changes on the backend through this process, and is there a typical order that those changes occur?
I run a forum where we discuss open source book scanning technology. Many users visit only occasionally. In a recent update, PHPBB enabled a feature called "Auto User Pruning", and it deleted users who had not logged in for 24 months. Two Thousand Users were deleted. It did not delete their posts, and their account names are still attached to their posts.
Please help me restore these users from my database backups or via some other method.
I'm looking for a simple way to textually describe data models, and can then produce something visual (an SVG, a PNG, etc.) An analogy would be how "Markdown" is a markup language that allows you to write something in plaintext, that can be converted to HTML. [more inside]
I want to take a comma delimited list of values e.g. "bacon, sausages, eggs" stored as a single text field and store these as selected values in a single multi-value lookup field. [more inside]
I'm trying to put together an automated SQL server monitoring and diagnostics solution, including SQL Trace data. I want to be able to group RPC:Completed event data by stored procedure. Unfortunately, the formatting and parameter values in each specific call make this kind of aggregation impossible.
For instance "Select * From qryLinksByNewsletterID Where NewsletterID=19" and "Select * From qryLinksByNewsletterID Where NewsletterID=234" would be considered different remote procedure calls.
does that for you. But, ClearTrace can't run as an automated SQL job. Some kind of script would be ideal, and someone by the name of Andrew Zanevsky made a post
describing one back in 2004, but the link to the actual script is dead. I could create my own with Regexes and such, but it seems like someone out there must have done it already. [more inside]
Hello Mefites! I'm looking for a reliable online service to pull population numbers by zip code, and while I know there are tons out there, I need one that isn't just plugging in one zip code at a time. Ideally, I'd like to be able to just download a database list of zip codes and their corresponding populations for the country, or state by state, to a CSV or XML file. Does this exist? The "reliable, up to date (as much as possible) source" part is important, as this data will be used as part of a franchise sale package. Thank you in advance!
I have a database that contains many thousands of time-stamped events each of which has a geographic location. What visualization projects could I use to explore this data? [more inside]
I'm looking for a cloud-based database solution with a web front end. The idea is that you could upload an Excel spreadsheet or CSV file (or Access export), and then customize a front end query that will bring back results. [more inside]
After a crazy Kickstarter adventure, I suddenly find myself with ~65 products to create, 2000 customers to send them to, and loads of information (names, email addresses, shipping details, order selections, order fulfillment status, funds donated) from 4 different sources (Kickstarter surveys, Surveymonkey.com, paypal.com, private emails). I need some way to keep track of all of it, so that I can easily find and export information (Who ordered product X? Who ordered product Y and hasn't yet had that order fulfilled), easily change entries (Customer B: Can I switch from product X to Y?) and easily add entries (New customer C). What's my best bet?
Web developers: My university research lab wants to drag our website
out of 1998 to a more easy-to-maintain and attractive design. We're tending towards using Wordpress, mostly for its large install base and plugin market. However our website won't follow the typical blog page/post format that Wordpress seems to support by default - it's more like a library with inter-related content types. Something like this
is beautiful but probably out of our budget. Those with Wordpress experience, what default features should we try to use? Or is there a plugin / theme that does what we want already? [more inside]
How do you keep track of your friend's babies/children? I'm looking for some kind of system to remind me of names, ages, and birthdates for the small humans that my large human friends have brought into the world. [more inside]
Hi, my company has an online photo database I normally login with Chrome to view. I can't see any of the image preview thumbnails today for some reason and it's making me crazy. I've tried some different things and I'm out of ideas. Maybe you can help? [more inside]
Is there such a thing as a Document-Oriented Database for Non-Programmers? I've been searching the web for several days and I'm quite confused so I thought to post here. [more inside]
Working on an old version of Filemaker Pro (7) in Windows, I created an alias (shortcut) of the main database, opened it and lost everything. Help? [more inside]
I've got a kid enjoying high school theater, and I'd like to help. My skills do NOT run to hammers or sewing machines, but I can work Chrome / Google Docs / databases like a pro.
The costume designer is wishing for a way to track student measurements, costume notes, and pictures / photos in some sort of online / app format for going to fabric stores and keeping track of sewing progress. She's coveting an iPad mini to use with it, so I guess an app would be fine. I'd prefer a Chrome / Google Doc option, because I'm cheap.
LOVE to hear from costume designers / wardrobe coordinators who've figured this out. Extra credit points for people who know how to create a costume database for completed costumes after the shows.
What can I do to become a database administrator or developer if I'm starting basically from zero? [more inside]
After an unexpected departmental shuffling last week, I was laid off from my database admin job of four years. My DB knowledge is largely self-taught, and pertains mostly to a number of niche applications that have little direct use to your average employer. I need to learn how to translate my skills into those that are actually in demand in today's job market and I need to do it quickly. Details below the fold. [more inside]
Is there a database of insect scientific names and their taxonomy available somewhere for free? For example Streptocerus speciosus - Family: Lucanidae - Order: Coleoptera. I'm hoping to avoid downloading wikipedia and crawling through it.
Is FileMaker Pro right for this? If so, please help me understand the costs/benefits of setting FMP up for certain project-specific functions. [more inside]
I'm working on a book to Microsoft Word. Every time that I go to do a figure (which gets added in the actual page layout process), I have to repeat the figure call out three times.
Once in the text, once in production directives, and once in the caption. Some chapters have as many as 60 figures. Meaning if I want to rearrange things, that life becomes very painful, and fraught with mistakes.
It seems like word has the ability to put in to track of this, but not triplicate. Hopefully, someone reading this will have expertise to tell me how this is done. I'm using word 2011 on Mac.
We have four departments and each has their own way of managing their student lists, I'd like to find one solution to rule them all. [more inside]
What's a good way to keep track of information about images of paintings I've downloaded (artist, title, year, museum, and so on)? [more inside]
I'm looking for a good online database app thingy that would let 50 teachers and 200 students easily and quickly input sentences in two languages *as well as pictures* and be easily searchable by all participants in the future. Any ideas? [more inside]
I'm looking for a publication ready recipe/photos to buy and share on a site for a food brand I'm working with. Unfortunately time rules out working with our own team and recipes. I've found snapandstir.com
which is perfect but pricey - is there anything else out there? A large archive would be ideal!
This is a simple thing to ask, but how do I capture input data through a form on mobile phones / tablets / laptop in a database? More details in... [more inside]
I remember coming across a game that represented rows in a database as stars in a galaxy, and gave the player visual feedback for the queries they entered. What was that called?
Looking for media to help planning web based development. [more inside]
I work for a small nonprofit. Part of what we do is collect and share first-person, nonfictional stories. I've been asked to find a better way to organize and keep these stories. [more inside]
We are storing information about application hits in a database. Sadly my database/excel skills are pretty limited and I'd like some help getting more info out of the information we have. [more inside]
I'm a fan of certain authors, critics, and academics whose taste and sensibilities are similar to my own. I'm currently looking for a way to search for books based on the blurbs or editiorial reviews about them from authors that I admire and trust.
Example: 1. Philip Roth's recent assessment of Jonathan Franken's writing was prominently blazed on the latter's most recent book.
2. Warren Buffett has referred to Dale Carnegie's book "How to Win Friends and Influence People" as one of the few books that changed his life.
3. Charlie Munger, Buffett's partner in arms, referred to John Cialdini's book on influence as one having a permanent influence on his thinking on that topic.
4. Harold Bloom, the critic, has impressive recommendations on Henri Cole's newest volume of verse.
Is there a database that I can use to help me scour who's been recommending what and how.
My friend is looking for a resource that will identify by states buyer contact information for large retail companies.
She is a "key account representative" for a national company with a presence in half of the states in the US, and wants to find information regarding buyers for large national retailers.
Years ago there was publication called "Contact Influential" that supplied this sort of info. I'm marginally familiar with Hoover's, and believe it is along these lines. Does the hive have any other suggestions?
So I've been using Evernote for a while now to organize research, projects I'm working on, collecting articles, recipes, etc. I've used Backpack in the past to organize projects and plan trips. I'm curious about possibly upcoming/newer solutions that are in this similar vein that might be more robust, have better search capabilities, etc for collecting and organizing all the information in your digital life.
What do you guys use? What comes after Evernote? What is the precursor to "Computer.. pull up all recipes that involve chicken, cheese, and cilantro." or "Computer.. all articles on Ruby on Rails relating to PostgreSQL databases." or even... "Computer.. all guitar tabs I've collected by Modest Mouse" (Who knows, maybe I just have to wait for Evernote to advance) [more inside]
Are there ways to "cross" or "join" data results in Google Analytics? Just as a for instance, I have a list of Referrals and a list of audience Location demographics. Is there a way to join those two lists, so that I know where site referrals are visiting from? (Generally, are there resources which list "pro tips" for getting the most out of Analytics?)
is there a database of riddles searchable by answer, such as "post office" or "police officer" or "a zoo"?
Tomorrow morning I'm meeting with someone to talk about implementing a local scheduling/database application. Most everything I know about the project suggests it's something I could do in my sleep. Thing is, I desperately need the money, I don't know how much to "bid," and I have a long history of undervaluing my work. How much should I ask for? [more inside]
I'm putting together an Access database (woe is me), which includes some "multiple choice" fields, that contain a defined list of options. I've got some code that puts together a query, and generates a report. The way these fields are displayed in this report is inconsistent, and I'm trying to figure out why. [more inside]
I'm designing and managing a very ambitious data visualization app for the arts and culture sector, and am trying to find the best way to organize the data types and attributes. Excel just ain't doin' it anymore. [more inside]
I'm developing a proposal to overhaul the way my company thinks about communication. One of the major components that would allow this to work is the creation of what is essentially a "wire service". What software already exists to do this? (lots of details inside) [more inside]
If I were to set up my own online book store, is there a provider that I can subscribe that will provide me with images of sample pages of books? [more inside]