Post by BigDaddyHotGue » Wed Oct 21, 2015 9:12 am

It seems that I've got an installation problem. Export/Import Tool (V2.27). My OpenCart v2.0.1.0.

I have followed the readme.txt instructions to the letter.
There is an issue with these steps:
Step 5)
Go to System > Users > User Group > Edit Administrator
Step 6)
Set access and modify permissions for 'tool/export_import'

'tool/export_import' IS NOT LISTED. All options are checked and I have looked at every line available and 'tool/export_import' is simply not in the list.

As a result, when going to Tools > Export/Import I am presented with a permissions error message indicating that I don't have permissions to access.

Help...??
Last edited by BigDaddyHotGue on Thu Oct 22, 2015 4:52 pm, edited 1 time in total.


Posts

Joined
Wed Oct 21, 2015 8:58 am

Post by andrey55555 » Wed Oct 21, 2015 8:46 pm

Hi
I have opencart-1-5-5-1-2.
I am download opencart-1-5-1-to-1-5-6-x-export-import-multilingual-2-27.zip
It's good tools, but I found bugs.
If update alone category by 'category_id' - all 'CategoryFilters' will delete.

I looked php code.
May be error in "protected function getAvailableCategoryIds" ?

Original version:

Code: Select all

	protected function getAvailableCategoryIds() {
		$sql = "SELECT `category_id` FROM `".DB_PREFIX."category`;";
		$result = $this->db->query( $sql );
		$category_ids = array();
		foreach ($result->rows as $row) {
			$category_ids[$row['category_id']] = $row['category_id'];
		}
		return $category_ids;
	}
My version (like "protected function getAvailableProductIds"):

Code: Select all

	protected function getAvailableCategoryIds(&$data) {
		$available_category_ids = array();
		$k = $data->getHighestRow();
		for ($i=1; $i<$k; $i+=1) {
			$j = 1;
			$category_id = trim($this->getCell($data,$i,$j++));
			if ($category_id=="") {
				continue;
			}
			$available_category_ids[$category_id] = $category_id;
		}
		return $available_category_ids;
	}
I right ?

Newbie

Posts

Joined
Wed Oct 21, 2015 8:22 pm

Post by filipe_silva86 » Sun Oct 25, 2015 12:34 am

Hello,

I don't know why but i have this error right now:

2015-10-24 15:01:59 - PHP Notice: Error: Duplicate entry '116-278' for key 'PRIMARY'<br />Error No: 1062<br /> Error in: <b>/home/******/public_html/admin/model/tool/export_import.php</b> line <b>857</b><br />INSERT INTO `oc_product_related` (`product_id`,`related_id`) VALUES
(116,290),
(116, 278),
(116, 280),
(116, 295),
(116, 278); in /home/******/public_html/system/library/db/mysql.php on line 55

Can you help me to solve this problema ?

Thanks


Posts

Joined
Sat Aug 08, 2015 7:00 pm

Post by yaris » Wed Oct 28, 2015 7:52 pm

I had similar problem,
- unzip opencart-2-x-export-import-multilingual-2-27.ocmod.zip
- rename install.xml to install.ocmod.xml
- go to Extension Installer and upload install.ocmod.xml
- install.ocmod.xml uploaded successfully and i can see it in modifications

Only problem is its not visible in user groups

Newbie

Posts

Joined
Wed Oct 28, 2015 7:47 pm

Post by JNeuhoff » Thu Oct 29, 2015 4:27 am

yaris wrote:I had similar problem,
- unzip opencart-2-x-export-import-multilingual-2-27.ocmod.zip
- rename install.xml to install.ocmod.xml
- go to Extension Installer and upload install.ocmod.xml
- install.ocmod.xml uploaded successfully and i can see it in modifications

Only problem is its not visible in user groups
Please follow the readme.txt instructions for the installation, and make sure you have the FTP root correctly configured. Your above mentioned approach won't work. If you have problems with FTP, use iSenseLabs installer fix.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by ajojavi » Thu Oct 29, 2015 10:48 pm

