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.
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.
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.
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
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.
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.
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