Help for Aimeos

alpin3rocker wrote:Is there out of the box a functional product import/export or should this be configured? Is there a sample csv available with demo-products to import this manually?

alpin3rocker wrote: Should i start with an extension or is it in the most cases enough to place the changes in the Scheduler tasks in the TypoScript configuration?
like this:

Code: Select all

controller.jobs.product.export.location = http://www.mydomain.com/aiexport

alpin3rocker wrote: I clicked the "Export" function in the Product area of the shop admin Interface and than i started a before created Scheduler Task "Product export" manually.
In the Shop Admin i can see that the Product export succeeded. Where is the exported file stored?

plugin.tx_aimeos {
 settings {       
        controller.jobs.product.export.location = /home/.../web/typo3temp/aimeos/

        controller.jobs.product.import.csv {
            location = /home/.../web/typo3temp/aimeos/
            container.content = CSV
        }
}

• Are there some minimum requirements for the CSV like the miniumum amount of columns (required columns) beside the ones shown here https://aimeos.org/docs/Developers/Cont ... and_format
• Is there an example CSV file which can be downloaded?
• Where do I have to place the configuration array with the mapping codes shown here https://aimeos.org/docs/Developers/Cont ... lt_mapping

AndyH wrote:

Code: Select all

plugin.tx_aimeos {
 settings {       
        controller.jobs.product.import.csv {
            location = /home/.../web/typo3temp/aimeos/
        }
}

AndyH wrote: I also created a simple CSV test file with one product, imported it in the "Product" tab and after a while in the "Overview" tab the message occured "Product text import: test-import.csv" with status green/check. When switching back to tab "Product" unfortunatelly no new entry can be found (and also not in table mshop_product).

AndyH wrote: [*] Are there some minimum requirements for the CSV like the miniumum amount of columns (required columns) beside the ones shown here https://aimeos.org/docs/Developers/Cont ... and_format

AndyH wrote: [*] Is there an example CSV file which can be downloaded?

AndyH wrote: [*] Where do I have to place the configuration array with the mapping codes shown here https://aimeos.org/docs/Developers/Cont ... lt_mapping

• start your scheduler with the command "php typo3/cli_dispatch.phpsh scheduler" from the bash in your document root of your website (don't jump into the typo3 folder because of the symlinks. The script will assume a wrong path for typo3conf folder). If you're using application contexts in your AdditionalConfiguration.php than you have to use "TYPO3_CONTEXT=Development php typo3/cli_dispatch.phpsh scheduler".
• Check if you have mysqli also running for the php5-cli. To find out see the phpinfo by typing "php -i"
  • (php5-cli uses a different php.ini as your webserver. On ubuntu/linux you can find the config file with "php -i |grep php\.ini")
  • In /etc/php5/cli/conf.d/20-mysqli.ini make sure that extension=mysqli.so is not commented out (;)

plugin.tx_aimeos {
    settings {
        controller.jobs.product.import.csv {
            location = /home/.../website_3/web/typo3temp/aimeos/
            mapping {
				item {
					0 = product.code
					1 = product.label
					2 = product.type
					3 = product.status
				}
				text {
					4 = text.type
					5 = text.content
					6 = text.type
					7 = text.content
				}
				media {
					8 = media.url
				}
				price {
					9 = price.quantity
					10 = price.value
					11 = price.taxrate
					12 = price.currencyid
				}
				attribute {
					13 = attribute.type
					14 = attribute.code
				}
				product {
					15 = product.code
					16 = product.list.type
				}
				property {
					17 = product.property.value
					18 = product.property.type
				}
				catalog {
					19 = catalog.code
					20 = catalog.list.type
				}
            }
        }
	}
}

<INCLUDE_TYPOSCRIPT: source="FILE:EXT:myaimeosext/Configuration/TypoScript/ext/aimeos/scheduler.ts">

AndyH wrote: After I added your csv file and changed the TS config, I tried to run the scheduler with the current logged into be user manually. This failed and created some pseudo products with some php code.

AndyH wrote: Is there a way to include the TypoScript code in the scheduler task from a file like

Code: Select all

<INCLUDE_TYPOSCRIPT: source="FILE:EXT:myaimeosext/Configuration/TypoScript/ext/aimeos/scheduler.ts">

so that it can be under version control? I did not find a way to get it working.