Bonjour,
Il va me falloir un plus de temps que je ne le pensais pour reprendre les cinq cent et quelque AIs pour les remettre en ordre.
J'ai joué un peu avec tes dernières modifications.
En testant ceci:
'GS1_Resolver "(01)00883873867792(10)220707(22)AvBn220707(21)PC22412085"
J'obtiens:
https://id.gs1.org/01/00883873867792/10/220707(22)AvBn220707/21/PC22412085
Selon l'ordre défini dans le nouveau module:
Indices.Add "22", 16 Indices.Add "10", 17 Indices.Add "21", 18
Je devrais avoir:
https://id.gs1.org/01/00883873867792/22/AvBn220707/10/220707/21/PC22412085
L'ordre n'est pas respecté.
J'ai ajouté 2 autres DataAttribute plus courant pour tester, soit
Indices.Add "11", 49 Indices.Add "17", 50
J'obtiens:
https://id.gs1.org/01/00883873867792/22/AvBn220707/10/220707(17)241025/21/PC22412085?11&231025
Je devrais avoir:
https://id.gs1.org/01/00883873867792/22/AvBn220707/10/220707/21/PC22412085?17=241025&11=231025
L'ordre n'est pas respecté non plus et il y a un problème avec le "=" entre l'AI et la valeur qui n'est pas géré.
Je n'ai pas réussi à corriger.
Le module supplémentaire compété.
' ############################################# ' # Query chain construction order: # ' ############################################# ' 521 AIs - 2 en double = 519 ' AI: 10 = lotCode, présent 2 fois car peut-être un Key qualifier (Indice N°17) ou un Data attribute (indice N°353) ' AI: 8020 = refNoCode, present 2 fois car peut-étre un Key qualifier (Indice N°21) ou un Data attribute (indice N°461) ' En présence du Primary key "00", l'AI "10" est un Data attribute. ' Dans les autres cas l'AI "10" est un Key qualifier. 'ATTENTION pour l'AI "8020" c'est de contraire de l'AI "10": ' En présence du Primary key "415", l'AI "8020" est un Key qualifier. ' Dans les autres cas l'AI "8020" est un Data attribute. 'Comment gérer ces "doublons" ???, en attendant les indices N° "353" et N° "461" ont étés commenté. Global Indices Sub InitIndices() Set Indices = CreateObject("Scripting.Dictionary") '### Primary key ### 'gtinCode / itipCode / gmnCode / cpidCode / glnCode / 'payToCode / partyGlnCode / gsrnpCode / gsrnCode / gcnCode / 'ssccCode / gdtiCode / gincCode / gsinCode / graiCode / 'giaiCode 'gtinCode Indices.Add "01", 0 'itipCode Indices.Add "8006", 1 'gmnCode Indices.Add "8013", 2 'cpidCode Indices.Add "8010", 3 'glnCode Indices.Add "414", 4 'payToCode Indices.Add "415", 5 'partyGlnCode Indices.Add "417", 6 'gsrnpCode Indices.Add "8017", 7 'gsrnCode Indices.Add "8018", 8 'gcnCode Indices.Add "255", 9 'ssccCode Indices.Add "00", 10 'gdtiCode Indices.Add "253", 11 'gincCode Indices.Add "401", 12 'gsinCode Indices.Add "402", 13 'graiCode Indices.Add "8003", 14 'giaiCode Indices.Add "8004", 15 '### Key qualifier ### 'cpvCode / lotCode / serCode / cpsnCode / glnxCode / 'refNoCode / srinCode / tpxCode / uicExtCode 'cpvCode Indices.Add "22", 16 'lotCode Indices.Add "10", 17 'serCode Indices.Add "21", 18 'cpsnCode Indices.Add "8011", 19 'glnxCode Indices.Add "254", 20 'refNoCode Indices.Add "8020", 21 'srinCode Indices.Add "8019", 22 'tpxCode Indices.Add "235", 23 'uicExtCode Indices.Add "7040", 24 '### Data attribute ### 'netWeightVMTICode / lengthVMTICode / widthVMTICode / depthVMTICode / areaVMTICode / 'netVolumeVMTICode / massPerUnitAreaVMTICode / grossWeightCode / logisticLengthCode / logisticWidthCode / 'logisticDepthCode / logisticAreaCode / logisticVolumeCode / processorCode / LotCode / 'expiryDateCode / expiryTimeCode / contentCode / prodDateCode / dueDateCode / 'packDateCode / bestBeforeDateCode / sellByDateCode / firstFreezeDateCode / harvestDateCode / 'pricePerUnitCode / variantCode / varCountCode / countCode / amountPayPerUnitCode / 'additionalIdCode / custPartNoCode / mtoVariantCode / pcnCode / secondarySerialCode / 'refToSourceCode / amountCode / amountISOCode / priceCode / priceISOCode / 'percentOffCode / orderNumberCode / routeCode / shipToLocCode / billToCode / 'purchaseFromCode / shipForLocCode / prodServLocCode / shipToPostCode / shipToPostISOCode / 'originCode / countryProcessCode / countryFullProcessCode / countryInitialProcessCode / countryDisassemblyCode / 'originSubdivisionCode / nhrnPZNCode /nhrnCIPCode / nhrnCNCode / nhrnDRNCode / 'nsnCode / meatCutCode / activePotencyCode / catchAreaCode / fishingGearTypeCode / 'prodMethodCode / refurbLotCode / funcStatCode / revStatCode / giaiAssemblyCode / 'dimensionsCode / cmtNoCode / ibanCode / prodTimeCode / versionCode / 'refNoCode / couponIDNACode / pointsCode / itipContentCode / certificationRefCode / 'aquaticSpeciesCode / opticalSensorCode / paperlessCouponIDNACode / internalCode / mutualCode / 'extensionCode / shipToCompCode / shipToNameCode / shipToaAdd1Code / shipToaAdd2Code / 'shipToSubCode / shipToLocalityCode / shipToRegCode / shipToCountryCode / shipToPhoneCode / 'rtnToCompCode / rtnToNameCode / rtnToAdd1Code / rtnToAdd2Code / rtnToSubCode / 'rtnToLocCode / rtnToRegCode / rtnToCountryCode / rtnToPostCode / rtnToPhoneCode / 'srvDescriptionCode / dangerousGoodsCode / authToLeaveCode / sigRequiredCode / notBeforeDelDateCode / 'notAfterDelDateCode / releaseDateCode / 'netWeightVMTICode Indices.Add "3100", 25 Indices.Add "3101", 26 Indices.Add "3102", 27 Indices.Add "3103", 28 Indices.Add "3104", 29 Indices.Add "3105", 30 ' Indices.Add "3200", 31 Indices.Add "3201", 32 Indices.Add "3202", 33 Indices.Add "3203", 34 Indices.Add "3204", 35 Indices.Add "3205", 36 ' Indices.Add "3560", 37 Indices.Add "3561", 38 Indices.Add "3562", 39 Indices.Add "3563", 40 Indices.Add "3564", 41 Indices.Add "3565", 42 ' Indices.Add "3570", 43 Indices.Add "3571", 44 Indices.Add "3572", 45 Indices.Add "3573", 46 Indices.Add "3574", 47 Indices.Add "3575", 48 'lengthVMTICode Indices.Add "3110", 49 Indices.Add "3111", 50 Indices.Add "3112", 51 Indices.Add "3113", 52 Indices.Add "3114", 53 Indices.Add "3115", 54 ' Indices.Add "3210", 55 Indices.Add "3211", 56 Indices.Add "3212", 57 Indices.Add "3213", 58 Indices.Add "3214", 59 Indices.Add "3215", 60 ' Indices.Add "3220", 61 Indices.Add "3221", 62 Indices.Add "3222", 63 Indices.Add "3223", 64 Indices.Add "3224", 65 Indices.Add "3225", 66 ' Indices.Add "3230", 67 Indices.Add "3231", 68 Indices.Add "3232", 69 Indices.Add "3233", 70 Indices.Add "3234", 71 Indices.Add "3235", 72 'widthVMTICode Indices.Add "3120", 73 Indices.Add "3121", 74 Indices.Add "3122", 75 Indices.Add "3123", 76 Indices.Add "3124", 77 Indices.Add "3125", 78 ' Indices.Add "3240", 79 Indices.Add "3241", 80 Indices.Add "3242", 81 Indices.Add "3243", 82 Indices.Add "3244", 83 Indices.Add "3245", 84 ' Indices.Add "3250", 85 Indices.Add "3251", 86 Indices.Add "3252", 87 Indices.Add "3253", 88 Indices.Add "3254", 89 Indices.Add "3255", 90 ' Indices.Add "3260", 91 Indices.Add "3261", 92 Indices.Add "3262", 93 Indices.Add "3263", 94 Indices.Add "3264", 95 Indices.Add "3265", 96 'depthVMTICode Indices.Add "3130", 97 Indices.Add "3131", 98 Indices.Add "3132", 99 Indices.Add "3133", 100 Indices.Add "3134", 101 Indices.Add "3135", 102 ' Indices.Add "3270", 103 Indices.Add "3271", 104 Indices.Add "3272", 105 Indices.Add "3273", 106 Indices.Add "3274", 107 Indices.Add "3275", 108 ' Indices.Add "3280", 109 Indices.Add "3281", 110 Indices.Add "3282", 111 Indices.Add "3283", 112 Indices.Add "3284", 113 Indices.Add "3285", 114 ' Indices.Add "3290", 115 Indices.Add "3291", 116 Indices.Add "3292", 117 Indices.Add "3293", 118 Indices.Add "3294", 119 Indices.Add "3295", 120 'areaVMTICode Indices.Add "3140", 121 Indices.Add "3141", 122 Indices.Add "3142", 123 Indices.Add "3143", 124 Indices.Add "3144", 125 Indices.Add "3145", 126 ' Indices.Add "3500", 127 Indices.Add "3501", 128 Indices.Add "3502", 129 Indices.Add "3503", 130 Indices.Add "3504", 131 Indices.Add "3505", 132 ' Indices.Add "3510", 133 Indices.Add "3511", 134 Indices.Add "3512", 135 Indices.Add "3513", 136 Indices.Add "3514", 137 Indices.Add "3515", 138 ' Indices.Add "3520", 139 Indices.Add "3521", 140 Indices.Add "3522", 141 Indices.Add "3523", 142 Indices.Add "3524", 143 Indices.Add "3525", 144 'netVolumeVMTICode Indices.Add "3150", 145 Indices.Add "3151", 146 Indices.Add "3152", 147 Indices.Add "3153", 148 Indices.Add "3154", 149 Indices.Add "3155", 150 ' Indices.Add "3160", 151 Indices.Add "3161", 152 Indices.Add "3162", 153 Indices.Add "3163", 154 Indices.Add "3164", 155 Indices.Add "3165", 156 ' Indices.Add "3600", 157 Indices.Add "3601", 158 Indices.Add "3602", 159 Indices.Add "3603", 160 Indices.Add "3604", 161 Indices.Add "3605", 162 ' Indices.Add "3610", 163 Indices.Add "3611", 164 Indices.Add "3612", 165 Indices.Add "3613", 166 Indices.Add "3614", 167 Indices.Add "3615", 168 ' Indices.Add "3640", 169 Indices.Add "3641", 170 Indices.Add "3642", 171 Indices.Add "3643", 172 Indices.Add "3644", 173 Indices.Add "3645", 174 ' Indices.Add "3650", 175 Indices.Add "3651", 176 Indices.Add "3652", 177 Indices.Add "3653", 178 Indices.Add "3654", 179 Indices.Add "3655", 180 ' Indices.Add "3660", 181 Indices.Add "3661", 182 Indices.Add "3662", 183 Indices.Add "3663", 184 Indices.Add "3664", 185 Indices.Add "3665", 186 'massPerUnitAreaVMTICode Indices.Add "3370", 187 Indices.Add "3371", 188 Indices.Add "3372", 189 Indices.Add "3373", 190 Indices.Add "3374", 191 Indices.Add "3375", 192 'grossWeightCode Indices.Add "3300", 193 Indices.Add "3301", 194 Indices.Add "3302", 195 Indices.Add "3303", 196 Indices.Add "3304", 197 Indices.Add "3305", 198 ' Indices.Add "3400", 199 Indices.Add "3401", 200 Indices.Add "3402", 201 Indices.Add "3403", 202 Indices.Add "3404", 203 Indices.Add "3405", 204 'logisticLengthCode Indices.Add "3310", 205 Indices.Add "3311", 206 Indices.Add "3312", 207 Indices.Add "3313", 208 Indices.Add "3314", 209 Indices.Add "3315", 210 ' Indices.Add "3410", 211 Indices.Add "3411", 212 Indices.Add "3412", 213 Indices.Add "3413", 214 Indices.Add "3414", 215 Indices.Add "3415", 216 ' Indices.Add "3420", 217 Indices.Add "3421", 218 Indices.Add "3422", 219 Indices.Add "3423", 220 Indices.Add "3424", 221 Indices.Add "3425", 222 ' Indices.Add "3430", 223 Indices.Add "3431", 224 Indices.Add "3432", 225 Indices.Add "3433", 226 Indices.Add "3434", 227 Indices.Add "3435", 228 'logisticWidthCode Indices.Add "3320", 229 Indices.Add "3321", 230 Indices.Add "3322", 231 Indices.Add "3323", 232 Indices.Add "3324", 233 Indices.Add "3325", 234 ' Indices.Add "3440", 235 Indices.Add "3441", 236 Indices.Add "3442", 237 Indices.Add "3443", 238 Indices.Add "3444", 239 Indices.Add "3445", 240 ' Indices.Add "3450", 241 Indices.Add "3451", 242 Indices.Add "3452", 243 Indices.Add "3453", 244 Indices.Add "3454", 245 Indices.Add "3455", 246 ' Indices.Add "3460", 247 Indices.Add "3461", 248 Indices.Add "3462", 249 Indices.Add "3463", 250 Indices.Add "3464", 251 Indices.Add "3465", 252 'logisticDepthCode Indices.Add "3330", 253 Indices.Add "3331", 254 Indices.Add "3332", 255 Indices.Add "3333", 256 Indices.Add "3334", 257 Indices.Add "3335", 258 ' Indices.Add "3470", 259 Indices.Add "3471", 260 Indices.Add "3472", 261 Indices.Add "3473", 262 Indices.Add "3474", 263 Indices.Add "3475", 264 ' Indices.Add "3480", 265 Indices.Add "3481", 266 Indices.Add "3482", 267 Indices.Add "3483", 268 Indices.Add "3484", 269 Indices.Add "3485", 270 ' Indices.Add "3490", 271 Indices.Add "3491", 272 Indices.Add "3492", 273 Indices.Add "3493", 274 Indices.Add "3494", 275 Indices.Add "3495", 276 'logisticAreaCode Indices.Add "3340", 277 Indices.Add "3341", 278 Indices.Add "3342", 279 Indices.Add "3343", 280 Indices.Add "3344", 281 Indices.Add "3345", 282 ' Indices.Add "3530", 283 Indices.Add "3531", 284 Indices.Add "3532", 285 Indices.Add "3533", 286 Indices.Add "3534", 287 Indices.Add "3535", 288 ' Indices.Add "3540", 289 Indices.Add "3541", 290 Indices.Add "3542", 291 Indices.Add "3543", 292 Indices.Add "3544", 293 Indices.Add "3545", 294 ' Indices.Add "3550", 295 Indices.Add "3551", 296 Indices.Add "3552", 297 Indices.Add "3553", 298 Indices.Add "3554", 299 Indices.Add "3555", 300 'logisticVolumeCode Indices.Add "3350", 301 Indices.Add "3351", 302 Indices.Add "3352", 303 Indices.Add "3353", 304 Indices.Add "3354", 305 Indices.Add "3355", 306 ' Indices.Add "3360", 307 Indices.Add "3361", 308 Indices.Add "3362", 309 Indices.Add "3363", 310 Indices.Add "3364", 311 Indices.Add "3365", 312 ' Indices.Add "3620", 313 Indices.Add "3621", 314 Indices.Add "3622", 315 Indices.Add "3623", 316 Indices.Add "3624", 317 Indices.Add "3625", 318 ' Indices.Add "3630", 319 Indices.Add "3631", 320 Indices.Add "3632", 321 Indices.Add "3633", 322 Indices.Add "3634", 323 Indices.Add "3635", 324 ' Indices.Add "3670", 325 Indices.Add "3671", 326 Indices.Add "3672", 327 Indices.Add "3673", 328 Indices.Add "3674", 329 Indices.Add "3675", 330 ' Indices.Add "3680", 331 Indices.Add "3681", 332 Indices.Add "3682", 333 Indices.Add "3683", 334 Indices.Add "3684", 335 Indices.Add "3685", 336 ' Indices.Add "3690", 337 Indices.Add "3691", 338 Indices.Add "3692", 339 Indices.Add "3693", 340 Indices.Add "3694", 341 Indices.Add "3695", 342 'processorCode Indices.Add "7030", 343 Indices.Add "7031", 344 Indices.Add "7032", 345 Indices.Add "7033", 346 Indices.Add "7034", 347 Indices.Add "7035", 348 Indices.Add "7036", 349 Indices.Add "7037", 350 Indices.Add "7038", 351 Indices.Add "7039", 352 'lotCode ' Indices.Add "10", 353 ' => Indices "17" 'expiryDateCode Indices.Add "17", 354 'expiryTimeCode Indices.Add "7003", 355 'contentCode Indices.Add "02", 356 'prodDateCode Indices.Add "11", 357 'dueDateCode Indices.Add "12", 358 'packDateCode Indices.Add "13", 359 'bestBeforeDateCode Indices.Add "15", 360 'sellByDateCode Indices.Add "16", 361 'firstFreezeDateCode Indices.Add "7006", 362 'harvestDateCode Indices.Add "7007", 363 'pricePerUnitCode Indices.Add "8005", 364 'variantCode Indices.Add "20", 365 'varCountCode Indices.Add "30", 366 'countCode Indices.Add "37", 367 'amountPayPerUnitCode Indices.Add "3950", 368 Indices.Add "3951", 369 Indices.Add "3952", 370 Indices.Add "3953", 371 Indices.Add "3954", 372 Indices.Add "3955", 373 'additionalIdCode Indices.Add "240", 374 'custPartNoCode Indices.Add "241", 375 'mtoVariantCode Indices.Add "242", 376 'pcnCode Indices.Add "243", 377 'secondarySerialCode Indices.Add "250", 378 'refToSourceCode Indices.Add "251", 379 'amountCode Indices.Add "3900", 380 Indices.Add "3901", 381 Indices.Add "3902", 382 Indices.Add "3903", 383 Indices.Add "3904", 384 Indices.Add "3905", 385 Indices.Add "3906", 386 Indices.Add "3907", 387 Indices.Add "3908", 388 Indices.Add "3909", 389 'amountISOCode Indices.Add "3910", 390 Indices.Add "3911", 391 Indices.Add "3912", 392 Indices.Add "3913", 393 Indices.Add "3914", 394 Indices.Add "3915", 395 Indices.Add "3916", 396 Indices.Add "3917", 397 Indices.Add "3918", 398 Indices.Add "3919", 399 'priceCode Indices.Add "3920", 400 Indices.Add "3921", 401 Indices.Add "3922", 402 Indices.Add "3923", 403 Indices.Add "3924", 404 Indices.Add "3925", 405 Indices.Add "3926", 406 Indices.Add "3927", 407 Indices.Add "3928", 408 Indices.Add "3929", 409 'priceISOCode Indices.Add "3930", 410 Indices.Add "3931", 411 Indices.Add "3932", 412 Indices.Add "3933", 413 Indices.Add "3934", 414 Indices.Add "3935", 415 Indices.Add "3936", 416 Indices.Add "3937", 417 Indices.Add "3938", 418 Indices.Add "3939", 419 'percentOffCode Indices.Add "3940", 420 Indices.Add "3941", 421 Indices.Add "3942", 422 Indices.Add "3943", 423 'orderNumberCode Indices.Add "400", 424 'routeCode Indices.Add "403", 425 'shipToLocCode Indices.Add "410", 426 'billToCode Indices.Add "411", 427 'purchaseFromCode Indices.Add "412", 428 'shipForLocCode Indices.Add "413", 429 'prodServLocCode Indices.Add "416", 430 'shipToPostCode Indices.Add "420", 431 'shipToPostISOCode Indices.Add "421", 432 'originCode Indices.Add "422", 433 'countryProcessCode Indices.Add "424", 434 'countryFullProcessCode Indices.Add "426", 435 'countryInitialProcessCode Indices.Add "423", 436 'countryDisassemblyCode Indices.Add "425", 437 'originSubdivisionCode Indices.Add "427", 438 'nhrnPZNCode Indices.Add "710", 439 'nhrnCIPCode Indices.Add "711", 440 'nhrnCNCode Indices.Add "712", 441 'nhrnDRNCode Indices.Add "713", 442 'nhrnAIMCode '* Indices.Add "714", 443 'nhrnUS-FDACode '* Indices.Add "715", 444 'nsnCode Indices.Add "7001", 445 'meatCutCode Indices.Add "7002", 446 'activePotencyCode Indices.Add "7004", 447 'catchAreaCode Indices.Add "7005", 448 'fishingGearTypeCode Indices.Add "7009", 449 'prodMethodCode Indices.Add "7010", 450 'testByDateCode '* Indices.Add "7011", 451 'refurbLotCode Indices.Add "7020", 452 'funcStatCode Indices.Add "7021", 453 'revStatCode Indices.Add "7022", 454 'giaiAssemblyCode Indices.Add "7023", 455 'dimensionsCode Indices.Add "8001", 456 'cmtNoCode Indices.Add "8002", 457 'ibanCode Indices.Add "8007", 458 'prodTimeCode Indices.Add "8008", 459 'versionCode Indices.Add "8012", 460 'refNoCode ' Indices.Add "8020", 461 ' => Indices "21" 'couponIDNACode Indices.Add "8110", 462 'pointsCode Indices.Add "8111", 463 'itipContentCode Indices.Add "8026", 464 'certificationRefCode Indices.Add "7230", 465 Indices.Add "7231", 466 Indices.Add "7232", 467 Indices.Add "7233", 468 Indices.Add "7234", 469 Indices.Add "7235", 470 Indices.Add "7236", 471 Indices.Add "7237", 472 Indices.Add "7238", 473 Indices.Add "7239", 474 'aquaticSpeciesCode Indices.Add "7008", 475 'opticalSensorCode Indices.Add "8009", 476 'paperlessCouponIDNACode Indices.Add "8112", 477 'internalCode Indices.Add "91", 478 Indices.Add "92", 479 Indices.Add "93", 480 Indices.Add "94", 481 Indices.Add "95", 482 Indices.Add "96", 483 Indices.Add "97", 484 Indices.Add "98", 485 Indices.Add "99", 486 'mutualCode Indices.Add "90", 487 'extensionKey Indices.Add "", 488 'AI AlphaNumérique ... 'shipToCompCode Indices.Add "4300", 489 'shipToNameCode Indices.Add "4301", 490 'shipToAdd1Code Indices.Add "4302", 491 'shipToAdd2Code Indices.Add "4303", 492 'shipToSubCode Indices.Add "4304", 493 'shipToLocalityCode Indices.Add "4305", 494 'shipToRegCode Indices.Add "4306", 495 'shipToCountryCode Indices.Add "4307", 496 'shipToPhoneCode Indices.Add "4308", 497 'shipToGeo Indices.Add "4309", 498 'rtnToCompCode Indices.Add "4310", 499 'rtnToNameCode Indices.Add "4311", 500 'rtnToAdd1Code Indices.Add "4312", 501 'rtnToAdd2Code Indices.Add "4313", 502 'rtnToSubCode Indices.Add "4314", 503 'rtnToLocCode Indices.Add "4315", 504 'rtnToRegCode Indices.Add "4316", 505 'rtnToCountryCode Indices.Add "4317", 506 'rtnToPostCode Indices.Add "4318", 507 'rtnToPhoneCode Indices.Add "4319", 508 'srvDescriptionCode Indices.Add "4320", 509 'dangerousGoodsCode Indices.Add "4321", 510 'authToLeaveCode Indices.Add "4322", 511 'sigRequiredCode Indices.Add "4323", 512 'notBeforeDelDateCode Indices.Add "4324", 513 'notAfterDelDateCode Indices.Add "4325", 514 'releaseDateCode Indices.Add "4326", 515 '??? ' Indices.Add "7240", 516 '* '??? ' Indices.Add "8200", 517 '??? ' Indices.Add "3956", 518 '??? ' Indices.Add "3957", 519 '??? ' Indices.Add "3958", 520 '??? ' Indices.Add "3959", 521 'Nouveaux AI PRJ 2027: '* '7240, Date and time of production,PROD TIME '7241,Optically Readable Sensor Indicator,OPTSEN '7242,Component/Part Identifier (CPID),CPID '4330,Functional status,FUNC STAT '4331,Revision status,REV STAT '4332,Global Individual Asset Identifier (GIAI) of an assembly,GIAI - ASSEMBLY '4333,Number of processor with three-digit ISO country code,PROCESSOR # 0 End Sub
20 févr. 2024 à 15:37
L'ordre pour les KeyQualifiers via les indices fonctionnes avec :
GS1_Resolver "010088387386779210220707" + Chr(29) + "22AvBn220707" + Chr(29) + "21PC22412085"
Debug.Print LigneHRI
Debug.Print Url
Donne:
(01)00883873867792(22)AvBn220707(10)220707(21)PC22412085
https://id.gs1.org/01/00883873867792/22/AvBn220707/10/220707/21/PC22412085
C'est avec les Ais entre parenthèses qu'il y a un souci:
GS1_Resolver "(01)00883873867792(10)220707(22)AvBn220707(21)PC22412085"
Debug.Print LigneHRI
Debug.Print Url
Donne:
(01)00883873867792(10)220707(22)AvBn220707(21)PC22412085
https://id.gs1.org/01/00883873867792/10/220707(22)AvBn220707/21/PC22412085
Modifié le 21 févr. 2024 à 23:35
Bonsoir,
Je viens d'échanger avec un membre de la communauté GS1
Concernant les code-barres scannés avec les AIs "enveloppés" de parenthèses.
Exemple:
(01)00883873867792(22)AvBn220707(10)220707(21)PC22412085
Il semblerait que la bonne pratique soit de replacer les balises de fin quand elles sont requises avant l'ouverture de la parenthèse du prochain AI et ensuite de supprimer les parenthèses autour des AIs avant traitement
Exemple avec la balise de fin habituel " + Chr(29) + ", on saies que les AIs 22, 10 et 21 la requièrent grâce aux patterns et \x1d.
Ce qui donne:
"010088387386779222AvBn220707" + Chr(29) + "10220707" + Chr(29) + "21PC22412085"
Quand tu auras un petit moment, pourrais-tu regarder comment gérer cela?
21 févr. 2024 à 23:45
Cette semaine compliqué, mais je devrais être plus libre la semaine prochaine
26 févr. 2024 à 20:32
Comme tu présentes 2 codes différents, j'étais un peu perplexe, sans explications de ta part.
J'ai donc essayé ça
Ce qui me donne
Du coup, ok, c'est pas dans le même ordre.
Après investigation, le problème vient du pattern suivant
Là dedans
Y'a les parenthèses d'autorisées, du coup ça matche (10)220707(22)AvBn220707
Du coup, il faudrait vérifier ce point, parce que si les parenthèses sont bien autorisées, ça ne va pas être facile.
26 févr. 2024 à 21:30
C'est le même code.
Le 1er avec les parenthèses.
Le 2eme sans parenthèses et les "balises de fin" repositionnées.
Oui les parenthèses sont bien autorisées!
C'est dans ce sens que s'oriente mon message 246.
Si le code-barres à les AIs entre parenthèses, l'idée est de reconstruit un code-barres sans parenthèses et de replacer les "balises de fin" avant traitement.
En partant de ceci:
(01)00883873867792(22)AvBn220707(10)220707(21)PC22412085
Obtenir:
010088387386779222AvBn220707"balises de fin pour l'AI 22"10220707"balises de fin pour l'AI 10"21PC22412085
Je ne suis peut-être pas très claire dans mon explication ?
Je ne suis pas sûr qu'en suppriment simplement les parenthèses cela suffisent !