merge inventory files
Moderator: CCGHQ Admins
merge inventory files
by raphael75 » 24 Jul 2009, 20:08
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.
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.
- raphael75
- Programmer
- Posts: 122
- Joined: 18 Feb 2009, 04:31
- Has thanked: 87 times
- Been thanked: 24 times
Re: merge inventory files
by Goblin Hero » 28 Jul 2009, 14:37
Try the attached file. It can export inventory/library files to MS Access and vice versa.
- Attachments
-
- MWSView.rar
- (507.05 KiB) Downloaded 494 times
When you´re a goblin, you don´t have to step forward to be a hero -- everyone else just has to step back.
-
Goblin Hero - Site Admin
- Posts: 1994
- Joined: 23 Oct 2005, 09:37
- Location: Russia
- Has thanked: 222 times
- Been thanked: 353 times
Re: merge inventory files
by raphael75 » 29 Jul 2009, 03:53
Thank you, Goblin Hero! I'll test it out soon.
- raphael75
- Programmer
- Posts: 122
- Joined: 18 Feb 2009, 04:31
- Has thanked: 87 times
- Been thanked: 24 times
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: Baidu [Spider] and 1 guest