It is currently 31 Oct 2024, 23:09
   
Text Size

merge inventory files

Moderator: CCGHQ Admins

merge inventory files

Postby 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.
raphael75
Programmer
 
Posts: 122
Joined: 18 Feb 2009, 04:31
Has thanked: 87 times
Been thanked: 24 times

Re: merge inventory files

Postby 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.
User avatar
Goblin Hero
Site Admin
Site Admin
 
Posts: 1994
Joined: 23 Oct 2005, 09:37
Location: Russia
Has thanked: 222 times
Been thanked: 353 times

Re: merge inventory files

Postby 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


Return to Masterbase/Sets

Who is online

Users browsing this forum: Baidu [Spider] and 1 guest


Who is online

In total there are 2 users online :: 1 registered, 0 hidden and 1 guest (based on users active over the past 10 minutes)
Most users ever online was 4143 on 23 Jan 2024, 08:21

Users browsing this forum: Baidu [Spider] and 1 guest

Login Form