Skip to main content

Suggested Cleanup Queries for GDS

www.trestechnologies.com
© Tres Technologies. All Rights Reserved.

Suggested Cleanup Queries for GDS

  • Updated

Cleaning up profiles in ClientBase before conversion helps to ensure that the Tres interface will run smoothly and accurately. Outdating or incorrect interface ids can cause warnings, duplicate profiles, and unnecessary troubleshooting after conversion.  

If you need assistance running these queries or with running Dupe Checker, please email support@trestechnologies.com or join a live chat session by clicking on the red Chat bubble in the lower right corner of the page.

Profiles with Hotel Chain Code as Vendor (Supplier) Interface ID

If these profiles remain unchained, all hotel bookings for the hotel chain will interface to that supplier instead of the individual property. This includes all hotel chain codes (300+). For agencies with large databases, consider running queries with fewer chain codes in each query.

 In the Profile Manager, click on the Level 3 tab and enter the following fields.  

 

 

  • Click OK
  • Click Summarize on the right and your query should look like the following:

***  Profile Level 3 Filter Number 1 _____________________

    (Profile Type [Vendor])

    AND (Interface ID Is Equal to Any "AA,AC,AE,AH,AI,AK,AL,AM,AO,AP,AR,AT,AU,AV,AY,AZ,BA,BC,BE,BG,BH,BI,BN,BQ,BR,BS,BT,BU,BV,BW,BX,BY,CB,CC,CD,CG,CI,CK,CM,CN,CP,CQ,CR,CS,CU,CV,CW,CX,CY,CZ,DA,DC,DD,DE,DI,DO,DP,DR,DS,DT,DV,DW,DX,DZ,EA,EB,EC,ED,EF,EG,EH,EI,EJ,EL,EM,EN,EO,ES,ET,EU,EW,EY,EZ,FA,FB,FC,FE,FG,FH,FI,FN,FP,FR,FS,FX,FZ,GA,GB,GD,GE,GF,GG,GH,GI,GK,GL,GN,GP,GQ,GS,GT,GU,GV,GW,HA,HB,HE,HG,HH,HI,HJ,HK,HL,HM,HO,HP,HQ,HR,HS,HT,HU,HX,HY,IA,IC,IG,IH,IJ,IM,IN,IQ,IS,IW,IZ,JA,JB,JD,JJ,JT,KB,KC,KI,KL,KY,LA,LC,LD,LE,LH,LL,LM,LO,LQ,LR,LT,LU,LV,LW,LX,LZ,MA,MC,MD,ME,MF,MG,MH,MI,MM,MN,MO,MR,MS,MT,MU,MV,MW,MX,MY,MZ,NB,NC,ND,NH,NK,NN,NO,NT,NW,NY,NZ,OA,OB,OC,OE,OF,OG,OH,OI,OK,OL,OM,ON,OO,OR,OS,OT,OX,OY,OZ,PA,PD,PE,PF,PH,PI,PJ,PK,PL,PM,PN,PO,PP,PQ,PR,PS,PT,PU,PV,PW,PY,PZ,QB,QC,QE,QH,QI,QQ,QR,QT,QU,RA,RB,RC,RD,RE,RF,RG,RH,RI,RK,RL,RM,RN,RO,RQ,RR,RS,RT,RU,RV,RW,RX,RZ,SA,SB,SC,SD,SF,SG,SH,SI,SJ,SK,SL,SN,SO,SP,SR,ST,SU,SV,SX,SY,SZ,TA,TC,TD,TF,TG,TH,TI,TJ,TL,TN,TO,TP,TQ,TR,TS,TW,TX,TY,UA,UB,UG,UI,UL,UN,UO,UP,UR,US,UV,UX,UZ,VA,VC,VG,VH,VI,VL,VN,VQ,VT,VX,VZ,WA,WB,WE,WG,WH,WI,WK,WO,WR,WS,WT,WV,WW,WX,WY,XE,XH,XR,XT,XV,XW,YI,YL,YO,YP,YR,YX,YZ,ZB,ZL,ZQ,ZX,ZZ,2E,2R,6C,7B,7C,7E,7F,7H,7I,7J,7N,7Q,7S,7T,7U,8B,8F,8U,8V,9E,9I,9S,9U")

    AND (Travel Category Is NOT Equal to Any "[Air]")

    AND (Profile Status Is Equal to Active)

  • Click Refresh on the right
  • If your display results do not include the Interface ID column, click on Columns 
  • On the left, under Fields Available, move down and DOUBLE click on PROFILE.Interface ID
  • The field will move to the right under Fields in Columns
  • Click OK
  • Review the Interface ID column.  If your agency uses the vendor, open the profile add a 'Z' at the end of the Interface ID.
    • For example, the first vendor in the display below is Alamo Car Rental.  If your agency uses this vendor, open the profile and change the Interface ID to ALZ.
  • If the agency does not use the vendor, open the profile and change the Profile Status to Inactive.  Click OK.

