Ask Your Question

Revision history [back]

Unable to download agents

Hi,

We can download some agents but not others using the following queries. Can someone let us know what could be the issue?

url: http://maxebrdi-rets.paragonrels.com/rets/fnisrets.aspx/MAXEBRDI/login?rets-version=rets/1.7.2 username: ccar_gabriels user-agent: gabriels

SELECT [Agent Identifier],[Agent Phone4 Number],[Agent Phone5 CountryId],[Agent Phone5 Description],[Agent Phone5 Extension],[Agent Phone5 Number],[Agent Salutation],[Agent State],[Active],[Active Book Count],[Agent Address Street Name],[Agent Address2],[Agent City],[Agent Designation],[Agent Email],[Agent First Name],[Agent Last Name],[Agent License Date],[Agent License ID],[Agent Logon Name],[Agent Mail Address2],[Agent Mail City],[Agent Mail Preference],[Agent Mail State],[Agent Mail Street Name],[Agent Mail Zip],[Agent Middle Initial],[Agent Office ID],[Agent Password],[Agent Phone1 CountryId],[Agent Phone1 Description],[Agent Phone1 Extension],[Agent Phone1 Number],[Agent Phone2 CountryId],[Agent Phone2 Description],[Agent Phone2 Extension],[Agent Phone2 Number],[Agent Phone3 CountryId],[Agent Phone3 Description],[Agent Phone3 Extension],[Agent Phone3 Number],[Agent Phone4 CountryId],[Agent Phone4 Description],[Agent Phone4 Extension],[Agent Status],[Agent Training],[Agent Type],[Agent Url],[AOFranchisor Opt-In],[AOIDX Y/N],[AOMain Office ID],[AOOffce Address Street Name],[AOOffice Abbreviation],[AOOffice Address2],[AOOffice City],[AOOffice Email],[AOOffice Name],[AOOffice Phone1 CountryId],[AOOffice Phone1 Extension],[AOOffice Phone1 Number],[Agent Zip],[AOBoard ID],[AOOffice State],[AOOffice Type],[AOOffice Url],[AOOffice Zip],[AOOffice Phone1 Description],[Board Prohibited By],[Board User ID],[Date Added],[Date Agent Type Changed],[Date Assigned to Office],[Date Key Assigned],[Date of Agt State Mbrshp],[Distributed User],[Hash],[Last Trigger Date],[Multiple Logon],[NRDS_ID],[Number of Keys],[Old Agent ID],[Pers PAC Contribution YTD],[Photographer],[Preferred Phone Area],[Preferred Phone Number],[Previous Key Number],[Prohibited],[Security Level],[Sold Book Count],[Source Access Rights],[Source Bill Type Role],[Source System Update Date],[Spouse First Name],[State Agent Is Member Of],[Status Date],[Training Date],[UPAgent image Timestamp],[Update By Agent],[Update Date],[UPLogo image Timestamp],[UPPreferred Phone],[User Code],[User Photos Code] FROM ActiveAgent:[All Active Agents] WHERE ([Active] IN ('No','Yes')))

or using this one too:

SELECT U_AgentID,U_PhoneNumber4,U_PhoneNumber5CountryCodeId,U_PhoneNumber5Desc,U_PhoneNumber5Ext,U_PhoneNumber5,U_UserSalutation,U_State,U_user_is_active, U_ActiveBookCount,U_AddressStreet,U_Address2,U_City,U_FreeFormDesig,U_Email,U_UserFirstName,U_UserLastName,U_AgentLicenseDate,U_AgentLicenseID,U_LoginName,U_MailAddress2, U_MailCity,U_PreferredMailCode,U_MailState,U_MailAddressStreet,U_MailZip,U_UserMI,U_HiddenOrgID,U_Password,U_PhoneNumber1CountryCodeId,U_PhoneNumber1Desc, U_PhoneNumber1Ext,U_PhoneNumber1,U_PhoneNumber2CountryCodeId,U_PhoneNumber2Desc,U_PhoneNumber2Ext,U_PhoneNumber2,U_PhoneNumber3CountryCodeId,U_PhoneNumber3Desc, U_PhoneNumber3Ext,U_PhoneNumber3,U_PhoneNumber4CountryCodeId,U_PhoneNumber4Desc,U_PhoneNumber4Ext,U_Status,U_Indoctrination,U_HiddenUsCID,U_WebPage,AO_Char10_1, AO_Char10_2,AO_BranchOfOrgID,AO_OrgAddressStreet,AO_ShortName,AO_OrgAddress2,AO_OrgCity,AO_EMail,AO_OrganizationName,AO_PhoneNumber1CountryCodeId,AO_PhoneNumber1Ext, AO_PhoneNumber1,U_Zip,AO_board_id,AO_OrgState,AO_HiddenOtyID,AO_WebPage,AO_OrgZip,AO_PhoneNumber1Desc,U_Char100_1,U_BoardId,U_InputDate,U_AgentTypeChangeDate, U_DateAssignedToOrg,U_DateKeyAssigned,U_StateAgentIsMemberOfDate,U_Dist,U_Hash,U_LastTrig,U_MultyLogin,U_users_nrds_id,U_NumberOfKeysAssigned,U_Char50_4,U_PersonalPACContrib, U_Photographer,U_Char10_1,U_Char10_2,U_PreviousKeyNumber,U_Char10_3,U_SecurityLevel,U_SoldBookCount,U_Char50_3,U_Char50_2,U_Char50_1,U_SpouseFirstName,U_StateAgentIsMemberOf, U_StatusDate,U_IndoctrinationDate,UP_AgentImageFileUpdt,U_UpdateAgent,U_UpdateDate,UP_LogoImageFileUpdt,UP_AgentPhone,U_UserCode,U_Photos FROM ActiveAgent:ActiveAgent WHERE (U_user_is_active=|0,1)