bad import, not processed #8323

Hello,

Why a got 2 errrors? line 14 and 164?

What is the error you are seeing? Can you post a screenshot of it?

And a see only update old articles!!
new content is not added
template id - 14
why?

You are seeing only update in your import because of id field in your import file. CSVI will add or update a article based on id field. If id field is available in import file, it will do an update else will do an insert of article. Remove this id field for new article and your import will be good.

Hello Anton,

You should not mess with the IDs, it is the job of the database to manage the IDs. When you edit articles via Joomla you can't control the ID either but you use the alias field for this. So do the same with the import.

Hello Anton,

ok, but script ignored field creation date!
how to add article or product with own different creation date?

if i add without id, it added as a new product and creation date is today date!

Since you are creating new articles your created date is today's date, It works the same when you create an article from Joomla article manager where you cannot have your own creation date.

i am move old products and materials from other site and i need that creation date was different by my file

The only option i can think of is you do a custom table import to Joomla contents table where you have only id and created as template fields and update the date as you want.

Hello Anton,

I see you are doing a custom table import, this means CSVI doesn't do any data validation. Which can be perfectly fine of course if that is what the goal is.

The problem with the import file in this case is that you are missing the primary key of the content table so CSVI is never able to find the record you want to update. That is why nothing gets updated.

The other problem is the value of the created field. The database needs a value like YYYY-MM-DD HH:II:SS, so it would look like 2015-12-31 23:59:59.

The regular Joomla content import sets the current date if you import a new article or updates the modified date if you are modifying an article.

The primary key is the unique identifier of an item. In your case, each article has an ID, this is the primary key. You may want to create an export template of the type CSVI Pro -> Custom table -> Content table. Add the fields id, title and created. After you export that file you can change the created value as you like and run the import with that file.

Have you changed the date/time format in your template? If not, if you see this in a spreadsheet, the spreadsheet is changing the format. Check the file with a basic text editor and it should be the same as it is in the database.

In any case, to import it must be the format I gave you.

Hello Anton,

Why i do export and are not field exporting?
content table consist 179 field - in export file - only 143 fields!!!
Why?

Are the rest of the fields published?

Hello Anton,

how to say to scrip to avoid several fields?

Add all the fields in your file to the template by going to Templates -> Template Fields. The fields you do not want to import, select the field type skip. CSVI will skip these fields during import.

fieldname choose skip - between othe fields?

What is the question?

Whats field equal product_title?

This is the product_name.

tittle for product? for meta?

Check the documentation for products and for Meta information