[aklug] Re: Speaking of GitHub and Google and Larry

On Mon, Aug 19, 2013 at 11:38:01AM -0800, Tim Johnson wrote:
> >
> > It seems the answer to "how they're worked out" depend upon what service is
> > being used, and what you would use locally as a substitute. Here's my example:
> >
> > We have a school of gymnastics. For class management, family/student data, and
> > billing we are using www.thestudiodirector.com today. We have tried two other
> > services before this one, each failing to meet a need or more expensive than
> > we desired.
> >
> > Before signing up with this latest one I read their privacy policy:
> > https://www.thestudiodirector.com/privacypolicy.htm and there were points
> > which bothered me about it. However, we need this service working now. Not
> > having anything to handle this for July and August (when we started a new
> > schedule of classes and got a good number of new students) means (a) we have
> > students written into class rosters by hand on paper, and (b) we don't know
> > who owes us how much money, who is behind, etc. Therefore, we don't even know
> > our expected monthly income.
> >
> > What we need, afaict, is a relational database management system (RDBMS).
> > There is MySQL, and as I'm learning more, that seems to be what we should use
> > long-term. But today, I need something in place, and how long would it take me
> > to learn how to configure MySQL, input all our data, and have it working on a
> > daily basis?
> >
> > There is a server on the LAN for my computer shop that could run MySQL, if
> > that is indeed what we need to do that job. In the meantime, we need a working
> > solution, so I'm inputting data into Studio Director online...very
> > reluctantly.
>
> Do you know the nature of thestudiodirector's database system?
>
> If Studio Director enables exporting data as an .sql, csv or
> a tab-delimited file, than you will have the option of migrating
> into a dbms of your choice once you get the hang of MySQL.
>
> see http://dazzlepod.com/ip/72.3.236.91/
> search on 'mysql'
> --
> Tim

Thanks, Tim! I'm not aware of or familiar with dazzlepod, but do see they use
MySQL. Last week I got a 404 on the privacy info because the link was
incorrect, and it told me they use a RedHat server.

Well, so far all they've done is import a spreadsheet file that was the exit
file for Jackrabbit Class in March of this year. It was titled
Export_Happy_Penguin_Gym.xls. After Jackrabbit we used iClassPro for about 2
months. Studio Director said, "I'm not able to read tupelo-export.txt (the
iClassPro exit file), it's not a text file." My Linux box says this about it:

tupelo-export.txt: Little-endian UTF-16 Unicode text, with CRLF, CR line
terminators

I've not installed, or looked at, MySQL. Wish it were as simple as build,
install, launch, input data. I'd just do it myself. For now, I'm inputting
data into The Studio Director's software. Just the little bit my friend in
London told me about RDBMS clues me in to some things I'm seeing entering data
into The Studio Director, and his answer to my questions, such as:

Q. How do I enter a second guardian (parent)?
A. You can either put both names in the guardian field (e.g. Mark and Jane),
or you can enter the second parent's name in the notes field.

From my friend's intro over IRC, it appears that The Studio Director does not
have a student_id field in their Guardians Table.

I'm only minutes into inputting data, and already have problems with the way
The Studio Director has setup their db. That's very disappointing, but maybe I
can make it work for the amount of time it takes me to learn MySQL and setup
my own.

ignorance != bliss

Cheers,
Bruce

-- 
Happy Penguin Computers               >')
126 Fenco Drive                       ( \
Tupelo, MS 38801                       ^^
support@happypenguincomputers.com
662-269-2706 662-205-6424
http://happypenguincomputers.com/
A: Because it messes up the order in which people normally read text.                                                                                                                                                          
Q: Why is top-posting such a bad thing?                                                                                                                                                                                        
A: Top-posting.                                                                                                                                                                                                                
Q: What is the most annoying thing in e-mail?
Don't top-post: http://en.wikipedia.org/wiki/Top_post#Top-posting
---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.