Uploading Products to MySQL via ODBC connection

[1stDuncan]

We have set an external link in Actinic to a MySQL database which has our site products. The link works fine as it pulled the data into Actinic and allows us to update those products.

The problem is it doesn't perform an insert if we create the product in Actinic (which is what we want to happen).

Has anyone done this? Reading through the help documentation it doesn't specifically mention inserting products/records. Pulling the data & updating is.

Is it possible to insert records with this feature and if yes - how?

Thanks,

[gabrielcrowe]

you need this feller:
http://www.interact-studio.co.uk/aca...Connector.html

done and dusted.

[Jan]

When you insert products, they are put in a section at the bottom of the screen - unallocated external products and you can then drag them into the correct section. Another way to do this to create a dummy product with the correct reference in the correct section (you generate a flat import file from your SQL data to make this easy), then the product data will automatically link to this product.

Regards,

[fergusw]

Duncan,
Is the mySQL database local to the PC/network or housed on a web server?

If it is local then make sure you have "Enable updates to external data" and "Link all products to external data if available" ticked.

[1stDuncan]

Insert not possible?

The SQL database is attached to the site hosting plan. I'm using the MySQL Connector/ODBC 3.51 program to create the link.

I have ticked all 3 options on the LHS of the External Link dialog.

I take it from the plugin that Gabe has linked to, Actinic does not natively support inserting records into an external table. Is that correct?

Regards,

[Jan]

I take it from the plugin that Gabe has linked to, Actinic does not natively support inserting records into an external table. Is that correct?

That's right, it will update if the product exists but it won't create it in the external link. I misread your post initially and thought you were creating the product in your external database and wanted it to appear in Actinic.

Jan.