user10648298 Newbie

It sounds like you may not have set the "Subtype" dropdown on the first page. For Items and Custom Records you have to select a specific subtype to import, this is new in 2007.0. -John

That's what the decodes are for ORACLE/PLSQL: DECODE FUNCTION The Oracle/PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement. ORACLE DECODE SYNTAX The syntax for the Oracle/PLSQL DECODE function is: DECODE( expression , search , result [, search , result]... [, default] ) PARAMETERS OR ARGUMENTS…

You can't create PL/SQL procedures with the formula capability, but I think you can get what you want done. I think it's a series of concatenations using the case or decode statement CASE WHEN {custitem97} = 'Yes' THEN 'LED, ' ELSE '' END || CASE WHEN {custitem91} = 'Yes' THEN 'Suitable for normally non-flammable surfaces…

The underlying issue has been fixed and is scheduled for next release. Very sorry for the inconvenience. -John

That refers to the internalId of the custom form in the saved import. Does the form no longer exist or not apply to the importing user? -John

Thursday night. -John

The process for importing Matrix items should be have a file with the parent matrix item first, then rows with each set of matrix features next. For example itemid,parent,matrix type,BoardLength surfboard bag,,PARENT, surfboard bag 5 ft,surfboard bag,CHILD,5 ft surfboard bag 6 ft,surfboard bag,CHILD,6 ft surfboard bag 7…

Unfortunately, that is not currently possible, please vote for enhancement 2689 CSV - Migrate JE import to assistant -John

There are two ways to do this, WebServices and SMBXML. The former is the preferred method at this point. There are partner tools available that import files via WebServices. -John

I think you want to ask this question in the "Best Practices" https://usergroup.netsuite.com/users/forumdisplay.php?f=56 or "Latest Release" https://usergroup.netsuite.com/users/forumdisplay.php?f=32 forum. This group is more about mass import or export via CSV or Search. -John

I would suggest setting up an advanced search ordered by internalId, and then add an "internal id number" criteria to each one in code. Search for a range of ~10,000 internalids each time. For example internalId between 1 and 10000 -> download 3456 results internalId between 10001 and 20000 -> download 5432 results -John

This is issue 154927. File a case with support and ask them to attach it to this issue. -John

Unfortunately no, Default Expense Account is not exposed in Saved Search. It is exposed in Web Services if you are willing to go that route. -John

In your case though you can Setup->Import->CSV Import Preferences and check "Run Server Suite Script" -John

It involves programming. If that's not a blocking factor then download our CRM sample application in your favorite language. http://www.netsuite.com/portal/developers/resources/suitetalk-sample-applications.shtml Then modify it do a search using a VendorSearchBasic. On each of the records returned there will be an…

I think you need to use either "customers" or "contacts" import for these updates. When you use "Customers and Contacts together" there is an implied relationship. I suggest doing 2 imports - one for the contacts and one for the customers. -John

Are you trying to make Color an Item Option for the Kit Item? If so you are stuck using Custom List. This is on our roadmap to implement, but it probably won't get done in the very near term. -John

It looks like it's giving you an error on a custom field, which I'm guessing sources from state. When you look in the browser at this field, what are the options? Do they change when you select a country? Also, is the country field on the customer (vs on an address line)? -John

Did you map the type column as well on the Related Items Sublist? -John

One way to get around invalid reference keys is to use internalIds - export the internalIds of the related items and then change the key type during mapping. Alternatively, here is a simple file that worked in my test account. I tested adding "Ball Point Pen" that is related to "Fountain Pen" which already existed. ----…

You should be able to set these custom fields via csv. They should be mappable on the line level, so look at the Item Sublist on the NetSuite fields. -John

You now need to map both "Child Of" and "Customer ID". They are no longer merged into a single field. To see what it looks like, look at a sub customer in the browser, your csv file should match those two fields. -John

SMBXML supports the notion of handles which are similar to externalIds. The customer externalId was designed for exactly this use case - updating records in NetSuite based on their Ids in 3rd party systems. My point is it's not a workaround, but supported behavior. -John

internalId is not there on "Add", but is there on "Add Or Update" and "Update". -John

You are correct, it should be instant. Try clearing your browser cache the next time you experience this. -John

You would have to write a Server Suite Script to do this (specifically a beforeSubmit script). ExternalId is not shown in the the browser because it is meant for integration with external systems (eg the primary key in the other system). It works for duplicate prevention, but that is not what it was designed for. -John

Why not use WebServices? Our WS interface was designed to bring in data from external systems in an automated fashion. -John

That corresponds to "system.netsuite.com" I believe - so yes, that is a valid IP. -John

If you are trying to match the record, Internal Id is mappable field. If you are trying to match a dropdown type field, it's available after the field has been mapped to a column and you click the pencil. What field are you trying to key by internalId that is lacking it? -John

Yes, map email address to both email address and externalId when importing. For existing contacts you would need to search for internalId and email address and export to CSV. Reimport as an update mapping internalId->InternalId and email->externalId. -John