standard field? or custom field?
# generalk
KevinJ of Kansas
04/30/2020, 5:36 PMstandard field? or custom field?
l
Lei
04/30/2020, 5:59 PMIt's a custom field.
k
KevinJ of Kansas
04/30/2020, 6:02 PMWhat is the custom field Type? Does it have a "filter" applied to it at all?
KevinJ of Kansas
04/30/2020, 6:02 PMMixed my conversations up, but still a valid question.
l
Lei
04/30/2020, 6:05 PMThe filed is address line 2. Some of the existing values need update to different values, some to null values. That's why I don't chose to set the values to null for all.
k
KevinJ of Kansas
04/30/2020, 6:05 PMaddress line 2 isn't a custom field?
KevinJ of Kansas
04/30/2020, 6:06 PMAnyways - if it's a subrecord like address, you're gonna have to do that using a painful method known as "overwrite sublist" - beware this will potentially break a ton of things.
KevinJ of Kansas
04/30/2020, 6:07 PMDo small samples first.
l
Lei
04/30/2020, 6:15 PMIt's a custom field.
k
KevinJ of Kansas
04/30/2020, 6:17 PMCan you share your field setup?
KevinJ of Kansas
04/30/2020, 6:17 PM(screenshot)
l
Lei
04/30/2020, 6:21 PMmessage has been deleted
Lei
04/30/2020, 6:21 PMThe Overwrite Sublists option replaces sublist data as a whole, rather than checking for individual fields mapped to CSV file fields with no data. It doesn't sound like what I want
k
KevinJ of Kansas
04/30/2020, 6:22 PMIt's not
KevinJ of Kansas
04/30/2020, 6:22 PMI just wanted to make sure "store value" was on, and that there wasn't something else going on.
KevinJ of Kansas
04/30/2020, 6:23 PMYou might be better off breaking your file into two different uploads
One to set values to blank, and another to update values
KevinJ of Kansas
04/30/2020, 6:24 PMThe blank ones, you can use the import mapping option to "provide a default value" and set to null.
l
Lei
04/30/2020, 6:24 PMYeah I thought about this, I hope there's a way to do them all in a batch
Lei
04/30/2020, 6:25 PMI wonder why it's not working when I check the overwrite missing fields, I even restart my computer😢
k
KevinJ of Kansas
04/30/2020, 6:26 PMIt should work, perhaps it's a defect?
l
Lei
04/30/2020, 6:29 PMI am not the admin, is it because the admin did not check it and override this option? I am just guessing
s
Sean Murphy
05/01/2020, 12:30 AMI think its not working because Its not working because its not a missing field. If the column is in your CSV. You are providing a blank value with which is not the same as missing. you may need to put a value like " " in the field in the CSV. if you open that CSV in Notepad I bet you will see "" in that position on the lines where there is no value.
k
KevinJ of Kansas
05/01/2020, 10:11 AMThat's how I've always done it. (Having a blank field in the file with no space)
KevinJ of Kansas
05/01/2020, 10:11 AMI don't think entering a space would solve this problem
l
Lei
05/01/2020, 5:30 PMTried. Entering a space wouldn't solve the problem, entering a " " in csv would import " " in NetSuite.
Lei
05/01/2020, 5:31 PMOverwrite missing fields: Enable the option during data updates, to clear NetSuite fields mapped to CSV file fields that do not contain data. The explanation is from SuiteAnswer. Somehow it's just not working
3 Views