View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] CSV extract tickets - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

[SOLVED] CSV extract tickets

More
25 Aoû 2022 12:20 #1 by pdecloedt
on V10.0.4, I try to extract tickets on CSV files, it's works, but when I open the csv file with Excel, the is empty and it's write "aucune donnée à afficher pour ce repas"

log file:2022-08-25 12:13:21.981 ***** ERROR ***** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-25 12:13:21.983 ***** ERROR ***** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-25 12:13:21.997 ***** ERROR ***** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-25 12:13:21.999 ***** ERROR ***** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-25 12:13:22.002 ***** ERROR ***** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-25 12:13:22.004 ***** ERROR ***** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-25 12:14:10.251 ***** ERROR ***** [V10.0.4] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ticket.test' in 'field list'
2022-08-25 12:14:10.252 ***** ERROR ***** [V10.0.4] For query : select ticket.id as id, ticket.name as name, ticket.idTicketType as idTicketType, ticket.idProject as idProject, ticket.idUrgency as idUrgency, ticket.test as test, ticket.creationDateTime as creationDateTime, ticket.idUser as idUser, ticket.idContact as idContact, ticket.idStatus as idStatus, ticket.idAccountable as idAccountable, ticket.idResource as idResource, ticket.actualDueDateTime as actualDueDateTime, workelement.realWork as realWork, ticket.doneDateTime as doneDateTime, ticket.idProduct as idProduct, ticket.idOriginalProductVersion as idOriginalProductVersion from ticket left join origin on ticket.id = origin.refId and origin.refType='Ticket' left join workelement on ticket.id = workelement.refId and workelement.refType='Ticket' where (ticket.idProject <> 317 or ticket.idProject is null) and ( ( 1=1 and (ticket.idProject in (0, 226, 232, 16, 29, 13, 334, 14, 15, 17, 248, 332, 326, 371, 2, 37, 25, 82, 96, 89, 77, 91, 84, 97, 98, 87, 107, 114, 132, 90, 72, 71, 307, 396, 70, 170, 106, 80, 171, 81, 115, 67, 116, 66, 123, 136, 151, 141, 207, 158, 192, 198, 178, 206, 218, 201, 225, 251, 253, 165, 249, 108, 109, 208, 233, 234, 131, 173, 219, 250, 236, 252, 215, 216, 217, 231, 235, 164, 209, 63, 254, 195, 244, 245, 246, 111, 110, 274, 221, 306, 271, 261, 264, 262, 272, 273, 237, 312, 268, 305, 284, 285, 280, 354, 279, 288, 290, 291, 294, 295, 286, 298, 299, 238, 303, 301, 323, 313, 292, 293, 347, 281, 345, 324, 338, 308, 329, 330, 344, 333, 302, 314, 339, 331, 346, 310, 311, 366, 340, 348, 343, 351, 362, 357, 194, 359, 352, 369, 368, 370, 358, 363, 372, 379, 378, 384, 387, 365, 355, 377, 376, 403, 364, 401, 390, 388, 385, 386, 380, 374, 399, 402, 391, 88, 408, 409, 404, 405, 406, 407, 470, 212, 441, 439, 59, 410, 463, 458, 454, 545, 240, 452, 451, 448, 447, 353, 475, 474, 551, 477, 473, 464, 471, 476, 395, 316, 478, 465, 491, 455, 461, 501, 490, 488, 517, 495, 393, 544, 479, 506, 513, 530, 503, 507, 518, 549, 548, 529, 565, 524, 525, 527, 494, 492, 547, 546, 564, 562, 552, 557, 571, 502, 558, 570, 567, 580, 56, 57, 586, 579, 482, 584, 587, 568, 588, 597, 583, 592, 260, 596, 573, 467, 572, 574, 593, 594, 589, 576, 55, 119, 65, 69, 68, 54, 53, 425, 575, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 39, 40, 33, 577, 578, 38, 35, 36, 83, 85, 86, 92, 93, 99, 121, 104, 105, 113, 117, 118, 120, 122, 124, 125, 126, 127, 128, 133, 134, 135, 137, 138, 139, 142, 152, 153, 154, 159, 167, 168, 169, 174, 176, 177, 182, 183, 184, 185, 186, 187, 190, 193, 197, 202, 203, 204, 210, 214, 220, 222, 223, 224, 228, 227, 229, 230, 242, 243, 247, 256, 257, 258, 265, 266, 269, 275, 276, 277, 278, 282, 296, 297, 304, 309, 318, 319, 320, 321, 325, 327, 328, 335, 336, 337, 341, 342, 349, 356, 360, 361, 373, 375, 383, 389, 392, 394, 397, 398, 400, 411, 414, 415, 416, 417, 426, 427, 428, 440, 442, 443, 444, 445, 446, 449, 450, 456, 457, 460, 462, 466, 469, 480, 481, 493, 499, 500, 504, 505, 508, 510, 511, 514, 516, 519, 520, 521, 522, 523, 526, 541, 542, 543, 550, 555, 556, 560, 561, 563, 566, 581, 582, 585, 590, 591, 595, 143, 437, 144, 255, 429, 430, 431, 145, 432, 433, 434, 435, 436, 3, 263, 75, 32, 129, 26, 27, 28, 382, 31, 472, 267, 283, 419, 420, 422, 421, 189, 34, 7, 10, 322, 73, 147, 148, 166, 418, 553, 554, 30, 211, 213, 162, 163, 259, 149, 150, 270, 157, 160, 239, 94, 95, 146, 100, 101, 102, 103, 424, 22, 172, 175, 179, 196, 287, 315, 438, 528, 4, 350, 367, 381, 24, 453, 5, 199, 6, 11, 12, 18, 19, 20, 21, 23, 140, 289, 161, 8, 509, 512, 300, 489, 483, 484, 485, 486, 487, 515, 569) or ticket.idProject is null) and ticket.idProject not in (0, 16, 29, 13, 15, 553, 94, 101, 199) ) or (ticket.idProject=16 ) or (ticket.idProject=29 ) or (ticket.idProject=13 ) or (ticket.idProject=15 ) or (ticket.idProject=553 ) or (ticket.idProject=94 ) or (ticket.idProject=101 ) or (ticket.idProject=199 ) ) and ( ((ticket.idProject not in (0) or ticket.idProject is null ) and (ticket.idProject not in (0) or ticket.idProject is null or (ticket.idResource=3) ) and (ticket.idProject not in (0) or ticket.idProject is null or (ticket.idUser=3) )) ) order by ticket.id desc
2022-08-25 12:14:10.252 ***** ERROR ***** [V10.0.4] Strack trace :
2022-08-25 12:14:10.252 ***** ERROR ***** [V10.0.4] #0 Sql->query called at [/var/www/html/projeqtor/tool/jsonQuery.php:794]
2022-08-25 12:14:10.252 ***** ERROR ***** [V10.0.4] #1 include called at [/var/www/html/projeqtor/view/print.php:288]
2022-08-25 12:15:06.733 ***** ERROR ***** [V10.0.4] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ticket.test' in 'field list'
2022-08-25 12:15:06.733 ***** ERROR ***** [V10.0.4] For query : select ticket.id as id, ticket.name as name, ticket.idTicketType as idTicketType, ticket.idProject as idProject, ticket.idUrgency as idUrgency, ticket.test as test, ticket.creationDateTime as creationDateTime, ticket.idUser as idUser, ticket.idContact as idContact, ticket.idStatus as idStatus, ticket.idAccountable as idAccountable, ticket.idResource as idResource, ticket.actualDueDateTime as actualDueDateTime, workelement.realWork as realWork, ticket.doneDateTime as doneDateTime, ticket.idProduct as idProduct, ticket.idOriginalProductVersion as idOriginalProductVersion from ticket left join origin on ticket.id = origin.refId and origin.refType='Ticket' left join workelement on ticket.id = workelement.refId and workelement.refType='Ticket' where (ticket.idProject <> 317 or ticket.idProject is null) and ( ( 1=1 and (ticket.idProject in (0, 226, 232, 16, 29, 13, 334, 14, 15, 17, 248, 332, 326, 371, 2, 37, 25, 82, 96, 89, 77, 91, 84, 97, 98, 87, 107, 114, 132, 90, 72, 71, 307, 396, 70, 170, 106, 80, 171, 81, 115, 67, 116, 66, 123, 136, 151, 141, 207, 158, 192, 198, 178, 206, 218, 201, 225, 251, 253, 165, 249, 108, 109, 208, 233, 234, 131, 173, 219, 250, 236, 252, 215, 216, 217, 231, 235, 164, 209, 63, 254, 195, 244, 245, 246, 111, 110, 274, 221, 306, 271, 261, 264, 262, 272, 273, 237, 312, 268, 305, 284, 285, 280, 354, 279, 288, 290, 291, 294, 295, 286, 298, 299, 238, 303, 301, 323, 313, 292, 293, 347, 281, 345, 324, 338, 308, 329, 330, 344, 333, 302, 314, 339, 331, 346, 310, 311, 366, 340, 348, 343, 351, 362, 357, 194, 359, 352, 369, 368, 370, 358, 363, 372, 379, 378, 384, 387, 365, 355, 377, 376, 403, 364, 401, 390, 388, 385, 386, 380, 374, 399, 402, 391, 88, 408, 409, 404, 405, 406, 407, 470, 212, 441, 439, 59, 410, 463, 458, 454, 545, 240, 452, 451, 448, 447, 353, 475, 474, 551, 477, 473, 464, 471, 476, 395, 316, 478, 465, 491, 455, 461, 501, 490, 488, 517, 495, 393, 544, 479, 506, 513, 530, 503, 507, 518, 549, 548, 529, 565, 524, 525, 527, 494, 492, 547, 546, 564, 562, 552, 557, 571, 502, 558, 570, 567, 580, 56, 57, 586, 579, 482, 584, 587, 568, 588, 597, 583, 592, 260, 596, 573, 467, 572, 574, 593, 594, 589, 576, 55, 119, 65, 69, 68, 54, 53, 425, 575, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 39, 40, 33, 577, 578, 38, 35, 36, 83, 85, 86, 92, 93, 99, 121, 104, 105, 113, 117, 118, 120, 122, 124, 125, 126, 127, 128, 133, 134, 135, 137, 138, 139, 142, 152, 153, 154, 159, 167, 168, 169, 174, 176, 177, 182, 183, 184, 185, 186, 187, 190, 193, 197, 202, 203, 204, 210, 214, 220, 222, 223, 224, 228, 227, 229, 230, 242, 243, 247, 256, 257, 258, 265, 266, 269, 275, 276, 277, 278, 282, 296, 297, 304, 309, 318, 319, 320, 321, 325, 327, 328, 335, 336, 337, 341, 342, 349, 356, 360, 361, 373, 375, 383, 389, 392, 394, 397, 398, 400, 411, 414, 415, 416, 417, 426, 427, 428, 440, 442, 443, 444, 445, 446, 449, 450, 456, 457, 460, 462, 466, 469, 480, 481, 493, 499, 500, 504, 505, 508, 510, 511, 514, 516, 519, 520, 521, 522, 523, 526, 541, 542, 543, 550, 555, 556, 560, 561, 563, 566, 581, 582, 585, 590, 591, 595, 143, 437, 144, 255, 429, 430, 431, 145, 432, 433, 434, 435, 436, 3, 263, 75, 32, 129, 26, 27, 28, 382, 31, 472, 267, 283, 419, 420, 422, 421, 189, 34, 7, 10, 322, 73, 147, 148, 166, 418, 553, 554, 30, 211, 213, 162, 163, 259, 149, 150, 270, 157, 160, 239, 94, 95, 146, 100, 101, 102, 103, 424, 22, 172, 175, 179, 196, 287, 315, 438, 528, 4, 350, 367, 381, 24, 453, 5, 199, 6, 11, 12, 18, 19, 20, 21, 23, 140, 289, 161, 8, 509, 512, 300, 489, 483, 484, 485, 486, 487, 515, 569) or ticket.idProject is null) and ticket.idProject not in (0, 16, 29, 13, 15, 553, 94, 101, 199) ) or (ticket.idProject=16 ) or (ticket.idProject=29 ) or (ticket.idProject=13 ) or (ticket.idProject=15 ) or (ticket.idProject=553 ) or (ticket.idProject=94 ) or (ticket.idProject=101 ) or (ticket.idProject=199 ) ) and ( ((ticket.idProject not in (0) or ticket.idProject is null ) and (ticket.idProject not in (0) or ticket.idProject is null or (ticket.idResource=3) ) and (ticket.idProject not in (0) or ticket.idProject is null or (ticket.idUser=3) )) ) order by ticket.id desc
2022-08-25 12:15:06.733 ***** ERROR ***** [V10.0.4] Strack trace :
2022-08-25 12:15:06.733 ***** ERROR ***** [V10.0.4] #0 Sql->query called at [/var/www/html/projeqtor/tool/jsonQuery.php:794]
2022-08-25 12:15:06.733 ***** ERROR ***** [V10.0.4] #1 include called at [/var/www/html/projeqtor/view/print.php:288]
 

Please Connexion or Create an account to join the conversation.

More
25 Aoû 2022 14:33 - 25 Aoû 2022 14:33 #2 by babynus
Replied by babynus on topic CSV extract tickets
There is a reference to non existing field "test".
Possibly you created it and restored DB without clening customization.
Clean customization for Ticket. (remove test field)

Babynus
Administrator of ProjeQtOr web site
Last edit: 25 Aoû 2022 14:33 by babynus.
The following user(s) said Thank You: pdecloedt

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.054 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.