GTAS | Global Travel Assessment System A passenger data screening

by US-CBP Java Version: v1.14.1 License: Non-SPDX

Download this library from

kandi X-RAY | GTAS Summary

GTAS is a Java library. GTAS has no bugs, it has no vulnerabilities and it has low support. However GTAS build file is not available and it has a Non-SPDX License. You can download it from GitHub.

The Global Travel Assessment System (GTAS) is web application for improving border security. It enables government agencies to automate the identification of high-risk air travelers in advance of their intended travel. The United Nations has called upon members to use Advance Passenger Information (API) and Passenger Name Record (PNR) data for preventing the movement of high-risk travelers, and GTAS was designed to give every country that capability. The World Customs Organization (WCO) has partnered with U.S. Customs and Border Protection (US-CBP) because of the shared belief that every border security agency should have access to the latest tools. US-CBP has made this repository avaialble to the WCO to facilite deployment for its member states. This belief has become a reality with GTAS in production. It is able to handle the load of a high-volume country, and has successfully identified high-risk travelers. The mission GTAS supports goes beyond combating terrorism and includes;. GTAS accomplishes these goals through providing all the necessary decision support system features to (1) receive and store air traveler data (2) provide real-time risk assessment against this data based on your own specific risk criteria and/or watch lists (3) view high risk travelers, their associated flight and reservation information, and possible affiliates.

Support

Quality

Security

License

Reuse

kandi-support Support

GTAS has a low active ecosystem.
It has 85 star(s) with 71 fork(s). There are 20 watchers for this library.
It had no major release in the last 12 months.
There are 273 open issues and 1391 have been closed. On average issues are closed in 331 days. There are 27 open pull requests and 0 closed requests.
It has a neutral sentiment in the developer community.
The latest version of GTAS is v1.14.1

GTAS Support

Best in #Java

Average in #Java

GTAS Support

Best in #Java

Average in #Java

quality kandi Quality

GTAS has 0 bugs and 0 code smells.

GTAS Quality

Best in #Java

Average in #Java

GTAS Quality

Best in #Java

Average in #Java

security Security

GTAS has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.
GTAS code analysis shows 0 unresolved vulnerabilities.
There are 0 security hotspots that need review.

GTAS Security

Best in #Java

Average in #Java

GTAS Security

Best in #Java

Average in #Java

license License

GTAS has a Non-SPDX License.
Non-SPDX licenses can be open source with a non SPDX compliant license, or non open source licenses, and you need to review them closely before use.

GTAS License

Best in #Java

Average in #Java

GTAS License

Best in #Java

Average in #Java

build Reuse

GTAS releases are available to install and integrate.
GTAS has no build file. You will be need to create the build yourself to build the component from source.
It has 97674 lines of code, 7980 functions and 1234 files.
It has medium code complexity. Code complexity directly impacts maintainability of the code.

GTAS Reuse

Best in #Java

Average in #Java

GTAS Reuse

Best in #Java

Average in #Java

Top functions reviewed by kandi - BETA

kandi has reviewed GTAS and discovered the below as its top functions. This is intended to give you an instant insight into GTAS implemented functionality, and help decide if they suit your requirements.

Helper method to generate where conditions .
Processes the fax .
Sets the jpa parameters for the given query entity .
Joins the hits view and hits views .
Get rid of pn fields
Parse the raw message to segment list .
Computes the delog hits for a table .
Create an event identifier from the message summary .
Populate singular voider
Finds a list of rows matching the criteria

GTAS Key Features

API and PNR Data Processing

Criteria Based Risk Assessment

Watch List Based Risk Assessment

Identification of partial Watch List matches

Risk Criteria Management Interface

Watch List Management Interface

View Flights and Passengers Interface

Query Flights and Passengers Interface

Cloud-Ready

Case Management for Decision Support

Free-Text Search

Customizable Dashboard

Graph Database (Neo4J)

Graph Database Rules Engine for Identifying Risk Patterns

GTAS Examples and Code Snippets

See all related Code Snippets

VBA loop that will read from different tables

Copy

Download

Dim db As DAO.Database
Dim tdf As DAO.TableDef

Set db = CurrentDb