Hi, I have read all the post and I did not find my problem.
I have installed 2.1.0.1
I have installed vqmod and works
I have changed my admin name folder so I have change name of admin folder of the module and in the "install file"
Now when I try to install opencart-2-x-export-import-multilingual-2-27.ocmod , and in the middle of the process I get this: (60% of the process - copying files)

Not Found

Not Found

<!DOCTYPE html>
<!--[if IE 7]> <html lang="en" class="ie7 responsive"> <![endif]-->
<!--[if IE 8]> <html lang="en" class="ie8 responsive"> <![endif]-->
<!--[if IE 9]> <html lang="en" class="ie9 responsive"> <![endif]-->
<!--[if !IE]><!--> <html lang="en" class="responsive"> <!--<![endif]-->
<head>
<title>The page you requested cannot be found!</title>
<base href="http://fluid-house.com/" />

<!-- Meta -->
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">

<link href="http://fluid-house.com/image/catalog/cart.png" rel="icon" />
<!-- Google Fonts -->
<link href='https://fonts.googleapis.com/css?family ... t,cyrillic' rel='stylesheet' type='text/css'>




<link rel="stylesheet" type="text/css" href="catalog/view/theme/superstar/css/bootstrap.css" />
<link rel="stylesheet" type="text/css" href="catalog/view/theme/superstar/css/stylesheet.css" />
<link rel="stylesheet" type="text/css" href="catalog/view/theme/superstar/css/responsive.css" />
<link rel="stylesheet" type="text/css" href="catalog/view/theme/superstar/css/menu.css" />
<link rel="stylesheet" type="text/css" href="catalog/view/theme/superstar/css/font-awesome.min.css" />
<link rel="stylesheet" type="text/css" href="catalog/view/theme/superstar/css/owl.carousel.css" />
<link rel="stylesheet" type="text/css" href="catalog/view/theme/superstar/css/blog-news.css" />
<link rel="stylesheet" type="text/css" href="catalog/view/theme/superstar/css/slider.css" />
<link rel="stylesheet" type="text/css" href="catalog/view/theme/superstar/css/slidebars.css" />
<link rel="stylesheet" type="text/css" href="catalog/view/theme/superstar/css/magnific-popup.css" />
<link rel="stylesheet" type="text/css" href="catalog/view/theme/superstar/css/brainyfilter.css" />
<link rel="stylesheet" type="text/css" href="catalog/view/theme/superstar/css/wide-grid.css" />








<script type="text/javascript" src="catalog/view/theme/superstar/js/jquery.min.js"></script>
<script type="text/javascript" src="catalog/view/theme/superstar/js/jquery-migrate-1.2.1.min.js"></script>
<script type="text/javascript" src="catalog/view/theme/superstar/js/jquery.easing.1.3.js"></script>
<script type="text/javascript" src="catalog/view/theme/superstar/js/bootstrap.min.js"></script>
<script type="text/javascript" src="catalog/view/theme/superstar/js/twitter-bootstrap-hover-dropdown.js"></script>
<script type="text/javascript" src="catalog/view/theme/superstar/js/common.js"></script>
<script type="text/javascript" src="catalog/view/theme/superstar/js/slidebars.js"></script>
<script type="text/javascript" src="catalog/view/theme/superstar/js/jquery.cookie.js"></script>
<script type="text/javascript" src="catalog/view/theme/superstar/js/brainyfilter.js"></script>
<script type="text/javascript" src="catalog/view/theme/superstar/js/jquery.ui.touch-punch.min.js"></script>
<script type="text/javascript" src="catalog/view/theme/superstar/js/jquery.themepunch.plugins.min.js"></script>

<script type="text/javascript" src="catalog/view/theme/superstar/js/jquery.themepunch.revolution.min.js"></script>
<script type="text/javascript" src="catalog/view/theme/superstar/js/jquery.magnific-popup.min.js"></script>



