Feb-05-2017, 11:30 AM
Pretty much. We have recalls, each with a recall number. They are in the format 16-018 (the 18th recall of 2016). That format, with the dash, is how they appear in all of our public documents. But for years the system wouldn't recognize recall numbers with a dash. It had to be 16018.
We have numeric product codes in the range 100-9999. When they (actually another set of contractors) built the database, they stored them as strings. That meant that when you searched for '801' in the interface, it also pulled up '1801', '2801', '3801', and so on. I'm having problems with exported data from the interface. When you export an Excel spreadsheet, all the dates are exported as strings. When you sort, '01/01/2017' comes before '12/31/1995'. You have to export it as csv, and then load the csv into Excel, in order to get it to recognize the dates as dates.
It just goes on and on and on. We're on our fourth set of contractors now. The second set got fired because they connected the test environment to the public web site, which posted a bunch of reports containing text like 'ka;jd;flakjd;afjkf'.
We have numeric product codes in the range 100-9999. When they (actually another set of contractors) built the database, they stored them as strings. That meant that when you searched for '801' in the interface, it also pulled up '1801', '2801', '3801', and so on. I'm having problems with exported data from the interface. When you export an Excel spreadsheet, all the dates are exported as strings. When you sort, '01/01/2017' comes before '12/31/1995'. You have to export it as csv, and then load the csv into Excel, in order to get it to recognize the dates as dates.
It just goes on and on and on. We're on our fourth set of contractors now. The second set got fired because they connected the test environment to the public web site, which posted a bunch of reports containing text like 'ka;jd;flakjd;afjkf'.
Craig "Ichabod" O'Brien - xenomind.com
I wish you happiness.
Recommended Tutorials: BBCode, functions, classes, text adventures
I wish you happiness.
Recommended Tutorials: BBCode, functions, classes, text adventures