1) Database schema, 2) Import utility


P

Poppy

I have two questions about Microsoft's RMS app.:

1) How can I view the database schema? In particular, I wanted to see the
link table for the tables Supplier and Item (e.g. I have an Item table then I
add a new Supplier, relating it to an Item, therefore, a link table must
exist).

2) Any suggestions for an import utility? I have an Excel spreadsheet with a
many to many relationship between suppliers and items. I want to import this
spreadsheets' data into the RMS producing three tables - Supplier, Item,
Supplier_Item link table.

Many thanks,
Poppy
 
Ad

Advertisements

T

Terrible Tom

You can use the QSCImport utility to import items & suppliers. It will
automatically connect the two tables. Make *absolutely* certain that the
Supplier data for every record in the Items table has an EXACT match on the
Supplier table. I'd recommend importing the Supplier table first.

I have (and have used with some success) EMS SQL Data Import/Export. It's a
decent product, but for some tasks less is more - in this case, the QSCImport
utility will probably treat you better.

If you don't have access to CustomerSource, you can download it from
jeanholland.com (free registration required).

HTH,
Tom
 
P

Poppy

Thanks Tom. I will check out that utility.

Now I need to look at the database schema. Maybe it's not possible with just
the Retail Mangement System application?

Poppy
 
M

Mick Hardy

Jeff,

Thanks for the link. The page is clearly labelled "Partner Only Article"
but the link works fine for Customers and has heaps of cool documentation to
download. Finally, an explanation for QSBridge, my missing link and Hooks
explained. Nice. Wish I'd found this two weeks ago. I searched high and
low for this on Customer Source with no luck.
 
M

Mick Hardy

Poppy,

There are no restrictions on the database schema. Just install the SQL
Server Client Interface and you have full access to everything. I think
there are trial versions available. This works for MSDE and SQL.

Another way you can gain access to the schema and table definitions is to
create an ODBC connection from the Administrator Control Panel in XP and link
to it with MS Access. You can use MS Access to import data from Excel. Its
also great for quick and easy queries and reports.

I personally did exactly what you're attempting using the Data
Transformation Services (DTS) built into SQL Server. My sources were Excel
spreadsheets with item information and supplier information. This took a lot
of trial and error on a development system and isn't a particulary easy
solution but it's as robust as you get.

These are grass roots suggestions. The utilities others have suggested are
far easier solutions but if you want total control, use DTS.
 
Ad

Advertisements

M

Mick Hardy

SQL Server 2000 Evaluation Edition Download (120-Day Trial). This is full
blown SQL Server 2000 but you only need to install the client tools and link
the Enterprise Manager to the MSDE installation of RMS.

http://tinyurl.com/j8qw2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top