<script type="text/javascript" src="catalog/view/theme/superstar/js/owl.carousel.min.js"></script>
<script type="text/javascript" src="catalog/view/theme/superstar/js/jquery.jcarousel.min.js"></script>
<script type="text/javascript">
var transition = 'slide';
var animation_time = 300;
var checkout_url = 'http://fluid-house.com/index.php?route= ... t/checkout';
</script>



<!--[if lt IE 9]>
<script src="http://html5shim.googlecode.com/svn/tru ... "></script>
<script src="catalog/view/theme/superstar/js/respond.min.js"></script>
<![endif]-->
</head>
<body>




<div id="notification" class="modal fade">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
<h4 class="modal-title" style="font-family: "Roboto Condensed",sans-serif!important;">Confirmation</h4>
</div>
<div class="modal-body">
<p></p>
</div>
<div class="modal-footer">
<button type="button" class="button modal-left-button" data-dismiss="modal">Continue Shopping</button>
<a href="http://fluid-house.com/index.php?route=checkout/cart" class="button modal-right-button">View Cart</a>
</div>
</div>
</div>
</div>

<div id="quickview" class="modal fade bs-example-modal-lg">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" style="text-align:left;" data-dismiss="modal" aria-hidden="true">&times;</button>
<h4 class="modal-title">Product</h4>
</div>
<div class="modal-body">
<p></p>
</div>
</div>
</div>
</div>




<script type="text/javascript">
$('body').on('click', '.quickview a', function () {
$('#quickview .modal-header .modal-title').html($(this).attr('title'));
$('#quickview .modal-body').load($(this).attr('rel') + ' #quickview_product' ,function(result){
$('#quickview').modal('show');
$('#quickview .popup-gallery').magnificPopup({
delegate: 'a',
type: 'image',
tLoading: 'Loading image #%curr%...',
mainClass: 'mfp-img-mobile',
gallery: {
enabled: true,
navigateByImgClick: true,
preload: [0,1] // Will preload 0 - before current, and 1 after the current image
},
image: {
tError: '<a href="%url%">The image #%curr%</a> could not be loaded.',
titleSrc: function(item) {
return item.el.attr('title');
}
}
});
});
return false;
});

$('#quickview').on('click', '#button-cart', function () {
$('#quickview').modal('hide');
cart.add($(this).attr("rel"));
});
</script>



<header>

<!-- Column Left Fixed -->
<div id="column_left_fixed" class="sb-slidebar sb-momentum-scrolling sb-left visible-lg col-sm-2 tg-padding-right sb-width-custom">
<div class="tg-logo"><a href="http://fluid-house.com/index.php?route= ... me">Column Left Fixed Text</a></div>
<span class="tg-close sb-close"></span>
<div class="clfixed_wrapper">

<div style="margin-bottom: 10px; margin-top: 20px;">
<a href="https://www.facebook.com/fluidhouse/" class="fa fa-facebook facebook" target="_blank" style="font-size: 18px; "></a>
<a href="https://twitter.com/Fluidhouse" class="fa fa-twitter twitter" target="_blank" style="font-size: 18px; "></a>



<a href="https://instagram.com/fluidhouse/" class="fa fa-instagram instagram" target="_blank" style="font-size: 18px; "></a>




<a href="https://google.com/+FluidHouseplus" class="fa fa-google-plus googleplus" target="_blank" style="font-size: 18px; "></a>




<a href="https://es.pinterest.com/fluidhouse/" class="fa fa- fa-pinterest pinterest" target="_blank" style="font-size: 18px; "></a>




<a href="https://www.youtube.com/channel/UCsj2Mb ... yp7juUJxNg" class="fa fa- fa-youtube youtube" target="_blank" style="font-size: 18px; "></a>




<a href="https://www.flickr.com/photos/128417732@N06/albums" class="fa fa- fa-flickr flickr" target="_blank" style="font-size: 18px; "></a>






</div>

<div class="box hidden-xs">

