Importing Orders Text File into MS Access or Excel

[CG]

Hi,

So, I downloaded our Orders text file. I'm trying to import the text file
into Excel and/or MS Access to massage the data and run custom reports.
However, Excel and MS Access craps out when it tries to import a customer
order with more than 18 line items.

Anyone experience the same problem?

Thanks,
Cheryl
Bliss! Weddings Market
www.BlissWeddingsMarket.com

[Barney Stone]

Due to the complex structure of ShopSite order downloads (with a variable
number of line items per text file record) it is difficult to import the
data directly into Excel or Access in any meaningful form without using a
program to break up the data into fields that have to do with the order
itself (address and payment info) and separate records for each line item.

You can save a lot of time and trouble, and add a huge amount of power to
your ShopSite store as well as any manual and point-of-sale orders that you
process, by getting the Stone Edge Order Manager for ShopSite
(http://www.stoneedge.com/OrderManager.htm).

If you handle more than 10 or 15 orders per day, the Order Manager should
pay for itself in saved time and trouble in a few weeks.

- Barney Stone, President
Stone Edge Technologies, Inc.
215-641-1837
www.ECommerceUtilities.com


"CG" <cgalvez@blissweddings.com> wrote in message
news:ann6jb$ut1$1@support.shopsite.com...

Hi,

So, I downloaded our Orders text file. I'm trying to import the text file
into Excel and/or MS Access to massage the data and run custom reports.
However, Excel and MS Access craps out when it tries to import a customer
order with more than 18 line items.

Anyone experience the same problem?

Thanks,
Cheryl
Bliss! Weddings Market
www.BlissWeddingsMarket.com

[Andrew G]

what version of shopsite do you have?

I recently attempted to do the same thing with v4.1 and was unsuccessful
with excel, but totally succesful with Access. When you select download
database in v4.1 it spits out the data into the browser window itself and
the only way i could get it to text file was to copy/paste to notepad. One
my first attempt this was impossible because of my computer's memory
limitations (the database was too big for my computer to handle a paste!),
but when my company upgraded it systems I able to paste it to notepad.

After that, it was just a matter of renaming the file to .tab so Access
recognizes it as a tab delimited file. I was able to open the file directly
into access, complete the import data wizard, and voila. As far as why it
stops at 18 items for your case... i dunno... I just hope my experience
helps any.


"CG" <cgalvez@blissweddings.com> wrote in message
news:ann6jb$ut1$1@support.shopsite.com...

Hi,

So, I downloaded our Orders text file. I'm trying to import the text file
into Excel and/or MS Access to massage the data and run custom reports.
However, Excel and MS Access craps out when it tries to import a customer
order with more than 18 line items.

Anyone experience the same problem?

Thanks,
Cheryl
Bliss! Weddings Market
www.BlissWeddingsMarket.com

[loren_d_c]

That's odd, normally when I cut-and-paste from the browser window the tabs are
lost. Usually I have to use the File -. Save As... function of the browser to
save it as a text file in order to preserve the tabs. That is in IE. In
Netscape you should be prompted to download the file directly to your desktop.

-Loren


Andrew G wrote:

what version of shopsite do you have?

I recently attempted to do the same thing with v4.1 and was unsuccessful
with excel, but totally succesful with Access. When you select download
database in v4.1 it spits out the data into the browser window itself and
the only way i could get it to text file was to copy/paste to notepad. One
my first attempt this was impossible because of my computer's memory
limitations (the database was too big for my computer to handle a paste!),
but when my company upgraded it systems I able to paste it to notepad.

After that, it was just a matter of renaming the file to .tab so Access
recognizes it as a tab delimited file. I was able to open the file directly
into access, complete the import data wizard, and voila. As far as why it
stops at 18 items for your case... i dunno... I just hope my experience
helps any.

"CG" <cgalvez@blissweddings.com> wrote in message
news:ann6jb$ut1$1@support.shopsite.com...
Hi,

So, I downloaded our Orders text file. I'm trying to import the text file
into Excel and/or MS Access to massage the data and run custom reports.
However, Excel and MS Access craps out when it tries to import a customer
order with more than 18 line items.

Anyone experience the same problem?

Thanks,
Cheryl
Bliss! Weddings Market
www.BlissWeddingsMarket.com