PLM 360 General Discussion

Reply
Contributor
sdibben
Posts: 23
Registered: ‎03-26-2012
Message 1 of 8 (194 Views)
Accepted Solution

Uploading items Error

194 Views, 7 Replies
01-04-2013 09:39 AM

When I try to upload data from an excel file I get this warning "The validator "Money" of field Travel Cost is not supported." 

I have a PLM data type as "Money" and have tried formatting my cells in excel as Number or Currency.  Will I need to change my PLM data type in order to import this data?

Contributor
sdibben
Posts: 23
Registered: ‎03-26-2012
Message 2 of 8 (188 Views)

Re: Uploading items Error

01-04-2013 12:35 PM in reply to: sdibben

I was able to get the import to work, but only by changing all data types to "Single Line Text".  After the import I edited the field and changed it back to "Money".  Not ideal, but I was able to complete the import.

Product Support
piggeej
Posts: 279
Registered: ‎03-27-2012
Message 3 of 8 (177 Views)

Re: Uploading items Error

01-08-2013 06:31 AM in reply to: sdibben

Scott,

 

Sorry about taking so long to get back to you but by chance did the money values have a sign (ie. '$') attached to them by chance?



Joe Piggee
Support Specialist
Product Support
Autodesk, Inc.

Contributor
sdibben
Posts: 23
Registered: ‎03-26-2012
Message 4 of 8 (169 Views)

Re: Uploading items Error

01-11-2013 11:37 AM in reply to: sdibben

No $ attached.  It looks like PLM will not allow the field that data is coming into to be of Data Type "Money".  It may have to do with the validation for that field.  If you switch it to slngle line text it works.  After the import I went back and then changed the field back to Data Type "Money"

Product Support
Andrew.Shaw
Posts: 44
Registered: ‎01-09-2012
Message 5 of 8 (157 Views)

Re: Uploading items Error

01-14-2013 05:46 AM in reply to: sdibben

Dear Scott,

 

I have just tried importing values in a Money field and have encountered no error.

 

Could you provide me with the steps to recreate your issue, including a screenshot of the settings for the money field and an excel sheet containing values to be imported?

 

Best regards,



Andrew Shaw
Premium Support Specialist PLM/PDM
Global Services
Autodesk, Inc.

Contributor
sdibben
Posts: 23
Registered: ‎03-26-2012
Message 6 of 8 (144 Views)

Re: Uploading items Error

01-21-2013 12:36 PM in reply to: sdibben

I apologize, it does seem to be working now.  I was not able to get the import to load files one afternoon.  I have since tried and was able to upload into a money field.

Product Support
piggeej
Posts: 279
Registered: ‎03-27-2012
Message 7 of 8 (138 Views)

Re: Uploading items Error

01-22-2013 09:53 AM in reply to: sdibben

Good to hear that it is working now, (did you do anything different this time around?)

 

And thank you for the update.



Joe Piggee
Support Specialist
Product Support
Autodesk, Inc.

New Member
Nyfiken
Posts: 2
Registered: ‎04-22-2013
Message 8 of 8 (101 Views)

Re: Uploading items Error

08-20-2013 03:47 AM in reply to: sdibben

I am now encountering the same problem. And it includes also the field "Integer".

"The validator "Integer" of field Art nr is not supported." 

"The validator "Money" of field Pris (SEK) is not supported."

 

I have checked the dataposts. They should be ok. I have added a UOM of SEK.

 

What more can I do?

Ann

 

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Ask the Community