Main Area and Open Discussion > General Software Discussion
how can I do this in excel?
kalos:
guys, it doesn't work
I uploaded a.txt, b.txt, c.txt to my server
I also uploaded index.xls in the same web folder
I am not sure what to write inside the xls file though
it cannot allow me to enter <A Href="c.txt"> c.txt in a cell as a hyperlink
it converts it to %3cA%20Href=%22c.txt%22%3e%20c.txt
what exactly the xls index file need to contain?
any hint?
TaoPhoenix:
he's given you a template file - all you need is to test it with one linked file to see if it works in practice.
-tomos (March 23, 2015, 05:32 PM)
--- End quote ---
^when you've done that^ you can worry about whether you need an app to list files (the "directory reader")
-tomos (March 23, 2015, 05:49 PM)
--- End quote ---
Tomos, the process I designed is meant to tie right in to a dir reader because it produces the complete index list of folders all at once - so he will need it pretty quickly. Part of the point is the dir reader "can't lie" vs typing them in by hand. So for example if there are client names, and he enters them by hand, and one of them is something like Schaefeirmann, whoever is doing data entry by hand will get that wrong 3 times out of 10, whereas the dir reader produces a "cold facts" dump where it cannot be wrong with random spelling errors. That's part of the system I designed.-TaoPhoenix (March 23, 2015, 08:39 PM)
--- End quote ---
^ I'm actually very interested in the process you describe. My point was that he try it with one or two ('manually') linked files first to see if it works - a proof of concept - then he could look at setting up the more complex system.
@kalos, it seems to me it would be a good idea if you showed your manager a few of the replies here - or the whole of the two threads. They might reconsider.
-tomos (March 24, 2015, 05:17 AM)
--- End quote ---
Sure Tomos, the "three file test" is what I began with here. The excel file needs nothing but a file name, and then it creates the links itself.
Then he would just run a directory reader for the real thing, and those file names already come out in a list, so he'd copy and paste those instead.
The big bug to fix doing the whole thing is that there's two lines at the bottom of the excel that go /body and /html that would have to just be moved down to the bottom of his list.
TaoPhoenix:
how exactly that html tag works?
is it the equivalent for 'search in the same directory' for hyperlinks of local files?
how actually the xls 'knows' its web folder and that html tag links the hyperlinks to the same folder?
I don't get the mechanism
can anyone explain me please
-kalos (March 24, 2015, 09:05 AM)
--- End quote ---
guys, it doesn't work
I uploaded a.txt, b.txt, c.txt to my server
I also uploaded index.xls in the same web folder
I am not sure what to write inside the xls file though
it cannot allow me to enter <A Href="c.txt"> c.txt in a cell as a hyperlink
it converts it to %3cA%20Href=%22c.txt%22%3e%20c.txt
what exactly the xls index file need to contain?
any hint?
-kalos (March 24, 2015, 10:18 AM)
--- End quote ---
Kalos,
You're asking about making an index.
But you might have missed something I was saying.
The index is a web file produced from half of the excel file.
So upload Excel Produced Index.html to that server and try those links.
The Excel file has a lot of components that aren't actually links - it assembles the links which you just copy and paste over into a text web file. That web file is your index. The links aren't directly live in the excel file.
kalos:
oh I see now
well, not exactly what I was looking for
but it is a good suggestion to replace the index from an xls file to a html file
1) I don't understand how the html file is produced from the excel file
2) Also, I don't understand, how the Href tag works.
3) And how the html file can 'know' its url and thus search for the specific files in that directory.
Can you explain these things to me please?
Also, couldn't we embed that html file into an excel document, so that when I download the excel file, it will display inside the html index?
Or isn't it possible to make an excel file that will open the html index and convert the links into the correct ones? ie. the filenames with the path of the current web folder?
TaoPhoenix:
oh I see now
well, not exactly what I was looking for
but it is a good suggestion to replace the index from an xls file to a html file
1) I don't understand how the html file is produced from the excel file
2) Also, I don't understand, how the Href tag works.
3) And how the html file can 'know' its url and thus search for the specific files in that directory.
Can you explain these things to me please?
Also, couldn't we embed that html file into an excel document, so that when I download the excel file, it will display inside the html index?
Or isn't it possible to make an excel file that will open the html index and convert the links into the correct ones? ie. the filenames with the path of the current web folder?
-kalos (March 24, 2015, 12:22 PM)
--- End quote ---
Let's look at those in slightly different order.
The html file source looks like this: (Modified for this post!) (And that URL tag is not in there!)
<HTML> <BR>
<Body> <BR>
<BR>
<BR>
<A Href="a.txt"> Top important file for Kalos!! - a.txt </A> <BR>
<A Href="b.txt"> b.txt </A> <BR>
<A Href="c.txt"> c.txt </A> <BR>
<BR>
<BR>
</Body> <BR>
</Html>
So for #3, because it is in the same folder as the files, it "just knows" because it's assuming it's in the same folder, and it is. A slightly fancier way to say it is that it is just what basic spec web behavior is - look in the same folder until you tell it to look anywhere else.
For #2, "Anchor" is the A letter, and that too "just is" - it's the raw command to produce a link. It basically says "look here for the file" but then "display the link like whatever comes next". The middle half is basically any text you want to put there.
Then it just closes the link so the computer knows it's done.
BR is a line break.
I didn't spend any time putting any fancy header text on there, but once the basics work, you can fiddle with that later.
For #1, How it is produced, it's basically the right couple of columns of the excel file copied wholesale and pasted into the text html file. Notice for later you can put other things in the excel file you don't need to copy over. That's for another day.
So once you get going, you just paste the list of files in the left couple of columns, and the right side is supposed to automatically concatenate them together to produce your index file.
"Also, couldn't we embed that html file into an excel document, so that when I download the excel file, it will display inside the html index?
Or isn't it possible to make an excel file that will open the html index and convert the links into the correct ones? ie. the filenames with the path of the current web folder?"
These make less sense. You were saying a big restriction was you couldn't load a lot of stuff up on that server. So the excel file is down on your machine where you're working on it. So you're not downloading it anywhere - you already have it on your machine. And you really can't try to embed the excel file inside the html one - that starts to get way out of hand. The production flow runs the other way. Your excel file is your "engine" that does all your work, and "12 clicks later" you have a simple html index. As long as that html index is in the same folder as the files, it shouldn't need a full path - that's what you wanted earlier, flexibility to move the files and not break the index.
And don't try to "super optimize it" to save 1 step - that just makes it get all messy! Once you get the proof of concept working like tomos was saying, it really is as easy as "drop file list into excel, copy right few columns of excel, open text file, control-v paste and save" and it's done. Fast and ruthless.
The other guys are right that later you'll want a parallel investigation into content systems, but this was supposed to get "this month's problems" solved in under a day once you get the idea, and then you can grind out a more thorough review of a few different content systems and maybe even get your IT guy or someone to engage a thorough test.
Does that help?
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version