Re: [dotcms] Content Identified Update For Content field

[Jason Tesser]

does your csv have an identifier column. and what options are you clicking when importing 

On Tue, Nov 7, 2017 at 12:09 PM Kumar <gsuj...@gmail.com> wrote:

Hi,

I am trying to import the external data to dotcms as content.I have totally around 400 records to be imported into dotcms.But i end up getting just around 385-390 records.

When I observed in the logs it updates the same field with different content identifiers.Instead of creating new content identifiers for each record, It creates for few and updates for few .Can any know how to resolve the issue ??

Attached is the issue I am facing presently

Creating New Content..   Study Id : 2971  -    - content identifier : d623e289-b929-4cde-8f1d-1392399a8523
Creating New Content..   Study Id : 2971  -    - content identifier : d2f38931-bc92-46c8-989a-9eb0e20634af
Creating New Content..   Study Id : 2971  -    - content identifier : ff425b00-c684-404f-86fd-4dd24ca9d48e
Creating New Content..   Study Id : 2971  -    - content identifier : 790b0021-287b-4e71-b38a-19cb98c281de
Updating New Content..  2971  -    - content identifier : d623e289-b929-4cde-8f1d-1392399a8523
Updating New Content..  2971  -    - content identifier : d2f38931-bc92-46c8-989a-9eb0e20634af
Creating New Content..   Study Id : 2971  -    - content identifier : 751aa675-cd72-4d8b-b67c-4136bbc2f4ab
Creating New Content..   Study Id : 2971  -    - content identifier : 2eb84ea9-87d0-4eb1-b05d-58acb89d710d
Creating New Content..   Study Id : 2971  -    - content identifier : 0edb0caa-4275-4991-a3aa-996be2f40e7a
Updating New Content..  2971  -    - content identifier : d2f38931-bc92-46c8-989a-9eb0e20634af
Updating New Content..  2971  -    - content identifier : d2f38931-bc92-46c8-989a-9eb0e20634af
Updating New Content..  2971  -    - content identifier : ff425b00-c684-404f-86fd-4dd24ca9d48e
Updating New Content..  2971  -    - content identifier : d2f38931-bc92-46c8-989a-9eb0e20634af
Updating New Content..  2971  -    - content identifier : ff425b00-c684-404f-86fd-4dd24ca9d48e
Updating New Content..  2971  -    - content identifier : ff425b00-c684-404f-86fd-4dd24ca9d48e
Updating New Content..  2971  -    - content identifier : ff425b00-c684-404f-86fd-4dd24ca9d48e
Updating New Content..  2971  -    - content identifier : ff425b00-c684-404f-86fd-4dd24ca9d48e
Updating New Content..  2971  -    - content identifier : d2f38931-bc92-46c8-989a-9eb0e20634af
Updating New Content..  2971  -    - content identifier : d2f38931-bc92-46c8-989a-9eb0e20634af
Updating New Content..  2971  -    - content identifier : d2f38931-bc92-46c8-989a-9eb0e20634af

--
http://dotcms.com - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com.
To post to this group, send email to dot...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/62c4fd97-4996-4d20-90f4-29b4739f729f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Jason Tesser]

No identifiers are the version id.  So if a content has 10 versions with a field change in each they ALL share the same identifier.  Inode is the version id 

On Tue, Nov 7, 2017 at 12:33 PM <gsuj...@gmail.com> wrote:

In the CSV file, i can see only the last updated content Identifier field.Actually, it should create new content Identifier everytime the new field is added, But it is updating instead.

Attached is the screenshot of the file.

To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/c61fd1ec-b940-4d8d-ba3a-b59a11638aaf%40googlegroups.com.

[Mark Pitely]

Kumar,

Could you post the CSV you are *importing* from?  That might give us more information about this.

As asked, you are not using identifiers in that data, right? Are you importing into a structure that already has content? Are you marking any field as 'key' during the import, or getting any warnings from the preview?

Any one of these things might be affecting it. Normally, you would not get 'inconsistent results' - I think you are missing some piece of this, which is perfectly understandable as it is rather arbitrary.

Mark Pitely

Marywood University

On Tue, Nov 7, 2017 at 1:50 PM, <gsuj...@gmail.com> wrote:

Here is one of the case Where you can see the below attachment where it creates new content Identifier for the new content Created.This is the issue I am facing due to the inconsistent results 

On Tuesday, 7 November 2017 11:49:44 UTC-6, sujeeth kumar wrote:

But, Here we can see the content identifier created new for some contents and Updated for few contents 

But, when I try to import the data in the local dotcms, I would get the new content identifier for each content Import.When I run the same plugin in Test/Staging dotcms environment I see the content getting updated, Instead creating a new content

To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+unsubscribe@googlegroups.com.

To post to this group, send email to dot...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/c4d8432d-eefc-45d3-abdc-e986ff122000%40googlegroups.com.

[Mark Pitely]

Okay, you are using handwritten/bespoke CODE to do the import, not the backend 'Import Content' tool (which is right where you were doing the export)? That looks like javascript, too, rather than Velocity.

That's an important distinction!

Mark Pitely

On Tue, Nov 7, 2017 at 3:06 PM, <gsuj...@gmail.com> wrote:

I did not get any exceptions while importing the content.

Below is the Query used 

// See if this Study exists using the StudyId

String query = "+structureName:" + studyInformation + " +"

+ studyInformation + "." + StudyId  + ":\""

+ studyId()+ "\"";

On Tuesday, 7 November 2017 14:01:00 UTC-6, sujeeth kumar wrote:

I am Exporting the CSV file from the content structure.No, I am not using the content Identifiers in my data.Whenever we export the CSV file from content, The CSV file data would be getting content Identifiers right.I am trying to import the new content.Have archived and deleted the old Content.I am querying on the StudyId and importing the content.

To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/c4d8432d-eefc-45d3-abdc-e986ff122000%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
http://dotcms.com - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+unsubscribe@googlegroups.com.
To post to this group, send email to dot...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/5caf99f9-bfaa-489f-a697-87f22c973985%40googlegroups.com.