Here is a minor update, that enable the copy function. I also integrate a new page that you can edit the css file via the web page (if you have the correct file permission) 🙂 . One note:
I translated this plugin in (my bad) english and german, if you are interested to translate this plugin in your language , don’t hesitate to contact me or use a copy of the german translation files. This plugin support the GNU Gettext localization. It already contain the German (.mo /.po) files. You can use the very good poEdit as translation tool under Windows.
It would be great, if you can forward me then your translation files, that I can integrate it in the next update.
Me again. I can’t get the CSV import feature to work. 😦
I need to know what is not working … Did you get any error message ?
Yes: I got a “was not a text file” error. I exported out of excel, trying CSV and tab-delimited text file options. I added all of the appropriate extensions to the file (.csv, .txt) and verified that notepad would open the files… they were just text.
Then please forward me your csv/text file, I will analyse it.
Send it to my email address you can see at “About”
Great plug-in suits my documentation needs perfectly. Two issues –
1 – Can’t copy a table, get Error : Table cannot insert to database
WordPress database error: [Unknown column ‘border_size’ in ‘field list’]
INSERT INTO wp_golftable ( table_name, description, alternative, show_name, show_desc, head_bold, border_size, cellpadding, cellspacing, table_width ) VALUES ( ‘Projection Template’, ”, ‘1’, ‘1’, ‘0’, ‘1’, ”, ”, ”, ”)
2 – Can I open up the description box for unlimited lines? Currently cuts off at three.
I’m not sure whether issue #1 is the plug in or my bad.
yes you are right, I made a mistake in the copy function. It’s updated and you can download now Version 1.32
The description field is at the moment limited to 200 chars, I check for a update later.
New version works perfectly.
Thanks for the timely response as well as the fix.
I don’t seem to be able to save the cell spacing and cell padding options.
I want to have cell spacing = 0
and cell padding = 2
Whenever I save, the result is
cell spacing = 2
cell padding = 0
If I the save this, the result is saved as per the first save, but the display still has the default 1 spacing when you view the table.
How do I get it to display a 1px border, rather than the double line border which has the 1px space between the borders.
I hope I’ve explained the problem well enough. This is a link to the actual post – http://www.go.id.au/?p=123#pp4
I managed to fix the first problem by applying the css table file instead of the plugin options.
Next problem – how do I display the “$” sign. The code strips it out, do I have to use the HTML symbol code for the sign?
thanks for your testing. I fix that spacing/padding bug, i will look for the ‘$’ and update then the plugin.
Yes, the css file offer you a more flexible solution, I think you instert “border-collapse: collapse;” (I only write this for all the people with the same problem).
That’s exactly what I did – it gives a much cleaner table design (im my opinion anyway!).
I will spend a little more time with the special chars problem, a first intermediate solution is to place a space betwen $ and the value : $ 230
Has anyone ever actually been successful in importing a table? I can’t get the import to work!
If you have been successful, how are you creating your CSV file?
Yes, always. Created tables in a number of ways, the east being to copy your table into Notepad (not Wordpad as Notepad is flat text) from your spreadsheet (assuming you’re using one). Then add a delimited character (I use the standard, ; ) after each item you want in your row.
Name Goals Assists Total
Player A 1 1 2
Now becomes –
Name; Goals; Assists; Total
Player A; 1; 1; 2
Copy the two rows from the spreadsheet without adjusting the formatting and Notepad will pick up the row issue. If you’re pasting an entire row from a spreadsheet it could pick up additional columns so make sure you delete all formatting after your final column.
Just save the Notepad file with the name you wish, as a text file and import through the plugin feature in the the WP admin section.
There are a ton of other things you could do, including functions to automatically add your characters for you, but this simple method should get you going.
OK… I’m good. Thanks, Dan, for the advice, and Alex, for the plug-in.
First of all, I had to create the uploads folder in /wp-content/plugins. Then, I need to copy the table date from Excel, paste it in to Word, then Convert the table to comma-delimited text and save it as a .txt file.
Ugh… but it works. 🙂
of course you need the upload folder, but I take the basic upload folder from WordPress. Not a special one.
Anyway, I test this in the follow way :
Create my table with excel and then I choose “Save as” csv …
Here it works 😦
As a sideline to this conversation, I work in spreadsheets a great deal and use Openoffice instead of Excel because conversion to other formats – necessary for my work – is cleaner than Microsoft products (in my opinion), and that includes csv. It’s free at the link below although the full suite is bulky and I wouldn’t recommend it if your computer is memory challenged.
I’m able to reproduce your main problem and I drop the check for the content type. So with the latest update also a Excel created csv file should work now…
Firstly – a superb plugin! There is nothing like this anywhere else, and it’s solved a lot of problems for me 🙂
One issue I’m having which you may be able to help with – I can’t seem to control the width of the table. I’ve tried using the CSS file and using the settings on the edit table page. Neither seem to change the table width at all. I’ve also tried altering the widths of each column – to no avail.
The situation is that the table is displaying across my sidebar. Not a good look!
Has anyone else experienced this, or are there any suggestions as to how I can fix this. Excellent plugin – just having some teething problems which I’d really like to sort out 🙂
send me link to the page where you integrate the table.
I will check what’s the reason for this behaviour
Which wordpress theme do you use ?
Thanks for your reply – I have found the problem. The client supplied the xls file, and I noticed upon looking at it again that they had included quite a long string of text in one of the cells, which was essentially a list of product numbers, but they hadn’t left a space after each comma. This meant that the cell’s text couldn’t wrap.
Problem solved – your plugin rocks! Thank you!
Just another point – I would HIGHLY recommend anyone using this plugin to add the “border-collapse: collapse;” to their CSS. This looks much better IMHO than the double-line border as it is “out of the box”.
Thanks again Alex – you saved me a lot of headaches with this plugin 🙂