Search Performance Analysis refers to a feature or tool that allows to analyze and optimize the performance of searches within NetSuite account. It shows the search name, id, search type, execution time, users and performance. To view the search performance analysis, navigate through, Customization > Performance > Search Performance Analysis Search Performance Details refers to… Continue reading Search performance analysis and details
Author: Nancy Enasu
Create new tile on Record Pages Monitor
By default, the dashboard displays the 10 most utilized record operations. You can configure the dashboard to show up to 20 record tiles. To create new tile; Customization > Performance > Record pages monitor click on Set up from the 3 dots 3. select Watch List and click Add Watch List Item 4. select record… Continue reading Create new tile on Record Pages Monitor
Record pages monitor
Record Pages Monitor is a feature that allows to monitor and analyze the performance of record pages within NetSuite account. Record pages refer to the individual pages that display and allow to interact with specific records, such as customers, sales orders, purchase orders, or custom record types. The above listed record shows: Record type Record… Continue reading Record pages monitor
MySQL DB and Kafka DB
MySQL DB – can store passbook data, user wallet transactions, and the wallet balance of users using tables and relationships. Passbook Data: You can create a table called “passbook” to store passbook-related information. Each row in this table represents an entry in the passbook for a specific transaction or event. User Wallet Transactions: To track… Continue reading MySQL DB and Kafka DB
Mongo DB
Mongo DB – platform that helps to store, retrieve, manage unstructured or semi structured data in JSON format called BSON (Binary JSON). Users: You can create a collection called “users” to store user-related information. Each user can be represented as a document within this collection. Transactions: For tracking transactions, you can create a separate collection… Continue reading Mongo DB
Amazon S3 – NetSuite integration
Amazon S3 (Simple Storage Service) offers object storage of storing and retrieving data from anywhere on web. Each piece of data is called ‘object’ and stored in containers called ‘buckets’. To get connection with celigo ,the required fields are Name Access key ID Secret access key Ping bucket The prebuild flows are : Export attachments… Continue reading Amazon S3 – NetSuite integration
To display date in specific format
To display date in “MM/DD/YYYY” format; Ex: 02/08/2023
Convert date to New Zealand date
To convert date to New Zealand date ;
Boolean selectors in celigo
Boolean selector: NOT is enabled by default in celigo, meaning that the filter excludes any data that meets the criteria you define with the rules. If NOT is disabled, the filter includes any data that meets your defined rule criteria. Ex: If you want to exclude all records that have customer ID 1256 , select… Continue reading Boolean selectors in celigo
Cron expressions
Examples of corn expressions: * * * * * Every minute 0 * * * * Every hour 0 0 * * * Every day at 12:00AM 0 0 ? * FRI At 12:00AM only on Friday 0 0 1 * ? At 12:00AM on the first day of the month