Recent Posts

576

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 24, 2015, 01:21 PM »

can we do this?
I edit the xls file to add the filenames and possibly add new files I have uploaded
the html at the time it is downloaded, it AUTOMATICALLY reads and grabs the hyperlinks from the xls file and displays the latest uptodate index

is that possible?

that would be interesting

577

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 24, 2015, 01:17 PM »

sorry, I don't know how the html file knows its url and parent web path and you answer "it 'just' knows" !

I see nothing inside the html file that contains its url

it seems the web browser when it opens an html and sees hyperlinks in it with no path, it automatically takes the same path of the url that was downloaded

but if you take that html file and send it in an email attached, and open it from that email, will these Href links without path, work?
if they work I will get mad!

so, if they don't work, and they only work when the index html is downloaded, there is no chance to do what I want, one thing of which was to have the index file (I said xls, you made it html) to be stored locally!

578

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 24, 2015, 12:22 PM »

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?

579

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 24, 2015, 10:18 AM »

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?

580

General Software Discussion / Re: metadata solution

« Last post by kalos on March 24, 2015, 09:16 AM »

yeah, I know
I am basically asking if there is another option than those I mention
ie. a way to assign a descriptive title in a file, apart from its filename

581

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 24, 2015, 09:05 AM »

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

582

General Software Discussion / Re: metadata solution

« Last post by kalos on March 24, 2015, 04:01 AM »

hello

I try to analyze a problem where I want to assign a decriptive title in each of a list of files with filenames that are not indicative of their content and the filenames cannot be changed (for various reasons)

so I came up with this logical thinking, but I need to know if I am missing something, if a workaround can work, a new idea, some new technology, or something

here it is then:

To assign a descriptive title in a file let's say named xxx.pdf, this title needs to be saved somewhere. This somewhere is either internally in the file or somewhere externally, eg an excel file, text file, etc. Internally, there are two options: either inside the body of the file itself, like the first or last page of the xxx.pdf file, or in its metadata. But to read and display that info, we will need a viewer (ie. it cannot be done without having a program to read either the file or its metadata). Externally, we can have a database of the descriptive titles for each of the files, and somehow bind that data in a viewer.

Do you have any idea about this binding? What could be done?
Is there anything missing from that logical thinking?

thanks!

-kalos (March 23, 2015, 05:00 PM)

anyone to comment on this please?
is this logical approach complete?

583

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 23, 2015, 05:43 PM »

"Then you take a program of the "directory reader" type to generate a complete list of all files in a folder."

so I need to run an external program? can't excel do that?

584

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 23, 2015, 05:40 PM »

(I make up a lot of my own terms.)

-TaoPhoenix (March 23, 2015, 01:30 PM)

lol, that's the problem
anyway I will test it again

585

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 23, 2015, 05:12 PM »

so TaoPhoenix, sorry but your posts are a bit hard to follow
so do I need anything else apart from the xls index file and the files themselves?
I think you mention something about a program that will perform a dir command to that folder?
but I need to have command line access to the web server, right?

586

General Software Discussion / Re: metadata solution

« Last post by kalos on March 23, 2015, 05:09 PM »

but I don't want it to be limited in metadata

587

General Software Discussion / Re: metadata solution

« Last post by kalos on March 23, 2015, 05:00 PM »

hello

I try to analyze a problem where I want to assign a decriptive title in each of a list of files with filenames that are not indicative of their content and the filenames cannot be changed (for various reasons)

so I came up with this logical thinking, but I need to know if I am missing something, if a workaround can work, a new idea, some new technology, or something

here it is then:

To assign a descriptive title in a file let's say named xxx.pdf, this title needs to be saved somewhere. This somewhere is either internally in the file or somewhere externally, eg an excel file, text file, etc. Internally, there are two options: either inside the body of the file itself, like the first or last page of the xxx.pdf file, or in its metadata. But to read and display that info, we will need a viewer (ie. it cannot be done without having a program to read either the file or its metadata). Externally, we can have a database of the descriptive titles for each of the files, and somehow bind that data in a viewer.

Do you have any idea about this binding? What could be done?
Is there anything missing from that logical thinking?

thanks!

588

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 23, 2015, 04:33 PM »

it's not a matter of difficulty, it's that the server is secure and I cannot run my own stuff on it

589

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 23, 2015, 04:17 PM »

@kalos: as I said in the other thread, where you asked exactly the same question: get a CMS. And please stop asking the same stuff if the answer is beyond your comprehension; do at least some research first

