https://netsuiteprofessionals.com logo
Join Slack
Powered by
Except it doesn't there are only 72 records in the...
# csvimports
k
Except it doesn't there are only 72 records in the account >.<
j
@KevinJ of Kansas Are you using external ID in your import? Oftentimes, I get that error when there are duplicate external IDs. Plus external IDs are unique across a weird combination of record types rather than one specific record, which make it doubly likely you run into this issue.
k
That's worth a shot. Maybe I'll add something funny to them.
j
oh, and make sure you don't have any extra lines or columns or null values in your external ID column
sometimes if you just typed in a row but then cleared it it'll pick that up as a legit value when you save to csv and then throw said error
but I'm sure you've run into that one before
k
A time or two. Normally won't let me even get to the import stage with that
j
Yeah, on rare occasions it'll pick it up as a value (usually on updates, where basically nothing is required)
k
No dice. I tried a new file with 1 row. Nada
j
@KevinJ of Kansas Can you share the 1 row sample and what record type?
k
Sure - it's a completely custom record we created in the account.
SerialNumber FinishedBed Partnumber SoNumber ExternalID 286759 1070014BEI S1903444 SNFB286759
There's a number of fields on the record - but we're just trying to import some serial numbers from their old system in for duplicate detection.
My CSV import isn't running script or workflows
I've tried playing with the custom record set up too. There's an FAM related article, but to be honest, I don't think it applies.
j
wait, so I see 5 column header, but only 4 data points
are you leaving the external ID field blank?
k
how the fudge...
there's only 4 columns in my file
Oh that's wierd
the first column has a hidden character in it that you don't see in excel.
j
fun!
yeah, sometimes I have to examine my csv in notepad when things get really desperate
k
Unfortunately, no dice.
.<
but it gives me something to try
j
so is SNFB286759 your external ID number?
that you're importing?
My spidey sense really thinks it's related to that
k
that was me setting an external ID for the sake of setting one
there's definitely no record in their account with that external ID
j
ah, but you weren't before. Okay then.
k
I thought maybe it was tied to the fact that I autonumbered the record with 8 digits and this has less than 8 digits.
so I chagned that setting
j
Did you check the 'include name field' on setup
and are you importing a name?
k
i tried turning that on and off
j
k
k
I changed the ID on the record and it let me import it...
so it doesn't like that the ID is a strict number.
j
hmph, interesting
k
That's dumb. >.<
j
netsuite
loading 1
k
Well - I suppose I now gotta be creative. Maybe a custom field with the number and then I let it auto number it.
just needs to be global searchable is all.
Open in Slack
PreviousNext
Powered by