Personalization, Customization and Productivity Tools

[rmmfg]

Hi,

I made a custom field in Inventory Management.  I have imported some data into the fields.  Now I have some items that this data does not apply to and I want to now make it blank for only some items via import (because there are a lot that I need to clear)?  If I want to clear that information for these items, how do I import so that the field becomes blank?  Please let me know?  Thank you!

P.S. - I tried importing a "blank" field, and it didn't seem to work?  The data remained?

[VKZIMM]

Could you tell us what fields you are trying to make blank?  What version of Mas are you running?

[BShockley · Accepted solution]

Try unchecking the "skip blank field" box in the field properties.

[rmmfg]

Hi,

I just made a custom field "Catalog item number" to reference my catalog database with my MAS database.  It is a text field.  There are a bunch of catalog item numbers that I am no longer using, therefore need to leave this field blank.  I tried importing the MAS item number field and then the Catalog item number field (leaving the catalog item number field blank), but this did not seem to make any changes to the field?  Please let me know?  Thanks for your help! 

[rmmfg]

by the way, i'm running 4.10.  and where would the "skip blank fields" box be?  i don't seem to see it? 

[rmmfg]

GOT IT!  FOUND THE BOX!  THANK YOU!

[mtilton]

Hi,

I'm looking for the "Skip Blank Field" checkbox in version 4.4 and can't find it. From the Data tab, I click on the field in question, which brings up the Import Field Properties--Operation, Col/Pos, etc. No checkbox that I see. Am I in the wrong place? 

Thanks for any help. 

Meg

[mtilton]

Apparently MAS90 4.4 no longer has this box. Instead, under field properties, you insert a conditional expression:

[FieldName]<>""

This tells MAS90 to only import the field if it isn't a blank. The data type has to be set to a string.

Meg