Database upload problem

[dgertgen]

Hello, I'm having trouble getting databases to upload to shopsite.

The record below has 61 tabs instead of the correct number of 62.
Please correct the problem and reload.

I found this problem in the forum and tried the fix (add an extra cell to the end of the excel spread sheet and put bogus data in it then Ignore the data on upload) but I'm still getting the error.

It is failing on the first record and here is the Tab delimited record (I'm only putting the first 2 items in the record):

ID CatNo SKURcrd MfgNo BarCode MfgID ShortDesc Warranty Quantity HazMatID ExtensionID ShipWeight ShipLength ShipWidth ShipHeight StatusID CategoryID ProductGroup GroupMisc Restricted MSRP Price MadeIn FireFinishID FireCaliberID FireSightID FireModelID FireStockID FireAmbID Picture Thumbnail GroupColorID GroupHandID GroupSizeID MfgAbbv ImgAlign MAP smShortDesc Rcstus VendorAbbv PicNote BR MetaID AddShip ExtraTxt1 ExtraFileNm1 Extra1Exp ExtraTxt2 ExtraFileNm2 Extra2Exp ExtraTxt3 ExtraFileNm3 Extra3Exp Ebay EbayBan PicEB mfgName mfgSite catName catAbbv catParentName Description Expr1
59498 23642 43547 81100 712548811009 68 Soft-Mouth Training Dummies 2 1 142401 0.55 3 3 11.25 1 207 FFX "Large, Bright White" $10.99 4.39 1 1 1 1 1 1 dtpicsoftcolors.jpg th_dtpicsoftcolors.gif 1 1 1 DT right $0.00 Bright White Large Plastic Dummy C 32149 $0.00 -1 -1 DT Systems www.dtsystems.com Dog Training Equipment PPAC Pet Products "When retrieving or picking up a Soft-Mouth Trainer your dog does not have to bite down hard like they would with conventional plastic dummies. Our dummies are made with softer, more pliable plastic materials which give them the soft, supple feel of a real bird's body. Our exclusive, non-slip, patent pending "" S Grip "" Technology design make these dummies the most advanced and easy to use training tool available. With the ""S Grip "" design, the dog's eye teeth lock firmly into the curves of the dummy's exclusive patterns.
The advanced design prevents slipping when a dog is grabbing or gripping and lets him use less downward pressure. The D.T. Systems' Soft-Mouth Trainer teaches your dog, over time, to use a softer, gentler grip.
The Soft-Mouth Trainer also has a specially designed adjustable pressure valve system which won't pull out or let water leak in like other brands. Our easy to use, needle style valve allows the handler to quickly let air pressure in or out to the make the dummy harder or softer or even to flatten the middle for more customized training. The Soft-Mouth Trainer is the most versatile and effective training tool available on the market today. This product will help you train like the professionals. Your dog will learn to use a softer, gentler grip and the transition to retrieving real birds will be even easier.

Features
Patent pending "" S GripTM "" technology for easier gripping and holding
Softer, more pliable plastic gives the New Soft-Mouth Trainer TM the feeling of a real bird's body when retrieving.
Trains your dog to naturally hold with a gentler grip
Adjustable pressure valve system allows handler to make the dummy softer or firmer for customized training
Excellent for water training or field use
Versatile, durable and long lasting

When retrieving or picking up a Soft-Mouth Trainer your dog does not have to bite down hard like they would with conventional plastic dummies. Our dummies are made with softer, more pliable plastic materials which give them the soft, supple feel of a real bird's body. Our exclusive, non-slip, patent pending "" S Grip "" Technology design make these dummies the most advanced and easy to use training tool available. With the ""S Grip "" design, the dog's eye teeth lock firmly into the curves of the dummy's exclusive patterns.
The advanced design prevents slipping when a dog is grabbing or gripping and lets him use less downward pressure. The D.T. Systems' Soft-Mouth Trainer teaches your dog, over time, to use a softer, gentler grip.
The Soft-Mouth Trainer also has a specially designed adjustable pressure valve system which won't pull out or let water leak in like other brands. Our easy to use, needle style valve allows the handler to quickly let air pressure in or out to the make the dummy harder or softer or even to flatten the middle for more customized training. The Soft-Mouth Trainer is the most versatile and effective training tool available on the market today. This product will help you train like the professionals. Your dog will learn to use a softer, gentler grip and the transition to retrieving real birds will be even easier.

Features
Patent pending "" S GripTM "" technology for easier gripping and holding
Softer, more pliable plastic gives the New Soft-Mouth Trainer TM the feeling of a real bird's body when retrieving.
Trains your dog to naturally hold with a gentler grip
Adjustable pressure valve system allows handler to make the dummy softer or firmer for customized training
Excellent for water training or field use
Versatile, durable and long lasting

When retrieving or picking up a Soft-Mouth Trainer your dog does not have to bite down hard like they would with conventional plastic dummies. Our dummies are made with softer, more pliable plastic materials which give them the soft, supple feel of a real bird's body. Our exclusive, non-slip, patent pending "" S Grip "" Technology design make these dummies the most advanced and easy to use training tool available. With the ""S Grip "" design, the dog's eye teeth lock firmly into the curves of the dummy's exclusive patterns.
The advanced design prevents slipping when a dog is grabbing or gripping and lets him use less downward pressure. The D.T. Systems' Soft-Mouth Trainer teaches your dog, over time, to use a softer, gentler grip.
The Soft-Mouth Trainer also has a specially designed adjustable pressure valve system which won't pull out or let water leak in like other brands. Our easy to use, needle style valve allows the handler to quickly let air pressure in or out to the make the dummy harder or softer or even to flatten the middle for more customized training. The Soft-Mouth Trainer is the most versatile and effective training tool available on the market today. This product will help you train like the professionals. Your dog will learn to use a softer, gentler grip and the transition to retrieving real birds will be even easier.

Features
Patent pending "" S GripTM "" technology for easier gripping and holding
Softer, more pliable plastic gives the New Soft-Mouth Trainer TM the feeling of a real bird's body when retrieving.
Trains your dog to naturally hold with a gentler grip
Adjustable pressure valve system allows handler to make the dummy softer or firmer for customized training
Excellent for water training or field use
Versatile, durable and long lasting

When retrieving or picking up a Soft-Mouth Trainer your dog does not have to bite down hard like they would with conventional plastic dummies. Our dummies are made with softer, more pliable plastic materials which give them the soft, supple feel of a real bird's body. Our exclusive, non-slip, patent pending "" S Grip "" Technology design make these dummies the most advanced and easy to use training tool available. With the ""S Grip "" design, the dog's eye teeth lock firmly into the curves of the dummy's exclusive patterns.
The advanced design prevents slipping when a dog is grabbing or gripping and lets him use less downward pressure. The D.T. Systems' Soft-Mouth Trainer teaches your dog, over time, to use a softer, gentler grip.
The Soft-Mouth Trainer also has a specially designed adjustable pressure valve system which won't pull out or let water leak in like other brands. Our easy to use, needle style valve allows the handler to quickly let air pressure in or out to the make the dummy harder or softer or even to flatten the middle for more customized training. The Soft-Mouth Trainer is the most versatile and effective training tool available on the market today. This product will help you train like the professionals. Your dog will learn to use a softer, gentler grip and the transition to retrieving real birds will be even easier.

Features
Patent pending "" S GripTM "" technology for easier gripping and holding
Softer, more pliable plastic gives the New Soft-Mouth Trainer TM the feeling of a real bird's body when retrieving.
Trains your dog to naturally hold with a gentler grip
Adjustable pressure valve system allows handler to make the dummy softer or firmer for customized training
Excellent for water training or field use
Versatile, durable and long lasting" Bogus
54663 25766 39861 980771-05 763357109405 7494 eXplorist GPS "Magellan prides itself on building rugged and reliable navigation products that you can depend on, backed by a full one-year warranty in North America (2 years in Europe)." 2 1 119252 0.6 5.75 2.25 9 1 650 EDB 500 $449.99 303.22 1 1 1 1 1 1 magepic980771-05.jpg th_magepic980771-05.gif 1 1 1 MAGE right $0.00 eXplorist 500 D 18432 $0.00 -1 -1 Magellan www.magellangps.com GPS ELGP Electronics & Instruments "Quick Features of the eXplorist 500 North America
- Color GPS Like No Other - Expandable and Compact
- Hi-resolution Color display
- Unlimited memory via optional Secure Digital (SD) cards and hi-speed USB port
- Li-Ion rechargeable battery
- Built-in Geocaching application
- No access fees, ever

Navigate in color! The 16-color display of the Magellan eXplorist 500 enables you to see where you are in vivid color. With a high-speed USB data port and unlimited data storage capacity via secure digital (SD) card expandability, you can easily add detailed street maps, topo or lake maps from optional Magellan MapSend software. eXplorist 500 is lightweight and pocket-sized so you can take it with you everywhere. The Magellan Geocache Manager enables you to download caches directly to your eXplorist 500 and the PC-style file system helps you to easily manage all of your data.

8 MB of built-in maps and an intuitive interface make it easy to start navigating right out of the box. Save 5 track log files, 20 routes and 500 points of interest to the 8 MB of additional internal memory, but store as many as you want on optional SD cards. You get all this and more, plus color!

Color GPS Like No Other - Expandable and Compact
Features:

- Full color screen
The color screen makes reading maps and GPS information easy with vibrant graphics in all lighting conditions.

- Unlimited SD Card Expandability
Your eXplorist 500 features SD card compatibility for unlimited memory expansion. Use optional Magellan MapSend software to add detailed street maps or topo charts to any number of SD memory cards (sold separately).

- USB data port
Transfer map data from your PC to your eXplorist 500 with the high-speed USB data port.

- Area Calculation
Want to find the distance between three or more points of interest that you plan to hike around or the area between them? Simply select the points of interest on the map and the eXplorist can determine the area between them and the perimeter around them.

- Li-Ion Rechargeable Battery
This Li-Ion rechargeable battery pack can keep your eXplorist continuously powered-up for up to 17 hours. Recharge your battery directly through your receiver again and again without reducing its performance.


- TrueFix Technology - Accurate & Reliable
TrueFix GPS technology takes advantage of 14 parallel channels, supported by WAAS and EGNOS Satellite-Based Augmentation Systems for fast signal acquisition, minimal signal loss and reliable accuracy to within 3 meters.

- Geocache Manager
Download geocache coordinates from Internet sites and use them on your outdoor adventures. This unique feature makes managing coordinates even easier with a PC-style file system. You don't have to be a geocacher to appreciate the Magellan Geocache Manager.

- Built-in mapping
With 8 MB of built-in North American or European maps it's easy to navigate around roads, parks, waterways and to find airports and other points of interest.

- Easy-to-use
One-button access takes you directly to all of the most important features. Intuitive operation with keypad and joystick control adds even more fun to GPS navigation. First-time user can easily navigate with the eXplorist 500.

- Languages
No matter your language, there's a good chance the eXplorist speaks it. Choose from English, French, German, Spanish, Italian, Swedish, Finnish, Portuguese, Dutch or Norwegian.

- Track Logging
Store up to 5 track log files, each with 2000 track-points to the internal memory and store an unlimited amount of track log files to optional SD cards, to easily find your way to your favorite spot again and again.

- Four navigation screens
View speed, direction, distance to destination and all the GPS information you need on 4 easy-to-read color navigation screens.

- No service fees
Your eXplorist 500 is ready to go with no service fees and no activation fees, so go ahead, use it all the time.

- Satellite status
Monitor the GPS satellites tracking your position and get information about their status.

Built to perform on the most challenging and rigorous adventure.
Specifications:

- Pocket-sized
Don't let the size fool you. The eXplorist 500 is packed with real GPS power and cool features. But at 2.1"" x 4.6"" x 1.3"" and only 4.6 oz you can take it anywhere.

- Large backlit color display
Navigate in color! Easily view all the GPS information you need to make your adventure fun and safe, even at night, with the large backlit color display.

- Rugged construction
Rubber armored, impact resistant plastic lets you to confidently take your eXplorist 500 on every adventure.

- Waterproof





Any help would be greatly appreciated. I have been trying to fix this for almost 2 weeks.

Thanks,

Dennis[/img]

[ShopSite Lauren]

You mentioned that you are using Excel to create your database. Excel will often times add additional fields to the first 12 - 15 rows, then drop those additional columns for the rest of the database.

One way to avoid this is to highlight all of your database fields from within Excel, then copy and paste into Notepad. This will create a tab-delimited file, with no extra fields, that you can then upload into ShopSite.

However, looking at the database that you have listed below, it looks like you have additional returns/tabs in your database, that might becausing additional problems. You would need to take out those extra returns in your database in Excel.

[dgertgen]

Thanks for your help. i'm still having trouble trying to clean up 3900 products but at least I know what the problem is.