www.uburst.com www.uburst.com

"Importing Data"

Go back to the LobbyClick here to Go Back to Main ListingClick here to see helpClick here to Search the Forum

General Questions
Forum Type: Public
Moderator: edmunds
Time Zone: EST
Printer Friendly Format
Original Message
 
"Importing Data"
Posted by ICNJill on Jul-09-02 at 01:25 AM (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

Click to Send Alert Message to the Administrator Click to edit this messageClick to EMail Click here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents

 Table of Contents

RE: Importing Data, Bill Weiner, Jul-09-02, (1)
If only it were that easy, Jill, Jul-09-02, (2)
RE: If only it were that easy, Bill Weiner, Jul-10-02, (3)
What do other clients use?, Jill, Jul-10-02, (4)
RE: What do other clients use?, Bill Weiner, Jul-11-02, (5)

 

 
Click here to goto Click here to goto the Lobby
Messages in this discussion
 
1 . "RE: Importing Data"
Posted by Bill Weiner on Jul-09-02 at 04:50 AM (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.

Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents
 
2 . "If only it were that easy"
Posted by Jill on Jul-09-02 at 10:43 PM (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

Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick to EMail Click here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents
 
3 . "RE: If only it were that easy"
Posted by Bill Weiner on Jul-10-02 at 06:47 AM (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.

Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents
 
4 . "What do other clients use?"
Posted by Jill on Jul-10-02 at 01:28 PM (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

Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick to EMail Click here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents
 
5 . "RE: What do other clients use?"
Posted by Bill Weiner on Jul-11-02 at 06:01 AM (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.

Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents


Archive This Thread: Admin and Moderator OnlyRemove This Thread: Admin and Moderator Only
Click here to goto Click here to goto the Lobby

 

 

 

 

 

 

 

 

 

 

 

 
Questions or problems regarding this bulletin board should be directed to Webmaster
©1997-1999 by DCScripts. All rights reserved.