|
 |
| | | 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: | Nubs_Select | | Posted: | Dec 29, 2023 01:26 | | Subject: | Re: BrickStore price guide question | | Viewed: | 30 times | | Topic: | Related Software | |
|
| 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 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: | Nubs_Select | | Posted: | Jan 1, 2024 00:13 | | Subject: | Re: BrickStore price guide question | | Viewed: | 36 times | | Topic: | Related Software | |
|
| In Related Software, Cob writes:
Hopefully it helps! 
|
|
| | | | | |
| | | | | Author: | wildchicken13 | | Posted: | Dec 29, 2023 12:02 | | Subject: | (Cancelled) | | Viewed: | 30 times | | Topic: | Related Software | |
|
| | (Cancelled) |
|
| | | | | | | | | |
| | | | | | | Author: | SylvainLS | | Posted: | Dec 29, 2023 12:17 | | Subject: | Re: BrickStore price guide question | | Viewed: | 26 times | | Topic: | Related Software | |
|
| No personal info on the forums, please.
In Related Software, wildchicken13 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
|
Once upon a time, I tried to install SQL on my personal computer, but it didn't
really work and I found the installation process to be inordinately complicated,
like NubsGPT's instructions. I guess SQL is more of a proprietary enterprise
software meant for large corporations and organizations than an application meant
for individuals with a laptop. You could try to find a website that can convert
a SQLite file to plain text. If you have not done so already, you could also
contact Robert, the developer of BrickStore, and ask him for advice. His BrickLink
username is sandman: https://www.bricklink.com/contact.asp?u=sandman
You could also try the discussion forum on GitHub:
https://github.com/rgriebl/brickstore/discussions
Or email Robert directly at [redacted]
Hope that helps.
|
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | wildchicken13 | | Posted: | Dec 29, 2023 12:22 | | Subject: | Re: BrickStore price guide question | | Viewed: | 27 times | | Topic: | Related Software | |
|
| 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: | SylvainLS | | Posted: | Dec 29, 2023 12:34 | | Subject: | Re: BrickStore price guide question | | Viewed: | 25 times | | Topic: | Related Software | |
|
| 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.
|
Yes it is.
This has no relation whatsoever with what is allowed here.
|
|
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | 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: | peregrinator | | Posted: | Dec 31, 2023 14:41 | | Subject: | (Cancelled) | | Viewed: | 29 times | | Topic: | Related Software | |
|
| In Related Software, wildchicken13 writes:
| | Once upon a time, I tried to install SQL on my personal computer, but it didn't
really work and I found the installation process to be inordinately complicated,
like NubsGPT's instructions. I guess SQL is more of a proprietary enterprise
software meant for large corporations and organizations than an application meant
for individuals with a laptop.
|
SQLite actually runs on smartphones and whatnot. I'm assuming it's used
by BrickStore because it has a small footprint but still allows querying data
using SQL.
|
|
| | | | | |
| | | | | Author: | hpoort | | Posted: | Dec 29, 2023 12:17 | | Subject: | Re: BrickStore price guide question | | Viewed: | 26 times | | Topic: | Related Software | |
|
| 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: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.
|
|
|
|
|
|
|
USA, Missouri
Canada, Ontario
France, Nouvelle-Aquitaine
Netherlands, Groningen