WordPress.org

1. kiwia
   Member
   Posted 3 years ago #
   

   Hi, Can anyone shed some light on best way to import existing spreadsheet into wordpress with this plugin.

   Have tried saving spreadsheet from excel as csv, html and xml but all lose their formating when usiing the plugin to import the table?

   Any guidance much appreciated.

2. TobiasBg
   Member
   Posted 3 years ago #
   

   Hi,

   thanks for your question!

   The plugin will only import the data (numbers, strings, etc.) from your table.
   It will NOT import formatting (because that actually doesn't get exported in CSV for example.)
   (To me, "formatting" means fonts, font-sizes, colors, and so on. If you mean something else with "formatting", please clarify.)

   You will have to re-apply the formatting (or styling) with CSS after importing.

   Hope this helps,
   Tobias

3. cohsmama
   Member
   Posted 3 years ago #
   

   I think I've got a similar question. When I try to import a CSV file on Excel I end up with

   ���������������������������������þÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ

   in most of the fields.

   Any thoughts?

4. TobiasBg
   Member
   Posted 3 years ago #
   

   Hi,

   this is most likely related to a different character encoding used in your table's CSV file. Have you stored it in UTF-8 encoding?

   Additionally it is possible that certain characters cause trouble (i.e. false quotation marks).

   If you can find any reason, please email the CSV file to me and I'll have a look at it. My address is in the "Imprint" on my website or in the main php file of the plugin.

   Regards,
   Tobias

5. xdg99667
   Member
   Posted 3 years ago #
   

   Hi there

   Firstly great plugin, I'm a bit new to all this wordpress world but it looks fantastic.

   I've got the problem where I've made me a table, put the shortcode in a page, previewed the post and its all gravy

   now I've published the post, if I navigate to it by URL of the post (http://www.2ponies.com/free-tips-back-place-results/) everything is fine however when i try to get to it by following the relevant category structure it loses all of its well table things (http://www.2ponies.com/category/results/place-bets-results/)

   This might be a silly question and I appologise if it is but I cant figure out whats going on

   thanks

   Gary.

6. TobiasBg
   Member
   Posted 3 years ago #
   

   Hi Gary,

   this is very likely caused by your theme.

   The theme does not show posts/pages in their entirety on category overview pages. (Within the theme folder, this probably is in one of the files category.php or archive.php.)
   The code to look for is "the_content()". Most probably there is some
   function applied around it that strips the HTML from the text. (This is
   actually a valid procedure for some projects, where the category overview page is, well, just an overview, but in your case it is hurting.)

   So, you have several possibilities, I guess: Fix the issue in the theme, or change to a different theme. :-)

   To really confirm, I suggest changing your page to the WordPress Default Theme and see if the problem happens there on those URLs.

   Hope this helps.

   Best wishes,
   Tobias

Topic Closed

This topic has been closed to new replies.