Redisplay Messages: Compact | Brief | All | Full Show Messages: All | Without Replies Author: | Cob | Posted: | Jan 31, 2024 15:14 | Subject: | Re: Fake or real? | Viewed: | 57 times | Topic: | Catalog Identification | |
|
| In Catalog Identification, Anje572 writes:
| We've had these two brown rifles with our Lego for over 20 years, they look
like part 30141, but they don't have any logo or numbers, are they fake?
The bottom one is part 30141, reddish brown.
|
They don't look real to me. However additional photos would be needed to
make a decision.
The trigger loop looks off, the sights are inconsistent, no circle mark underneath
the hammer.
|
Author: | Cob | Posted: | Jan 18, 2024 11:24 | Subject: | Re: sh010 Variant | Viewed: | 44 times | Topic: | Catalog | |
|
| In Catalog, axaday writes:
| In Catalog, TimeWarpDrive writes:
| In Catalog, Nubs_Select writes:
I made a post about this here in 2021; I wonder what happened to that one.
|
Maybe a TimeWarp
|
🤯
|
Author: | Cob | Posted: | Jan 18, 2024 10:40 | Subject: | Re: What do you think about seller notice? | Viewed: | 53 times | Topic: | Media | |
|
| | I don't want any other victims
|
I consider both you and the seller to be victims.
Both of you have been hurt with the negative feedback.
|
|
Author: | Cob | Posted: | Jan 9, 2024 11:10 | Subject: | LEGO T-Shirt humor | Viewed: | 123 times | Topic: | Off Topic | |
|
| Those who are interested on where to find this t-shirt, search these key words.
Geekoutfit Pain Scale
|
|
|
Author: | Cob | Posted: | Dec 31, 2023 14:16 | Subject: | Re: BrickStore price guide question | Viewed: | 30 times | Topic: | Related Software | |
|
| I think the that the data is in two parts, one with reference data and two embedded
txt files that are linked to the reference data.
I will try these steps, but this export of data appears to be complex and or
take several steps.
Thanks for the help!
In Related Software, hpoort writes:
| In Related Software, Cob writes:
| The price guide in BrickStore is now in a SQLite file. In the past I would would
gather all of the txt files and accumulate them into one price guide file to
assist in determining my item prices.
Doing limited research I have been able to open the SQLite file but cannot access
the price guide data. Does anyone have suggestions on what to use to export
the data from the SQLite file?
From my research there appear to be many options but I can't find the "SQLite
for Dummies" version of how to do export the data.
Thank you,
Cob
|
Assuming you want the data in Excel, instead of looking for 'export'
you should look to access and use the data directly. For this you need a way
to connect Excel's query engine to SQLite files, which can be done through
the ODBC driver for SQLite files. There are several of these available on the
web. After having installed this driver, you can use all features of Excel's
Power Query functions, same like you would import the CSV or text files.
ChatGPT gives the following instruction outline:
Microsoft Excel does not have native support for connecting directly to SQLite
databases. However, you can use third-party tools or methods to achieve this
connection. Here's a general approach:
ODBC Driver for SQLite:
You can use an ODBC (Open Database Connectivity) driver to connect Excel
to SQLite. SQLite provides an ODBC driver that you can install and configure
on your system.
SQLite ODBC Driver Installation:
Download and install an SQLite ODBC driver compatible with your operating
system.
Configure the ODBC driver to connect to your SQLite database. This usually
involves specifying the database file path, authentication details, etc.
Excel Data Connection:
Open Excel and go to the "Data" tab.
Select "Get Data" or "Get External Data," depending on
your Excel version.
Choose "From Other Sources" and then select "ODBC."
In the ODBC dialog, choose the DSN (Data Source Name) configured for
your SQLite database.
Querying Data:
After establishing the connection, you can use Excel's Power Query
Editor to write SQL queries or load tables from the SQLite database.
Power Query can be accessed through the "Data" tab, and you can
use the "Advanced Editor" to write custom SQL queries if needed.
|
|
|
Author: | Cob | Posted: | Dec 31, 2023 14:13 | Subject: | Re: BrickStore price guide question | Viewed: | 18 times | Topic: | Related Software | |
|
| Thanks for this information.
In Related Software, wildchicken13 writes:
| In Related Software, SylvainLS writes:
| No personal info on the forums, please.
|
Robert's email address isn't personal information. It's publicly
displayed on his GitHub profile: https://github.com/rgriebl
|
|
|
Author: | Cob | Posted: | Dec 31, 2023 14:10 | Subject: | Re: BrickStore price guide question | Viewed: | 26 times | Topic: | Related Software | |
|
| Thanks Nubs GPT!
In Related Software, Nubs_Select writes:
| I asked gpt and it said
“Hello!
To export data from a SQLite file, you can use a tool like DB Browser for SQLite,
which offers a user-friendly interface. Here are the steps to export data:
1. Download and Install DB Browser for SQLite: You can download it from sqlitebrowser.org.
2. Open Your SQLite File:
• Open DB Browser for SQLite.
• Click on ‘Open Database’ and select your SQLite file.
3. Browse and View Data:
• Once the database is open, you can browse the tables and view the data to
ensure you’ve opened the right database.
4. Export Data:
• To export data, go to the ‘File’ menu and select ‘Export’.
• Choose ‘Table(s) as CSV file’.
• Select the tables you want to export and specify where to save the CSV file.
5. Customize Export (Optional):
• You can customize the export settings like field separator, encoding, and
whether to include column names in the first row.
6. Save the Exported File:
• Once you’ve set your preferences, click ‘OK’ to export.
• The data from your SQLite file will be saved in a CSV format, which you can
open with Excel or similar programs.
This process allows you to export your price guide data into a more accessible
format like CSV, which is easier to handle for price analysis.
I hope this helps!”
|
|
|
Author: | Cob | Posted: | Dec 29, 2023 01:06 | Subject: | BrickStore price guide question | Viewed: | 83 times | Topic: | Related Software | |
|
| The price guide in BrickStore is now in a SQLite file. In the past I would would
gather all of the txt files and accumulate them into one price guide file to
assist in determining my item prices.
Doing limited research I have been able to open the SQLite file but cannot access
the price guide data. Does anyone have suggestions on what to use to export
the data from the SQLite file?
From my research there appear to be many options but I can't find the "SQLite
for Dummies" version of how to do export the data.
Thank you,
Cob
|
|
Author: | Cob | Posted: | Dec 18, 2023 15:11 | Subject: | Re: I can't identify this figure..... | Viewed: | 41 times | Topic: | Help | |
|
| | Thanks Guys,,,,,I have re-united him with the correct legs, hands, head and hair
!
|
Looks like a great find!
|
Author: | Cob | Posted: | Dec 9, 2023 10:50 | Subject: | Re: Requirments for new sellers | Viewed: | 56 times | Topic: | Suggestions | |
|
| When I joined BrickLink I was very suspicious that this was a real site that
actually shipped LEGO, I made my first purchases carefully.
When I became a seller I was not sure if I wanted to sell on this site and it
took me a while to get started.
I am pretty cheap and hate unnecessary fees. I doubt I would have paid a dime
to become a seller on BrickLink.
|
|
Author: | Cob | Posted: | Dec 7, 2023 12:44 | Subject: | Re: Poll | Viewed: | 50 times | Topic: | General | |
|
| In General, wildchicken13 writes:
| heated Topic in the Forum..........
Poll:
What do you Think?
A) no, this is stupid
B) yes absolutely
C) maybe
D) no, but it is a good idea
E) yes, it would be nice
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
please just give a simple letter vote, no harrassing others for their vote. we
are a Civilized Lego Society.
|
I am missing something, have not been on the forum for a while. What is the
message id?
|
Author: | Cob | Posted: | Dec 1, 2023 13:58 | Subject: | Re: Cigarette Smoke - Try to salvage or Return? | Viewed: | 81 times | Topic: | Buying | |
|
| 1. Is there an effective way to thoroughly clean and remove odor from figs, polybags,
and parts without ruining them?
Dawn soap and water
|
|
Author: | Cob | Posted: | Nov 29, 2023 15:43 | Subject: | Re: HELP: International shipment damaged | Viewed: | 37 times | Topic: | Shipping | |
|
| In Shipping, galaxyfe writes:
| Hi, I am a seller and a recent international order was damaged. The buyer sent
me the pics and it looks like the package was run over. The package and label
are clearly damaged. I will gladly insure packages if requested and paid for
but this package did not have insurance. The buyer wants a refund and it's
like $40. Do I have to refund the shipment? I feel for the buyer for sure but
not sure I have to take the hit here. I do have in my shipping terms that if
you don't buy insurance then I am not responsible but maybe that is not true.
Any help would be appreciated.
|
Learned my lesson long ago, I don’t ship Internationally in bags. Only boxes.
|
|
Author: | Cob | Posted: | Nov 17, 2023 20:03 | Subject: | Re: My store still close.. Why?? | Viewed: | 67 times | Topic: | Technical Issues | |
|
| In Technical Issues, Deabricks writes:
| In Technical Issues, tonnic writes:
| In Technical Issues, Deabricks writes:
| Since November 8, they closed my store for verification after the page was hacked.
I already sent all the documentation again and it is the day that they have not
yet authorized it.
Does this happen to anyone else?
|
I think you need to unlock it yourself.
You have a green square for buying and selling, this should mean all is ready
to go.
The lock means you need to unlock it on your own ‘my Bricklink’ or whatever it
is called.
|
I can't.. The bottom is locked. 🥲 and I texted in the message section next
Tu the verification page and nobody respond me
|
Post a screenshot of what is locked. I'm not sure if you are looking in
the correct location.
|
|
Author: | Cob | Posted: | Nov 17, 2023 11:40 | Subject: | Re: My store still close.. Why?? | Viewed: | 81 times | Topic: | Technical Issues | |
|
| In Technical Issues, Deabricks writes:
| Since November 8, they closed my store for verification after the page was hacked.
I already sent all the documentation again and it is the day that they have not
yet authorized it.
Does this happen to anyone else?
|
Go here
https://www.bricklink.com/v2/mystore/display.page
Click Management
Click Open
Click Save Changes
|
Author: | Cob | Posted: | Nov 12, 2023 09:23 | Subject: | Re: Torn or Ripped or Torn & Ripped or Rip Torn ? | Viewed: | 33 times | Topic: | Catalog Identification | |
|
| You can buy a used phone or tablet for cheap and use it for this purpose. |
Author: | Cob | Posted: | Nov 8, 2023 13:25 | Subject: | Reopening sales | Viewed: | 88 times | Topic: | Sales | |
|
| I wonder how many sellers are going to have a "reopening" sale?
All jokes aside.
Welcome back everything, it has been a long several days.
Thanks to everyone at BrickLink behind the code that helped to keep us safe!
|
Author: | Cob | Posted: | Oct 28, 2023 16:11 | Subject: | USA to Germany - VAT question | Viewed: | 67 times | Topic: | Taxes | |
|
| Does Bricklink automatically collect the VAT when shipping from the USA to Germany?
I have a buyer asking how VAT works to Germany and I do not know.
|
|
Author: | Cob | Posted: | Oct 26, 2023 18:21 | Subject: | Re: buyer trying to lowball me after purchase? | Viewed: | 88 times | Topic: | Selling | |
|
| In Selling, Kouch_Pot8o writes:
| In Selling, stranqe writes:
| So yesterday I had a buyer agree to purchase a set and I send the invoice right
away. Today he responds with:
"Hello, Thank you for the speedy reply. Are you able to price match ETOYS
MACAO? They are charging $23.91 USD plus tax."
Is this a thing? buyers asking for a 50% discount and want me to price match
some other store in a different country? and this is AFTER they clicked on "agree
to purchase" from my store. I also assume shipping from macao would costs
more than the set alone thats why they decided to buy from my store to begin
with since my shipping will be less than $10.
Does this just become a NPB situation then? How would other sellers handle this?
|
I would just politely respond saying "No, unfortunately we do not offer price
matching" and if they decide they want to cancel instead, I would just go
ahead and oblige the cancel request.
|
Canceling opens up the possibility of negative feedback.
Consider opening a NPB complaint instead.
|
|
Author: | Cob | Posted: | Oct 26, 2023 16:44 | Subject: | Re: Real or fake legs | Viewed: | 34 times | Topic: | Help | |
|
| In Help, Bricksgram writes:
| Hello,
I bought some mini figures and legs feel weird to me. Plastic seems to me to
be different, lighter and there is no Lego logo on feets and some weird marks
deep inside.
Maybe just I am not informed enough?
|
Those legs may be from a key chain or some type of minifig that started as "gear"
instead in a set.
|
|
Author: | Cob | Posted: | Oct 26, 2023 15:36 | Subject: | Re: Double accounts | Viewed: | 72 times | Topic: | Problem Order | |
|
| | hope you never forget your wallet at home when you go to the grocery, only realizing
it at the chechout..
they will ban you from ever shopping there again & report you to the police if
you ever show up there again.
geez.....*facepalm
Society at it's finest
|
Why post this? This isn't helpful nor is it nice.
When potential buyers read these posts, do you think that they are more or
less likely to purchase from your store?
|
|
Author: | Cob | Posted: | Oct 24, 2023 17:24 | Subject: | Re: $50,000+ Of Fake Deadpools Sold On BrickLink | Viewed: | 78 times | Topic: | General | |
|
| How did you get $50,000?
In the last 6 months
87 new sold at $50 = $4,350
177 used sold at $33 = $5,800
At the last 6 month rate every Deadpool sold would have to have been fake for
the last 2.5 years.
|
Author: | Cob | Posted: | Oct 20, 2023 10:16 | Subject: | Re: What MF does this belong to? | Viewed: | 56 times | Topic: | Help | |
|
| In Help, kittybrickz writes:
| Seeking your expertise! Any idea what MF this is from? This is soft and NOT starched.
This is the reverse. The obverse is a little fuzzy. Thanks in advance!
|
Every time I read this subject line, I picture Samuel L Jackson asking this question...
|
Next Page: 5 More | 10 More | 25 More | 50 More | 100 More
|