What we collect!

 

Stamporama Discussion Board Logo
For People Who Love To Talk About Stamps
Discussion - Member to Member Sales - Research Center
Stamporama Discussion Board Logo
For People Who Love To Talk About Stamps
Discussion - Member to Member Sales - Research Center
Stamporama Discussion Board Logo
For People Who Love To Talk About Stamps



What we collect!
What we collect!


Sales, Swaps, Auction & Approvals/Auction Disc. : A question for sellers who use the Bulk Uploader

 

Author
Postings
auldstampguy
Members Picture


Tim
Collector, Webmaster

09 May 2023
08:39:05pm
I had a question tonight from one of our members who was having a problem uploading Topicals using the Bulk Uploader. The message that they were getting was:

"Record 6: The number of fields should be 10 of you are not using Topicals or it should be 12 if you are using Topicals. 11 fields were found."



I believe that they were using Quatro Pro on a Windows 11 computer to create the Bulk Upload file. The problem was that Quatro Pro was losing the last collumn because it didn't have anything in it. I got them to send me the file they were trying to upload. I ran it through Libre Office Calc. I didn't make any changes, I just opened it and re-saved it and sent it back. That fixed the problem. They were successfully able to upload the file.

My question for you all is: have any of you seen this problem before? If so, how did you get around it? There have been no changes in the Bulk Loader program for quite a while.

Regards ... Tim.
Like 
1 Member
likes this post.
Login to Like.

"Isaac Asimov once said if his doctor told him he was dying, he wouldn’t lament, he would just type a little faster. "

mncancels.org
hfbaker
Members Picture


09 May 2023
11:26:06pm
re: A question for sellers who use the Bulk Uploader

If the bulk load file is a csv file you can add an extra comma at the end of each row using notepad++ (a free replacement for windows notepad). Open the file in notepad++, select Search, Replace, select regular expressions as the search mode, enter $ in the find what: box and , (comma) in the replace with: box and click on replace all.

Alternatively, install any of the free spreadsheet programs such as Libre Office Calc or FreeOffice Planmaker.

Like 
3 Members
like this post.
Login to Like.
Brechinite

10 May 2023
09:40:13am

Auctions - Approvals
re: A question for sellers who use the Bulk Uploader

I have no problem as I do not use the Topicals categories and never will.

Like
Login to Like
this post

"Gonnae no dae that!..........Just gonnae no!"
michael78651

10 May 2023
09:54:49pm
re: A question for sellers who use the Bulk Uploader

"I do not use the Topicals categories and never will."



You don't need to, Ian. Your a topical all to yourself! Rock On

Like
Login to Like
this post
Brechinite

11 May 2023
02:15:05pm

Auctions - Approvals
re: A question for sellers who use the Bulk Uploader

I's just a simple soul and can find what I am interested in by using the "Countries" search or "Keyword" search.

It is bad enough listing with the countries list next to you, and the categories list and to have another long list of "Topicals" as well.

The additional time spent typing would wear out my poor delicate digits.Big Grin

Like
Login to Like
this post

"Gonnae no dae that!..........Just gonnae no!"
CapeStampMan
Members Picture


Mike, The shirt says "Trust me I am a Philatelist".

11 May 2023
04:53:23pm
re: A question for sellers who use the Bulk Uploader

From a glimpse of your body scan, you have worn out all of your digits and everything connected to them. Just sayin"! ROFLOL
Mike

Like 
1 Member
likes this post.
Login to Like.

"It's been 8 years now, since I joined a support group for procrastinators. We haven't met yet..."
        

 

Author/Postings
Members Picture
auldstampguy

Tim
Collector, Webmaster
09 May 2023
08:39:05pm

I had a question tonight from one of our members who was having a problem uploading Topicals using the Bulk Uploader. The message that they were getting was:

"Record 6: The number of fields should be 10 of you are not using Topicals or it should be 12 if you are using Topicals. 11 fields were found."



I believe that they were using Quatro Pro on a Windows 11 computer to create the Bulk Upload file. The problem was that Quatro Pro was losing the last collumn because it didn't have anything in it. I got them to send me the file they were trying to upload. I ran it through Libre Office Calc. I didn't make any changes, I just opened it and re-saved it and sent it back. That fixed the problem. They were successfully able to upload the file.

My question for you all is: have any of you seen this problem before? If so, how did you get around it? There have been no changes in the Bulk Loader program for quite a while.

Regards ... Tim.
Like 
1 Member
likes this post.
Login to Like.

"Isaac Asimov once said if his doctor told him he was dying, he wouldn’t lament, he would just type a little faster. "

mncancels.org
Members Picture
hfbaker

09 May 2023
11:26:06pm

re: A question for sellers who use the Bulk Uploader

If the bulk load file is a csv file you can add an extra comma at the end of each row using notepad++ (a free replacement for windows notepad). Open the file in notepad++, select Search, Replace, select regular expressions as the search mode, enter $ in the find what: box and , (comma) in the replace with: box and click on replace all.

Alternatively, install any of the free spreadsheet programs such as Libre Office Calc or FreeOffice Planmaker.

Like 
3 Members
like this post.
Login to Like.
Brechinite

10 May 2023
09:40:13am

Auctions - Approvals

re: A question for sellers who use the Bulk Uploader

I have no problem as I do not use the Topicals categories and never will.

Like
Login to Like
this post

"Gonnae no dae that!..........Just gonnae no!"
michael78651

10 May 2023
09:54:49pm

re: A question for sellers who use the Bulk Uploader

"I do not use the Topicals categories and never will."



You don't need to, Ian. Your a topical all to yourself! Rock On

Like
Login to Like
this post
Brechinite

11 May 2023
02:15:05pm

Auctions - Approvals

re: A question for sellers who use the Bulk Uploader

I's just a simple soul and can find what I am interested in by using the "Countries" search or "Keyword" search.

It is bad enough listing with the countries list next to you, and the categories list and to have another long list of "Topicals" as well.

The additional time spent typing would wear out my poor delicate digits.Big Grin

Like
Login to Like
this post

"Gonnae no dae that!..........Just gonnae no!"
Members Picture
CapeStampMan

Mike, The shirt says "Trust me I am a Philatelist".
11 May 2023
04:53:23pm

re: A question for sellers who use the Bulk Uploader

From a glimpse of your body scan, you have worn out all of your digits and everything connected to them. Just sayin"! ROFLOL
Mike

Like 
1 Member
likes this post.
Login to Like.

"It's been 8 years now, since I joined a support group for procrastinators. We haven't met yet..."
        

Contact Webmaster | Visitors Online | Unsubscribe Emails | Facebook


User Agreement

Copyright © 2024 Stamporama.com