Product/Page databases - upload/download

[Jeremy Bloom]

When shopsite databases are downloaded, there is an empty line in between
each entry. It seems that once it is exported, I can not re-upload the file
without going through a horrid process. The pages database I can't do
anything with.

How can I get around this? Why does shopsite export with the extra lines,
and then insist that they not exist upon upload?

Is this nuts?

Thanks,
Jeremy

[loren_d_c]

I have never seen that problem, are you sure that it is not whatever
software you are uploading the downloaded text file into that is adding
the extra lines?

-Loren

P.S. Yes, definitely nuts.


Jeremy Bloom wrote:

When shopsite databases are downloaded, there is an empty line in between
each entry. It seems that once it is exported, I can not re-upload the file
without going through a horrid process. The pages database I can't do
anything with.

How can I get around this? Why does shopsite export with the extra lines,
and then insist that they not exist upon upload?

Is this nuts?

Thanks,
Jeremy

[Jeremy Bloom]

Since you said something about the software, and I'm on a Mac, I tried a new
approach. I usually export a db, download with Fetch, then do something
with it. When viewing in Fetch and/or after downloading and opening in any
program, there is an extra line between every page/product.

This time, I exported the database and viewed the file in the browser
window. Which looked fine, so I saved the file as text, and it seem to have
worked OK.

From there, my final problem is importing my pages data in to Excel. I have
HTML in one of the fields for all my pages, it's navigation. Excel gets
stuck and turns it in to HTML which does not work for making adjustments.
Yes, this sounds dumb, but that is what I've found.

Thoughts about this final Excel issue? Is the only solution to get rid of
the HTML before doing this work?

Jeremy

From: Loren <loren_d_c@yahoo.com
Organization: ShopSite
Newsgroups: forum.shopsite
Date: Tue, 12 Nov 2002 21:24:00 -0700
Subject: Re: Product/Page databases - upload/download

I have never seen that problem, are you sure that it is not whatever
software you are uploading the downloaded text file into that is adding
the extra lines?

-Loren

P.S. Yes, definitely nuts.


Jeremy Bloom wrote:

When shopsite databases are downloaded, there is an empty line in between
each entry. It seems that once it is exported, I can not re-upload the file
without going through a horrid process. The pages database I can't do
anything with.

How can I get around this? Why does shopsite export with the extra lines,
and then insist that they not exist upon upload?

Is this nuts?

Thanks,
Jeremy

[jim]

Jeremy,
Another problem you will have with Excel is exporting the file back out as tab
delimited. Excel seems to think that it needs to quote any text that has a " in it
so you end up with text that has quotes around it where it didn't before. I
personally use Corel's QuattroPro instead of Excel since it doesn't have that
problem. You might try other database programs like Access to see if they will
handle the html correctly.

Jim

Jeremy Bloom wrote:

Since you said something about the software, and I'm on a Mac, I tried a new
approach. I usually export a db, download with Fetch, then do something
with it. When viewing in Fetch and/or after downloading and opening in any
program, there is an extra line between every page/product.

This time, I exported the database and viewed the file in the browser
window. Which looked fine, so I saved the file as text, and it seem to have
worked OK.

From there, my final problem is importing my pages data in to Excel. I have
HTML in one of the fields for all my pages, it's navigation. Excel gets
stuck and turns it in to HTML which does not work for making adjustments.
Yes, this sounds dumb, but that is what I've found.

Thoughts about this final Excel issue? Is the only solution to get rid of
the HTML before doing this work?

Jeremy

From: Loren <loren_d_c@yahoo.com
Organization: ShopSite
Newsgroups: forum.shopsite
Date: Tue, 12 Nov 2002 21:24:00 -0700
Subject: Re: Product/Page databases - upload/download

I have never seen that problem, are you sure that it is not whatever
software you are uploading the downloaded text file into that is adding
the extra lines?

-Loren

P.S. Yes, definitely nuts.


Jeremy Bloom wrote:

When shopsite databases are downloaded, there is an empty line in between
each entry. It seems that once it is exported, I can not re-upload the file
without going through a horrid process. The pages database I can't do
anything with.

How can I get around this? Why does shopsite export with the extra lines,
and then insist that they not exist upon upload?

Is this nuts?

Thanks,
Jeremy

[Jeremy Bloom]

Hi guys,
I'm all set after switching to FTP via the browser window instead of
putting/getting the file on the server. It works fine. I never even
thought of it before.

Here's my bigger story with ShopSite on this issue...

I used to use the browser FTP to upload and download files years ago. It
didn't work for yet another mac reason, so I learned to upload the file to
the server and import from there. And of course now we have been discussing
my problems with uploading/downloading using the server feature.

So I tried the browser uplaod/download, and it works like a charm. Go
figure.

I agree with you about using another program. I was thinking of downloading
an office suite I read about a while ago that was meant to be universal and
was open source. Supposed to have a Word and Excel type program, which
probably work better and are more flexible with other files. I'll try that
too.

Thanks,
Jeremy

From: jim <jim@icentral.com
Organization: ShopSite
Newsgroups: forum.shopsite
Date: Wed, 13 Nov 2002 09:10:09 -0700
Subject: Re: Product/Page databases - upload/download

Jeremy,
Another problem you will have with Excel is exporting the file back out as tab
delimited. Excel seems to think that it needs to quote any text that has a "
in it
so you end up with text that has quotes around it where it didn't before. I
personally use Corel's QuattroPro instead of Excel since it doesn't have that
problem. You might try other database programs like Access to see if they
will
handle the html correctly.

Jim

Jeremy Bloom wrote:

Since you said something about the software, and I'm on a Mac, I tried a new
approach. I usually export a db, download with Fetch, then do something
with it. When viewing in Fetch and/or after downloading and opening in any
program, there is an extra line between every page/product.

This time, I exported the database and viewed the file in the browser
window. Which looked fine, so I saved the file as text, and it seem to have
worked OK.

From there, my final problem is importing my pages data in to Excel. I have
HTML in one of the fields for all my pages, it's navigation. Excel gets
stuck and turns it in to HTML which does not work for making adjustments.
Yes, this sounds dumb, but that is what I've found.

Thoughts about this final Excel issue? Is the only solution to get rid of
the HTML before doing this work?

Jeremy

From: Loren <loren_d_c@yahoo.com
Organization: ShopSite
Newsgroups: forum.shopsite
Date: Tue, 12 Nov 2002 21:24:00 -0700
Subject: Re: Product/Page databases - upload/download

I have never seen that problem, are you sure that it is not whatever
software you are uploading the downloaded text file into that is adding
the extra lines?

-Loren

P.S. Yes, definitely nuts.


Jeremy Bloom wrote:

When shopsite databases are downloaded, there is an empty line in between
each entry. It seems that once it is exported, I can not re-upload the
file
without going through a horrid process. The pages database I can't do
anything with.

How can I get around this? Why does shopsite export with the extra lines,
and then insist that they not exist upon upload?

Is this nuts?

Thanks,
Jeremy