By samoyeds on

hi,

is it possible to copy some tables from ms word or excel?? please give me quick response
if this post is in incorrect topic... sorry

greetings

⋅ Categories: Drupal 6.x

Comments

Island Usurper’s picture

Island Usurper commented

Long answer: You really need to say what you want to do with your data. What format is it in? Can you convert it to plain text or HTML? Does it belong in a database table for a module? Can't really help you until we know more about the problem.

-----
Übercart -- One cart to rule them all.

David_Rothstein’s picture

David_Rothstein commented

You might find the Node Import module useful in getting data from a spreadsheet into Drupal, but yeah, I agree, you really need to explain more exactly what you're trying to do if you want an actual answer to this question ;)

samoyeds’s picture

samoyeds commented

no, its just simple table in ms word. i`ve got it converted to html, but.... if i copy te source of this site to drupal there is to much of unneeded tags... so i dont know wkat to do with this...

thanks

GN’s picture

GN commented

Have you tried the "Paste from Word" button in TinyMCE?
After pasting a table this way, the html code still needs some cleaning, but it's better than just pasting all the MS mess.

samoyeds’s picture

samoyeds commented

there is no tinyMCE for D6... any other ideas??

thanks

-Anti-’s picture

-Anti- commented

I get handed most of my content from other people in word documents.
I'm new to drupal, but when working with e107, my process is:

- copy paste all text into the website form-field.
- add formatting back into it (eg bold, underline, size, etc) using bbcode tools or wysiwyg.
- then I go back to the word doc and screenshot all the images and tables.
- I import each screenshot into photoshop, trim and 'save it for web'.
- upload them all to the relevent folder for the article
- go back to the article and create the links to each jpg

Alternatively, if users don't need to read the whole thing online, sometimes I just convert the whole word document to a pdf file for download, copy/paste the first paragraph as a 'teaser', and link to the file.

Both methods are a pain, but that's the cost of working in both MS Word and an html-based environment. Hopefully this situation won't go on forever, so that far into the future we'll be able to directly upload word-quality formatted documents as webpages without having to convert any of the data or formatting.

GN’s picture

GN commented

You may try FCKeditor - it should also have this button (see http://drupal.fckeditor.net/wysiwyg).
Lots of modules aren't yet ready for D6, starting from Views and CCK...

David_Rothstein’s picture

David_Rothstein commented

First of all, when you save the Word file to HTML, make sure that in Microsoft Word you choose the "Web Page, Filtered" option rather than "Web Page". That is designed to save it in a format that strips out all (or at least most) of the crazy Microsoft-specific tags. (Another option would be to open the Word file in OpenOffice and save it to HTML from there.)

If you still have problems, you might also want to play around with the input formats and HTML filters in Drupal. When you copy the HTML code into Drupal, you should choose an input format that is right for the job. "Full HTML" is certainly worth trying first, but if that causes problems you could create a new filtered HTML format or edit an existing one (go to admin/settings/filters to do this) so that it only uses the HTML tags you need. For example, for importing a table, you'd probably want to make sure that the tags listed at http://en.wikipedia.org/wiki/HTML_element#Tables are on your list of allowed tags.

Hope this helps -- good luck!

GN’s picture

GN commented

Yes, saving a document as "Web Page, Filtered" does indeed strip a good lot of the MS garbage, but what is left is still way too much to live with it.
There are some special HTML code cleaners, but I haven't yet seen a perfect one.
"Paste from Word" option in TinyMCE or FCK also requires some manual cleaning and fixing, but can be used as a starting point.

s.daniel’s picture

s.daniel commented

To convert Excel files to html this site might be intereting:
http://gdsland.com/excel2html/home.php

Also another workaround if you want to use tinymce and don't have the module installed is to bookmark http://tinymce.moxiecode.com/example_full.php?example=true and copy the html over to your site.

GN’s picture

GN commented

Thank you for the Excel convertor link.
It leaves nothing to clean in the HTML code - just plain td's.

peter panes’s picture

peter panes commented

There should be some way to strip tags (particularly Microsoft tags) from the input all together.

"Input Formats" only strips tags as a node is viewed, if you edit it again then the tags are still there and its just confusing, I want certain tags removed from user input completely and permanently, I don’t want <w:.../> or /<meta> tags saved any where on my site.

There is also know way to strip the contents of tags so anything between <meta> and </meta> still gets displayed its annoying and confusing.

I certainly can't expect my users to know how to use the "Paste from Word" button in TinyMCE.

Does anyone know of a module that will let me strip tags automatically before the node gets saved to database?

WorldFallz’s picture

WorldFallz commented

I certainly can't expect my users to know how to use the "Paste from Word" button in TinyMCE.

wow-- and I thought my users were challenging, lol.

Maybe the http://drupal.org/project/safehtml module?

s.daniel’s picture

s.daniel commented

I don't believe this helps alot. Afaik it is part of D6 where we still have this issue.

-Anti-’s picture

-Anti- commented

> I don't believe this helps alot. Afaik it is part of D6 where we still have this issue.

That kind of integration between our local documents and internet publishing is five years away.
And it is entirely up to everyone to stop using microsoft products.
They have no interest whatsoever in that type of open integration.