Help needed for idiot starting out

I chanced upon this after looking for several solutions for work. We have just started a MyBB based bulletin board for knowledge exchange. Next what I would like to to is add progress sheets that people can update for workflow purposes. Ultimately it would be nice to get this into a MyBB post / page but I’m trying to simply get any old page working right now.

And that’s the thing. I’ve managed to install the code (after a bit of a struggle) but now I’m a bit lost to be honest. I’ve read the guide but I’m none the wiser (hence the idiot bit). CAn someone walk me through what I need to do to get a simple page showing a spreadsheet please?

Many thanks.

Hi,
after installing you should just place a code with spreadsheet initialization at required page:

<script src="{url_to_spreadsheet}/codebase/spreadsheet.php?sheet=2&key=key2&parent=box" ></script>
<div id="box" style="width: 800px; height: 400px; background-color:white;"></div>

{url_to_spreadsheet} it’s url to your spreadsheet directory.

Radyno

Thanks.

Hate to further seem like an idiot but I tried to copy and paste that into a .html blank file (just the code with opening and closing tags), after changing the path, but all I got was a blank screen. It seems inevitable I’m doing something wrong. ANy idea what?

Hi,
does any javascript error occur?
Could you provide link to your spreadsheet page?

CAn I PM you the address for it?

No sign of any error.

Hi,
it looks like that some error appears but php returns HTTP 500 Internal error instead of error details. Try to have a look in apache logs, it may contain useful details.

Hi,
please, make sure that table sampledb.sample_sheet exists in database.
If it exists with some another prefix (not “sample_”) then you should configure $db_prefix in file codebase/php/config.php.

I created the sheet using the MySQL command line, making a column by the name of column1 as VARCHAR. The exception now shows Unknown column ‘cfg’ in ‘field list’ in the same php file. How should I have set the table up?

I also tried to change the MySQL user in the config. php file in case there was a problem there but even using root it won’t work.

Thanks for your continued patience and help.

Hi,
you should use spreadsheet installer to generate all required tables. Have you done it?

If by that you mean did I visit mysite.com/installer.installer.php then yes. NO apache errors in running it but nothing shows on the screen either.

No,
I mean spreadsheet installer.
When you’re getting spreadsheet the first what you do is copying it into some directory. After that you should open file spreadsheet/index.php which runs installing process. This installer will create all required tables in database, configure connection to database. After that you may use spreadsheet.
Here is a link into docs which describes installing process:
docs.dhtmlx.com/doku.php?id=dhtm … installing

Ah yes of course. Yes I ran that, just did again to make sure, and it tells me I already have it installed. I went to update it just now and it goes to blank screen. The error logs tell me that sampledb.sample_triggers doesnt exist. I presume then I need to create this in MySQL - if so what columns should my table have? Or did I miss something else?

MAny thanks again for your help btw. Much appreciated

You may find database sql dump in spreadsheet package (not installed version) in file installer/spreadsheet.sql. You should load this dump into database. Don’t forget to replace #__ with your table prefix.

Did some deleting and some reinstalling etc but the final piece was dumping the sql data into the database. Perfect. Thanks you very much indeed for your help and patience.

Now to go have a play with it and see what happens next .