Reliable Chicago IT company

Step 1: Set up the ODBC Data Source

1. Install the ODBC driver for SQL Server (if not already installed) as described in the previous answer.
2. Configure the ODBC Data Source:
   • Open the ODBC Data Source Administrator (in Windows, search for “ODBC Data Sources”).
   • Click on the System DSN tab (for all users) or User DSN (for only your user).
   • Click Add, select the ODBC Driver for SQL Server, and set up the connection to your SQL Server.
   • Test the connection and complete the setup.

Step 2: Set up the ODBC Connection in LibreOffice

1. Open LibreOffice Base (even though we’ll be using Calc, Base is needed to manage the database connection).
2. Create a New Database:
   • Choose “Connect to an existing database” from the initial screen.
   • From the dropdown, select ODBC and click Next.

1. Select ODBC Data Source:
   • Click on Browse, and a window showing your system’s ODBC connections will open.
   • Select the ODBC data source you created earlier for the SQL Server connection, then click OK.
2. Enter your credentials:
   • If your SQL Server requires a username and password, you’ll be prompted to enter them. You can save them for future use if desired.
3. Save the Base Database file:
   • LibreOffice Base will ask you to save the connection as a .odb file. This file is required for managing the connection to the database from Calc.
4. Test the Connection:
   • When asked, click Yes to test the connection to make sure everything is set up correctly. You should be able to see the tables from your SQL Server.

Step 3: Import Data from Base to Calc

1. Open LibreOffice Calc and go to Data > Select Range.
2. To import data:
   • Click View > Data Sources (or press Ctrl+Shift+F4).
   • This will open a pane with all registered data sources. Find your ODBC connection in the pane (it will show up as the .odb file you saved earlier).
   • Navigate to the table or query you want to use.
3. Drag and drop the query or table from the data source window into your Calc spreadsheet. The data should populate in your spreadsheet.

Step 54: Enable Data Refresh in Calc

Now that the data is imported:

1. Select the range of data that you imported.
2. Go to Data > Define Range, and give the range a name.
3. After defining the data range, the Refresh Range option should now be enabled.
4. To refresh the data, go to Data > Refresh Range. This will pull the latest data from the connected SQL Server through the ODBC connection.

This process correctly handles database connections between LibreOffice Calc and SQL Server via ODBC.

Implementing an RFID-based inventory tracking system is an excellent way to streamline the management of your inventory, especially if it’s spread across various locations. Here’s a detailed guide to help you make the best use of this technology:

1. Applying RFID Labels:

• Purchase Pre-Programmed and Pre-Printed RFID Labels: These labels should be compatible with your chosen RFID readers and inventory management system.
• Apply Labels to Inventory Items: Attach RFID labels to each item or their packaging. Ensure the labels are placed in a standardized and accessible position to facilitate easy scanning.

2. Organizing Inventory:

• Categorize and Assign Locations: Define specific areas, shelves, or containers for different categories of items. Each area or shelf can have a designated RFID tag that corresponds to its location.
• Boxing and Containerization: When placing items in boxes or containers, record the association between the item’s RFID tag and the container’s or location’s RFID tag.

3. Tracking and Locating Inventory:

• Mapping Inventory Locations: Use an RFID scanner to record the location of each item by scanning both the item’s tag and the location’s tag.
• Real-Time Tracking: Implement a system that updates item locations in real-time as they are moved and scanned at different locations.

4. Choosing an Inventory System:

• Online vs. Hosted In-House: An online system (cloud-based) offers accessibility from anywhere and reduces the need for in-house IT infrastructure. However, an in-house system might offer more control and security. Given your interest in compatibility, an online system might be more adaptable to various integrations.
• Open Source Options: Consider open-source inventory management systems like Snipe-IT, PartKeepr, or Odoo. Ensure they support RFID integration and check for compatibility with WooCommerce/WordPress and possibly QuickBooks.

5. Integration with WooCommerce/WordPress:

• Look for plugins or modules that allow your chosen inventory system to integrate with WooCommerce, enabling real-time inventory updates on your e-commerce platform.

6. Using Scan Guns (RFID Readers):