For Each tdf In db.TableDefs

    ' ignore system and temporary tables
    If Not (tdf.Name Like "MSys*" Or tdf.Name Like "~*") Then

        Dim sTable As String
        sTable = tdf.Name

        Dim strSQL
        strSQL = "INSERT INTO Tbl_GTAS ( SF133_Rpt_Line, LineDescription, LineAmt, TS)" & _
            "SELECT T.F1, T.F2,T.F3, '" & Replace(sTable, "_NEW SF 133", "") & "' AS TS " & _
            "FROM " & sTable & " AS T" & _
            "GROUP BY T.F1, T.F2, T.F3,'" & Replace(sTable, "_NEW SF 133", "") & "';"

        'do what you will with SQL

    End If

Next

See all related Code Snippets

Community Discussions

Trending Discussions on GTAS

VBA loop that will read from different tables

Trending Discussions on GTAS

QUESTION

VBA loop that will read from different tables

Asked 2017-Jan-30 at 20:25

I need to write a VBA that will loop through 128 different tables that are linked into my access database from 128 different excel files and take the data and place it into one table. Each table is the same just a different TS. I was able to write this:

strSQL = "INSERT INTO Tbl_GTAS ( SF133_Rpt_Line, LineDescription, LineAmt, 
TS ) SELECT [75-XXXX-XXXX_NEW SF 133].F1, [75-XXXX-XXXX_NEW SF 133].F2, 
[75-XXXX-XXXX_NEW SF 133].F3, '75-XXXX-XXXX' AS TS FROM [75-XXXX-XXXX_NEW SF 133] 
GROUP BY [75-XXXX-XXXX_NEW SF 133].F1, [75-XXXX-XXXX_NEW SF 133].F2, 
[75-XXXX-XXXX_NEW SF 133].F3, '75-XXXX-XXXX';"

I just need to take that somehow and have it pull for each of my tables.

All of my tables have the same naming convention with either XX, XXXX or X after the 75-. Any help would be very appreciated!!

Thanks!

edit:

Full VBA code:

Public Function GTAS()

   Dim SBRLink2017 As DAO.Database
   Set SBRLink2017 = CurrentDb


   Dim delSQL As String
   Dim updSQL As String
   Dim str1SQL As String

   DoCmd.SetWarnings False

   delSQL = "DELETE tbl_GTAS.* FROM tbl_GTAS';"

   DoCmd.RunSQL (delSQL)

   str1SQL = "INSERT INTO Tbl_GTAS ( SF133_Rpt_Line, LineDescription, LineAmt, TS ) SELECT [75-XXXX-XXXX_NEW SF 133].F1, [75-XXXX-XXXX_NEW SF 133].F2, [75-XXXX-XXXX_NEW SF 133].F3, '75-XXXX-XXXX' AS TS FROM [75-XXXX-XXXX_NEW SF 133] GROUP BY [75-XXXX-XXXX_NEW SF 133].F1, [75-XXXX-XXXX_NEW SF 133].F2, [75-XXXX-XXXX_NEW SF 133].F3, '75-XXXX-XXXX';"

   DoCmd.RunSQL str1SQL

   updSQL = "UPDATE Tbl_GTAS SET Tbl_GTAS.TS_SF133_Rpt_Line = [TS] & '_' & [SF133_Rpt_Line];"

   DoCmd.RunSQL (updSQL)

   DoCmd.SetWarnings True

 End Function

ANSWER

Answered 2017-Jan-30 at 20:03

Untested and double-check that I included all parenthesis as needed. I think I did:

Dim db As DAO.Database
Dim tdf As DAO.TableDef

Set db = CurrentDb

For Each tdf In db.TableDefs

    ' ignore system and temporary tables
    If Not (tdf.Name Like "MSys*" Or tdf.Name Like "~*") Then

        Dim sTable As String
        sTable = tdf.Name

        Dim strSQL
        strSQL = "INSERT INTO Tbl_GTAS ( SF133_Rpt_Line, LineDescription, LineAmt, TS)" & _
            "SELECT T.F1, T.F2,T.F3, '" & Replace(sTable, "_NEW SF 133", "") & "' AS TS " & _
            "FROM " & sTable & " AS T" & _
            "GROUP BY T.F1, T.F2, T.F3,'" & Replace(sTable, "_NEW SF 133", "") & "';"

        'do what you will with SQL

    End If

Next

Source https://stackoverflow.com/questions/41944257

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install GTAS

You can download it from GitHub.
You can use GTAS like any standard Java library. Please include the the jar files in your classpath. You can also use any IDE and you can run and debug the GTAS component as you would do with any other Java program. Best practice is to use a build tool that supports dependency management such as Maven or Gradle. For Maven installation, please refer maven.apache.org. For Gradle installation, please refer gradle.org .

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .