user10648298 Newbie

You can't do this in CSV with version 11. When you are upgraded to 2007, export the internalId's of all the items you want to modify. Add a column for the new parent (can be name or internalId) and re-import using "update" mode. Until then you would have to use handles and SMBXML or WebServices (again internalId). The…

Krysta, are you getting success for each individual row and yet seeing no update or are you getting an error back in your CSV Reponse file? -John

I have walked through the steps you outlined - Pick "Custom Records" in the Record Type dropdown Pick a custom Record Type in the SubType dropdown Select a file to upload. Click Next, and I get the "Import Options" page. Are you seeing something different? After Item Options, I click next and I get the field mapping page.…

To get you unblocked: if you map internalId or externalId you will not have any of the problems looking up the items for update. For the child item, did you also map and have a value for the Parent field? Again, with internalId or externalId you don't need any heirarchy. To get the internalIds, you can search for your…

Also, the NetSuite fields in the mapping page (what I think you mean by exported headings) correspond to the labels on the form for the record in your web browser. So if you want to check what a field on Customer import means, go to Lists->Releationships->Customers->new and find the label on that web page. -John

Item type and subtype are set in the "Subtype" dropdown on the first page of the assistant. Instead of just Item Imports, you also specify the sub type (eg "NonInventoryItem For Resale". You may not have noticed it because a default is set for you when you pick Items. The same is true for custom record imports. -John

When you select the file to upload (the "select..." button) the file name should appear next to the button with a "Remove" Link. If you see thiis text/link you shouldn't get the "please select a file to upload" error. -John

Item Type & Item Subtype are set in the second drop down on the first page of the assistant ("Subtype"). To use the old templates for pricing, map your existing price column to "Item Pricing 1" (The first folder under the "Item Pricing" folder)->"Price" Add the NetSuite Field "Item Prcing 1"->"Price Level" to the middle…

Support Cases are not currently importable via CSV. You can import them via SMBXml and Web Services. -John

Do you mean "Direct List Editing" like when you do an item search in the browser? -John

You are correct, single operation per WS user unless you have SC+ and designate the user as a concurrent WS user, in which case it is 10. The restlet limit is an account wide limit. -John I believe the other systems you mention have governance as well, just of a different sort

You should probably create a support case with the exact date and time you try this, they can look at the log file. If you submit multiple different requests, they will either be processed in parallel or you'll get the "too many concurrent requests" fault. -John

The concurrent WS user allows you to make multiple simultaneous WS requests with the same user, but it will not break up the job on the server. Are you getting a concurrent user not allowed fault back when you try to submit multiple jobs? -John

I haven't seen that error internally (for 2011.1 or 2011.2). Any idea which function it's complaining about? -John

Here is my ant task for my test client. [CODE] <axis-wsdl2java output="${clientbld.dir}/src" verbose="false" url="${clientbld.dir}/xsds/netsuite.wsdl" all="true" wraparrays="true"> <mapping namespace="urn:platform_${version-name}.webservices.netsuite.com" package="com.netsuite.${pkgname}.platform"/> <mapping…

What happens if you wget or curl the wsdl/xsd curl https://webservices.sandbox.netsuite.com/xsd/platform/v2010_2_0/core.xsd curl https://webservices.sandbox.netsuite.com/wsdl/v2010_2_0/netsuite.wsdl Do you get the complete file or an error message? -John

Request Level Credentials (resending the username/password with every request) is designed to reuse the session behind the scenes. It eliminates the complexity of having to store the session locally and does not require php code to have arbitrary file write permissions on the web server (a possible security vulnerability).…

On the way back to NS from your application, how do you access NetSuite via WS without the user's NS password? Do you have one central user and store/use their password? We built Suite-Sign-On to accomplish this same "request came from NetSuite" validation, I think it's available from Server Suite Script as well. -John

Are you using AdvancedSearch? The search you do in the browser and AdvancedSearch (returning columns) are equivalent. Our default Search/SearchBasic returns much more information and is slower. It is strongly recommended to use AdvancedSearch whenever possible. -John

Is this still happening? Can you get to https://webservices.netsuite.com/services/NetSuitePort_2009_2 in your web browser? If you are still getting that error message, please file a support case. -John

The following is an AdvancedSearch to bring back the name/ids of all the AccountingPeriods AccountingPeriodSearchAdvanced apsa = new AccountingPeriodSearchAdvanced(); // Return fields AccountingPeriodSearchRowBasic apsrb = new AccountingPeriodSearchRowBasic(); apsrb.internalId = new SearchColumnSelectField[]{new…

Can you break it into blocks of 1000 or fewer? That should fix your problem. Thanks, John

As Chris indicates, the balance field on the customer record is the correct balance (customerRecord.balance ). It should always equal the value in the browser. It is serious if it does not. Trying to calculate the balance by summing transactions in a search is not advised, the whole point of NetSuite is to keep track of…

I think the problem is that the datetime that is returned is coming back without a time component, but the filter respects the time part. Both that and the > 1000 problem are scheduled to be fixed in the next efix. A note on the > 1000 problem - it's not a good idea to return much more than 1000 rows at a time as it…

I may have misunderstood. Initializing a CustomerPayment will give you a record that has the list of unpaid invoices and their amounts on it (initialize() operation). Your search is not returning customer balance because it is a "bodyFieldsOnly" search, which is the default. BodyFieldsOnly does not return the balance (it's…

No, there are two ways around this 1) Use request level credentials - there is no login/logout. This was specifically designed for web pages / web applications that might not be able to keep state between requests. 2) Your next login will invalidate the previous session, so logout is not necessary. -John

Glad it worked. Due to our abstract types (eg record), our WSDL trips up a lot of SOAP toolkits (including the default PHP one). -John

What date and time did that happen? -John

You reference the namespace "ns" xsi:type="ns:Contact" but don't declare namespace "ns" until you are in the child elements &lt;ns:firstName xmlns:ns="urn:relationships_2009_2.lists.webservices.netsuite.com"&gt;MyFirstName&lt;/ns:firstName&gt; To repeat Mariano's point, are you hand-coding the SOAP or using a toolkit? The…

Add the name of the field to the NullFieldList, custom or standard it will be nulled out. -John