Airlines without an Airline Number

Profiles for airline vendors must include the correct ARC/BSP validating airline code. Missing airline codes can cause interface warnings that don't match to a Supplier profile. Refer to https://www2.arccorp.com/support-training/travel-agencies/participating-airline-information or the GDS to find the airline number.

  • In the Profile Manager, select the Level 3 tab.
  • Click Add Filter on the right.
  • Select the following fields:
  • Click Summarize on the right.  Your query should look like the following:

***  Profile Level 3 Filter Number 1 _____________________

    (Profile Type [Vendor])

    AND (Travel Category Is Equal to Any "[Air]")

    AND (Airline No. Is BLANK)

    AND (Profile Status Is Equal to Active)

  • Click OK
  • Click Refresh on the right.
  • Double click to open the profile 
  • Enter the Airline No. (validating ARC/BSP code)
  • Click OK
  • Repeat for each profile
    • Note: If the carrier does not have an ARC/BSP number (charters, special carriers, etc.) leave the field blank.

 

Car Companies

Check for car vendors (suppliers) to make sure they use the two-character GDS code for interface ID.  Click here for a list of card codes.

  • In the Profile Manager, select the Level 3 tab.
  • Click Add Filter on the right.
  • Select the following fields:

 

  • Click Ok.
  • Click Summarize on the right and your query should look like the following:

***  Profile Level 3 Filter Number 1 _____________________

    (Profile Type [Vendor])

    AND (Travel Category Is Equal to Any "[Car]")

    AND (Profile Status Is Equal to Active)

  • Click Refresh on the right.
  • If your display results do not include the Interface ID column, click on Columns
  • On the left, under Fields Available, move down and DOUBLE click on PROFILE.Interface ID
  • The field will move to the right under Fields in Columns
  • Click OK
  • Review the Interface ID column and if there are any that are not correct or blank, double click to open the profile and enter the correct two-character GDS code in the Interface ID field.
  • Click OK to save.
2025-09-25_13-12-17.png

 

Agent IDs

Verify the each agency profile matches the Interface ID for the GDS.  Incorrect or missing agency Interface IDs may prevent GDs bookings from associated to the correct advisor in Tres.  

  • In the Profile Manager, click on the Level 3 tab.
  • Click Add Filter on the right.
  • Select the following fields:
  • Click Ok.
  • Click Summarize on the right and your query should look like the following:

***  Profile Level 3 Filter Number 1 _____________________

    (Profile Type [Agent])

    AND (Profile Status Is Equal to Active)

  • Click Refresh on the right.
  • If your display results do not include the Interface ID column, click on Columns.
  • On the left, under Fields Available, move down and DOUBLE click on PROFILE.Interface ID
  • The field will move to the right under Fields in Columns
  • Click OK
  • Review the Interface ID column to ensure the Interface ID matches the GDS.
    • Amadeus: AIAN
    • Sabre: DK
    • Travelport: DI.AC-

 

Client Profiles without Interface IDs

Check for profiles that are missing Interface IDs. Interfaced records matching to a Client profile is necessary in Tres to ensure payments apply to the reservations. 

If any profiles are found with missing Interface IDs, use the Interface ID Generator to create them. Run the dupe checker after this step in case the generator creates any interface IDs that duplicate existing ones.  Links to directions are below.  

  • In the Profile Manager, click on the Level 3 tab.
  • Enter the following fields:

 

  • Click OK
  • Click Summarize on the right and your query should look like the following:

***  Profile Level 3 Filter Number 1 _____________________

    (Profile Type [Leisure,Corporate])

    AND (Interface ID Is BLANK)

    AND (Profile Status Is Equal to Active)

  • Click Refresh on the right
  • If your display results do not include the Interface ID column, click on Columns
  • On the left, under Fields Available, move down and DOUBLE click on PROFILE.Interface ID
  • The field will move to the right under Fields in Columns
  • Click OK

After generating the Interface IDs, run Dupe Check to ensure there are no duplicate Interface IDs in your database.  Click the link below for directions. 

Dupe Checker

Click the link above to for directions on running Dupe Checker in ClientBase Windows.  Check for any duplicate Interface IDs in the following profile types:

  • Clients (corporate/leisure, combined)
  • Vendors
  • Agents

If you need assistance running these queries or with running Dupe Checker, please email support@trestechnologies.com or join a live chat session by clicking on the red Chat bubble in the lower right corner of the page.

Related articles