Film-Tech Cinema Systems
Film-Tech Forum


Post New Topic  Post A Reply
my profile | my password | register | search | faq & rules | forum home
  next oldest topic   next newest topic
» Film-Tech Forum   » Operations   » Ground Level   » Excel help (Page 1)

 
This topic comprises 2 pages: 1  2 
 
Author Topic: Excel help
Mike Blakesley
Film God

Posts: 12106
From: Forsyth, Montana
Registered: Jun 99


 - posted 10-31-2015 01:47 PM      Profile for Mike Blakesley   Author's Homepage   Email Mike Blakesley   Send New Private Message       Edit/Delete Post 
I'm having an Excel problem which is causing me to pull my remaining hair out.

For years I have created our work schedule on a spreadsheet. I then "save as web page" in Excel with the file name "index.htm" and I load that into a folder called calendar on website. So the employees can just go to roxytheatre.net/calendar and the schedule comes up.

Last week my office computer crashed so I'm doing all this on a different computer which has a different (newer) version of Excel. When I follow the EXACT same process, now the calendar URL comes back with:

The requested URL /calendar/index_files/sheet001.htm was not found on this server.

I notice that in that error message it appears to be looking for a subfolder - which I found and uploaded it into the same folder on the website -- but even with that subfolder there I'm still getting the same error message. I've tried Chrome, Explorer, Safari all with the same results. Anybody got any ideas?

 |  IP: Logged

Frank Cox
Phenomenal Film Handler

Posts: 1749
From: Melville Saskatchewan Canada
Registered: Apr 2011


 - posted 10-31-2015 02:47 PM      Profile for Frank Cox   Author's Homepage   Email Frank Cox   Send New Private Message       Edit/Delete Post 
What is sheet001.htm? Note that it's not the index.htm file that you think it is.

I just went to roxytheatre.net/calendar and I got a calendar from Oct 25-December 5, which I assume is what you expect to have there.

You might want to look at the index.htm file on your computer with a text editor (Windows notepad maybe) and see what it's actually doing. Do a search for the words "sheet001.htm" and you might find interesting things.

 |  IP: Logged

Rick Raskin
Phenomenal Film Handler

Posts: 1068
From: Manassas Virginia
Registered: Jan 2003


 - posted 10-31-2015 03:51 PM      Profile for Rick Raskin   Email Rick Raskin   Send New Private Message       Edit/Delete Post 
Get yourself am FTP program (FileZilla comes to mind) and see whats really in the calendar directory on the server. Sounds to me like it really isn't what you think it is. I suspect Excel created sheet001 instead of index.htm. Just a guess though.

I also took a look at your page and noticed its trying to load your favicon (to display along with the web address) and can't find the file. http://roxytheatre.net/favicon.ico

 |  IP: Logged

Frank Cox
Phenomenal Film Handler

Posts: 1749
From: Melville Saskatchewan Canada
Registered: Apr 2011


 - posted 10-31-2015 04:19 PM      Profile for Frank Cox   Author's Homepage   Email Frank Cox   Send New Private Message       Edit/Delete Post 
If you don't have shell access to the webserver that you're using, then one of the easiest ways to manage a webpage is sitecopy.

If you do have shell access, use rsync.

Either way (rsync or sitecopy) you simply create a complete local copy of your website on your computer, then tell the program to make the directory on the webserver look just like that one.

It's easy to make changes and test stuff that way -- if it doesn't work locally then it won't work on your webserver so don't sync it until it does. And you always know what's on the remote (webserver) end, too.

 |  IP: Logged

Mike Blakesley
Film God

Posts: 12106
From: Forsyth, Montana
Registered: Jun 99


 - posted 10-31-2015 08:32 PM      Profile for Mike Blakesley   Author's Homepage   Email Mike Blakesley   Send New Private Message       Edit/Delete Post 
quote: Frank Cox
What is sheet001.htm? Note that it's not the index.htm file that you think it is.

I just went to roxytheatre.net/calendar and I got a calendar from Oct 25-December 5, which I assume is what you expect to have there.

I have a feeling the "problem" has arisen from me using a newer Excel version. I was using 2003 on the old computer.

Previously I would "save as" a webpage, which would create a html file. I would copy that to the server and that was that.

Now, using Excel 2010 on this computer, if I follow that same process and copy that file to the server, it shows up in a directory listing but it can't be found by a browser.

