Categories
View Replies (5)

Resolved Export: Is it possible to join two tables?

  1. stubr
    stubr
  2. RO CSVI
  3. Wednesday, 28 May 2014
  4.  Subscribe via email
Hi
We have two tables users / jsn_users. We would like to join those two tables, and export some fields from users, and other fields from jsn_users. Is this possible whit CSVI Pro (v5.17), and if yes, how can we do this?

Thanks a lot for any advice.
Bernhard
0
Responses (5)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Bernhard,

With the custom table import/export it is not possible to join tables. It is a very basic 1 table import/export.

The only solution would be to write your own import/export routine.
Kind regards,

RolandD

=========================
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
PCo
PCo
Accepted Answer Pending Moderation

The only solution would be to write your own import/export routine.


Is that possible to solve with CSVI Pro?

Thx in advance,
Pierre.
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Pierre,

Even with CSVI Pro, you will need to write your own import/export routine.
Kind regards,

RolandD

=========================
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
PCo
PCo
Accepted Answer Pending Moderation
Hello Rolandd,

yes, that sentence I did read :-)
But I do not know what that means. Do I have to write a plugin for CSVI, or is there a field available which could manage it. Or more simpler asked: How can I join two tables?

I am practiced with the custom fields and sql and I have a query which does a table LEFTJOIN for a complete csv for a special export of more than the available fields of (for e.g.) included order-products, -users and so on.
So now I try to realize an based sql statement (which is including 2 or more tables) and I do not get it to work with CSVI :-)
Please point me a direction.

Best regards,
Pierre.
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Pierre,

But I do not know what that means.
Check the manual, Override import/export routines.

Or more simpler asked: How can I join two tables?
You can't unless you write the code.

Check the article on overrides, it should make things clearer.
Kind regards,

RolandD

=========================
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. # 5
  • Page :
  • 1


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