<div class="box-heading2">Latest</div>
<div class="box-content products ">
<div class="box-product">
<div id="myCarousel4223076" >
<!-- Carousel items -->
<div class="carousel-inner">
<div class="active item"><div class="product-grid"><div class="row"> <div class="col-sm-12 col-xs-6">

<!-- Product -->
<div class="product clearfix">
<div class="left">
<div class="sale">-10%</div>

<div class="image">



<div class="flybar hidden-xs hidden-sm hidden-md">

<div class="compare">
<a onclick="compare.add('42');" title="Add to compare" class="fa fa-external-link product-icon"></a></a>
</div>

<div class="quickview">
<a rel="http://fluid-house.com/test" title="Apple Cinema 30"" class="fa fa-search"></a>
</div>

<div class="wishlist">
<a onclick="wishlist.add('42');" title="Add to wishlist" class="fa fa-heart-o product-icon"></a></a>
</div>

<div class="addtocart">
<a onclick="cart.add('42');" class="button"><span>Add to cart</span></a>
</div>
</div>


<a href="http://fluid-house.com/test">
<img src="http://fluid-house.com/image/cache/catalog/demo

Any idea?

Best,

New member

Posts

Joined
Thu Oct 24, 2013 8:51 pm
Location - Spain

Post by JNeuhoff » Thu Oct 29, 2015 11:30 pm

ajojavi wrote:Hi, I have read all the post and I did not find my problem.
I have installed 2.1.0.1
I have installed vqmod and works
I have changed my admin name folder so I have change name of admin folder of the module and in the "install file"
Now when I try to install opencart-2-x-export-import-multilingual-2-27.ocmod , and in the middle of the process I get this: (60% of the process - copying files)
First of all, you don't need VQmod for the Export/Import tool on 2.1.0.1. Secondly, you are using a non-standard OpenCart configuration, e.g. renamed 'admin'. This is bound to cause problems with many extensions. The Export/Import tool has been successfully tested on standard OpenCart versions.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by ajojavi » Thu Oct 29, 2015 11:48 pm

Ok, now I am going to remove the issue because now is happening wiht some modules not just yours, so it have to be something tricky... sorry and best regards
Last edited by ajojavi on Tue Nov 03, 2015 3:40 pm, edited 2 times in total.

New member

Posts

Joined
Thu Oct 24, 2013 8:51 pm
Location - Spain

Post by schiggi » Fri Oct 30, 2015 2:05 am

Just a quick question: What does the option "phpTemp Cache" do? Is it somehow better or more reliable as the standard version?

New member

Posts

Joined
Tue May 13, 2014 4:23 am

Post by 4squares » Tue Nov 03, 2015 3:51 am

JNeuhoff wrote:The only thing to do is this:
Go to admin backend at Extensions > Modifications, from there select the 'Export/Import Tool for OpenCart 2.x' and then click on the Delete button at to top right. That's it.

After that, install as per the 'readme.txt' instructions.
This method is for ver 2x but how to remove the old version and install the new version of your extension in 1.5.6.4.
Thanks

User avatar
Newbie

Posts

Joined
Mon Nov 02, 2015 3:53 am

Post by bhy » Wed Nov 04, 2015 8:24 pm

bhy wrote:
I could not get the mod installer to work so I uploaded the files via ftp. I have since refreshed Modifications as well several times.

I am able to see the tool in the User Groups but it does not show up on the Tools Menu or in the Modifications list either.

I am using OC 2.0.3.1 with the Journal 2 Theme and opencart-2-0-x-export-import-multilingual-2-26.ocmod.zip

I have not installed vqmod as I thought I didn't have to with 2.0.

What might I have missed?
TAC, this is exactly the problem I have.

I think I may have found a solution, but didn't have time to test it yet.

The key is the file install.xml inside the opencart-2-0-x-export-import-multilingual-2-26.ocmod.zip file.

If you look at it, you can see it's probably supposed to modify some files -- notably admin/controller/common/menu.php and some others -- and add the respective menu entries in them in order for the extension to be accessible.

