Well here is what I am shooting for:

Easy ones:

100% if Locality is in the data - done
100% if Locality not available, but Rating is available and unique - done

Now the hard ones are:

(1) Locality not in the data, Rating available but not unique
(2) Neither Locality nor Rating available in the data, then default is GS1 code lookup

Both (1) and (2) are dependent on the data. If you have ideas for improving the percentage correct, let me know - for example, I have considered asking the user for a "default Locality" to be used if I don't have a good guess. Also, I could code in specific exceptions if they are known and consistent ( a consistent exception???). For example if the first x digits = whatever, then it is always a certain Locality, even if the first 3 digits of the UPC have a different GS1 mapping. If you know any of those, give me the list and I will code them in.

Quoting mediadogg:

Quote:
Now up to 18/25 correct on Test 2, with no special handling of exceptions.

Well 72% is quite good for this case (I'd guess that the similar UK/Ireland/Australia ratings mess things up a bit)
That would still beat the heck out of e.g. entering loads of personal information by hand if one wants to import his collection, so a clear 

cya, Mithi

Quoting mediadogg:

Quote:
Any ideas for some heuristics that would improve the score?

Heu...what?

Well if I could program at all I'd try:
1) Locality
2) SRP-Currency
3) Rating
4) GS1-Countrycodes

Where 2-4 should depend on each other, a SRP-currency "Euro" would weed out UK and Australia for a rating shared by UK/Ireland/Australia. After that as a last effort the GS-1 which is, as seen, notoriously inaccuarate at least inside Europe. All depending of course whether those fields are present at all.

Quote:
I would just cycle through the locality choices and ask "is this valid?" until I got a match (or not). Of course I would need to cycle only when Locality is not in the data and Rating, if present, is not unique.

Or, as an option, a dirty fix: if more than one possible profile comes up, just add them all with exactly the same personal data (maybe with an additional tag "multiples"). Reason: I think for the new-by it would be easier to look at the two or more profiles and delete the wrong one(s) then to toggle through the possibilities with Collection -> Change Locality


cya, Mithi

Whew! 

Uncovered a whole nest of bugs in my Ratings subsystem. Slowly moving forward.

Now up to 20/25 without any coding for exceptions or using the currency trick. Everything is table driven so far, so I would expect these results to hold for similar data.

Now, maybe I will try Mithi's currency trick ... I'll use the SRP currency if available, otherwise I'll try Purchase Price currency if available. Last ditch effort is the GS1 code, which is useless in these test cases, by design. I think only 2/25 are correct with the GS1 mapping. Hopefully nobody will have a data set packed so full of these types of exceptions.

Based on the way my code is set up, I won't be able to add multiple profiles with alternate localities at the moment - in fact I'm not entirely sure I want to do it that way. I'm still considering it though.

BulkEdit V2.33 Available

- Added auto-recognition of CSV header fields to pre-fill the mapping table
- Improved locality handling on CSV Import when Rating is available
- Improved display of Rating information
- Corrected errors in Currency dropdown
- Corrected bug in CSV Import in building manual Profile ID when Locality available
- Fixed the empty CaseType bug, but you will still be restricted to official DVDP dropdown values
- Fixed another bug relating to column copy that was created accidentally on a previous update
- Fixed the bug that ignores Locality when included in CSV import
- Added a "Tools\Quick Search (Alt-F9)" menu item. Currently only Collection Number supported. Other fields will be added by request.

Thanks to Mithi and Rander for bug reports and excellent diagnostic information.

Ok, I think that is the rollup of existing bugs and feature requests. Let me know if I missed anything or messed something up.

Oh drat. Will I ever get this software free of bugs!!! 

Thanks for the report.

hi mediadogg,

an user has a very specific problem that I thought he could solve with BulkEdit.

My Idea was to simply use "Copy Column To Column" to duplicate the data from the 'Edition'-field to 'Location' and 'Slot', but the 'Edition' isn't available!
Would it be very complicated to add this field? At least to the "From"-selection as a source of data.

cya, Mithi

Quoting mediadogg:

Quote:
No problem. For you, anything can be done ... 

Can you wire me 2 Million USD? 
(worth a try!  )

Quote:
Working on the 3.8.1 update trying to be ready when it goes live. If you need it before then, PM me and I'll give you a link to my work in progress

Nah, I don't think it's really urgent, take your time.

Quote:
From that post, it seems that your thought is to use regex to parse the location and slot out after the copy. I'm not a regex expert, so I hope you stay engaged with the user. Sounds like a good plan.

I toyed around a bit and managed to sever my two-words Edition (copied via XML) into their individual parts.

cya, Mithi