Still working on Caspio

I haven't made a lot of progress over the break; granted, I haven't tried a whole lot. Right after our class Tuesday, my philosophy professor assigned a paper and two books for us to read over break, so I focused most of my energy on that and a Turkey coma. (I also succeeded in getting another job offer, so overall I felt successful even though Caspio has been trying to bring me down.)


I just posted to the discussion board about my progress, but I'll quickly talk about it here. (My mom is just finishing dinner, and that means I have minimal time to write.) I have made all of my tables, and I've input all the data into them. I suppose I've stopped there because the next step is more difficult … I don't know exactly what I'm doing.


All of the tables have to be connected into some sort of database … Obviously. I'm assuming one of those eight tutorials can help with that. I watched all of them, but since I wasn't working on a table when I watched them, I don't remember a lot of the information. I'm going to go through and figure out which one can help, but if anyone already has some information on this, I'm totally open to that. (I learn very poorly from video tutorials. Throughout college, they have been my least favorite form of learning.) Once I can figure out how to link these tables, we should have another prototype.


I also have another, slightly unrelated, question. Can a Google map be made from a Caspio database? Because that is the direction I want to go if possible. If no one knows, I'm going to figure it out once I've finished with the database.


I have other information that I want to put in here, but dinner is ready. I'll come back once I'm back in Durham … It will be later tonight. I'm assuming no one will read this between now and then anyway.

UPDATE: I'm back! Here is an e-mail from David Nobles that I wanted to share. This was his response to the phone message I left him. I'm not sure what all of it means, but he answered all of my questions so that's a start.

Chelsea,
The name of our vendor is Southern Software.  They are located in Southern
Pines (800 842 8190).  The product is called Sheriff-Pak. They would have to
be the one to tell you about different formats.  What I have been sending
you is from pre-designed reports built into the software.  Any extracts
other than those would probably have to be built by Southern and would have
to be limited as to the content, i.e., public vs. investigative information.
I don't know if that type of report has been requested from them in the past
or if it would have an associated cost.

The individual reports are e-mailed daily one at the time to Bob right now.
There is a media report that contains all of the reports for a specified
time frame but it is not as detailed.  

I'll see if I can find the UCR crime codes already listed somewhere so we
don't have to recreate the list.

David