When the installation process doesn't work and you upload the extension manually, these changes of course don't happen. That's why you can't see the tool in the administration. It should be possible to modify the files such as menu.php manually, according to what's described in the install.xml file. It's a dirty hack but it should work.

As I said, I didn't have time to test that yet, if you can try it I'll be happy to hear whether you succeeded or not, otherwise I'll get back to you here after I can test it myself.
So, actually I got it fixed using the Installer fix mentioned many times in this thread. I had no idea this could be related to FTP access as I have FTP access enabled and the error messages indicated the problem was something completely different. So, please try the Installer fix if you have any issues with installing this extension, no matter whether the problem seems to be FTP-related or not.

bhy
New member

Posts

Joined
Fri Jul 17, 2015 7:28 pm

Post by pompey » Fri Nov 06, 2015 6:22 am

Hello!

I donwloaded this extension. Very good extension, but i have some problems with picture import.
When i try to make import, i don`t see any problem.
I see a message - Success: You have successfully imported your data!

But after i don`t see no one picture on frontend of my store. In Error log no any info.

I added all images to FTP folder /image/items/
I try to choose different ways for images:
www.mysite.com/image/items/image1.jpg
/image/items/image1.jpg

I can open images by direct link... so... with my link all ok.
I try all variants... i try to delete all products before via phpMyAdmin, I try tp clear cache in all places, like admin, image or vqMod... No any results - no one image was not added...

Can you answer - what`s problem?

Newbie

Posts

Joined
Fri Nov 06, 2015 6:15 am

User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by pompey » Sun Nov 08, 2015 3:11 am

JNeuhoff wrote:Images should be listed as items/image-1.png etc.
Thank you! It`s work...

But extension don`t give me to make only 1 photo in listing.... I must to add additional images to second list of my .xls file.

How can i import items only with one photo and without any attributes and options?

Newbie

Posts

Joined
Fri Nov 06, 2015 6:15 am

Post by JNeuhoff » Sun Nov 08, 2015 3:54 am

Leave the worksheets for AdditionalImages, ProductOptions, ProductOptionValues, ProductAttributes empty if you don't have additional products images, nor attributes, nor options.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by fastuning » Thu Nov 12, 2015 7:55 pm

i have a problem importing in 2.0 from 1.5

Export/Import: Invalid header in the Categories worksheet
Export/Import: Invalid header in the Products worksheet

what could happen?

Newbie

Posts

Joined
Mon Nov 05, 2012 5:09 pm

Post by JNeuhoff » Thu Nov 12, 2015 9:37 pm

Do an Export first from your OpenCart 2.x and then use the resulting spreadsheet to copy and paste your data from your old spreadsheet to the new one before the new import. The spreadsheet formats for OpenCart 1.5.x and 2.x are different!

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by ceramics » Tue Nov 17, 2015 11:28 am

When I click the refresh button to rebuild the modification cache after installing this plugin I get the following error:

Code: Select all

Fatal error: Call to a member function getElementsByTagName() on a non-object in /home/mauricet/ceramics.mauricetheriot.com/admin/controller/extension/modification.php on line 453
Please assist. Thank you in advance for the support.

Newbie

Posts

Joined
Tue Nov 17, 2015 11:27 am

Post by JNeuhoff » Tue Nov 17, 2015 11:01 pm

ceramics wrote:When I click the refresh button to rebuild the modification cache after installing this plugin I get the following error:

Code: Select all

Fatal error: Call to a member function getElementsByTagName() on a non-object in /home/mauricet/ceramics.mauricetheriot.com/admin/controller/extension/modification.php on line 453
Please assist. Thank you in advance for the support.
Unable to reproduce your error. Can you give us some more details? Line 453 is an empty line in a standard OpenCart 2.0.3.1 or 2.1.0.1, so are you not telling us the whole story.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by kazihaha » Wed Nov 18, 2015 4:56 pm

Could you add ability to export Download List for product?

https://sieuthithietbivanphong.com


New member

Posts

Joined
Wed Sep 23, 2015 2:13 pm
Who is online

Users browsing this forum: No registered users and 6 guests