Consultas Masiva Terceros en la DIAN! | Olvídate del CAPTCHA y Ahorra Tiempo

Summary

The video presents version 3 of a third-party bulk query tool for Colombia’s DIAN, designed to automate tax ID lookups and bypass the need for manually solving CAPTCHAs. The creator walks through initial configuration steps, including setting click positions and timing intervals, then demonstrates how the tool processes Excel-based ID lists, updates statistics in real time, and handles pauses or errors. The video highlights improvements, automation benefits, and recommended usage practices, emphasizing how the tool streamlines large-volume DIAN queries efficiently for users.

Takeaways

• 😀 The video introduces version 3 of a third-party bulk query tool for the DIAN (Colombian Tax Authority), which solves the CAPTCHA issue.
• 😀 Users can easily run the tool without installation by simply double-clicking the executable file.
• 😀 The tool mimics the DIAN website interface and includes extra options for a better user experience.
• 😀 Initial configuration only needs to be done once, which includes setting up the CAPTCHA click area and adjusting waiting times.
• 😀 Waiting times can be customized depending on internet speed (6 seconds for CAPTCHA appearance, 4 seconds for solving, etc.).
• 😀 The tool allows users to deactivate the CAPTCHA click during runtime for multitasking, but it's recommended to keep the click activated for optimal performance.
• 😀 The tool supports querying multiple tax ID numbers by loading them into an Excel file, with each ID placed in column A.
• 😀 Users can pause, resume, and track the progress of the queries in real-time, with statistics showing how many records have been successfully queried.
• 😀 The tool updates the Excel file with results, marking IDs as 'consulted' or 'not consulted' based on their status.
• 😀 The program can run in the background while users interact with other tasks on their computer, but the CAPTCHA click should ideally remain activated for smooth operation.

Q & A

What is the main purpose of the version 3 third-party bulk query tool?

The main purpose of version 3 of the third-party bulk query tool is to automate and simplify the process of querying the DIAN (Colombian Tax Authority) website. It solves the CAPTCHA problem that often arises when querying manually, allowing users to automate the process.

How do you set up the CAPTCHA click configuration in the tool?

To set up the CAPTCHA click configuration, you need to open the tool and define the click location by clicking on the center of the CAPTCHA when it appears. Once clicked, save the configuration. This setup only needs to be done once.

What waiting times can be configured in the tool and why are they important?

The tool allows configuration of four waiting times: 6 seconds for the CAPTCHA to appear, 4 seconds for it to be solved, 1 second before clicking the 'Consult' button, and the waiting time for retrieving results. These times are adjustable based on internet speed and ensure the tool works efficiently.

Can the CAPTCHA click feature be disabled during the process? Why would you want to do that?

Yes, the CAPTCHA click feature can be disabled during the process. This option is helpful if you need to perform other tasks on your computer while the tool runs in the background. However, it is recommended to keep the click activated to ensure the CAPTCHA can solve itself or be clicked when needed.

How do you prepare an Excel file for querying with the tool?

To prepare an Excel file for querying, input the tax ID numbers in column A, leaving the header row intact. The tool requires the file to be saved and closed before starting the query process.

What happens if the tool cannot query a particular tax ID number?

If the tool cannot query a tax ID number (e.g., due to CAPTCHA issues or the record not being registered), the tool marks it as 'not consulted' in the Excel file, allowing it to be queried again during the next run.

How does the tool keep track of the query process?

The tool tracks the query process by updating the statistics in real-time. It shows how many records have been consulted, how many were not registered, and which records are pending. These updates are displayed in the Excel file and the tool’s interface.

What options are available for pausing and resuming the process?

The process can be paused at any time by clicking the 'Pause' button. If the user pauses the process, it stops the current query, and the user can resume the process later, continuing from where it left off.

Can the tool be used while the computer is being used for other tasks?

Yes, the tool can be used while the computer is being used for other tasks. If the CAPTCHA click is disabled, the tool will continue querying in the background, but it's recommended to leave the click activated for best results.

What should be done if the 'close' and 'minimize' buttons do not work in the tool?

If the 'close' and 'minimize' buttons do not work, it is because the tool is designed to run in full-screen mode. The 'close' button is deactivated to prevent accidental interruption during the query process. You can still exit the tool using the designated exit button in the interface.