user10648298 Newbie

You can use InternalId and External ID, but you have to set the key type during the mapping stage. To do this click the "pencil" icon for the mapped column and instead of picking a default, set the key type to Internal Id or External Id. To lookup by name, click the "pencil" icon and look at the possible defaults drop…

Use Address Book 1. The Assistant will attempt to match addresses by label. Map the address label of Address Book 1 to the label of the address in the system. Map the Country field of Address Book 1 to nothing, but set the default for the Country to US (via the pencil icon). Make sure you have mapped the internalId of the…

This looks like Issue 130935. File a case with support noting this and you should be notified when it is fixed (should be soon). -John

Dates should be formatted in the date format you use in NetSuite. They should not include times. -John

What are you trying to import? It sounds like Contacts. If so, the Company must already be in the system (it's not a text field, it's a foreign key field). If you are trying to import Leads and Contacts, one straight forward way is to create the Contacts first (without a company), then create the Leads with the "primary…

Did you map the contact ID field? Try creating a field in your CSV file that is =[FirstName] & " " & [LastName] where first and last name are CSV columns (Excel). Save as CSV and import. Map the new column to Contact ID. -John

Do you mean that new imports have single line addresses, or that the old imported data is formatted as a single line? -John

I believe your post would be better answered in the Campaigns/Bulk Mail forum. https://usergroup.netsuite.com/users/forumdisplay.php?f=15 -John

Good news - as of 2008.2 this is supported in Web Services and in CSV Import. In CSV look at the poorly named "Item Items" sublist. This will be changed to "Item Related Items" next week. The one subtlety to this is that there are two fields in the related item sublist, item and type, while only one (item) appears in the…

The CSV assistant was built with the principle of bringing import more in line with the way the applications works in the browser. The label for a field on the webpage will be the same as the label in the assistant. Likewise, the legal values for a dropdown field (such as assetaccount) are the legal values in the web…

There is an outstanding issue for preferred vendor. Most likely you are running into Issue 129963, which is targetted for release on 8/28. If you want to be sure that is it, import some of the items without mapping preferred vendor. -John

Are you using Leads and Contacts together, or doing two imports (one after the other, Contacts then Leads)? The error has different resolutions in each case. -John

Thanks, I will look in to why your Vendor's addresses are not fixed. The first patch is working, correct? (Vendor addresses are no longer reformatted on update). -John

It can not be done yet. It's on the roadmap for webservices. -John

I'm surprised support told you that. You simply map the "Child Of" field to the parent company. I tried it this morning and it worked in my test account. There are several way to link contacts and companies. The pre-2007 method still works, specifically import the contact and then import the customer with the "Primary…

Multi-selects are supported. The separator is "|" (pipe) without the quotes. -John

Using your example, if I have a lead that has 9877887760AC, I assign the contact with the same number (9877887760AC). It does not link them, but sets up the lead separate from the contact and vice versa... File 1 LinkField,Company Name,... 9877887760AC,"A great company" File 2 LinkField,First Name, Last Name...…

I believe you need to have the Contact as the Customer's Primary Contact. To do so you need to map the "Attached Role" field on Contact, you can either have a field that contains "Primary Contact" or "Alternate Contact", or you can set it via a default value (the pencil). -John

The likely suspects are external ID (if you are using that), and contact ID, as well as first name + last name. Try searching by both of those. If not, open a case with support and hopefully they can find which record is a duplicate. -John

First, make sure you have the correct item subtype selected in the first step. Second, is your default item form customized to remove this field? The CSV import assistant shows you fields on your default entry form for a record. If you can find the field in your browser, and can not find the same label in the CSV…

This is tracked by issue 128121 and will be fixed in Tuesday night's e-fix. -John

To separate MultiSelect values use "|" (pipe). A *custom* field delimiter is currently not supported. -John

Is it always 59%? Try your import again, though there will be an issue soon for correcting the erroneous message. -John

One thing you need to do is make sure that you input all the quantities for your new price level, so if you have quantities 0,12,144, you need three prices. Alternatively you can simply define a quantity pricing schedule and set a base price for that item. Doing so will completely overwrite all the prices. If neither of…

I still see "subitem of" on my account. Do you still see "Subitem Of' when you go to Lists->Accounting->Items New. Do you have the right SubType? -John

This is two issues, one for a bad completeness message - the other for why the import is stopping part way through. They should be fixed Thursday night (at the very least the latter will be). -John

If you set the default to "TRUE" or set the value in the column you've mapped to isperson to "T", it should read your customers as individuals. -John

Go to the Item Pricing folder on the right, and open the first Item Pricing subfolder. Map "Price" to your "Base Price" column, and set the default for "Price Level" to "Base Price". Go to the Second Item Pricing subfolder and map "Price" to your "Online Price" column and set the default for "Price Level" to "Online…

Thats a very good description - we'll look at it. -John

Custom Field delimiter support is coming (it's issue 105184 for now). File a case for the child item body fields not updating. Our QA team will look at that. The failure to differentiate by subtype is Issue 128077. -John