uShop English (U.S.) for 179!

uStorekeeper English (U.S.) for 149!

 Products
       uTest
       uReserve
       uShop
       uStorekeeper
       uGolf
       uDirectory
       uSignIn
 Tech Support
       Support Policy
       Knowledge Base
            uTest
            uReserve
            uShop
            uStorekeeper
            uGolf
            uDirectory
            uSignIn
       Documentation
       Reference Sites
 Legal
       Software Piracy
       Legal Notices
       Privacy Policy
       Licensing
 Miscellaneous
       Reseller Info
       Contact Us
       Site Map
Importing Data

Knowledge Base Lobby : uStorekeeper Support Conference : General Questions
Dec-12-17 02:46 PM EST
Original Message
Importing Data
Author ICNJill on 07-09-2002 at 01:25 (EST)
Okay.. here's a bonehead question. I would like to import my data and have done it successful just using notepad and creating the file that way. The problem is that it's a sucky way to do it. I couldn't figure out how to save file made in access as a flat file database that imported correctly?? How about in excel??? How do people normally prepare the file?? Just with notepad.. or what.

The instructions that came with it didn't help at all with respect to which programs to use to create the file, if any? I'd love to use something other than notepad. Any suggestions? Please email me your answer.

Jill@ic-network.com
E-MAIL AUTHOR | TABLE OF CONTENTS

Table Of Contents
  RE: Importing Data Bill Weiner, 2002-07-09 04:50:16 (1)
            If only it were that easy Jill, 2002-07-09 22:43:43 (2)
                 RE: If only it were that easy Bill Weiner, 2002-07-10 06:47:31 (3)
                      What do other clients use? Jill, 2002-07-10 13:28:56 (4)
                           RE: What do other clients use? Bill Weiner, 2002-07-11 06:01:20 (5)

Messages In This Discussion
         1. RE: Importing Data
        Author Bill Weiner on 07-09-2002 at 04:50 (EST)
You really should be able to use any program... such as MS Access or MS Excel to create the import data file.... just as long as the import data file is in the bar-delimited format described in section 8 of the uStorekeeper User's Guide:

http://www.uburst.com/uStorekeeper/UsersGuide.html#ImportingData

If the data is not being imported, then you may want try opening the Access/Excel-generated file with a text editor and see where the formatting is wrong.
TABLE OF CONTENTS
                 2. If only it were that easy
                Author Jill on 07-09-2002 at 22:43 (EST)
Okay... so I've tried Access and Excel and the problem is that none have a bar delimited format. Yes, I can find comma, tab or space. But no bar-delimited.

So... how should the file be saved in any of these programs to reach the bar-delimited format???

Jill
TABLE OF CONTENTS
                         3. RE: If only it were that easy
                        Author Bill Weiner on 07-10-2002 at 06:47 (EST)
I'm pretty sure there is a way (possibly in a Template Wizard??) where you can specify the delimiter to be any character you want. (Although, I just spent 5 minutes with Excel and didn't see it.) I guess worse-comes-to-worse, you could use a tab-delimiter and then do a search-and-replace on the generated file to change the tabs to bars. Kind of a pain, but....

Also, if you do use some intermediate delimiter, you'll probably have to use tabs... because commas and spaces will probably interfere with the uStorekeeper data.
TABLE OF CONTENTS
                                 4. What do other clients use?
                                Author Jill on 07-10-2002 at 13:28 (EST)
FYI... What do other clients use to generate their data files??? Cause, if you couldn't see it, and I couldn't see it... well then... we're both missing something. I did the search and replace and it didn't work easily. Not worth doing as it added a variety of extras that needed to be tweaked out.

Surely, there's an easier way, eh?

Jill
TABLE OF CONTENTS
                                         5. RE: What do other clients use?
                                        Author Bill Weiner on 07-11-2002 at 06:01 (EST)
I'm not that familiar with all of the features and utilities of MS Access and MS Excel .... so maybe someone else out there will answer your question on how to export data from those programs with "bar" delimiters?

In the meain time, if you export with the "tab" delimiter and then do the search-and-replace with the "bar" character... just be sure to do a "Replace All". That shouldn't be difficult.

TABLE OF CONTENTS

© 2003 Microburst Technologies, Inc.