VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: mirra on November 13, 2011, 08:30:52 AM

Title: Independent development of export-import
Post by: mirra on November 13, 2011, 08:30:52 AM
Module import and export goods through the format of the csv.

The module is intended for export and import data from the shop Virtue Mart and tested on Joomla 1.5.22 and VM 1.1.6 (although tried previous versions of Joomla 1.5.25 and VM 1.1.9.

This program is not a competitor com_csv_improved but only a complement for specific tasks.

Demonstration site (Joomla 2.5.9, VM 2.0.20b) http://mirra.hol.es

To save in OpenOffice with the following parameters need to select Save As, at the set
a) CHANGE tick filter settings and SAVE with the parameters separator character ^
b) Text delimiter character ~, encoding Cyrillic (Windows-1251))

In order to export and import data into a csv file to:
1. Install the module from the archive mod_hellofrom.zip. As a result of installation, a new module Export Import.
2. Configure the module (position: left, Access: specifically to run the module at the entrance to a administrator password.)
3. The result of the program will be a file Export export.csv being in the root folder of joomla. (This file can be downloaded via FTP client or a link module)
4. The result of the program will be appended to the Import VM product from a file located import.csv in the root folder of joomla. This file must be downloaded using an FTP client or the module itself. If the import is to be established for categories of goods, they will create automatically. If the product is already in the database, then re-entered it will not.
5. Pictures of products which are referenced in the CSV file must be written using an FTP client
  in the directory \ components \ com_virtuemart \ shop_image \ product for VM 1.9
  in the directory \ images \ stories \ virtuemart \ product for VM2
The structure of the data files export and import of the following

These columns are filled in the file import.csv (one line for each item):
1. A good article
2. Product name
3. Price
4. Currency
5. Name of the category
6. Brief description of the goods
7. Full product description
8. Small picture of the goods
9. Big picture of the goods
10. Products available
11. Item ID
12. Category ID
13. Parent category

Current - Made module mod_hellofrom_2.0.20_ru_ru (in attachment). All previous issues are solved with prices
30/07/2012 - :) good day did the module for Joomla_2.5.6, VM 2.0.8e (mod_hellofrom_2.0.8_en-GB, mod_hellofrom_2.0.8_ru_ru)
16/12/2011 - Module for VM 2.0.0_RC3
Because the new version has changed several tables in her previous modules do not work.
17/11/2011 - mod_hellofrom_1.9.8.RC2.zip for Joomla 1.7, VM Virtuemart1.9.8.RC2k
22/05/2011 - In the program, the coefficient of price changes of goods
02/04/2011 - In the program mode appeared commodity price adjustment
02/03/2011 - The program now exports and imports by category
06/02/2011 - The program is a module Joomla 1.5

Brief description (instructions) and test case (examples of CSV files) in the archive. ;)
The program consists of two sub-Export and Import. To read the file I used export.csv . The archive module has a sample file export.csv . Encoding Cyrillic (UTF8) module is also available in the archive file example import.csv .

OUR RUSSIAN FORUMS
http://biola.ltd.ua/index.php?option=com_kunena&view=topic&catid=2&id=9&Itemid=215
Title: Re: Independent development of export-import
Post by: JtouchMobile.com on November 15, 2011, 03:25:18 AM
Very useful for site has more goods need to be imported!
Suggest that you have a tutorial with screenshots ;)

Cheers,
Title: Re: Independent development of export-import
Post by: mirra on November 15, 2011, 06:27:11 AM
Unfortunately not yet made

There is only readmy.txt  in archive module

Install as a normal module

The module is intended for export and import data from the shop Virtue Mart

(He began to write himself because he was tired tune com_csv_improved)


The program consists of two sub-Export and Import

The archive module has a sample file export.csv To read the file I used export.csv

OpenOffice .

while asking as a separator character ^ but as the text delimiter character ~, encoding

Cyrillic (UTF8) module is also available in the archive file example import.csv

delimiter character ^ but as the text delimiter character ~, encoding Cyrillic (Windows-1251).

(To save in OpenOffice with the following parameters need to select Save As, at the set

CHANGE tick filter settings and SAVE with the parameters delimiter character ^

text delimiter character ~, encoding Cyrillic (Windows-1251))

In order to export and import data into a csv file to

1. Install the module from the archive mod_hellofrom.zip. As a result of installation, a new module

Export Import.

2. Configure the module (position: left, Access: specifically to run the module at the entrance to a

administrator password.)

3. The result of the program will be a file Export export.csv being

in the root folder of joomla. (This file can be downloaded via FTP client or a link module)

4. The result of the program will be appended to the Import VM product from a file located import.csv

in the root folder of joomla. (This file must be downloaded using an FTP client or the module itself)

(If the import is to be established for categories of goods, they will create automatically.

If the product is already in the database, then re-entered it will not)

5. Pictures of products which are referenced in the CSV file must be written using an FTP client

in the directory \ images \ stories \ virtuemart \ product


Yours

Prisada Alexander

