user10648298 Newbie

Nothing systemic. I assume you are using our Outlook Client please call support, they should be able to troubleshoot with you. -John

When you import the customer for the first time, import the 3rd party's key as "externalId". Do this again on subsequent imports and if you use "add or update" it will handle it appropriately. -John

I believe SMBXML imports are incompatible with OneWorld (there are plans to sunset it). You need to either use CSV import or Web Services. -John

I'm not sure what the problem is, but we definitely don't cap at 60 KB/s (I tested to verify). Even so, a poster in the other thread put it well, upload bandwidth is not generally a large part of overall NetSuite performance. Is there a workflow you are attempting that is blocked by network speed? -John

You could do what you are suggesting via Web Services (either Search or GetSelectValue). However, I would probably suggest search export->vlookup as well if you only had to do one. -John PS I think 65535 is the limit for Excel lines.

Is there any unique field (per transaction) on your transactions -maybe a tran id or a unique key from the system you export from? If not, how do you know where one transaction ends and the next begins in your file? -John

A couple of things to try 1) After mapping the category field, click the "pencil" icon and use the default dropdown to see if the category is there. 2) Find out what the internalId of the category is and using the pencil icon, map by InternalId. You may want to file a case with support, often a second pair of eyes helps…

How would you do this in the Browser? -John

Invoices will be available for CSV Import in the upcoming release (second half of 2008). -John

We certainly don't cap at that level. There must be a problem with your connection to us (unless you are using Dialup or EDGE or some such). -John

I think the would following work, am I misunderstanding your use case? Search items with result columns internalId and item name only Export that to CSV Edit the names Reimport as an update We only update the fields that are mapped, so if you only have two fields, those are the only ones that will be affected by the…

Invoices will be in the 2008_2 release (so no help there). You may want to look at partner applications for import (they use WebServices but expose it via simpler formats like CSV). -John

Also, if you want to use web services you can write a very simple program to do this. Download the sample applications from the portal and modify it to search, loop through and update. mhulshult's solution will work as well (but I worry about a timeout). -John

You could use web services. Write a program that does a search, and for each record returned remove the internalId and change the name appropriately. Then add() the modified record. There may be a couple of gotcha's, but that is the process that sounds most closely like what you are trying to do. Unfortunately it does…

NetSuite exports as UTF-8 by default and Excel does a terrible job of handling it. The example you gave has the strange result because the character was not an apostrophe Netsuite’s is "Netsuite 0xe2 0x80 0x92 s" which turns out to be the "RIGHT SINGLE QUOTATION MARK" -…

Can you repost this in the Enterprise Reporting forum - I think you'll find better answers there https://usergroup.netsuite.com/users/forumdisplay.php?f=18 -John

This should be straight-forward. Export via a search the internalId and SKU of the items you wish to update as a CSV file. Add a column "Price Level:Base Price" to the file. Now use Excel, a SQL database, etc, to match up the new prices with internalId/SKU's under the base price field. For 900 or event 3000 items, Excel's…

Also, you can extract your images automatically by via WebServices. It would be a simple file search and then iterate through all the results. I don't know if one of our partners has already written such an application, but it would be very easy to do. -John

At first the contact will not be mapped to a customer. Once the customer is imported (with primary contact set) it will update the contact record appropriately. For those without a role, import the contacts, import the customers, then import the contacts as an update and set the Company field. -John

As a followup, if you want to avoid having to use Excel, etc in the future, you can update the ExternalId of all of your items to be the SKU. Then all you would need is a CSV file with two columns: SKU and Base Price. You would map SKU to ExternalId and the Base Price field as above (Price -> Price, Pricel Level -> default…

You actually want to do the contacts first, and then import leads second mapping the "Primary Contact" field. -John

You should be able to update the file you just added, and should not get uniqueness violation message in that case. It really seems like it was trying to add. Your headers look OK. Couple of changes on pricing. First is that if you have discount levels defined for an item the assistant will calculate the simple discounts…

The problem is your pricing matrix isn't "square", specifically the first quantity always has to be 0, and for every quantity you must have all price levels. The pricing matrix can be complicated - a good way to understand it is to go into the browser and see what cells you have to fill in for everything to work. Each cell…

The file is whatever data you have. You don't need to reformat your files, but instead use the assistant to map columns and set default values. The minimum file has "Item Number/Id", but it doesn't need to be titled as such. What specific problems are you having? Is it mostly around pricing? -John

Eric, the fields you seem to have trouble with all seem to be on lists on the item. They will not get automatically mapped, but you should see them in the "NetSuite Fields" side of the mapping pane if you open up the list folders. For example Site Categories are available by going to "Item Site Categories" and then "Site…

This sounds like a problem in NetSuite (please file a case). A workaround would be to export the internalId's of the customers (via a saved search) and replace customer names with internalIds. -John

Sorry - you also have to change the the key type to InternaId instead of Name (click the pencil on the row after you have mapped it). -John

ODBC Documentation is in the Help Center ("Help" link in the upper right corner) Here is a deep link: https://system.netsuite.com/help/helpcenter/en_US/Output/Help/DashboardsSearchesReports/EnterpriseViews/EnterpriseViews.52.1.html

Are you including the parent name in the entity name? ie "Grandparent:parent:entity"? Or is it really long company names such as "Really long,long,long,long,long,long,long,long,long,long,long,long,long,long,long named Widget Company"? -John

Unfortunately, we don't yet support scheduled search like we do scheduled reports. The only way to do what you want is via Web Services or possibly SuiteScript, but that requires programming. -John