Skip to content

Instantly share code, notes, and snippets.

View dperussina's full-sized avatar

Daniel Perussina dperussina

  • FragilePAK
  • Unknown
View GitHub Profile
function parseFile(callback) {
U.logLn('parseFile - Number of files to process', FILES.length);
if (FILES.length == 0) {
callback(false);
return;
}
DATA = [];
function parse(file) {
SQL(query2, function (err, reply) {
if (err) {
ERRORS.push({
source: 'exec insertAddressPoints2',
stack: reply,
data: e,
query: query2
});
U.errorLn('insertAddress', query2);
next(true, reply);
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 4.
ID,SourceIP,URL,Request,Response,CreatedDate,Api_Key
79003679,64.250.229.5,http://64.250.229.5:80/pts/OnboardItems,"{""close"":false,""items"":[],""truck"":""l190731-00004""}","{""batch"":""l190731-00004"",""total"":0,""status"":""OPEN""}",2019-08-06 10:48:23.080,883:386086a8-9cc4-433c-90bc-2dbd5053b077
79004396,64.250.229.5,http://64.250.229.5:80/pts/OnboardItems,"{""close"":true,""items"":[10359812,10359874,10359845,10359849,10359816,10359864,10359875,10359813,10359850,10359876,10359811,10359699,10359814,10359815,10359700,10359873,10359870,10359865,10359831,10359817,10359818,10359830,10359866,10359828,10359827,10359832,10359844,10359843,10359848,10359829,10359867],""truck"":""l190731-00004""}","{""batch"":""l190731-00004"",""total"":31,""status"":""OPEN""}",2019-08-06 10:51:37.440,883:386086a8-9cc4-433c-90bc-2dbd5053b077
79242896,64.250.229.5,http://64.250.229.5:80/pts/unload,"{""truck"":""L190731-00004"",""items"":[10359812,10359813,10359811,10359874,10359875,10359876,10359845,10359843,10359849,10359850,10
[{
"question": "Was the delivery team prompt and courteous?",
"answer": "Yes"
}, {
"question": "Was your merchandise received in good condition?",
"answer": "Yes"
}, {
"question": "Are you missing any portion of your order?",
"answer": "No"
}, {
{
"jobUniqueID": "BCH0000005758",
"arrivalDateTime": "11:43",
"departDateTime": "11:43",
"signatureText": "Robert Simms Judy hi",
"notificationEmail": "[email protected]",
"form": [],
"refused": false,
"attempt": false,
"attemptReason": "",
{
"jobUniqueID": "BCH0000005758",
"arrivalDateTime": "11:43",
"departDateTime": "11:43",
"signatureText": "Robert Simms Judy hi",
"notificationEmail": "[email protected]",
"form": [],
"refused": false,
"attempt": false,
"attemptReason": "",
/****** Object: StoredProcedure [dbo].[GetPrintJobs] Script Date: 31-07-2019 20:34:44 ******/
DROP PROCEDURE [dbo].[GetPrintJobs]
GO
/****** Object: StoredProcedure [dbo].[GetPrintJobs] Script Date: 31-07-2019 20:34:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
[2019-06-11 15:57:35] DEBUG[1439][C-00009a95] audiohook.c: Read factory 0x7f8274200158 was pretty quick last time, waiting for them.
[2019-06-11 15:57:35] DEBUG[1474][C-00009a95] audiohook.c: Write factory 0x7f82a4597fa8 was pretty quick last time, waiting for them.
[2019-06-11 15:57:35] DEBUG[19063][C-00009cee] chan_sip.c: Acked pending invite 102
[2019-06-11 15:57:35] DEBUG[19063][C-00009cee] chan_sip.c: Stopping retransmission on '[email protected]:5060' of Request 102: Match Found
[2019-06-11 15:57:35] DEBUG[19063][C-00009cee] chan_sip.c: SIP response 200 to standard invite
[2019-06-11 15:57:35] DEBUG[19063][C-00009cee] chan_sip.c: Processing session-level SDP v=0... UNSUPPORTED OR FAILED.
[2019-06-11 15:57:35] DEBUG[19063][C-00009cee] chan_sip.c: Processing session-level SDP o=- 20767 20767 IN IP4 10.1.4.57... OK.
[2019-06-11 15:57:35] DEBUG[19063][C-00009cee] chan_sip.c: Processing session-level SDP s=SDP data... UNSUPPORTED OR FAILED.
[2019-06-11 15:57:35] DEBUG[19063][C-000
[2019-05-31 05:32:33] NOTICE[19063] chan_sip.c: Created realtime peer 'mamos' for registration
[2019-05-31 05:32:33] NOTICE[19063] chan_sip.c: Created realtime peer 'WinDevices847' for registration
[2019-05-31 05:32:33] VERBOSE[19063] config.c: [2019-05-31 05:32:33] == Parsing '/etc/asterisk/sip_notify.conf': Found
[2019-05-31 05:32:33] NOTICE[19063] chan_sip.c: -- Re-registration for [email protected]
[2019-05-31 05:32:33] VERBOSE[19063] chan_sip.c: [2019-05-31 05:32:33] REGISTER 10 headers, 0 lines
[2019-05-31 05:32:33] VERBOSE[19063] chan_sip.c: [2019-05-31 05:32:33] Reliably Transmitting (NAT) to 72.244.189.50:5060:
[2019-05-31 05:32:33] REGISTER sip:ca1-siptrunk-a.voice.speakeasy.net SIP/2.0
[2019-05-31 05:32:33] Via: SIP/2.0/UDP 64.250.229.6:5060;branch=z9hG4bK2361cb8f;rport
[2019-05-31 05:32:33] Max-Forwards: 70
[2019-05-31 05:32:33] From: <sip:[email protected]>;tag=as18705b42