• Types: Choose handheld or fixed RFID readers depending on your operation size. Handheld devices offer flexibility, while fixed readers can automatically scan items passing through specific locations.
• Functionality: Look for readers with good read range, data filtering capabilities, and compatibility with your inventory software. Durability and battery life are also key for handheld units.

7. Label Printers:

• If you need to print your own RFID labels in the future, consider RFID label printers that are compatible with your tag format and frequency. Popular brands include Zebra and Brother, known for their reliability and quality.

Use Case Scenarios:

• Receiving Inventory: Upon receiving new stock, apply RFID tags and scan them along with the location tags where they’ll be stored.
• Stocktaking: Use handheld RFID readers to quickly scan shelves and verify inventory counts, updating your system in real time.
• Locating Items: To find an item, your system can indicate its last scanned location, and a handheld reader can be used to pinpoint its exact position.

Conclusion:

Implementing an RFID system for inventory management will significantly enhance your efficiency and accuracy in tracking items. By carefully selecting compatible hardware and software, you can create a robust system that aligns with your business needs and technology infrastructure.

Upon applying mundane WordPress update in an eCommerce store based on WooCommerce the store crashed, and the error message said:

There has been a critical error on this website. Please check your site admin email inbox for instructions.

Learn more about troubleshooting WordPress.

“This is awesome” — said I and after logging in recovery mode info WordPress Admin I noticed

One or more plugins failed to load properly.
You can find more details and make changes on the Plugins screen.

At the bottom of the email the Error Details were

Uncaught RuntimeException: Unable to claim actions. Database error: Unknown column 'priority' in 'order clause'. in plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:942 

Turned out that the database user that WordPress is using lacked all the necessary privileges to change the structure of the database and during the upgrade of WooCommerce it was unable to add an additional column named `priority`

In order to solve this, you need to add this column manually. You can log into phpMyAdmin, click on table wp_actionscheduler_actions on the left, then cl;ick “Structure” tab and under the

Now the most important part. Add the field with the following params:

Name: priority	Type:tinyint(3)		UNSIGNED	Null: No	Default: 10

Voila, problem solved! The field is added with default number value of 10 and WooCommerce should be working!

Odoo is an open-source business management software suite that includes a wide range of applications, from CRM and e-commerce to accounting and inventory management. If you want to start with Odoo development, you’ll need to have a good understanding of Python and web development, as Odoo is built on top of these technologies. Here’s a crash course on how to get started with Odoo development:

1. Setting up Your Development Environment:
   • Install Python: Make sure you have Python installed on your machine. Odoo primarily uses Python for its backend development.
   • Install Odoo: You can install Odoo on your local machine or set up a development environment. You can find installation instructions on the Odoo website or the Odoo community GitHub repository.
   • Install a Code Editor: Choose a code editor or integrated development environment (IDE) like VSCode or PyCharm for your development work.
2. Understanding the Odoo Framework:Odoo uses a framework that follows the Model-View-Controller (MVC) pattern. In Odoo, these components are referred to as Models, Views, and Controllers.
   • Models: Models represent database tables and their fields. You define these models in Python classes, and they are used to interact with the database.
   • Views: Views are responsible for the user interface and how data is presented. They are defined in XML files and can be used to customize forms, lists, and reports.
   • Controllers: Controllers handle the logic that ties models and views together. This is where you define the behavior of your modules.
3. Creating an Odoo Module:In Odoo, functionality is often packaged as modules. To create your own module:
   • Create a new directory in the Odoo addons directory, typically found in odoo/addons.
   • Inside your module directory, create a __manifest__.py file that defines your module. This file should include information about the module’s name, version, author, and dependencies.
   • Create Python files for your models, views, and controllers within your module’s directory.
   • Define your data models in Python classes, views in XML files, and the module’s logic in Python files.
4. Basic Development Workflow:
   • Create or extend models to define your data structure.
   • Define views to customize the user interface.
   • Implement controllers to define the business logic.
   • Use XML files to define menus, actions, and workflows.
