There's an option to forward data in the original format.
Thank you for the guidance that the order is correct.
Below I show you the log of my dispatch app, it has some fields that I do not have on the traccar server.
I'm trying to make it arrive in that order but the service only receives UDP
00000 502105$GPGGA,142 35 30 32 31 30 35 24 47 50 47 47 41 2C 31 34 32
00010 738,1826.914,N,0 37 33 38 2C 31 38 32 36 2E 39 31 34 2C 4E 2C 30
00020 6958.742,W,1,12, 36 39 35 38 2E 37 34 32 2C 57 2C 31 2C 31 32 2C
00030 0.5,80.0,M,0.0,M 30 2E 35 2C 38 30 2E 30 2C 4D 2C 30 2E 30 2C 4D
00040 ,,*57$GPVTG,026. 2C 2C 2A 35 37 24 47 50 56 54 47 2C 30 32 36 2E
00050 0,T,,,000.0,N,00 30 2C 54 2C 2C 2C 30 30 30 2E 30 2C 4E 2C 30 30
00060 0.0,K*29 30 2E 30 2C 4B 2A 32 39
[ TRACE] 2024/03/20 10:27:57.088 { 5928} ===>>> DRAVLService::doReceive
[ TRACE] 2024/03/20 10:27:57.088 { 6368} ===>>> DRAVLService::processPacket
[ TRACE] 2024/03/20 10:27:57.088 { 5928} <<<=== DRAVLService::doReceive
[ TRACE] 2024/03/20 10:27:57.088 { 6368} ===>>> DRAVLService::parseNMEAGPGGASentence
[ TRACE] 2024/03/20 10:27:57.089 { 5928} <<<=== DRAVLService::processedReceivedData
[ TRACE] 2024/03/20 10:27:57.089 { 6368} DRAVLService::parseNMEAGPGGASentence: Calculated NMEA sentence checksum: 57; extracted NMEA sentence checksum: 57.
[ TRACE] 2024/03/20 10:27:57.089 { 6368} <<<=== DRAVLService::parseNMEAGPGGASentence
[ TRACE] 2024/03/20 10:27:57.089 { 6368} ===>>> DRAVLService::parseNMEAGPVTGSentence
[ TRACE] 2024/03/20 10:27:57.090 { 6368} DRAVLService::parseNMEAGPVTGSentence: Calculated NMEA sentence checksum: 29; extracted NMEA sentence checksum: 29.
[ TRACE] 2024/03/20 10:27:57.090 { 6368} <<<=== DRAVLService::parseNMEAGPVTGSentence
[ TRACE] 2024/03/20 10:27:57.090 { 6368} ===>>> DRAVLService::dbInsertAVLData
[ TRACE] 2024/03/20 10:27:57.090 { 6368} ===>>> NDDbODBCAVLDataDAO::insert
[ TRACE] 2024/03/20 10:27:57.091 { 6368} ===>>> NDDbODBCConnectionFactory::getConnection
[ TRACE] 2024/03/20 10:27:57.091 { 6368} ===>>> NDDbODBCConnection::NDDbODBCConnection
[ TRACE] 2024/03/20 10:27:57.091 { 6368} ===>>> NDDbODBCConnection::connect
[ TRACE] 2024/03/20 10:27:57.091 { 6368} ===>>> NDDbODBCConnection::disconnect
[ TRACE] 2024/03/20 10:27:57.091 { 6368} <<<=== NDDbODBCConnection::disconnect
[ TRACE] 2024/03/20 10:27:57.092 { 6368} NDDbODBCConnection::connect: Connection is using DNS 'XXXXXXX-pgsql' and username 'XXXXX' with password '***'.
[ DEBUG] 2024/03/20 10:27:57.092 { 6368} NDDbODBCConnection::connect: Allocating connection handle ...
[ DEBUG] 2024/03/20 10:27:57.092 { 6368} NDDbODBCConnection::connect: OK! Connection handle allocated successfully.
[ DEBUG] 2024/03/20 10:27:57.092 { 6368} NDDbODBCConnection::connect: Connecting ...
[ DEBUG] 2024/03/20 10:27:57.093 { 6368} NDDbODBCConnection::connect: OK! Connected successfully.
[ TRACE] 2024/03/20 10:27:57.093 { 6368} <<<=== NDDbODBCConnection::connect
[ TRACE] 2024/03/20 10:27:57.094 { 6368} <<<=== NDDbODBCConnection::NDDbODBCConnection
[ TRACE] 2024/03/20 10:27:57.094 { 6368} <<<=== NDDbODBCConnectionFactory::getConnection
[ TRACE] 2024/03/20 10:27:57.094 { 6368} ===>>> NDDbODBCConnection::createStatement
[ TRACE] 2024/03/20 10:27:57.094 { 6368} <<<=== NDDbODBCConnection::createStatement
[ TRACE] 2024/03/20 10:27:57.094 { 6368} ===>>> NDDbODBCStatement::execute
[ DEBUG] 2024/03/20 10:27:57.095 { 6368} NDDbODBCStatement::execute: Executing SQL -->INSERT INTO avl_data ( avl_device_id, pkt_date, pkt_counter, pkt_len, pkt_version, eventid, event_info, gps_date, gps_data_valid, gps_fix_valid, num_sats, lat, lon, altitude, heading, speed, max_speed, tripA_distance, tripB_distance, ai1_voltage, ai2_voltage, ai3_voltage, ai4_voltage, ai5_voltage, ai6_voltage, din1_on, din2_on, din3_on, din4_on, din5_on, din6_on, ign_on, keypad_state, fob_id ) VALUES ( '502105', '2024-03-20 10:27:57', 0, 0, 0, 0, 0, '2024-03-20 14:27:38', '0', '1', 12, 18.448567, -69.979033, 0, 26, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0', '0', '0', '0', '0', 0, NULL );<-- ...
[ DEBUG] 2024/03/20 10:27:57.097 { 6368} NDDbODBCStatement::execute: SQLExecDirect returned SQL_SUCCESS
[ DEBUG] 2024/03/20 10:27:57.097 { 6368} NDDbODBCStatement::execute: Number of rows affected: 1.
[ TRACE] 2024/03/20 10:27:57.097 { 6368} <<<=== NDDbODBCStatement::execute
[ INFO] 2024/03/20 10:27:57.098 { 6368} NDDbODBCAVLDataDAO::insert: Inserted 1 record in 8 milliseconds.
[ TRACE] 2024/03/20 10:27:57.098 { 6368} ===>>> NDDbODBCConnection::~NDDbODBCConnection
[ TRACE] 2024/03/20 10:27:57.098 { 6368} ===>>> NDDbODBCStatement::~NDDbODBCStatement
[ TRACE] 2024/03/20 10:27:57.098 { 6368} <<<=== NDDbODBCStatement::~NDDbODBCStatement
[ TRACE] 2024/03/20 10:27:57.098 { 6368} ===>>> NDDbODBCConnection::disconnect
[ DEBUG] 2024/03/20 10:27:57.099 { 6368} NDDbODBCConnection::disconnect: Disconnecting from ODBC data source ...
[ DEBUG] 2024/03/20 10:27:57.099 { 6368} NDDbODBCConnection::disconnect: Freeing ODBC connection handle ...
[ TRACE] 2024/03/20 10:27:57.099 { 6368} <<<=== NDDbODBCConnection::disconnect
[ TRACE] 2024/03/20 10:27:57.099 { 6368} <<<=== NDDbODBCConnection::~NDDbODBCConnection
[ TRACE] 2024/03/20 10:27:57.100 { 6368} <<<=== NDDbODBCAVLDataDAO::insert
[ INFO] 2024/03/20 10:27:57.100 { 6368} DRAVLService::dbInsertAVLData: AVL data for unit with device ID '502105' inserted successfully.
[ TRACE] 2024/03/20 10:27:57.100 { 6368} <<<=== DRAVLService::dbInsertAVLData
[ TRACE] 2024/03/20 10:27:57.100 { 6368} <<<=== DRAVLService::processPacket
[ TRACE] 2024/03/20 10:27:57.178 { 5928} ===>>> DRAVLService::processedReceivedData
I'm confused. How is UDP related to selecting values? Those are two completely unrelated things.
Excuse my way of explaining the problem, perhaps the way I describe it for the translator is making it confusing.
Let's forget the order of the values.
Is there any way to make the foward UDP?
There's an option to forward data in the original format.
If data is coming as UDP, you can forward to UDP as well.
Understood,
Thank you very much, especially for your patience.
For me the thread is resolved
Could you please delete this line from the Log, it has the name of the database.
[ TRACE] 2024/03/20 10:27:57.092 { 6368} NDDbODBCConnection::connect: Connection is using DNS 'XXXXXXX-pgsql' and username 'XXXXX' with password '***'.
Masked the data.
Hello, I have configured the Forward.URL it works fine when sending to another server than traccar that I have... but I have another application that service only accepts UDP packets.
The Question,
Is there a way to send it UDP or do you recommend any other way that I can select the values I want to send?
I need the Value in this order
Sorry for my english,
Regards,