MySQL Forums
Forum List  »  MySQL for Excel

Re: Cannot edit table in Excel
Posted by: naveen ganpat
Date: February 14, 2016 08:26AM

Dear Javier, Shay,
First let me start by apologising that I did not read your reaction that you asked for further information. I think I read over it the first time around. Please see my answers to the questions (both latest blog as well as previous blog).
To start of some background information. The table I am trying to edit is based in a database of Wordpress (CMS). I am trying to make some changes in the back-end. The table we are talking about is called wp_posts
1. Can you consistently duplicate this with any table?
• Yes, other tables I can both import AND edit in Excel.
2. If it is a specific table only, what data types do the columns have?

Name Type Collation Attributes Null Default Extra
1 ID bigint(20) UNSIGNED No None AUTO_INCREMENT
2 post_author bigint(20) UNSIGNED No 0
4 post_date datetime No 0000-00-00 00:00:00
6 post_date_gmt datetime No 0000-00-00 00:00:00
8 post_content longtext No None
10 post_title text No None
12 post_excerpt text No None
14 post_status varchar(20) No publish
16 comment_status varchar(20) No open
18 ping_status varchar(20) No open
20 post_password varchar(20) No
22 post_name varchar(200) No
24 to_ping text No None
26 pinged text No None
28 post_modified datetime No 0000-00-00 00:00:00
30 post_modified_gmt datetime No 0000-00-00 00:00:00
32 post_content_filtered longtext No None
34 post_parent bigint(20) UNSIGNED No 0
36 guid varchar(255) No
38 menu_order int(11) No 0
40 post_type varchar(20) No post
42 post_mime_type varchar(100) No
44 comment_count bigint(20) No 0


column Sample information
1 1743
2 1
4 42023.72
6 42023.72
8 [vc_row bg_type="image" bg_grad="background: -webkit-gradient(linear, left top, left bottom, color-stop(0%, #E3E3E3));background: -moz-linear-gradient(top,#E3E3E3 0%);background: -webkit-linear-gradient(top,#E3E3E3 0%);background: -o-linear-gradient(top,#E3E3E3 0%);background: -ms-linear-gradient(top,#E3E3E3 0%);background: linear-gradient(top,#E3E3E3 0%);" parallax_style="vcpb-vz-jquery" bg_image_repeat="repeat" bg_image_size="cover" bg_img_attach="scroll" parallax_sense="25" animation_direction="left-animation" animation_repeat="repeat" video_opts="" bg_override="full" parallax_content_sense="30" fadeout_start_effect="30" overlay_pattern_opacity="80" multi_color_overlay="" multi_color_overlay_opacity="0.6" seperator_type="none_seperator" seperator_position="top_seperator" seperator_shape_size="40" seperator_svg_height="60" seperator_shape_background="#ffffff" seperator_shape_border="none" seperator_shape_border_width="1" icon_type="no_icon" icon_size="32" icon_style="none" icon_color_border="#333333" icon_border_size="1" icon_border_radius="500" icon_border_spacing="50" img_width="48" ult_hide_row_large_screen="off" ult_hide_row_desktop="off" ult_hide_row_tablet="off" ult_hide_row_tablet_small="off" ult_hide_row_mobile="off" ult_hide_row_mobile_large="off" bg_image_new="1745" disable_on_mobile_img_parallax="off" bg_color_value="#000000" viewport_vdo="off" enable_controls="off" overlay_pattern_attachment="fixed" css=".vc_custom_1424954380605{padding-top: 60px !important;padding-bottom: 60px !important;}" parallax_content="parallax_content_value" fadeout_row="off" enable_overlay="off" overlay_pattern="transperant"][vc_column width="1/1"][ultimate_heading heading_tag="h2" alignment="center" spacer="no_spacer" spacer_position="top" spacer_img_width="48" line_style="solid" line_height="1" line_color="#333333" icon_type="selector" icon_size="32" icon_style="none" icon_color_border="#333333" icon_border_size="1" icon_border_radius="500" icon_border_spacing="50" img_width="48" line_icon_fixer="10" main_heading_font_family="font_family:Open Sans|font_call:Open+Sans|variant:600" main_heading_style="font-weight:600;" main_heading_font_size="45" main_heading_color="#ffffff" sub_heading_font_family="font_family:Open Sans|font_call:Open+Sans|variant:300" sub_heading_style="font-weight:300;" sub_heading_font_size="16" sub_heading_color="#ffffff" main_heading="CATEGORY <strong>BANNER</strong>" el_class="heading-bold"]Set banners and description for any category of your website.[/ultimate_heading][/vc_column][/vc_row]
10 Parallax Banner
12
14 publish
16 closed
18 closed
20
22 parallax-banner
24
26
28 42195.08
30 42195.08
32
34 0
36 http://newsmartwave.net/wordpress/porto/dummy/?post_type=block&#038;p=1743
38 0
40 block
42
44 0




3. What Office Version are you using? What version of MySQL for Excel?
• Excel 2013 32-bit
• MySQL 1.3.6
• MySQL Installer 1.4


4. Are you getting any error message? If not, do you see any error messages in the application log found at %APPDATA%\Oracle\MySQL for Excel?

=>> I am not able to locate this folder / log file. Please can you indicate where I should look? I am using Windows 7.



Thanks again.

Naveen

Options: ReplyQuote


Subject
Views
Written By
Posted
1917
January 23, 2016 06:57AM
1133
January 25, 2016 03:04PM
1101
January 26, 2016 05:51PM
978
January 29, 2016 01:40PM
1018
February 03, 2016 02:54PM
Re: Cannot edit table in Excel
1203
February 14, 2016 08:26AM
1103
February 22, 2016 04:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.