Starting to work on updating service records. First problem - no vendor field made it from 3.0 to 4.0. All records are ‘NULL’ for vendor - ZServicedBy - I ‘assume’ that is the correct field - no records have any info in ‘facility/Vendor’ (for me, that’s 111 records!).
Additionally, I can’t make sense of the order in the service list. It is not in date order as other lists are, it also is not in name order - I would think date order is the preferred order . . but is also not in database record order either so I’m at a loss on that one . . will attach picture of what the list looks like.
Thanks Steve. Both bugs fixed for the next build. Service Records are now listed in a sane order, and the vendor field is now properly imported for future imports.
I can run a quick script to add the missing vendor fields if you’d like to send me your legacy database, plus an export of your current database.
If I can’t figure it out myself, I’ll do that but I think I want to try it myself - just to make sure I can still do things I used to do without thinking . . .
Did it - got all records updated. Only curve was the ZVendor in the ZServiceRecord expected a PK from the Vendor table, not the vendor name. Just added another step to get it done . . but, no biggie . . .
