heh

It was probably the most useless thing I'd done

But it got a lot of mileage.

lots of: NSBot: Hey @JackSalesman! Great win on Smalltown City, PA! $3k recur!

@rjayaraman I have used this csv template for user access and roles Internal ID External ID Role-internal ID Login Access Password Confirm Password

I bet they haven't changed the API keys either.

note that I have used role's internal ID for CSV - make sure to assign the field type to internal ID in the mapping

@rjayaraman I just did an experiment in my sandbox. I changed e-mails for three employees, mapped the fields internal id, give access (Yes), password, confirm password, and require password change (Yes). My advanced options were to NOT check overwrite sublists and NOT overwrite missing fields. That worked. I logged in using the new email and temp password and it prompted me to change my password. I then did the same thing with give access (No) and it did remove the roles.

Im trying to design a dashboard, Does Netsuite have a API or RSS feeds or something? I think its Suitetalkapi ?

yes @ShawnM

@bednar: that's funny. I was thinking more along the lines of inventory updates

You could probably pretty easily go the other direction with some kind of WS call

Thanks @Sam-I-Am and @mbucklaew for looking into it. I am trying to update the existing records where users already have more than one role assigned. It worked 😀 if I pull the role's internal id associated with that employee along with the other required fields.

@User uploaded a file:

How to convert PST to EST timezone

@sravanthi you can pass oslon values as timezone

sorry oslon means

its numeric values given to represent different timezones

you may search in help section

if you are dealing with datetime field you can fetch the time in your required timezone

with datetime zone apis

Does anybody use FloDocs? I am trying to view the information regarding the companyname under client record and its not list under the FloDocs ERD? Any clue?

I thought FloDocs ERD pretty much gives all the information about all the fields under any record. Am I missing something

Im sure this has been asked before. Does a Netsuite Sandbox exist anywhere?

you have to pay for it @ShawnM

Ah gotcha okay. Thanks @al3xicon

yeah it's kind of a bummer, it's fairly pricey to my understanding, i've never worked somewhere that has one

I just asked our CEO and he said its just as expensive as our live production deployment.

Sandbox pricing is (more or less) a %age of your total contract value

At least, as I understand the pricing model to work