Title: Re: Independent development of export-import
Post by: groentjie on November 17, 2011, 22:20:52 PM
How can we make changes like, export custom fields and import custom fields.
also add fields like weight etc
Title: Re: Independent development of export-import
Post by: mirra on November 18, 2011, 04:36:03 AM
Hello
Initially, our shop size and weight of goods
role not played (they are not very large). But it was very convenient for a year that data structure is not changed. In the near future I plan to make full English version of the module and Activities change data structures to take account of what you say (in fact it is not difficult).
Title: Re: Independent development of export-import
Post by: dominiosclave on December 19, 2011, 07:13:03 AM
What file for RC3?
Title: Re: Independent development of export-import
Post by: mirra on December 29, 2011, 03:39:05 AM
hello

If you have VM 2.0.0 RC3 or VM 2.0.0
it needs a module mod_hellofrom_2.0.0_RC3.zip (in attachment)
because these stores have changed the database

If you have VM 1.9.8 RC2 need a module mod_hellofrom_1.9.8.RC2

If you have a VM 1.1.x you need a module mod_hellofrom_1.1.9

(Apparently I did not clear it was written.)

[attachment cleanup by admin]
Title: Re: Independent development of export-import
Post by: nouespai on January 19, 2012, 16:24:40 PM
Hi Mirra,

Thanks for your work.

Your latest module works in joomla 1.7 and VM 2.0 ?

My english is not very good and I'm not sure if I understood well the post.
Title: Re: Independent development of export-import
Post by: Clocked0ne on January 20, 2012, 01:05:03 AM
Yes, he is saying that if you use VM 2.0 you need to use the download mod file for 2.0RC3 as this is the latest version supporting the RC3/final database changes. :)

Great work on this, I have a site with a large number of products and cannot wait to try your new English version when it becomes available, excellent  ;D
Title: Re: Independent development of export-import
Post by: jenkinhill on January 20, 2012, 09:39:54 AM
Thanks for the headsup, BT, I have been using CSVI4 beta2 which is already impressive. Also good to see an alternative being developed.
Title: Re: Independent development of export-import
Post by: mirra on January 21, 2012, 09:23:16 AM
Hello.
I would like the next version of the module to significantly expand, change the format of the data.
Therefore, much will need to alter significantly and it will take some time.
Yours
Alexander Prisada
:)
Title: Re: Independent development of export-import
Post by: mirra on January 23, 2012, 05:18:19 AM
Found that the module was not working on WAMP.
Corrected this error.

EDIT: Attachments removed as suspicious
Title: Re: Independent development of export-import
Post by: mirra on March 08, 2012, 06:46:12 AM
Corrected module to store com_virtuemart.2.0.2

:)

EDIT: Attachments removed as suspicious
Title: Re: Independent development of export-import
Post by: mirra on July 30, 2012, 09:07:23 AM
good day
did the module
mod_hellofrom_2.0.8_en-GB
mod_hellofrom_2.0.8_ru_ru
checked on
Joomla_2.5.6-Stable-Full_Package
com_virtuemart.2.0.8e_extract_first
A brief description and a test case in the archive module

EDIT: Attachments removed as suspicious
Title: Re: Independent development of export-import
Post by: mirra on February 11, 2013, 02:32:02 AM
hello

In an attachment, the English version of the module

mod_hellofrom_en_2.0.18a_en-GB.zip checked with Joomla_2.5.9-Stable-Full_Package

mod_hellofrom_en_2.0.18a_ru-RU.zip checked with Joomla_2.5.6-Stable-Full_Package_Russian_v3

EDIT: Attachments removed as suspicious
Title: Re: Independent development of export-import
Post by: mirra on April 07, 2013, 07:41:13 AM
Made module
mod_hellofrom_2.0.20_ru_ru (in attachment)

All previous issues are solved with prices

Edit by MikeUK: Attachments removed as unclear content or posters intention.
Title: Re: Independent development of export-import
Post by: Milbo on June 12, 2013, 21:32:00 PM
Do you post it in 3rd party components?
Title: Re: Independent development of export-import
Post by: mirra on December 15, 2014, 06:38:18 AM
Module made by VM 3.0.2 yet on Russian. The other day translate

Edit by MikeUK: Attachments removed as unclear content or posters intention.
Title: Re: Independent development of export-import
Post by: Maxim Pishnyak on December 20, 2014, 13:10:50 PM
No web site in English for your extension?
Title: Re: Independent development of export-import
Post by: mirra on April 16, 2015, 05:31:10 AM
Program to promote your site by automatically display its pages.
Entered in the file URL_LIST your sitemap URL from, display when viewing in seconds per page and click the Preview button (for the program needed framework 4.0)

Edit by MikeUK: Attachments removed as unclear content or posters intention.
Title: Re: Independent development of export-import
Post by: Studio 42 on November 25, 2016, 22:09:58 PM
Quote from: Milbo on June 12, 2013, 21:32:00 PM
Do you post it in 3rd party components?

DO you checked the ZIP max ? I think you remove your message, when you look inside
Title: Re: Independent development of export-import
Post by: MikeUK on November 25, 2016, 22:50:06 PM
Quote from: Studio 42 on November 25, 2016, 22:09:58 PM
Quote from: Milbo on June 12, 2013, 21:32:00 PM
Do you post it in 3rd party components?

DO you checked the ZIP max ? I think you remove your message, when you look inside

Looks like you've got a point. Attachments posted have been removed as they could be dangerous to other VM users.

And hello all! Been a while.