Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • René 327 posts 852 karma points
    Aug 14, 2014 @ 23:48
    René
    0

    Import - saved definition

    Using CMSImport

    Hi

    I cant get the import to work. 

    I have this structure for importing the products

    For the relation i have this in the excel.

    1 Category(CategoryParentId)

    2  CategoryId(CategoryParentId) 

    3  ProductsID (CategoryId)

    4 Variant (ProductsId)

     

     

    I get the category to show but i cant get the producta and variants to show.

    When i look in the database CMSImportRelation i can see both the products and variants. 

    4744764257Excel filecategoryId1
    6044894476Excel filecategoryId14
    6144904476Excel filecategoryId15
    6244914476Excel filecategoryId16
    6344924476Excel filecategoryId17
    9945284489d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId1
    10045294489d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId2
    10145304489d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId3
    10245314489d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId4
    10345324489d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId5
    10445334489d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId6
    10545344489d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId7
    10645354490d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId8
    10745364490d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId9
    10845374490d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId10
    10945384490d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId11
    11045394490d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId12
    11145404490d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId13
    11245414490d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId14
    11345424491d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId15
    11445434491d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId16
    11545444491d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId17
    11645454491d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId18
    11745464491d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId19
    11845474491d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId20
    11945484491d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId21
    12045494492d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId22
    12145504492d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId23
    12245514492d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId24
    12345524492d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId25
    12445534492d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId26
    12545544492d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId27
    12645554492d877a128-76b0-4f47-97c7-5a9ab8a63d9bExcel fileproductId28
    15845934257Excel filecategoryId2
    15945944257Excel filecategoryId3
    16045954257Excel filecategoryId4
    16145964257Excel filecategoryId5
    16245974257Excel filecategoryId6
    16345984257Excel filecategoryId7
    16445994257Excel filecategoryId8
    16546004257Excel filecategoryId9
    16646014257Excel filecategoryId10
    16746024257Excel filecategoryId11
    16846034257Excel filecategoryId12
    16946044257Excel filecategoryId13
    17046054593Excel filecategoryId18
    17146064593Excel filecategoryId19
    17246074593Excel filecategoryId20
    17346084593Excel filecategoryId21
    17446094594Excel filecategoryId22
    17546104594Excel filecategoryId23
    17646114594Excel filecategoryId24
    17746124594Excel filecategoryId25
    17846134595Excel filecategoryId26
    17946144595Excel filecategoryId27
    18046154596Excel filecategoryId28
    18146164596Excel filecategoryId29
    18246174596Excel filecategoryId30
    18346184596Excel filecategoryId31
    18446194597Excel filecategoryId32
    18546204597Excel filecategoryId33
    18646214597Excel filecategoryId34
    18746224597Excel filecategoryId35
    18846234598Excel filecategoryId36
    18946244598Excel filecategoryId37
    19046254598Excel filecategoryId38
    19146264598Excel filecategoryId39
    19246274599Excel filecategoryId40
    19346284599Excel filecategoryId41
    19446294599Excel filecategoryId42
    19546304600Excel filecategoryId43
    19646314600Excel filecategoryId44
    19746324601Excel filecategoryId45
    19846334601Excel filecategoryId46
    19946344602Excel filecategoryId47
    20046354602Excel filecategoryId48
    20146364602Excel filecategoryId49
    20246374603Excel filecategoryId50
    20346384603Excel filecategoryId51
    20446394603Excel filecategoryId52
    20546404528943e18aa-3051-44ab-aeee-bc9f00b781eaExcel filevariantId1
    20646414528943e18aa-3051-44ab-aeee-bc9f00b781eaExcel filevariantId2
    20746424528943e18aa-3051-44ab-aeee-bc9f00b781eaExcel filevariantId3
    20846434528943e18aa-3051-44ab-aeee-bc9f00b781eaExcel filevariantId4
    20946444528943e18aa-3051-44ab-aeee-bc9f00b781eaExcel filevariantId5
    21046454528943e18aa-3051-44ab-aeee-bc9f00b781eaExcel filevariantId6

    Any ideas... 

    René 

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Aug 15, 2014 @ 07:29
    Richard Soeteman
    0

    Relations seem ok. Can you verify that the categories you see have the following ids

    4476 4489 4490 4491 4492

    One category has a different parent than the others that si also weird. But I have seen before that the recycle bin was updated so better check the id's first :)

    Copy Link
  • René 327 posts 852 karma points
    Aug 15, 2014 @ 08:17
    René
    0

    Hi Richard

    The id´s for the nodes i see. 

    4257
    -- 4593
    ---- 4605
    ---- 4606
    ---- 4607
    ---- 4608

    René 

     

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Aug 15, 2014 @ 08:22
    Richard Soeteman
    100

    Hi René,

    Then that is the problem. Your imported categories id's are different than the imported ones. Updating the relation table is easiest I think. Just update the id's with the ones you see. Otherwise search for the other documents and move them to the correct location

    Best,

    Richard

    Copy Link
  • René 327 posts 852 karma points
    Aug 15, 2014 @ 08:25
    René
    0

    HI again 

    Yesterday i deleted all the nodes, for trying again. If i understand this correct, if i delete the nodes i must delete the saved definition too. 

    René

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Aug 15, 2014 @ 08:31
    Richard Soeteman
    0

    Hi René,

    No don't need to do that. When deleting these relation records will be deleted to.

    Best,

    Richard

    Copy Link
  • René 327 posts 852 karma points
    Aug 15, 2014 @ 10:50
    René
    0

    Finaly i got it working.

    I updated the id´s in the database for the products, and the id for the variant. 

    After i updated the variant id i searched for the node in the Umbraco backend and moved it to the right place. and then it works. 

    René 

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft