Page 1 of 1

merge inventory files

PostPosted: 24 Jul 2009, 20:08
by raphael75
Is there any possible way to merge several Inventory files into a single file and preserve the values in the QTY (Quantity) field?

In researching this, I learned that the MWS databases (Deck, Inventory, and master files) are actually .cds format (Delphi TClientDataset) files but just have their extension renamed to be .mwdeck, etc. instead of .cds.

I've searched for hours to find a program that can open .cds files (something like Excel or Access for .cds), but the few I found couldn't do anything with the data other than look at it. I thought xbaseviewpro might work, but it was nothing like Excel where you could select a range of values and paste them into another .cds file. At best you could only select 1 row at a time, and it can't export to .cds, only .cds XML which I'm assuming is something different that MWS wouldn't be able to read.

I just can't understand why MWS doesn't copy the Quantity field so you can merge inventory files together and preserve the QTY field values. Feeling very frustrated.

Thanks.

Re: merge inventory files

PostPosted: 28 Jul 2009, 14:37
by Goblin Hero
Try the attached file. It can export inventory/library files to MS Access and vice versa.

Re: merge inventory files

PostPosted: 29 Jul 2009, 03:53
by raphael75
Thank you, Goblin Hero! I'll test it out soon.