V
Vandija Sanoth
Greetings, all. Question: Are there any other high-quality RTF editors like
WordTabs, ones still being worked on? Thanks.
WordTabs, ones still being worked on? Thanks.
M
Melinda Meahan - take out TRASH to reply
Vandija said:
AbiWord?
R
REMbranded
I've been trying out editors and placing information into tables.
The first link is sortable by the column headings (thanks Lars!)
http://www.woundedmoon.org/text/test.php
The second is an Excel generated page:
http://www.woundedmoon.org/text/editor.htm
The editors that support RTF, yet are not word processors, are few in
number. The above is still in progress, I haven't made it to WordTabs
yet.
J
John Fitzsimons
Wow ! Now I am IMPRESSED. Don't think I have seen that option
around too often. If at all. If one wanted to put something like that
on one's own site then does anyone know what steps would be
required ? I expect simply saving the above page and replacing data
wouldn't work. Lars ? Anyone ?
Being able to download the original Excel file would be nice.
< snip >
Regards, John.
--
****************************************************
,-._|\ (A.C.F FAQ) http://clients.net2000.com.au/~johnf/faq.html
/ Oz \ John Fitzsimons - Melbourne, Australia.
\_,--.x/ http://www.aspects.org.au/index.htm
v http://clients.net2000.com.au/~johnf/
R
REMbranded
I'll have to defer to Lars here. This is his creation. Very nice!
Being able to download the original Excel file would be nice.
I can help here:
http://www.woundedmoon.org/text/editor2.xls
T
tlshell
Looks like it's a script using PHP.
L
Lars Erik Bryld
Scripsit (e-mail address removed):
It is a PHP-script, which means that what you can see (and save) is made
on-the-fly by the woundedmoon-server. The script is at this moment very
crude, because I didn't want to spend too much time on it before others
found it useful. My suggestion was to only update a simple text file in
e.g. Excel and let a script like this do the html-tables rather than let
Excel generate the HTML. But I won't change the lay-out all the time until
a definite one has been settled on.
If (ant that's a big if) your server *is* PHP-capable (most pay sites and
only a few free sites are), you too are welcome to the script - It's no
secret. Put this into a file called something.php:
<?
// Open file into a 2-dimensional array
$i = 0;
$handle = fopen ("test.txt","r");
while($data = fgetcsv ($handle, 1000, ",")) {
if ($i == 0) { $key_arr = $data; }
reset($key_arr);
while(list($index,$name) = each($key_arr)) { $temp_arr[$name] =
$data[$index]; }
$result_arr[$i] = $temp_arr;
$i++;
}
fclose ($handle);
// $sourceArray is the multidimensional array to sort
// $key is the key to sort on
// $nullVal is the value to use if $key is unset for a row
function array_my_multisort( $sourceArray, $key, $nullVal )
{
// Create an array with the values to sort on
foreach ( $sourceArray as $arrayRow ) {
if (isset($arrayRow[$key])) {
$sortVals[] = $arrayRow[$key];
} else {
$sortVals[] = $nullVal;
}
}
// Now sort the multidimensional source array by the key array
array_multisort( $sortVals, $sourceArray );
return $sourceArray;
}
// Now lets see how to use it for key 'sortby'
$sortedArray = array_my_multisort( $result_arr, $sortby, 0 );
function displayResultSet($resultset)
{ //Indicate if the resultset is empty
if (empty($resultset))
{
echo "<CENTER>\n";
echo "<BR>\n";
echo "Action Returned No Rows!";
echo "</CENTER>\n";
return ;
}
echo "<BR>\n";
echo "<CENTER>\n";
echo "<TABLE CELLSPACING=5 CELLPADDING=5 BORDER=3 ";
echo "BORDERCOLOR=\"0000FF\" >\n";
echo "<THEAD>\n";
echo "<TR>\n";
$keycount = 0;
//Output each key as a column heading
while (list ($key,$value) = each($resultset[0]))
{
$keycount++;
echo "<TH>";
echo "<A HREF=\"test.php?sortby=$key\">$key</A>";
echo "</TH>\n";
}
echo "</TR>\n";
echo "</THEAD>\n";
//Output each value as elements of a table starting a new row
//each time the key number of columns is reached
$rowcount = sizeof ($resultset);
for($rowCounter = 0; $rowCounter < $rowcount; $rowCounter++)
{
$valuesarray = array_values($resultset[$rowCounter]);
$keysarray = array_keys($resultset[$rowCounter]);
if ($valuesarray <> $keysarray)
{
echo "<TR>\n";
for($colCounter = 0; $colCounter < $keycount; $colCounter++)
{
echo "<TD>\n";
echo " ";
echo $valuesarray[$colCounter];
echo " ";
echo "</TD>\n";
}
}
}
echo "</TR>\n";
echo "</TABLE>\n";
echo "</CENTER>\n";
echo "<BR>\n";
}
displayResultSet($sortedArray);
?>
then upload to your server together with a text file called test.txt with
some data in this form:
Heading, Another heading, A third one, And so on
Data, More data, Even more data, Datand so on
And more, 34, URL, anything
- that's all
It is a PHP-script, which means that what you can see (and save) is made
on-the-fly by the woundedmoon-server. The script is at this moment very
crude, because I didn't want to spend too much time on it before others
found it useful. My suggestion was to only update a simple text file in
e.g. Excel and let a script like this do the html-tables rather than let
Excel generate the HTML. But I won't change the lay-out all the time until
a definite one has been settled on.
If (ant that's a big if) your server *is* PHP-capable (most pay sites and
only a few free sites are), you too are welcome to the script - It's no
secret. Put this into a file called something.php:
<?
// Open file into a 2-dimensional array
$i = 0;
$handle = fopen ("test.txt","r");
while($data = fgetcsv ($handle, 1000, ",")) {
if ($i == 0) { $key_arr = $data; }
reset($key_arr);
while(list($index,$name) = each($key_arr)) { $temp_arr[$name] =
$data[$index]; }
$result_arr[$i] = $temp_arr;
$i++;
}
fclose ($handle);
// $sourceArray is the multidimensional array to sort
// $key is the key to sort on
// $nullVal is the value to use if $key is unset for a row
function array_my_multisort( $sourceArray, $key, $nullVal )
{
// Create an array with the values to sort on
foreach ( $sourceArray as $arrayRow ) {
if (isset($arrayRow[$key])) {
$sortVals[] = $arrayRow[$key];
} else {
$sortVals[] = $nullVal;
}
}
// Now sort the multidimensional source array by the key array
array_multisort( $sortVals, $sourceArray );
return $sourceArray;
}
// Now lets see how to use it for key 'sortby'
$sortedArray = array_my_multisort( $result_arr, $sortby, 0 );
function displayResultSet($resultset)
{ //Indicate if the resultset is empty
if (empty($resultset))
{
echo "<CENTER>\n";
echo "<BR>\n";
echo "Action Returned No Rows!";
echo "</CENTER>\n";
return ;
}
echo "<BR>\n";
echo "<CENTER>\n";
echo "<TABLE CELLSPACING=5 CELLPADDING=5 BORDER=3 ";
echo "BORDERCOLOR=\"0000FF\" >\n";
echo "<THEAD>\n";
echo "<TR>\n";
$keycount = 0;
//Output each key as a column heading
while (list ($key,$value) = each($resultset[0]))
{
$keycount++;
echo "<TH>";
echo "<A HREF=\"test.php?sortby=$key\">$key</A>";
echo "</TH>\n";
}
echo "</TR>\n";
echo "</THEAD>\n";
//Output each value as elements of a table starting a new row
//each time the key number of columns is reached
$rowcount = sizeof ($resultset);
for($rowCounter = 0; $rowCounter < $rowcount; $rowCounter++)
{
$valuesarray = array_values($resultset[$rowCounter]);
$keysarray = array_keys($resultset[$rowCounter]);
if ($valuesarray <> $keysarray)
{
echo "<TR>\n";
for($colCounter = 0; $colCounter < $keycount; $colCounter++)
{
echo "<TD>\n";
echo " ";
echo $valuesarray[$colCounter];
echo " ";
echo "</TD>\n";
}
}
}
echo "</TR>\n";
echo "</TABLE>\n";
echo "</CENTER>\n";
echo "<BR>\n";
}
displayResultSet($sortedArray);
?>
then upload to your server together with a text file called test.txt with
some data in this form:
Heading, Another heading, A third one, And so on
Data, More data, Even more data, Datand so on
And more, 34, URL, anything
- that's all
J
John Fitzsimons
Would that be able to be put on any web site ? I know some scripts
(cgi ?) aren't possible (allowed ?) on some sites ?
Does anyone know a "how to", tutorial and/or downloadable code,
to do something similar to the above URL please ?
Regards, John.
J
John Fitzsimons
On Sat, 6 Sep 2003 21:31:13 +0200, Lars Erik Bryld
Yes, that's one thing that concerned me. As I mentioned in my earlier
post.
< snip >
Though it looks a little too complicated for me at the moment I will
try and "digest" it at a later time. Thanks.
Regards, John.
Yes, that's one thing that concerned me. As I mentioned in my earlier
post.
< snip >
Though it looks a little too complicated for me at the moment I will
try and "digest" it at a later time. Thanks.
Regards, John.
J
John Fitzsimons
Thanks. Look forward to taking a look at it when I get some spare
time. Sure hope you have the bandwidth to keep the latest version
available.
Regards, John.
T
tlshell
R
REMbranded
Though it looks a little too complicated for me at the moment I will
try and "digest" it at a later time. Thanks.
It's not all that bad. You might have missed a part earlier in the
thread. Read about PHP scripts on your host site if it is available.
This is a script that Lars sent that will divulge your PHP version:
-----------------
<?
phpinfo();
?>
-----------------
My site says that all scripts must begin with "chmod 755" to make them
executable:
-----------------
chmod 755
<?
phpinfo();
?>
-----------------
So this is what I sent in as "test.php" and upon opening that page I
got a long page of information about the version of PHP that is
running on my host site.
If you get the information then you have access to run PHP.
If successful upload the larger script that Lars created. The only
thing that you might need to tweak is the name of the file opened.
This is the second line of the script:
$handle = fopen ("test.txt","r");
You can either name whatever .csv file you want to view "test.txt" or
you can change the name in the script (above) to say "john.csv" or
"my.txt" or whatever you name your .csv file.
Seeing how it sorts rows by columns, you really only need a single
heading. This will be highlighted and clickable. I had to remove the
dupe headings I had in my original file because these will be sorted
if left in the .csv file.
T
Tiger
Not feature-rich, but certainly fast:
http://www.flashpeak.com/inted/inted.htm
--
Tiger
"Zero is where the fun starts
There is too much counting everywhere else."
- Hafiz
J
John Fitzsimons
Wow ! That looks like a pretty good "rainy weekend" site. Thanks for
your help.
Regards, John.
J
John Fitzsimons
< snip >
Thanks, but the obvious question is "How do I run it ?" Am I supposed
to telnet to my web site then run that command ?
Regards, John.
R
REMbranded
Copy and paste the area between the lines, beginning with "<?" and
ending with "?>" and save it to a file named "test.php."
FTP into your account and upload this file. Then open your browser to
that file: http://www.john.com/test.php
I suppose that you could telnet in, but ftp works for me.
If it doesn't display a long list of features of the version of PHP
running on your server, check and see if you need to add a line to
make it executable, as I did for my server. Or write tech support and
ask them. Careful though, my host wants to charge $80 per hour to
setup a script for me and there is no need in that. Just ask what is
necessary to run a small PHP script if you had no previous luck.
G
Glev Zarriontal
It may not have all the bells and whistles you seek yet it does the job
well.
http://www.jarte.com/
You will want Jarte. Jarte is freeware compared to Jarte Plus which is
shareware.
And you should try Crypt Edit 4 even if it is defunct via CE5. CE5 is
shareware.
http://ftp.kmu.edu.tw/Win/editor/Crypt Edit 4.1/
*****************************************************************************
Lefse is really good grub..."Jeg Elsker Lefse! I Love Lefse!" on Matbird's page sums it up well
http://www.geocities.com/TimesSquare/Dome/3918/index.html