The save-as process creates a folder called "index_files" (which is where it LOOKS LIKE the missing html file is) so I copied that folder to the server but the calendar still can't be found.

There is a calendar there now because I quick-built an HTML version with FrontPage just to get it up there for my crew. I guess if I can't figure this out I'll just keep using that version, which is easier to do fast updates on but more of a pain to edit the whole month.

 |  IP: Logged

Frank Cox
Phenomenal Film Handler

Posts: 1749
From: Melville Saskatchewan Canada
Registered: Apr 2011


 - posted 10-31-2015 09:42 PM      Profile for Frank Cox   Author's Homepage   Email Frank Cox   Send New Private Message       Edit/Delete Post 
Don't copy the folder to the server. Just copy the file named index.htm from that folder.

If it's in a folder on the server then you have to specify the name of the folder in the url as well, and you don't want that.

 |  IP: Logged

Mike Blakesley
Film God

Posts: 12106
From: Forsyth, Montana
Registered: Jun 99


 - posted 10-31-2015 09:55 PM      Profile for Mike Blakesley   Author's Homepage   Email Mike Blakesley   Send New Private Message       Edit/Delete Post 
The "save as web page" function creates:

- a file named index.htm
- a folder named index_files with a file in it "sheet001.htm" (and a couple other files)

I did copy the index.htm file to start with, which is when the problems surfaced.

If you look at that error message it appears that it "can't find" the sheet001.htm file which is supposedly located in the index_files folder. So I copied that folder and still got the same result from the browser -- but the ftp program DOES show the index.htm file in the proper place on the website. So...?

 |  IP: Logged

Frank Cox
Phenomenal Film Handler

Posts: 1749
From: Melville Saskatchewan Canada
Registered: Apr 2011


 - posted 10-31-2015 10:22 PM      Profile for Frank Cox   Author's Homepage   Email Frank Cox   Send New Private Message       Edit/Delete Post 
So what are the contents of index.htm and sheet0001.htm?

html files are plain text, so you can look at them with any text editor.

Email them to me and I'll take a look at them for you if you don't know what to look for.

 |  IP: Logged

Rick Raskin
Phenomenal Film Handler

Posts: 1068
From: Manassas Virginia
Registered: Jan 2003


 - posted 11-01-2015 09:09 AM      Profile for Rick Raskin   Email Rick Raskin   Send New Private Message       Edit/Delete Post 
What is in the index_files folder? My guess is it is index.htm. Try renaming it sheet001.htm and see what happens. Maybe the index.htm file you created is referencing sheet001.htm in the index_files folder. Either way, reading out the contents of YOUR index.htm should yield the answer.

 |  IP: Logged

Mike Blakesley
Film God

Posts: 12106
From: Forsyth, Montana
Registered: Jun 99


 - posted 11-02-2015 10:53 AM      Profile for Mike Blakesley   Author's Homepage   Email Mike Blakesley   Send New Private Message       Edit/Delete Post 
Well, I looked at all the files. On MY computer, when I look at it in a browser, index.htm is the calendar as it should look.

The index_files folder has:

stylesheet.css (list of formatting styles for the calendar)
filelist.xml (list of all the files in the folder, seems redundant but whatever)
sheet001.htm (the calender, without formatting)
tabstrip.htm (image of the tabs that appear when viewing the calendar in Excel)

So, seems like it SHOULD work since I'm uploading the index file AND the index_files folder to the server. If the index file is referencing a file in the index_files folder, why isn't it showing up?

I'm about ready to bag the whole process and just use the calendar I created in Front Page going forward, which is a little more work but not that much.

 |  IP: Logged

Frank Cox
Phenomenal Film Handler

Posts: 1749
From: Melville Saskatchewan Canada
Registered: Apr 2011


 - posted 11-02-2015 12:07 PM      Profile for Frank Cox   Author's Homepage   Email Frank Cox   Send New Private Message       Edit/Delete Post 
Load index.htm into a text editor and search for the word "index_files". Is that word present in the index.htm? If so, what is the context?

Does the calendar look ok to you if you view it locally on your own computer? Load the index.htm file that's present on your computer into a web browser and see what happens.

Is it possible that you have a permission problem on the remote end? The webserver that you're using runs apache 2.2.31 on Red Hat Enterprise Linux 5. Do you have a .htaccess file in that directory? If so, are you sure that you know what it's doing?

