Skip to main content

Notifications

Announcements

No record found.

Service | Customer Service, Contact Center, Fie...
Suggested answer

Error Importing Units

Posted on by 342

Importing the Unit Groups (attached image), went fine.

When importing the Units the 5 "Connector" units imported successfully but the other 19 received an error: "The base unit does not belong to the schedule".

I've checked to make sure there's not a space afterward and also I exported the Unit Groups to show that the base unit does in fact belong to the schedule (third image attached)

What gives?

Unit-Groups.pngBulk-Cable.pngdescription.png

  • crham Profile Picture
    crham 342 on at
    RE: Error Importing Units

    Okay, but if the imported Unit Group is now there and the default Unit is there and tied to that Unit Group (because you imported the Name of the Default Unit at the time of importing the Unit Group), then on to my next question:

    1.  If we're using the Unit Group's Name and the Default Unit's Name as the lookup during the import I don't understand why it doesn't work.

  • Moximox Profile Picture
    Moximox 2 on at
    RE: Error Importing Units

    Correct because you can’t change the guid for the already created unit group with the unit you wish to import in your second step. 

  • crham Profile Picture
    crham 342 on at
    RE: Error Importing Units

    Thanks for answering.

    One follow up set of questions.

    So importing Unit Groups is fine, the key issue is importing the Units for those groups in the same import is the challenge?

    If the lookup being done is by name though I don't understand why it would be an issue.

    Regardless, if we imported Groups and then pulled the ID from each groups default unit and then did a separate import of Units shouldn't that work?

  • Suggested answer
    Moximox Profile Picture
    Moximox 2 on at
    RE: Error Importing Units

    Sorry it hasn’t. I deal with this issue each project. I have considered building some workarounds myself but it hasn’t been worth it so far. Issue is that unit groups require units when being created. Therefore when you create unit group you are in fact creating also a unit connected. Then you try to import same unit but this time it won’t have the same guid as the one that was created by the system when unit groups were created.

  • crham Profile Picture
    crham 342 on at
    RE: Error Importing Units

    ...except that was like from 7 years ago.  ...I'd be very disappointed if that hasn't gotten resolved by now.

  • Suggested answer
    Moximox Profile Picture
    Moximox 2 on at
    RE: Error Importing Units

    Hi

    Please see url below for comment in previous forum thread from mvp stating it is not supported which confirms my already suggested answer.

    community.dynamics.com/.../369102

    Please mark my answer if you find it helpful.

    Mox

  • crham Profile Picture
    crham 342 on at
    RE: Error Importing Units

    Who'da thunk that a database program would have potential to NOT be able to import data into it's tables...beyond me.

  • crham Profile Picture
    crham 342 on at
    RE: Error Importing Units

    You are correct about single base unit per Unit Group.  However, did you not look at the attachments?  They answer your question.  I am not importing multiple base units.

  • crham Profile Picture
    crham 342 on at
    RE: Error Importing Units

    You say that pretty confidently and I like that so it seems like it MIGHT be true.  I was able to successfully import Unit Groups and even SOME unit's but then others failed.  Nothing I saw could help me understand it so I am going to assume your information might be accurate, but will hold out for any further definitive evidence.  :)

  • Gene Glenn Profile Picture
    Gene Glenn 125 on at
    RE: Error Importing Units

    I'm not sure exactly, but seems you can only have a single base unit defined per Unit Group.  Are you trying to Import multiple base units into 1 Unit Group?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans