We have started to play around with getting the data OUT of EXPLORIS ( NexPart by WHI ) and into Excel. There are many things you can do with the data in excel that you can not do in standard reports ..... for example I just noticed that each of our 3 stores has approx 300 sku's of parts that do NOT have data in the PN Code ( sub line ) .... gee ... that could have been eliminated with better programing - do NOT allow this field to be BLANK when you write up a new part ( as one example )
Anyways - I finally got the ENTIRE dump to come thru without CRASHING EXPLORIS ( see image ) -t takes 13,682 pages of a report ( 3 stores ) and copies to Excel (data only)
Once you start working the data -- you file sizes drop-- we had approx 100mb file with 8 sheets ( as older excel stop at 65,000 rows ) --then copied and pasted into one sheet ...saved as newer version .XLSX and file size drops to 31 mb ...along the way re trashed the JUNK they also put into the report ( like the total of every part for every line ) and dropped the over 500,000 lines in excel to 375,000 lines ( each store has 1/3 of this - we started with 42,000 good parts when we went to EXPLORIS and quickly inherited another approx 80,000 of JUNK ????? WTF .... and these junk lines can not be deleted ... we tried a few in the ABA line as it pops up first ( ABA is Exide ....from 100 years ago ??? since we use BAT by East Penn )
The next time we try this and EXPLORIS CRASHES --- damm -- but at least we got this report out .....
No comments:
Post a Comment