import csv file to RMS HQ


J

Jose

Hi, I have 873 pages that I need to import to HQ. what do I need to import
this file?
can I do from HQ?
if I can, How?
thanks
Jose
 
Ad

Advertisements

G

Glenn Adams [MVP - Retail Mgmt]

HQ has no built in Import functions (nor does SO).

MS has an UNSUPPORTED import utility called QSImport, but this is for
SO, not HQ. Speak to your reseller or open a support request on
Customer Source to get this utility - or search the newsgroup, I'm sure
you'll find a link to it.

RMS is built on SQL Server, so there are MANY generic import tools that
you can use to load data, but you would have to make sure it is done
correctly, which is difficult as the RMS database is not well
documented; again, search the newsgroup - there are links to what
documents exist...

Retail Realm has an import utility that will work with either SO or HQ
to import several types of data. http://www.retailrealm.us - or see
your reseller.

Digital Retail Solutions has a package specific to Bike Shops that you
might want to take a look at - they may directly support your
distributor's data... I think the url is http://www.digitalretailer.com

Talk to your reseller, they many have another add-in or package that
they recommend.

Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
(e-mail address removed)
 
T

Terrible Tom

873 pages of what?

If it's customers, you can use QSImport and they will be sent to HQ with
your next WS401.

If it's suppliers or items, things get trickier.

QS Import isn't intended for use with HQ but I have used it to import items
into HQ with success. If you decide to try it, make sure you backup your
database first. I would recommend making this an after hours project.

If you import items and want to assign a supplier for each item during the
import, your data has to be perfect.

If you need more info, provide more detail.

Tom
 
J

Jose

Is to import items and suppliers. I have try QS. but you are right not EZ to
do.
 
R

robertinho

Jose, you can use QSImport to import in a SO Database, and then you can
Import from HQ Administrator. In KB there's have a couple of articles that
explain it (dont remember the numbers). This proccedure is recommended if
your HQ DATABASE IS EMPTY.
Contact me if need some help

'(e-mail address removed)'
 
J

Jose

Thanks Robertinho. can you show me how? or tell me where I can read the
articles
 
Ad

Advertisements

R

robertinho

ok
did you have acces to PARTNER SOURCE?

you can visit this url

http://tinyurl.com/gsfy3

in that url yoy can download the utility to import customers, items, matrix,
supliers.

if you dont have access to partner source
email me or msn me to send your the utility import,
my email address is in the past post
 
J

Jose

Yes I do. I will check right now. thanks again robertinho.
jose
 
R

robertinho

ok, email me again
someone wrote me but i push the wrong button and eliminate all my new emails
:( (i hate windows live mail :mad:!!!!)
 
T

Terrible Tom

Jose,

Here's how I did it:

Import the suppliers. Make sure you aren't importing any duplicates.

From the HQ Admin program, run this query and export the result:
SELECT ID, SupplierName from Supplier

Use this data and the VLOOKUP function in Excel to add a SupplierName column
to you item data. For QSimport, you must have an exact match for Supplier
Name for each item.

Good luck,
Tom
 
Ad

Advertisements

J

Jeff

Robert,

You need to understand that this is a Public newsgroup primarily for end
users. End users will only have access to CustomerSource. In addition,
some pages/links in PartnerSource are not accessible via CustomerSource.

PartnerSource is only for MS Partners/resellers.

If you are going to provide a link in this public newsgroup, provide it into
CustomerSource.
 
Ad

Advertisements

D

Developain

If you have the definition of the CSV I can quickly create a simple program
in vb with source code and everything that will allow you to import the data
to whatever database and table you point it to.

No cost. Just want to help as I had this same problem as well.
 

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