-Ath (March 23, 2015, 03:03 PM)

why so mean with me not knowing? I told you I cannot do CMS

590

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 23, 2015, 02:59 PM »

I don't want the
DirRead PreProcessIndex1.txt
Excel Produced Index.html
to be present
only the a,b,c and the xls index file
is it possible?

591

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 23, 2015, 02:33 PM »

sorry, I am not sure I understood

do I need something else apart from the xls file and the files in the folder?

can you upload the xls files to rom http://www.freevoteusa.com/Zexcel1/ and http://www.freevoteusa.com/Zexcel2/ please?

592

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 23, 2015, 01:23 PM »

man that looks amazing! thanks!

so I only have to hyperlink the files with <A Href="c.txt"> ?

and I am done?

593

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 23, 2015, 01:08 PM »

from http://www.freevoteusa.com/Zexcel1/
the files are moved to http://www.freevoteusa.com/Zexcel2/
yes, the index xls is moved like the files too

how the index xls will update itself with the new hyperlinks?

594

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 23, 2015, 01:05 PM »

no, the files are not stored locally! they are only in the web server!

595

General Software Discussion / metadata solution

« Last post by kalos on March 23, 2015, 10:46 AM »

hello

when I was first exposed to the concept of metadata, it was when I had my mp3 collection
it was amazing that I could store all the info I would ever need (like name of artist, recording year, edition, title of album, etc) and I wasn't limited by the filename restrictions (too few characters, specific characters aren't allowed, need to create a consistent filename template, like Artist_Album_Year or Year_Artist_Album? etc)

now I am again facing that problem, but with files with xls, doc, pdf, zip, etc

am I limited to the filename of these files? or can I store additional information within them?
I am basically interested in a 'second filename': the original filename needs to be maintain for consistency purposes (eg hyperlinks, search/find it, etc) but it is not self descriptive, so I need another filename to describe that it actually is

is there a solution for this? it may not be based on metadata, but I would really like NOT to have a seperate file (eg. excel or text) that will contain the 'second filenames' of the files, because it won't be standalone within the files

thanks!

596

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 23, 2015, 09:53 AM »

when an xls opens, it knows its filepath
but when a downloaded xls opens, can it know its download url?
I am not sure, if there is a stamp like 'Downloaded from /path/'
so that it can then search for its hyperlinks inside that path/folder

but even if that exists, we would need to download a fresh copy each time, in order to get the links updated
which is inconvenient

that's why the only possible solution I see, is a script that will search for the specific filenames (maybe a file id like a hashtag?) in the whole web server
but doesn't that need special access to this server, like ftp access, command line access or something?
please advise

unless I miss something?

597

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 23, 2015, 09:46 AM »

the business requirement is this:

in a web folder, there is an excel file and some other files

the excel file contains an index of the hyperlinks of the other files

when that web folder is being moved in another location of the same web server, the links get broken

if the excel file is set to search within its own folder for the files that their hyperlinks are stored in this excel file, then they won't get broken

I don't think it can be done at least without some scripting (what that would be really?), but I am not sure

598

General Software Discussion / Re: how can I do this in excel?

« Last post by kalos on March 23, 2015, 07:41 AM »

my manager is convinced that it can be done

but I think it's impossible without any scripting

I want the xls file stored in a specific web folder, to have hyperlinks of the files in the same folder

I think this needs the xls file to get its own url and then generate the hyperlinks of the filenames by adding the www.domain.com/folder/ to their hyperlinks

or is another way?

599

General Software Discussion / how can I do this in excel?

« Last post by kalos on March 23, 2015, 07:00 AM »

hello!

I have an excel file uploaded in www.domain.com/folder/some.xls

I want to put hyperlinks of the rest of the files included in the www.domain.com/folder/

BUT I don't want to put hyperlinks like www.domain.com/folder/file.doc etc, but hyperlinks like */file.doc, so that basically to search for the files, it will search within the folder that the xls is located at

I know it's very easy to do it when we are talking about local files (you can make xls search in the current folder for that specific filename and hyperlink it)

but how about files stored in a web server?

thanks!

600

General Software Discussion / Re: links of files of a web server

« Last post by kalos on March 22, 2015, 05:38 PM »

thanks!
but regarding CMS, I wouldn't like my work to be depended on a website or internet connectivity
I want a physical file to work with
any specific suggestions for solutions?