Stuck in DB upload Hades

[ckm1966]

No matter what format I use - delimited by tab, comma or exclamation point - it says I have one more tab then I should. This happens if is use excel, excel pasted into notepad, export from access or pasted from access to notepad.

I can not even download the shopsite database to text and then re-upload it.

What on earth is wrong with this program????

[ckm1966]

This was part of the problem:

Submitted by: ShopSite

Product database upload hangs/stops on linking phase

Problem: S5519 Product: ShopSite Manager and Pro
Version: v8.1x
Platform: ALL

I have a ShopSite Manager or Pro v8.1x store and when I attempt to upload a tab-delimited text product file to my ShopSite the first upload status bar (Updating data records...) completes, but the upload stops after this and the next status bar (Updating page and product links...) never completes. Why is this, and what can I do about it?

Solution: 1 This can occur if you have ever tried to upload a tab-delimited text products file at some point that included both the Add To Pages and Product On Pages fields. Only one of these should be used. If both are used in the same upload, we have seen that this can cause problems with the linking tables, even on subsequent upload attempts that do not include both fields.

The only way currently to fix the linking phase of the uploads after trying to upload a file like this is to Empty the products database (Via the Empty function in Utilities -> Database, and after backing up and downloading the data, of course) and re-upload the products fresh without including both of those linking fields in the upload file.

The description of the function of these two different fields in the product upload is as follows:

The Add To Pages (previously known as In These Pages) field is additive-only, in other words the product will be added to pages listed in this field (if it is not already on them) but will not be removed from any pages that it may be on but that are not in this field.

The Product On Pages is new in v8.1 and it is absolute, in other words the product will be added to pages listed in this field (if it is not already on them) and removed from any pages in may be on that are not included in this field.

You should choose which one of these two fields best fits your needs and not use the other.


The above fixed everything for me - good luck!