Transfering Files To FTP Server using Suitescript

In simple terms, FTP is a communication protocol that enables users to share files between systems. We can do this in Netsuite using Suitescript. Following is a sample code that can be used to upload file from Netsuite to the FTP server,

var fileObj = file.load({id: 271});

var FTPurl = ‘test.rebex.net’;

var FTPusername = ‘demo’;

var passwordGuid = ‘7a8812d753a94399996e007f965ac462’;

var hostKey = “AAAAB3NzaC1yc2EAAAABJQAAAQEAkRM6RxDdi3uAGogR3nsQMpmt43X4WnwgMzs8VkwUCqikewxqk4U7EyUSOUeT3CoUNOtywrkNbH83e6/yQgzc3M8i/eDzYtXaNGcKyLfy3Ci6XOwiLLOx1z2AGvvTXln1RXtve+Tn1RTr1BhXVh2cUYbiuVtTWqbEgErT20n4GWD4wv7FhkDbLXNi8DX07F9v7+jH67i0kyGm+E3rE+SaCMRo3zXE6VO+ijcm9HdVxfltQwOYLfuPXM2t5aUSfa96KJcA0I4RCMzA/8Dl9hXGfbWdbD2hK1ZQ1pLvvpNPPyKKjPZcMpOznprbg+jIlsZMWIHt7mq2OJXSdruhRrGzZw==”;

var conn = sftp.createConnection({

‘username’: FTPusername,

‘passwordGuid’: passwordGuid,

‘url’: FTPurl,

‘hostKey’: hostKey… Read the rest

Invoice Group in Netsuite – Features and Scripting

Netsuite’s Invoice Groups feature enables grouping of invoices for customers. This feature allows for the creation of several Invoice Groups per customer. Applying payments to an Invoice Group is made easier by this functionality. All of the invoices in an Invoice Group are affected when a payment is applied to that group of invoices. Netsuite enables partial and full payment for Invoice Group just like it does for regular invoices.

For accessing the invoice groups, … Read the rest

Filtering in Celigo using Javascript

Filtering in Celigo flows is of two types.

1. Output filter – Used to filter data exiting an import(lookups)/export step
2. Input filter – Used to filter date entering an import step

To add filters on a flow step

1. Click on define options in the import/export step

2. Now you can see the filter symbol next to your import/export

The symbol with the arrow exiting shows the output filter and the arrow entering shows the input filter

Now … Read the rest

Export & Import Data Into Microsoft Sql Using Celigo

Microsoft Sql Server : Its a relational database management system developed by Microsoft.It is a software product with the primary functions of storing and retrieving data as requested by other software applications.

Export Data From Microsoft Sql Server

• From the Resource menu, select Exports to open the list of exports of account.OR, at the upper right of exports page click + create export.

• For creating an export, a new window will pop up,

Adding Lookup in HTTP Request body

Import mapping defines how your source data relates to your import destination record data. During mapping, lookup in the field mapping settings is used to retrieve additional data from the same destination system.

In field-to-field mapping, you can add lookups from the settings.

But, when you are using HTTP Request Body to map your data, Things are different.

Here, you need to separately create lookup codes and call them in your request body.

To add … Read the rest