I have imported content into WP from a wiki page that was using bitweaver…the format of the tables in the wiki platform are quite different and i wonder if there is a query i can run in phpmyadmin to change the wiki table syntaxto regular html..
the wiki format sample is as below which when viewed is a table…
||RANK|COUNTRY|MILLION USA DOLLARS
1|South Africa|8,967
2|Egypt|8,133
3|Morocco|6,899
4|Tunisia|2,999
5|Mauritius|1,302
6|Kenya|1,182
7|Ghana|910
8|Ethiopia|639
9|Botswana|539||
Hi,
thanks for your question, and sorry for the trouble.
This format looks very similar to CSV, so that I suggest that you simply try to import it as that.
To increase the changes that the auto-detect works, you could a text editor and search/replace the bar | with a semicolon ;.
Regards,
Tobias
Tobias,
Thanks for the response, i replaced it and tried but was unable to import the table as a csv.
Hi,
what does the content that you then used look like?
Are you getting any error messages?
Regards,
Tobias
Hello,
I was able to import as csv all i did was edit the 2 bars at the beginning and end and remove them so i got as below and imported as csv…thanks.
RANK|COUNTRY|SCORE
1|Country A|74
2|Country b|70
3|Country c|69
4|Country d|3
Hi,
ah, nice find! Hadn’t really noticed those. Yes, if you remove them, this looks like regular CSV. Good to hear that importing worked with that!
Best wishes,
Tobias
P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!
