1. ssanchezmtz
  2. RO CSVI
  3. Tuesday, 23 July 2019
  4.  Subscribe via email
Hi,

Im having a multilingual site, and Im very interested to import with custom table, for the table, "associations", I made a template, to export, I put the 3 fields of that table, and I get perfectly the actual associations. But when I use the import template with all possible configurations, after the process of import I only get the status of:

Processed 34
Filename Master - IMPORT ASSOCIATION.csv
Debug log No debug log found

But there is no change on any table on my db.

There may be something that I am not contemplating?

Thanks in advance
---
Sergio
Accepted Answer Pending Moderation
Hello Sergio,
Im having a multilingual site, and Im very interested to import with custom table, for the table, "associations",

You don't need to use custom table import but can import associations using Joomla content import.

To import associations you can use field associations in your import file with multi languages set like "nl-NL#article-alias|el-gr#article-alias" where article-alias is the alias of the specific language article.

Processed 34
Filename Master - IMPORT ASSOCIATION.csv
Debug log No debug log found

Take a look at How to get debug information? document to get the debug log.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hi, Thanks for your reply,

I want to add the associations of categories, articles and menus, via the table associations, because y only need to provide, ID, CONTEXT and KEY, I already made some SQL injections to the table and the associations works perfectly, so thats the way I will try to associate all my objects in all the 3 languages with Im working.

I could already enable the debug and It shows me this message on all the rows:

1 Skipped Notice Item context => com_categories.item not updated because the option overwrite existing data is set to No

I read the table, and there are no values named item context, there is a column name context, and with the CVSI export, I already export the values of the table and It gives me this:

"id","context","key"
"8","com_categories.item","170c944978496731ba71f34c25826a34"
"84","com_categories.item","170c944978496731ba71f34c25826a34"

So mi CSV to import, has the same header row, an the same files, so Im not sure that If I enable the overwrite existing data dont affect other tables, or other contents. The import field, that Im using is for create new values on the association table, so there is no explanation for the overwrite warning.

Im just want your opinion, if you recomen to me to enable this features of overwrite.

Thanks for the support

---
Sergio
  1. 3 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Sergio,
1 Skipped Notice Item context => com_categories.item not updated because the option overwrite existing data is set to No

In your import template on File tab you have set Overwrite existing data to No which means you are telling CSVI to not to update any existing records. So only new items will be inserted.

I read the table, and there are no values named item context, there is a column name context, and with the CVSI export, I already export the values of the table and It gives me this:

The value com_categories.item is under column context. I guess in your import template on Options tab, you have set Import based on field as context. You should be setting a field with unique values here like primary key field of a table and not a field which can have duplicates. The use of import based on field is to check if the record already exists in database and update the values. If the record does not exists already a new row will be inserted.

So mi CSV to import, has the same header row, an the same files, so Im not sure that If I enable the overwrite existing data dont affect other tables, or other contents. The import field, that Im using is for create new values on the association table, so there is no explanation for the overwrite warning.

Enabling overwrite existing data will not affect any other table other than the one you have set in your import template.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
HI,

After trying with the overwrite, I could notice that the CSVI directly select the context column as primary key, so in the Import Template, on the Option Tab, I just define the id, as the import based on, and works perfectly.

Thanks for the support and your patience.

---
Sergio
  1. 3 weeks ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Sergio,
I could notice that the CSVI directly select the context column as primary key,

I won't agree to this statement. CSVI does not set any field on its own. By default the Import based on field will look like attached screenshot. The import based on field is specifically set by the user in his template.

so in the Import Template, on the Option Tab, I just define the id, as the import based on, and works perfectly.

Glad to know that you got it working.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
I just has a last question about your documentation of Joomla content import.

If I had an article with some ID, I could export the information to that article, and update only the title, intro text, full text, and the category? Or I need to add more columns to the update?

To update the category of an article, I could just set the catid without the category_path?

Thanks for your replies.
---
Sergio
  1. 3 weeks ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello Sergio,
If I had an article with some ID, I could export the information to that article, and update only the title, intro text, full text, and the category? Or I need to add more columns to the update?

CSVI needs few required fields on import to check if the record exists in database, for Joomla content import you need to have alias and category_path or catid field in your import file. You can add other fields which are to be updated along with these needed fields.

To update the category of an article, I could just set the catid without the category_path?

Yes you can use catid field without the category_path if you are sure that the id you use in your import file exists in the database.
Kind regards,

Tharuna

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


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