· 9 years ago · Jan 26, 2017, 10:00 PM
1bduser
2)=U\aM?{+C@:-y7H
3
4Write-S3Object -AccessKey AKIAIQYJPRJS5KKH2CQA -SecretKey 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 -BucketName "businessdirectoryfs2/inbox" -Key "AU UBD Weekly Address Extract_20160424160003.txt" -File ".\AU UBD Weekly Address Extract_20160424160003.txt" -Region us-west-2 -CannedACLName "bucket-owner-full-control" -ServerSideEncryption "AWS:KMS" -ServerSideEncryptionKeyManagementServiceKeyId "5dab8e96-061d-4398-b0a9-4091e6bd7f16"
5
6
7UAT
8
9AU
10
11Write-S3Object -AccessKey AKIAI3T7TIPJAABW7YAA -SecretKey 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 -BucketName "businessdirectoryfs-uat/inbox" -Key "AU UBD Weekly Entity Extract_20160529160003.txt" -File ".\AU UBD Weekly Entity Extract_20160529160003.txt" -Region us-west-2 -CannedACLName "bucket-owner-full-control" -ServerSideEncryption "AWS:KMS" -ServerSideEncryptionKeyManagementServiceKeyId "5dab8e96-061d-4398-b0a9-4091e6bd7f16"
12
13NZ
14
15Write-S3Object -AccessKey AKIAI3T7TIPJAABW7YAA -SecretKey 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 -BucketName "businessdirectoryfs-uat/inbox" -Key "AU UBD Weekly Entity Extract_20160529160003.txt" -File ".\AU UBD Weekly Entity Extract_20160529160003.txt" -Region us-west-2 -CannedACLName "bucket-owner-full-control" -ServerSideEncryption "AWS:KMS" -ServerSideEncryptionKeyManagementServiceKeyId "178ea5c5-bed3-4102-a691-09300afbaf2b"
16
17
18
19Write-S3Object -AccessKey AKIAI3T7TIPJAABW7YAA -SecretKey 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 -BucketName "businessdirectoryfs-uat/inbox" -Key "AU UBD Weekly Address Extract_20160417160004.txt" -File ".\AU UBD Weekly Address Extract_20160417160004.txt" -Region us-west-2 -CannedACLName "bucket-owner-full-control"
20
21https://connect.squareup.com/v1/me/payments/?begin_time=2016-04-22T00%3a00%3a00%2b02%3a00&end_time=2016-04-23T00%3a00%3a00%2b02%3a00
22https://connect.squareup.com/v1/me/payments/?begin_time=2016-04-22T00%3a00%3a00%2b02%3a00&end_time=2016-04-23T00%3a00%3a00%2b02%3a00
23
2404/22/2016 06:21:00 PM - 04/23/2016 06:22:00 PM
25
26sa@businessdirectory-cluster.cluster-cknb8p9hseas.us-west-2.rds.amazonaws.com:3306
27
28AU UBD Weekly Address Extract_20160417160004.txt
29AU UBD Weekly Address Extract_20160501160004.txt
30
311311111 row(s) affected, 3 warning(s): 1292 Truncated incorrect DOUBLE value: 'VedaBusinessNumber' 1265 Data truncated for column 'IncorporatedRegNumber' at row 2 1265 Data truncated for column 'LastUpdateDate' at row 2 Records: 1311111 Duplicates: 0 Warnings: 3
32
33'UPDATE businessdirectory.BusinessDirectory BD
34INNER JOIN veda.NZUBDEntityExtract EN ON EN.VedaBusinessNumber = BD.BusinessDirectorySourceId
35SET
36BD.BusinessName = EN.IncorporatedOrgName,
37BD.BusinessNumber = EN.NZBN,
38BD.UpdatedDate = Now()
39#BD.Status = ''STATUS/ACTIVE''
40WHERE BD.BusinessDirectorySourceId IN (SELECT VedaBusinessNumber FROM EntityToUpdate)'
41
42Error Code: 1451. Cannot delete or update a parent row: a foreign key constraint fails (`businessdirectory`.`NZVedaData`, CONSTRAINT `FK_NZVD_BDID` FOREIGN KEY (`BusinessDirectoryId`) REFERENCES `BusinessDirectory` (`BusinessDirectoryId`) ON DELETE NO ACTION ON UPDATE NO ACTION)
43
44
45git@github.dev.xero.com:Xero/BusinessDirectory.git
46git@github.dev.xero.com:Xero/Xero.WebPay.git
47
48
49Statement Message IBRC ACC 400263495
50Additional information ROSS O'FLANAGAN
51 18 HUNTERSHALL
52 HUNTERSWOOD, FIRHOUSE
53 D24
54
55 Maheedhar:Route Table blocks first12:15:29 PM
56http://blog.celingest.com/en/2013/04/19...(See full link) 12:15:30 PM
57http://cdn.blog.celingest.com/wp-conten...(See full link) 12:16:05 PM
58Once the instance is up,12:23:59 PM
59nc -vz datapipeline.us-west-2.amazonaws.com 443