Is it possible that you have both an index.htm file and a index.html file in /calendar directory?

The problem that you have is either on your end (with the actual generated html files) or on the other end (least likely: webserver misconfiguration; most likely: improper file permissions). If it looks ok on your end, then that eliminates one source of grief.

What happens if you copy index.htm to a different location on your computer and view that in a web browser? That's an easy way to find out if index.htm is actually an independent and complete web page or if it depends on the files in the index_files directory.

 |  IP: Logged

Mike Blakesley
Film God

Posts: 12106
From: Forsyth, Montana
Registered: Jun 99


 - posted 11-03-2015 11:49 AM      Profile for Mike Blakesley   Author's Homepage   Email Mike Blakesley   Send New Private Message       Edit/Delete Post 
Well I followed all your advice and I'm still stumped.

I copied the index file into a different spot and it does open as a complete page with all the formatting etc.

I highly doubt the problem is on the other end because nothing has changed there from last month to this month, that I'm aware of anyway.

Literally the only thing tha'ts changed is the computer I'm working from. (And, I got the old computer back now so I just need to reload Office onto it and that'll give me back my ancient Excel version so that'll probably fix the problem until I upgrade.)

I did look at the index file in a text editor and there are lots of references to index_files folder -- and I can see why, because the actual calendar content (names, etc.) does not show up, so that's apparently why it needs to reference the other file that's located in the index_files folder. But I AM COPYING that folder to the server so it doesn't make sense that it can't be found.

As I said above I'm about resigned to going ahead with the "alternate" solution anyway. It's a little more work but there are things I do like about doing it that way. (I keep looking into work-schedule creating software that would make this a lot easier task but everything I like is too f-ing expensive.)

 |  IP: Logged

Rick Raskin
Phenomenal Film Handler

Posts: 1068
From: Manassas Virginia
Registered: Jan 2003


 - posted 11-03-2015 12:44 PM      Profile for Rick Raskin   Email Rick Raskin   Send New Private Message       Edit/Delete Post 
An alternate solution might be to print your spreadsheet to a PDF file schedule.pdf then upload it to the server. Change the URL to roxytheater.net/schedule.pdf.

Just curious, what version of Excel is giving you problems?

 |  IP: Logged

Frank Cox
Phenomenal Film Handler

Posts: 1749
From: Melville Saskatchewan Canada
Registered: Apr 2011


 - posted 11-03-2015 01:19 PM      Profile for Frank Cox   Author's Homepage   Email Frank Cox   Send New Private Message       Edit/Delete Post 
Are you sure that the file permissions for the index_files folder are set such that apache can read the contents?

 |  IP: Logged

Carsten Kurz
Film God

Posts: 3277
From: Cologne, NRW, Germany
Registered: Aug 2009


 - posted 11-03-2015 05:27 PM      Profile for Carsten Kurz   Email Carsten Kurz   Send New Private Message       Edit/Delete Post 
This is not super-tight, I just had a quick go on it on my Mac with Excel2004 and 2008.

I noticec that EXCEL creates an html-file + folder structure when you have multiple sheets in your work book. The Website export will then create a navigation structure to access the other sheets from the index page to simulate the workbook/worksheet access scheme in Excel.

Try to erase those empty sheets in Excel until only your schedule sheet is left, or, if that option exists in your version of Excel, try to use the 'Sheet only' save option. Check if only one file is created, rename if necessary.

- Carsten

 |  IP: Logged



All times are Central (GMT -6:00)
This topic comprises 2 pages: 1  2 
 
Post New Topic  Post A Reply Close Topic    Move Topic    Delete Topic    next oldest topic   next newest topic
 - Printer-friendly view of this topic
Hop To:



Powered by Infopop Corporation
UBB.classicTM 6.3.1.2

The Film-Tech Forums are designed for various members related to the cinema industry to express their opinions, viewpoints and testimonials on various products, services and events based upon speculation, personal knowledge and factual information through use, therefore all views represented here allow no liability upon the publishers of this web site and the owners of said views assume no liability for any ill will resulting from these postings. The posts made here are for educational as well as entertainment purposes and as such anyone viewing this portion of the website must accept these views as statements of the author of that opinion and agrees to release the authors from any and all liability.

© 1999-2018 Film-Tech Cinema Systems, LLC. All rights reserved.