W3BGUY
/ 00-Jitterbit_NetSuite_RESTlet_API_GET
Last active
January 25, 2023 16:05
Jitterbit Scripts to Call NetSuite RESTlet via GET
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 01> Create transformation operation with script 01 as the first step. | |
| 02> Create script operation with step 02 as teh script (called by script 01 script). | |
| 03> Create JavaScript with contents from step 03 (called by Step 02 script). |
W3BGUY
/ country_ISO3166-1_to_NetSuite.txt
Last active
November 10, 2021 16:54
#Jitterbit #Country Codes Conversion - #ISO3166-1 Alpha-2 format to #NetSuite format
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $countryCodeDict=Dict(); | |
| AddToDict('countryCodeDict','AF','_afghanistan'); | |
| AddToDict('countryCodeDict','AX','_alandIslands'); | |
| AddToDict('countryCodeDict','AL','_albania'); | |
| AddToDict('countryCodeDict','DZ','_algeria'); | |
| AddToDict('countryCodeDict','AS','_americanSamoa'); | |
| AddToDict('countryCodeDict','AD','_andorra'); | |
| AddToDict('countryCodeDict','AO','_angola'); | |
| AddToDict('countryCodeDict','AI','_anguilla'); | |
| AddToDict('countryCodeDict','AQ','_antarctica'); |
W3BGUY
/ NetSuite_TBA_OAuth.php
Last active
February 17, 2024 06:47
Basic PHP NetSuite OAuth1.0 (SHA256) authentication to call RESTlet script.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /** | |
| * @Author w3bguy | |
| * @Created 2021-09-08 | |
| * | |
| * Description: | |
| * Basic PHP NetSuite OAuth1.0 (SHA256) authentication to call RESTlet script. | |
| * | |
| * @modifications | |
| * Date Author Version Remarks |
W3BGUY
/ NetSuite_GetItemType.js
Created
June 7, 2021 11:41
Simply function to get any item type by internal ID. Adding this since I've seen multiple questions about how to do it.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function getItemType(itemID){ | |
| var itemData={}; | |
| try{ | |
| itemData=search.lookupFields({type:search.Type.ITEM,id:itemID,columns:['type','externalid','price','displayname']}); | |
| log.debug('itemData',JSON.stringify(itemData)); | |
| }catch(err01){ | |
| log.error('getItemType('+itemID+').err01',JSON.stringify(err01)); | |
| }finally{ | |
| return itemData; | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Connect to PostgreSQL from Linux | |
| /opt/jitterbit/pgsql/bin/psql -d postgres -U jitterbit -p 46914 | |
| # List databases | |
| \l | |
| # list tables | |
| \dt | |
| # Connect to TranDb database |
W3BGUY
/ Jitterbit_PostgreSQL_Update
Last active
August 19, 2022 14:49
Updates to improve PostgreSQL performance.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Add to Jitterbit.conf file | |
| [LogSync] | |
| # Max number of records at once to sync - This is the initial batch size only! After retries it goes | |
| #back to MinRecordsToSync! | |
| MaxRecordsToSync=500 | |
| #Max sleep between retries | |
| MaxRetryDelaySec=60 | |
| #It's actually the maximum after retries have kicked in! | |
| MinRecordsToSync=500 |
W3BGUY
/ Jitterbit_PowerShell.ps
Created
November 25, 2020 14:10
Call a Powershell command from within Jitterbit
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Author - Danial Fields | |
| $command = "cmd"; | |
| $arguments = '/c powershell -ExecutionPolicy ByPass -File "C:\\directory\\RunCommand Test.ps1" -p1 ' + $p1 + ' -p2 ' + $p2 + ' -p3 '+ $p3 + '"'; |
W3BGUY
/ Wifi Password List
Created
August 16, 2020 14:33
List of random passwords that I've gathered
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Gloria's Cafe | |
| - I Love Gloria's | |
| - iloveglorias | |
| Austin Oral (on 1) | |
| - AOS-GUEST | |
| - aos-guest | |
| Dozen Street | |
| - The Doz |
W3BGUY
/ NetSuite_DueDateCalculation.js
Last active
August 6, 2020 14:50
Simple function to calculate the due date based on an invoice date and terms ID.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function calculateDueDate(termID,invDate){ | |
| var dueDate='' | |
| try{ | |
| var daysToAdd=search.lookupFields({type:'term',id:termID,columns:['daysuntilnetdue']}).daysuntilnetdue; | |
| dueDate=new Date(format.parse({value:invDate,type:format.Type.DATE})); | |
| dueDate.setDate(dueDate.getDate()+parseInt(daysToAdd)); | |
| }catch(err01){ | |
| log.error('calculateDueDate.err01',JSON.stringify(err01)); | |
| handleErrorAndSendNotification(err01,'calculateDueDate'); | |
| }finally{ |
W3BGUY
/ NetSuite Transaction Status Codes
Created
August 4, 2020 19:45
List of NetSuite Transaction Status Names and Codes
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Bill:Open <===> VendBill:A | |
| Bill:Paid In Full <===> VendBill:B | |
| Bill Payment:Voided <===> VendPymt:V | |
| Bill Payment:Online Bill Pay Pending Accounting Approval <===> VendPymt:Z | |
| Cash Sale:Unapproved Payment <===> CashSale:A | |
| Cash Sale:Not Deposited <===> CashSale:B | |
| Cash Sale:Deposited <===> CashSale:C | |
| Check:Voided <===> Check:V | |
| Check:Online Bill Pay Pending Accounting Approval <===> Check:Z | |
| Commission:Pending Payment <===> Commissn:A |