Copied to clipboard

Flag this post as spam?

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


  • Ulf Möllerström 67 posts 233 karma points
    Oct 04, 2017 @ 09:00
    Ulf Möllerström
    0

    Failing import: Multinode Treepicker (MNTP2)

    Hi,

    Trying to import "brands" on products, but that doesn't work...

    I've tested two different setups of the datatype/MNTP: both xPath and just selecting the start node.

    I've also tested changing to node name, instead of id.

    Brands can be selected manually on a single product.

    Versions: CmsImport 3.7.2 Umbraco version 7.6.5

  • Richard Soeteman 4031 posts 12817 karma points MVP
    Oct 04, 2017 @ 13:13
    Richard Soeteman
    0

    Hi,

    It should work with NodeName(not Id) when the document with the same name exists it should create a reference on the PRO version. I assume you have documents on Brands with the same name?

    Best,

    Richard

  • Ulf Möllerström 67 posts 233 karma points
    Oct 04, 2017 @ 13:58
    Ulf Möllerström
    0

    Dear Richard,

    Yes, the brands have the same node names as in the import file.

    Re-running the import with brand mapped to the name instead of node-id, generates the following error when viewing a product/node in back office:

    Server error: Contact administrator, see log for full details. Failed to retrieve entity data for ids Fa**e

    Regards /Ulf

  • Richard Soeteman 4031 posts 12817 karma points MVP
    Oct 05, 2017 @ 05:38
    Richard Soeteman
    0

    Hmm seem like mapping didn't happen if it shows you the normal names. Sure names are exactly the same?

  • Ulf Möllerström 67 posts 233 karma points
    Oct 05, 2017 @ 07:50
    Ulf Möllerström
    0

    Richard,

    Yes, the names are copy-pasted from back office into the import file (had also a second pair of eyes on that).

    In umbraco.config the imported values show up like

    <brand><![CDATA[Fa**e ]]></brand>
    

    and a manually added brand on a product

    <brand><![CDATA[umb://document/*GUID-ID*]]></brand>
    

    (If it is of any importance?)

    /Ulf

  • Richard Soeteman 4031 posts 12817 karma points MVP
    Oct 10, 2017 @ 10:41
    Richard Soeteman
    1

    Hi,

    There was an issue with the picker indeed. Can you check with this version?

    Best,

    Richard

  • Robert 33 posts 172 karma points
    Feb 12, 2018 @ 16:10
    Robert
    0

    I am using the latest version of CMS Import pro but I have the same error as above. I have a collection of document types in the root called "Services" and these have a name and id. I have another document type at the same level in the root called "Packages" and one of the fields on the Package type is a Multinode Treepicker2 which points to the Services node as Package can have multiple child services. When running a CMSImport for Packages I pass across a Service name which exists but it does not map and I get the error: Failed to retrieve entity data for ids "blah blah blah". Any ideas how to fix?

  • Richard Soeteman 4031 posts 12817 karma points MVP
    Feb 13, 2018 @ 07:50
    Richard Soeteman
    0

    Hi Robert Have you tried withy the hotfix release as well?

  • Robert 33 posts 172 karma points
    Feb 13, 2018 @ 09:31
    Robert
    0

    No, I tried the link to the dropbox above but it returns a 404. Where can I get the hotfix release?

  • Richard Soeteman 4031 posts 12817 karma points MVP
    Feb 13, 2018 @ 09:43
    Richard Soeteman
    0

    This one should be ok for now https://www.dropbox.com/s/kg4pglvlkk7n11d/cmsimport37_4.zip?dl=0

  • Robert 33 posts 172 karma points
    Feb 13, 2018 @ 10:02
    Robert
    0

    Hi Richard I installed the hotfix and it works if I pass a csv list of names. However when I pass a csv list of ID's it does not map. How can we get the ID csv list to map?

  • Richard Soeteman 4031 posts 12817 karma points MVP
    Feb 13, 2018 @ 10:23
    Richard Soeteman
    0

    Hi Robert,

    That is a bit strange since selection is

    var nodeIds = (from v in csv select childnodes.FirstOrDefault(n => n.NodeId == v.ToInt() || n.NodeName.Equals(v.Trim(), StringComparison.CurrentCultureIgnoreCase)) into node where node != null select node.UID).ToList();
    

    So should except node id as well.

  • Robert 33 posts 172 karma points
    Feb 13, 2018 @ 10:29
    Robert
    0

    Sorry I meant to clarify that it's an ID property not the real nodeid. So we have a document type called Service and it has two propeties defined, ServiceId and ServiceName. We import these values from our own central database via csmimport to a document type called Package which has a MNTP of Services. When I do the package import and pass across a csv list of ServiceName then they map correctly but we want to pass across the csv list of ServiceId how could we get that to work?

  • Robert 33 posts 172 karma points
    Feb 13, 2018 @ 10:48
    Robert
    0

    Well we could just change our node names to use the serviceid instead so we will do this.

  • Richard Soeteman 4031 posts 12817 karma points MVP
    Feb 13, 2018 @ 10:56
    Richard Soeteman
    0

    That will work out of the box indeed so might be the best option thye other opion requires a bit of coding

  • Simon Tompsett 8 posts 28 karma points
    Nov 14, 2018 @ 12:30
    Simon Tompsett
    0

    Richard

    Running 3.7.5 on 7.7.9 I now have the same problem with the MNTP not finding the values. Been using this great tool for a couple of years, but this latest version seems to have broken the MNTP mapping when used as content picker. Import just hangs.

    Ignore the MNTP and all runs as expected.

    Tried to get your fix detailed in posts above, but it is no longer available. Could you provide the fix please.

    Thanks

    Simon

  • Richard Soeteman 4031 posts 12817 karma points MVP
    Nov 14, 2018 @ 12:33
    Richard Soeteman
    0

    Hi Simon,

    What are the values you are trying to map. Current version includes the fix mentioned above.

    Best,

    Richard

  • Simon Tompsett 8 posts 28 karma points
    Nov 14, 2018 @ 13:53
    Simon Tompsett
    0

    Richard

    Just simple node names of categories. Just cut it all back to a single product for testing, also tried the ID but to no avail.

    Import creates the new node but it remains empty of content and just hangs.

    The datatype of the MNTP is only used for these Categories.

    At a bit of a loss as to where to go from here. As I have used your package on multiple sites without issue.

    Just ripping it all out and re-installing, back to you if that fails to solve it!

    Simon

  • Richard Soeteman 4031 posts 12817 karma points MVP
    Nov 14, 2018 @ 13:54
    Richard Soeteman
    0

    Hi Simon,

    Best to check the log if it hangs then it must be an exception that causes it and those will be logged,

    Best,

    Richard

  • Simon Tompsett 8 posts 28 karma points
    Nov 14, 2018 @ 14:50
    Simon Tompsett
    0

    Richard

    That is the odd thing, it returns nothing to the log file.

    I have ripped it out completely and re-installed, same result

    It appears to get stuck in a loop as the SQL process runs at 50% until I quit the process manually. It never seems to find the node by required by dataType and nodeName. This appears to be why it logs no error. I assume there is a large timeout set on the page which is why it never gets there.

    Any other ideas?

    Thanks

    Simon

  • Richard Soeteman 4031 posts 12817 karma points MVP
    Nov 14, 2018 @ 14:51
    Richard Soeteman
    0

    What is the datasource you are using?

  • Simon Tompsett 8 posts 28 karma points
    Nov 14, 2018 @ 16:15
    Simon Tompsett
    0

    Richard

    Coming from MS SQL on another web server.

    Just realised that I have not been waiting long enough for it to complete!

    Without the MNTP element a single product import takes a second or two, when I include it, the import took 35 minutes (see attached).

    Surely something must be amiss with this?

    Thanks

    Simon!

  • Simon Tompsett 8 posts 28 karma points
    Nov 14, 2018 @ 17:28
    Simon Tompsett
    0

    Richard

    Just as an update, I amended the import to look for the MNTP value by ID and it took 35:16 to complete, which is within 4 seconds of looking for the node by name.

    It must be cycling through in a very laborious way to take that long and be that consistent in terms of time. The whole time it is running, SQL is using around 50% of the processor (This is currently on a dedicated server on its own, with only me accessing it).

    Any further thoughts?

    Simon

  • Richard Soeteman 4031 posts 12817 karma points MVP
    Nov 15, 2018 @ 08:03
    Richard Soeteman
    0

    I see why that might be slow.

    CMSImport will determine if the name of a childnode of the configured MNTP matches the name of the value that you map against the property to import. So if that has a lot of childnodes it will scan all those nodes. Since the childnode collection can be updated as well during import I can't cache this.

    What would help propably is narrow the possible childnodes by specifying an xptah or rootnode id on the MNTP configuration.

    Hope this helps.

    Richard

  • Simon Tompsett 8 posts 28 karma points
    Nov 15, 2018 @ 13:44
    Simon Tompsett
    0

    Richard

    Tried the Xpath idea, took even longer at 48 minutes!

    Something must have changed with this version of your software as the initial data for this site was imported using the same settings and went without a hitch on an earlier version, that was 7 months ago.

    The interface states that the MNTP uses the dataType configuration to look up the values. In this case there are only 38 nodes on that dataType so I would not expect it to take any time at all.

    I cannot see that anything our end can be at fault.

    Any further thoughts?

    Thanks for your support in this.

    Simon

  • Richard Soeteman 4031 posts 12817 karma points MVP
    Nov 15, 2018 @ 14:01
    Richard Soeteman
    0

    Hi Simon,

    This part of the software haven't been touched for years as well. Maybe got a lot of more nodes over the last 7 months since?

    Tried rootnode id config to narrow down options as well?

    I can see room for improvement for these lookups but require a fundamental change in the current solution which isn't a quick fix..

    Best,

    Richard

Please Sign in or register to post replies

Write your reply to:

Draft