Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX 2012 Excel Import &...
Microsoft Dynamics AX (Archived)

AX 2012 Excel Import "Specified cast is not valid."

(0) ShareShare
ReportReport
Posted on by CJ 373 295

I'm using the AX 2012 pre-release version of the excel add-in to try to import data.

I'm currently using the demo data and am trying to create a new vendor for the demodata's "CEU" company.

I've made the connection in excel to the CEU company, added the tables vendtable and dirpartytable and refreshed the data.

My plan is to create a new PartyID in dirpartytable by creating a company called "Test" by typing in "Test" in the name field of the excel sheet and typing in the number 7163 into the Party ID field (the previous Party ID had been 7162 so I know that 7163 has not been used.)

When I go to publish the new table I get the error "Specified cast is not valid." and I'm not sure what the error means or how to fix it.

Once I can get a new PartyID in the dirpartytable created, I can use the "Field Lookup" to look up the created PartyID in the vendtable and sucessfully publish a new vendor, but I don't know what the error means that I'm getting from the dirpartytable. Is it the error that is giving me problems or am I doing the entire process incorrectly?

Any help would be greatly appreciated, thank you.

*This post is locked for comments

  • Xander Vink Profile Picture
    Xander Vink 2,550 on at
    Re: AX 2012 Excel Import "Specified cast is not valid."

    [quote]Also, using excel add in AX 2012 RTM, I was able to load vendors in two tables DirPartyTable, VendTable for organization type.[/quote]

    Could you please explain how you did this?

    Loading (creating) vendors using the Excel add-in gives me a 'surrogate key expansion error', no matter what... :(

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: AX 2012 Excel Import "Specified cast is not valid."

    Using the AIF services i was able to add the products/product master/variants and release products. Thanks to  Volodymyr Yakubiv.

    But to release product variants i need "InventDimCombinationService". It is no where in AOT services. Any idea please?

    Also, using excel add in AX 2012 RTM, I was able to load vendors in two tables DirPartyTable, VendTable for organization type. But for people type i was not able to load. Getting a personal suffix issue. i have involved DirPerson and DirPersonName table as well. But not succeded. Is it a product bug or any solution to do this?

     

     

  • Xander Vink Profile Picture
    Xander Vink 2,550 on at
    Re: AX 2012 Excel Import "Specified cast is not valid."

    Bill Thompson suggests in an answer to the previously posted post that importing vendors isn't possible with the Excel add-in. So if you know another (simple) way to do this, please share :)

    Second, you should upgrade to AX 2012 RTM with CU1. There is no need to work with the pre-release anymore.

  • 640579632b5c4e6780a624c4771b6f93 Profile Picture
    640579632b5c4e6780a... 4,730 on at
    Re: AX 2012 Excel Import "Specified cast is not valid."

    Please read the following post to get an idea on what services are support and if not why not...

    community.dynamics.com/.../114790.aspx

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: AX 2012 Excel Import "Specified cast is not valid."

    This is a great post. Thanks much for sharing. I will give a try and update.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: AX 2012 Excel Import "Specified cast is not valid."

    please read following article:

    blogs.msdn.com/.../product-item-data-management-services.aspx

    This should help you with Products/Items import using services.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: AX 2012 Excel Import "Specified cast is not valid."

    Tim,  You are correct. i am trying to load load product/items with product variants and storage and tracking dimensions using excel add in both methods (add data/add table). but finally forced to agree your point after cracking my head. could you share me the best way to do this task.

    Thanks for your help.  

  • Tim Schofield Profile Picture
    Tim Schofield on at
    Re: AX 2012 Excel Import "Specified cast is not valid."

    I don't the standard Excel import is capable of handling complex imports like Vendors, Customers, Adresses, Products/items, Forecasts, Journals,, or anything with an InventDimId.

    But I'd love for someone to prove me wrong!

  • Suggested answer
    CJ 373 Profile Picture
    CJ 373 295 on at
    Re: AX 2012 Excel Import "Specified cast is not valid."

    For those who run into this problem:

    I did some research on "Specified cast is not valid" and it seems to be coming from the sql server database when you try to 'cast' an incompatible data type. I think it may be because the excel sheet contains empty cells which try to become null values in the database.

    I'm not entirely sure how accurate that is but I ended up being able to import parties into the dirpartytable by adding the additional fields from field chooser and added data into the 'Language', 'Party Type', and 'Search Name' fields.

    Even though it looks like the field chooser only designates 'Party ID' and 'Name' as necessary fields, leaving blank values in at least one of the additional fields seems to cause it to reject the import.

    Good luck!

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans