PLM 360 General Discussion

PLM 360 General Discussion

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

Uploading items Error

206 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?

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.

Contributor
sdibben
Posts: 23
Registered: ‎03-26-2012
Message 2 of 8 (200 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: 281
Registered: ‎03-27-2012
Message 3 of 8 (189 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 (181 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 (169 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 (156 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: 281
Registered: ‎03-27-2012
Message 7 of 8 (150 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 (113 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

 

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.