Categories
View Replies (3)

Resolved Custom Table

  1. davidex21
    davidex21
  2. RO CSVI
  3. Monday, 25 January 2021
  4.  Subscribe via email
Hello. I should export an acymailing field (field_id) and be sure that it is linked to the email of the virtuemart user who placed an order (who has the same email).
The field_id field resides in the acymailing table: acym_user_has_field

How can I do?
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
You can run the export using Advanced custom table export template. In the template on Options tab you join the tables you need to get the data and add needed export template fields based on the selected tables.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
davidex21
davidex21
Accepted Answer Pending Moderation
it is not clear to me how to set field join table and join field. I don't understand how it works
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
You need field_id from acym_user_has_field table in export, so you should select this as main table. VirtueMart user table will be a join table and join field will be email address which will be join field for both these table. I don't have acymailing extension installed so in the attached screenshot i have connect two tables #__virtuemart_products and #__virtuemart_products_en_gb which are joined by virtuemart_product_id field. You should use the same way to connect acymailing and virtuemart tables.

Let me know if it is clear.
Attachments (1)
Screenshot 2021-01-26 at 2.57.31 PM.png Screenshot 2021-01-26 at 2.57.31 PM.png
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!