| 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
|
Next Page: 5 More | 10 More | 25 More | 50 More | 100 More
|
|
USA, Missouri