5. Testing and Debugging:Odoo provides tools for testing your modules, and you can use the built-in debugging features to find and fix issues in your code.
6. Learn and Explore:Odoo has a large and active community, as well as extensive documentation. Be sure to explore the official Odoo documentation, forums, and online resources to learn more about Odoo development.
7. Version Control: It’s a good practice to use version control, such as Git, to manage your code. You can create a Git repository for your module to track changes and collaborate with others.
8. Deployment:Once your module is ready, you can deploy it to your Odoo instance for testing or production use.

Remember, Odoo development can be quite complex, especially for more advanced features and integrations. Start with small, manageable projects and gradually work your way up as you become more comfortable with the Odoo framework and Python development.

DECLARE @SearchValue NVARCHAR(255)
SET @SearchValue = ‘VALUE’

— Create a temporary table to store results
CREATE TABLE #Results (
TableName NVARCHAR(128),
ColumnName NVARCHAR(128),
ColumnValue NVARCHAR(4000)
)

— Dynamic SQL to search for the pattern in all tables (excluding views)
DECLARE @Sql NVARCHAR(MAX)
SET @Sql = N”

SELECT @Sql = @Sql +
‘INSERT INTO #Results (TableName, ColumnName, ColumnValue) ‘ +
‘SELECT ”’ + t.TABLE_NAME + ”’, ”’ + COLUMN_NAME + ”’, ‘ + QUOTENAME(COLUMN_NAME) +
‘ FROM ‘ + QUOTENAME(t.TABLE_SCHEMA) + ‘.’ + QUOTENAME(t.TABLE_NAME) +
‘ WHERE (‘ +
‘ (‘ + QUOTENAME(COLUMN_NAME) + ‘ LIKE @SearchValue COLLATE DATABASE_DEFAULT)’ +
‘ OR (‘ + QUOTENAME(COLUMN_NAME) + ‘ LIKE @SearchValue COLLATE Latin1_General_BIN)’ +
‘);’ + CHAR(13)

FROM INFORMATION_SCHEMA.COLUMNS c
JOIN INFORMATION_SCHEMA.TABLES t ON c.TABLE_NAME = t.TABLE_NAME
WHERE t.TABLE_TYPE = ‘BASE TABLE’ — Exclude views
AND c.DATA_TYPE IN (‘NVARCHAR’, ‘NCHAR’, ‘VARCHAR’, ‘CHAR’, ‘TEXT’)

— Execute the dynamic SQL
EXEC sp_executesql @Sql, N’@SearchValue NVARCHAR(255)’, @SearchValue

— Retrieve the results
SELECT * FROM #Results

— Clean up the temporary table
DROP TABLE #Results

Click on Ease of Access button at login prompt

Choose On-Screen Keyboard

Open Start

Click on Gear icon (Settings button)

Click on Ease of Access

go to Keyboard section

Enable Use the On-Screen Keyboard

Open Start and type Device Manager

Open Device Manager

Expand the Keyboards Section

Right click Update Driver

Select Browse my computer for for driver software

Select Let me pick from a list of available drivers on my computer

Select Standard PS/2 Keyboard, Press Next, then Yes to restart if prompted

---

If this did not work

try removing the PS/2 keyboard and rebooting

---

Settings -> Ease of Access -> Keyboard section

Located user filter key section

Enable OR disable it

---

open start and type: taskschd

Expand Task Scheduler Library -> Microsoft -> Windows -> TextServices Framework

on the Right select Enable, then Run

Restart computer

---

Open Start , type Task Manager

Open task manager

Click on More Details

Select Cortana and select End Task

---

Start -> Run

Open Run

“C:\Windows\system32\ctfmon.exe”

---

go to Device manager -> Keyboard -> Update Driver

Search automatically for updated driver software

Restart

---

Start -> Settings -> update and Security -> Troubleshoot

Keyboard on right panel -> Run the troubleshooter

---

Start -> Settings -> update and security -> recovery

---

Enable or disable the keyboard on notebook that can be folded into tablet

You can change the position of your x360 notebook to enable or disable the keyboard and power key (depending on the model).

To enable the keyboard and the power button key on an x360 notebook, place the notebook in clamshell mode.

To disable the keyboard on an x360 notebook, place the computer in stand mode, tent mode, or tablet mode.