Resolved Timeout while Preview/Import

Hello Chris,

Is this normal?

I hope not :silly:

So I tried your CSV file and the preview is instant here, as expected with such a small file. Does it happen every time and with any file? If so, I am thinking that maybe there is an issue with the folder permissions. You can check the About page to see if there is any permission issue with the folders CSVI uses.

Thanks Roland,

Checked the permissions, they are ok. I managed to get it working, i don't know exactly how, but maybe it helps:

I went into the template settings and disabled logging. Then it previewed the file properly. I reenabled the logging, still ok. So maybe the save of the template settings did the trick? (hadn't done this since the creation of the template)

Now i get a new error when importing, see below:

An error has occured during the import. Below the information received from the server.
Status error: 200
Status message: OK

Notice: unserialize(): Error at offset 0 of 3 bytes in /administrator/components/com_csvi/addon/com_virtuemart/helper/com_virtuemart_config.php on line 90

Notice: unserialize(): Error at offset 0 of 45 bytes in /administrator/components/com_csvi/addon/com_virtuemart/helper/com_virtuemart_config.php on line 86

Notice: unserialize(): Error at offset 0 of 3 bytes in /administrator/components/com_csvi/addon/com_virtuemart/helper/com_virtuemart_config.php on line 90

Notice: unserialize(): Error at offset 0 of 16 bytes in /administrator/components/com_csvi/addon/com_virtuemart/helper/com_virtuemart_config.php on line 90

.... (There are many lines similar to the above going on forever :P )

Rgrds,
Chris

Hey Chris,

Re-saving the template makes sense. Actually every template must be saved twice the first time round because when you create a template CSVI has no clue what kind of template it is. So you save it the first time saying it is a product import template for example. Then the other tabs become visible and you need to save it again so those options are known as well. I am still looking for a more elegant solution to that.

(There are many lines similar to the above going on forever :P )

Very pretty :silly:

This indicates something is off with your VirtueMart config in the database. If you know how, could you please check the virtuemart_configs table and see what is stored in the field config? I wonder what is in there.

Hi Roland,

Sure, here it is: (Virtuemart version is 3.0.6.2)

shop_is_offline="0"|offline_message="Our Shop is currently down for maintenance. Please check back again soon."|use_as_catalog="0"|currency_converter_module="convertECB.php"|order_mail_html="1"|useSSL="0"|dangeroustools="0"|debug_enable="none"|google_jquery="1"|multix="none"|usefancy="1"|jchosen="0"|pdf_button_enable="1"|show_emailfriend="1"|show_printicon="1"|show_out_of_stock_products="1"|coupons_enable="1"|show_uncat_child_products="0"|coupons_default_expire="1,D"|weight_unit_default="KG"|lwh_unit_default="M"|list_limit="20"|showReviewFor="all"|reviewMode="registered"|showRatingFor="all"|ratingMode="registered"|reviews_autopublish="1"|reviews_minimum_comment_length="50"|reviews_maximum_comment_length="500"|vmtemplate="default"|categorytemplate="default"|showCategory="0"|categorylayout="0"|categories_per_row="3"|productlayout="0"|products_per_row="3"|vmlayout="0"|show_store_desc="0"|show_categories="0"|homepage_categories_per_row="4"|homepage_products_per_row="3"|show_featured="1"|featured_products_rows="1"|show_topTen="0"|topTen_products_rows="1"|show_recent="0"|recent_products_rows="1"|show_latest="1"|latest_products_rows="1"|assets_general_path="components\/com_virtuemart\/assets\/"|media_category_path="images\/stories\/virtuemart\/category\/"|media_product_path="images\/stories\/virtuemart\/product\/"|media_manufacturer_path="images\/stories\/virtuemart\/manufacturer\/"|media_vendor_path="images\/stories\/virtuemart\/vendor\/"|forSale_path_thumb="images\/stories\/virtuemart\/forSale\/resized\/"|img_resize_enable="1"|img_width="200"|img_height="200"|no_image_set="noimage.gif"|no_image_found="warning.png"|browse_orderby_field="product_name"|browse_orderby_fields=["product_name","product_s_desc","category_name","mf_name"]|browse_search_fields=["product_name","product_s_desc","category_name","category_description","mf_name"]|show_prices="1"|price_show_packaging_pricelabel="0"|show_tax="1"|basePrice="0"|basePriceText="1"|basePriceRounding="-1"|variantModification="0"|variantModificationText="1"|variantModificationRounding="-1"|basePriceVariant="0"|basePriceVariantText="1"|basePriceVariantRounding="-1"|basePriceWithTax="1"|basePriceWithTaxText="0"|basePriceWithTaxRounding="-1"|discountedPriceWithoutTax="0"|discountedPriceWithoutTaxText="1"|discountedPriceWithoutTaxRounding="-1"|salesPriceWithDiscount="0"|salesPriceWithDiscountText="0"|salesPriceWithDiscountRounding="-1"|salesPrice="1"|salesPriceText="0"|salesPriceRounding="-1"|priceWithoutTax="0"|priceWithoutTaxText="1"|priceWithoutTaxRounding="-1"|discountAmount="0"|discountAmountText="0"|discountAmountRounding="-1"|taxAmount="0"|taxAmountText="1"|taxAmountRounding="-1"|addtocart_popup="1"|check_stock="0"|automatic_payment="1"|automatic_shipment="1"|agree_to_tos_onorder="1"|oncheckout_show_legal_info="1"|oncheckout_show_register="0"|oncheckout_show_steps="1"|oncheckout_show_register_text="COM_VIRTUEMART_ONCHECKOUT_DEFAULT_TEXT_REGISTER"|inv_os=["C"]|email_os_s=["U","C","X","R","S"]|email_os_v=["U","C","X","R"]|seo_disabled="0"|seo_translate="0"|seo_use_id="0"|enable_content_plugin="0"|reg_captcha="0"|active_languages=["en-US","nl-NL","ru-RU","pt-BR","it-IT","en-AU","es-ES","de-DE","en-GB","pt-PT","fr-FR","nb-NO","el-GR","sv-SE"]|enableEnglish="1"|useVendorEmail="1"|multixcart="0"|pdf_icon="1"|recommend_unauth="1"|ask_captcha="1"|ask_question="1"|asks_minimum_comment_length="50"|asks_maximum_comment_length="2000"|handle_404="1"|cp_rm=["C"]|product_navigation="1"|display_stock="1"|show_pcustoms="1"|show_uncat_parent_products="0"|show_unpub_cat_products="1"|latest_products_days="90"|latest_products_orderBy="created_on"|lstockmail="0"|stockhandle="disableadd"|rised_availability="2-3d.gif"|image="2-3d.gif"|rr_os=["C"]|show_manufacturers="1"|productsublayout="0"|manufacturer_per_row="3"|mediaLimit="20"|llimit_init_BE="20"|pagseq=""|llimit_init_FE="6"|pagseq_1="3,6,9,18,36"|pagseq_2=""|pagseq_3="3,6,9,18,36"|pagseq_4=""|pagseq_5=""|feed_cat_published="0"|feed_cat_show_images="0"|feed_cat_show_prices="0"|feed_cat_show_description="0"|feed_cat_description_type="product_s_desc"|feed_cat_max_text_length="500"|forSale_path="\/home\/qttest\/vmfiles\/"|add_img_main="1"|feed_latest_published="0"|feed_latest_nb="5"|feed_topten_published="0"|feed_topten_nb="5"|feed_featured_published="0"|feed_featured_nb="5"|feed_home_show_images="0"|feed_home_show_prices="0"|feed_home_show_description="0"|feed_home_description_type="product_s_desc"|feed_home_max_text_length="500"|css="1"|jquery="1"|jprice="1"|jsite="1"|askprice="1"|rappenrundung="0"|roundindig="0"|cVarswT="1"|unitPrice="0"|unitPriceText="0"|unitPriceRounding="2"|popup_rel="1"|oncheckout_opc="0"|set_automatic_shipment="-1"|set_automatic_payment="-1"|oncheckout_only_registered="1"|oncheckout_show_images="1"|vmlang_js="1"|oncheckout_change_shopper="1"|del_date_type="m"|attach=""|attach_os=["U","C","X","R"]|prd_brws_orderby_dir="ASC"|browse_cat_orderby_field="category_name"|cat_brws_orderby_dir="ASC"|seo_sufix="-detail"|task="apply"|option="com_virtuemart"|view="config"|86f22a402a55c2b990585e086bfbb94f="1"

Rgrds,
Chris

Hey Chris,

Sure enough I saw the same problems as you did with your config. All I will say about this is that it is fixed and this type of config is handled as well in the attached patch file.

If you load the patch file you should be able to run your import.

Thanks Roland, that did the trick

So, managed to import the small rating file i sent you. Used the minimum fields as per your article here:

http://www.csvimproved.com/en/support/import/203-virtuemart/1060-import-virtuemart-2-ratings

Maybe things are abit changed in VM3, so noticed the following:

- Review is imported and showing in frontend, however it is not showing in backend (Virtuemart -> Products -> Reviews and Ratings) so it is not manageable anymore from within VM.
- CSVI creates entries in _virtuemart_rating_reviews and _virtuemart_rating_votes tables, but is is not creating an entry in _virtuemart_ratings table like when you manually create a review.

Rgrds,
Chris

Hello Chris,

but is is not creating an entry in _virtuemart_ratings table like when you manually create a review.

That should be happening though. Can you post your debug log?

Hi Roland,

Sure, pls see attached.

Also noticed that when i click to download the debug file, the php contained in the zip is empty (0 bytes). The attached file is just a select all-copy from the Show/Open options.

Rgrds,
Chris

Hello Chris,

The download of the debug log seems to be troublesome since Joomla 3.4.0, I have to take a look at that. Thanks for the log, I will check it.

Hey Chris,

This one I believe to have found as well and fixed of course. Attached patch file adds the rating also to the ratings table, I was able to see it from the backend now.

Thanks Roland, it is working ok now and i can see the rating in backend

I have some trouble with importing the date for the created_on field. What is the proper format? I tried to export some existing records to see the format of CSVI but i saw some weird ones in the exported csv like:

"created_on"
"3Europe/Athens3Europe/AthensSun, 08 Mar 2015 03:56:19 +0200amSunday"

Rgrds,
Chris

Hello Chris,

The format of the date format is "YYYY-MM-DD HH:MM:SS" or to give a real example 2013-02-02 10:00:00.

As for the exported date, it looks like you have something odd with the settings. Did you set a date format in your template?

Hello Roland,

The format of the date format is "YYYY-MM-DD HH:MM:SS" or to give a real example 2013-02-02 10:00:00.

That was it, thanks!

Did you set a date format in your template?

Didn't do anything special. How can you set a date format?

Rgrds,
Chris

Hey Chris,

My bad, this template doesn't have the option indeed to set the date format in the template. I should add it because the code does expect it. This explains the weird date you see.