Loading...

Change all users to an alternate domain suffix

In Active Directory users and computers, right click Queries> New. Give it a name, click “define query”. Stay on the “Users” tab. Select “Is not” and type an invalid name like testtesttest. Click ok, ok. It should return a result with all users whose name is <<not>> testtesttest. Select all, right click> Properties. Go to Account tab> check “UPN Suffix” and change it to the appropriate suffix. That’s it! There are PowerShell methods to do this too but when handling hundreds of user accounts, you have to be absolutely careful in PowerShell. There are solutions online that work fine that I am not going to post here. This is purely for the GUI. Good luck!

Exchange and AD Powershell Useful Commands

I’ve had a few odd issues & tasks with Exchange 2010 and AD recently and wanted to take a moment to document them as well as the command used to resolve the issue:

The following command was useful to resolve an issue of multiple copies of the same shared mailbox showing where only one would allow access and the other copies would only fail to open.

Add-MailboxPermission -Identity <shared mailbox alias> -User <your mailbox alias> -AccessRights FullAccess -InheritanceType All -Automapping $false

The following will find all active user accounts whose Password Never Expires attribute is set to true formatted in a nice table of username and the value. Value is not really necessary because it should only return true, but everyone loves a sanity check right?

get-aduser -filter * -properties Name, PasswordNeverExpires | where { $_.passwordNeverExpires -eq "true" } | where {$_.enabled -eq "true"} | Format-Table -Property Name, PasswordNeverExpires -AutoSize

Stock Alerts

Stock Alerts

Boxstorm has the capability to provide stock alerts for users when inventory in a location reaches below a minimum
quantity. These are established as Reorder Points in the Items Module.

An alert may be sent to a user via SMS or Email, as specified in the Reorder Points Tab of each Item.

Reorder Points allow you to set min, max, and alert levels for each of your parent locations.
If a phone number or email address is provided, a notification will be sent when the total inventory on
hand for that location reaches the alert levels.

Create a Stock Alert

  • To create a stock alert, go to the Items Module and select the desired item from the list.
    After opening the item, choose the Reorder Points tab. Click the Add Item Reorder
    Point

    icon in the upper right hand corner.
  • Once the Set Reorder Details box is open, enter the information for this item and click
    Save.

  • Parent Location – The head location for this item.
  • Min – The minimum inventory quantity that should be in stock for this item.
  • Max – The maximum inventory quantity that should be in stock for this item.
  • Alert – The inventory quantity amount that triggers an alert to be sent to the phone and/or
    email associated with this item.
  • Phone (SMS) – The phone number to receive a message when the specified alert level has been
    reached.
  • Emails – The email address to receive a message when the specified alert level has been
    reached.

The Item Reorder Points tab will show a list of all Parent Locations associated with this item.
Each Parent Location can have their own min, max, and alert levels.

The Setting icon will allow the user to choose which columns are view-able in the Reorder Points
tab.

What do the Min and Max mean?

The minimum and maximum levels set here are for the Auto – Purchase Order creation. When the Auto Order
feature is selected (from the Purchase Order Module), any items that are below their minimum levels will automatically be
created on a PO. The alert level is the number referred to when SMS or Emails are sent, not for
when a PO is to be created.

Import Alert Levels via CSV File

Reorder Point Levels (Alert/min/max levels) may be imported in mass through a CSV file.

1. First, choose the Import/Export icon from the upper right hand corner of the Items Module. Choose
Reorder Point: Import

2. All Imports provide you with the option to download a sample CSV file.
This will help you to see how a file should be formatted so that it can correctly import. You can use this file
as a template and delete the information shown for the sample database (recommended), or you can create
your own file and add each of the headers needed yourself.

3. Once the CSV file has been properly formatted, repeat Step 1 above. This time, select Choose File.

4. Once uploaded, your screen will show a summary report like the image below. If the file
has been filled accurately and has all of the necessary information in the correct places you will see green
check marks next to the columns. If there is data that needs a little more specification there will be a red
X and a notice asking you to choose the correct column for the info. For example, if the system can not tell
which column on your spreadsheet is supposed to be the description, it will ask you to select the column manually
using the dropdown. If you continue to have problems with the upload after this point, please contact (support@boxstorm.com)
and attach your spreadsheet as well as a screenshot image and detailed description of the problem. Once the columns
are appropriately matched, click Next.

5. A summary page of all the reorder points to be imported will be shown. Here you can click
on any field to finalize the import and make any last minute changes. Once you are satisfied with your import,
choose the Import Data option in the lower right hand corner.

6. Congratulations! You have now imported your reorder points into your database. If you have
any difficulty after reading this documentation, please email support@boxstorm.com. It will be helpful if you
include the spreadsheet or details on what you need help with when you contact us.

Permissions

Permissions

The Permissions Module allows administration to create and assign users to specific Groups. Each Group
is custom made, has an unlimited number of people that can be assigned to them, and can be given
different Module rights. For example, some users may be given Full Access, while others may be given
access only to Purchasing or Sales.
Note: Only those with admins rights are able to create and grant User permissions.


Show or Hide Columns – This icon allows the Module to be customized by showing or hiding
the Name or Description columns.


History – This icon shows a history of the Group, including any Users who made changes.


Create a Permissions Group

1. In the
Permissions Module click the
New icon in the upper right hand corner. A
New Permissions Group box will be displayed.

2. Under the
Main Info Tab, enter the
Name and
Description of the Group. The right side will display the list of Users associated with
this Boxstorm account. Choose the users to be added to this group by checking the box next to their
name.

3. Click the
Permissions Tab to view and grant access to all of the different permissions for this group.
Checking the box next to each module will grant permission to all of the features within that module.
If only partial module permissions should be granted, the box next to individual features within
a module may be checked.

4. Click
Save to save all changes.


Filter Permissions

1. Filters may be added by choosing the
Filter Permissions button located in the upper left corner of the Permissions Module. Choose
to filter by
Name or
Description and click
Apply.

 

2. To
Save a filter for quick future access, simply choose the
Save icon.

3. To
delete a filter click the ”
X” located next to the filter name and click
Yes to confirm deletion.


Delete a Permissions Group

A permissions group may be deleted by first checking the box on the row next to the group name. The selected
row will become visible where the
Delete
icon is now available. Choose
Yes to confirm the group’s deletion.

FAQs

Frequently Asked Questions (FAQs)

The following questions are those most asked to our Sales and Support team! Before reaching out to our staff, we recommend browsing these questions for some insight.

How can I schedule a Boxstorm Training?

Existing customers: Email support@boxstorm.com with a list of questions and a preferred date and time.

Prospects: For those looking into Boxstorm for the first time, email Christy Hair at: christy.hair@boxstorm.com

How do I reset my password?

On the login screen click the “Forgot Password” link to receive an email that helps reset your password. If an email does not arrive soon, please check any spam and junkmail folders.

How do I import and export?

Almost every module has the capability to import/export data in batch files.

  • Go to the desired module and click the 3 vertical dots  located in the upper right hand corner of the screen.
  • Choose to Import/Export items.
  • We recommend downloading a sample CSV file to first see the correct format that a file needs to be in.
  • Once the CSV file is prepared correctly, it may be imported by using the Import | Choose File option.

Please see Import Items using a CSV file  for additional step by step instructions.

Does the Auto Create create a PO per item or per vendor?

The Auto Create will create a PO per vendor.

How do reorder points work? What are they for?

Reorder points set a minimum and maximum threshold for when an item should be reordered. If setup, Boxstorm will automatically create Purchase Orders through the Auto Order feature when these points are crossed. Low stock alerts may also be sent via email or text.

Additional information may be found at: Create an Item (reorder points) and Purchase Orders.

How do I undelete an item?

1. Go to the Items Module and click the Filter Items option in the top left corner.

2. Filter Items by Active Status | Deleted. Click Apply.

3.  Highlight the checkbox of the item to be undeleted and click the  “Undelete Selected Rows” icon. Click Yes to confirm the decision.

How do I add or remove inventory?

  • In the Items Module focus on the line item of interest and choose the  Inventory icon located on the far right side.
  • A list of inventory items by location are found in the pop up box. Select the location to modify and choose to Add, Remove, Cycle, adjust Cost, or Move inventory.

For additional detailed instructions please see Adjusting Inventory for an Item.

How are the Boxstorm web and mobile app different?

Unlike the web app, the iOS and Android apps cannot create sales orders or purchase orders. The current purpose of the mobile app is to look up items, see quantities, and edit items. Additional features (creating SOs and POs) for the mobile app will be included at a future date.

Can Boxstorm handle 2D barcodes?

The iOS and Android mobile apps do not support 2D barcodes. However, this is a feature that will be included at a future date.>

Set up Blue Iris Surveillance software with IFTTT

I have two cameras in which I’d like to always have a notification for if I’m not home. Initially I set this up to always send me an alert but I’m sure as you can imagine, my phone blew up with me walking around. Blue Iris has a neat feature which is simply a traffic light. If red, it will disable various things including recording (not desired for me in this case), but it can also disable alerts. I selected to only disable alerts if the traffic light is red. In the past, I had never used this feature. So here’s a brief how-to.

Click settings button and modify the settings as illustrated.

Set User Account that will perform this action.

Set Traffic Signal to Alerts Only

Verify web server port & disable Secure only for the web server

  1. On your server computer (Blue Iris Windows machine), install something like WAMP or XAMPP to handle web requests.
  2. After install set up a script similar to this one in PHP (create a php file with the name of your choice and .php extension):
    1. After you’ve created the script, drop it in your HTDOCs directory in WAMP or XAMPP
      1. For example, my directory is here: C:\Bitnami\wampstack-7.1.19-0\apache2\htdocs
<?php
$home = $_GET['home']; //get and set variable for the home status.
$my_file = 'log.txt'; //store logs so we know if our server is being used improperly and by whom

if($home == 'true')
{
	$handle = fopen($my_file, 'a') or die('Cannot open file:  '.$my_file);
	$data = date("Y.m.d.h.i.s") . ' on requesting ip: ' . $_SERVER['REMOTE_ADDR'] . ' Request to set RED.' . "\r\n";
	fwrite($handle, $data);
	fclose($handle);
	file_get_contents("http://10.1.1.99:8080/admin?user=admin&pw=password&signal=1");
	echo "home";
}
elseif($home == 'false')
{
	$handle = fopen($my_file, 'a') or die('Cannot open file:  '.$my_file);
	$data = date("Y.m.d.h.i.s") . ' on requesting ip: ' . $_SERVER['REMOTE_ADDR'] . ' Request to set GREEN.' . "\r\n";
	fwrite($handle, $data);
	fclose($handle);

	file_get_contents("http://10.1.1.99:8080/admin?user=admin&pw=password&signal=1");
	echo "away";
}
else
{
		
	$handle = fopen($my_file, 'a') or die('Cannot open file:  '.$my_file);
	$data = date("Y.m.d.h.i.s") . ' on requesting ip: ' . $_SERVER['REMOTE_ADDR'] . ' FAILED REQUEST!!! Request: ' . $home . "\r\n";
	fwrite($handle, $data);
	fclose($handle);
	echo "invalid";
	//donothing
}
?>
  1. Now let’s explain the URL in there so you can get an idea of what is happening and how Blue Iris is interpreting it. http://10.1.1.99:8080/admin?user=admin&pw=password&signal=1
    1. Where 8080 is the port you’ve set blue iris to
    2. User is the user account you create in Blue Iris
    3. PW is the password for said account (recommended to restrict this account down to admin tasks only not viewing rights or anything else).
    4. Signal is the traffic symbol where 1 is active (green) and 0 is inactive (red).
  2. Now if you browse to your local host URL 127.0.0.1/myphpfile.php?home=false you should have a value returned. In this case, you should see “away” in your web browser. If you see this, that means your PHP script is working. Blue Iris at this point should also change the animation in the traffic symbol.

  3. Let’s take a moment to understand all of what just happened and why. You set up a web server with a script to change the alert status on the local Blue Iris machine. Now you’ll need to expose the web server to the internet (or if your security aware, you may also set it to only work with IFTTT IP addresses). This step I will not outline as there are too many router combinations, but you need to port forward to your web server.
  4. IFTTT is super easy! Just log in, select Location for the “this” (set up an enter an area and set it appropriately for your home) and a “that” with a webhook in which you will put in your IP/ domain so something like x.x.x.x:PORT/myphpfile.php?home=true for enter and home=false for exit. You will create 2 webhook applets, one for enter and one for exit, each with the appropriate URL.

This guide is somewhat advanced as it assumes you know/ can port forward and you have a static IP or a domain set to change with your IP.

Mobile app for Android

Boxstorm Mobile for Android

Boxstorm Mobile provides the convenience of inventory management anytime, anywhere and may be installed on both ios and Android devices. Boxstorm Mobile has Dashboard, Items, and Scan modules for its basic functionality.


Installing Mobile for Android

1. Find Boxstorm Mobile by first browsing for and installing the app on your mobile device.

2. After installation is complete and the app is opened, the login page will be displayed where the Username and Password are entered. This is the same login information used for the website.

3. To access the different modules, simply choose the menu icon  located in the upper left corner of the app. The modules that are accessible will be shown in the drop down menu.

Dashboard

The Dashboard will be the first screen that is shown (depending on rights given for the user).  The Dashboard will instantly show the items that are needing to be Reordered (by location), the Open Sales Orders (with status of Accepted, Partial, or Quote) and the Open Purchase Orders (with status of Open or Partial).

Please note that the Dashboard module is informational only. Purchase Orders and Sales Orders can not be fulfilled through Mobile.


Items

The Items module provides a list of all items in the Boxstorm database and their quantities. (even if that quantity is 0). They are listed alphabetically.

Create a New Item

1 Items may be created by clicking the New Item  icon in the top right corner of the Items Module. Enter the information for the item and add an image if desired. Click Save to finish.

Search for an Item

2. To search for an item enter any part of the item’s name into the search field. Choose the desired item from the given list.

View Details and Edit an Item

3. To view the details of an item, choose one from the list and click on it. This screen is the easiest way to see an inventory break down by location. The Name, Description, Price, SKU, UPC, URL, Tags and Notes are also viewed here. Please Note: Inventory MAY NOT be changed from this module. To change inventory, see the Scan module. 

4. To edit an item, click the Edit button in the top right corner. This allows for the Name, Price, Description, UPC, and Notes to be modified. Click Save to save any changes. Please Note: Inventory MAY NOT be changed from this module. To change inventory, see the Scan module. 


Scan (Adjust Inventory)

1. Inventory may be typed or scanned into Boxstorm using the Scan Module. Items may be created using the  Add New Item icon, may manually be searched using the keyboard, or scanned using a scanner device. The  Camera icon allows for a picture to be taken of a barcode and used as a scanner.

 Add Inventory – Recommended to use when adding additional inventory.

 Cycle Count – Recommended to use when adjusting the total quantity amount at a given location. The number entered here is the physical count of inventory in stock.

 Transfer Inventory – The movement of inventory from one location to another.

 Remove Inventory – Removing inventory from a specific location.

2. To adjust inventory first Add, Scan, or take a picture of a barcode and choose the desired part from the given list. Once an item has been selected, a screen will be displayed to enter the quantity needing to be adjusted.

3. Click “Save” to save the quantity, then press the  icon to open the Inventory options.

4. Once an inventory option has been chosen, the default location will be shown as the destination. To change either the Root or Sub location simply select the current location and choose a new location from the given list. Click “Save” in the upper right hand corner to complete the change.

Adjust inventory in batch

5. Inventory may be adjusted for multiple items at the same time. To remove an item, click the . To remove ALL items, click Clear in the upper right corner.

Import Items Using a CSV File


Import Items Using a CSV File

Using a new software and setting up a database correctly can be a worry for any company, but Boxstorm’s easy to use interface and simple directions can make this a smooth process. This article has been created to provide you with the most beneficial information when it comes to Getting Started.
Information may be added manually to your database at any time; however, depending on the amount of data that needs to be entered it may be more beneficial to import information in batches.

There is a certain order that information should be imported into your database for the most success. We suggest viewing the Getting Started page for this recommended order that items should be entered into your database.


Importing Items

1.To import items first go to the Items module located on the left sidebar. Choose to create a drop down menu where all of the import/export options will be shown. Select Item:Import.

2. All Imports provide you with the option to download a sample CSV file. This will help you to see how a file should be formatted so that it can correctly import. You can use this file as a template and delete the information shown for the sample database (recommended), or you can create your own file and add each of the headers needed yourself.

3. Once the sample CSV file has been downloaded, you can open it by clicking the file located in the lower left hand corner of your screen (It may also be located in your Downloads folder).


The green columns shown above are REQUIRED for the import to be successful. We recommend deleting the sample data from this file and using it to enter your own data. Or, you also have the option of creating a new spreadsheet (CSV file format) and simply copying the headers to your new file.

4. The spreadsheet shown below is the correct format for importing items. All of these columns do NOT need to be filled in order to import items. The columns highlighted in green are the ONLY REQUIRED COLUMNS for a successful import.

The information below provides the description of each field. Remember, only the GREEN HIGHLIGHTED fields are required to be populated. Every other field is optional.

Default Vendors: (Optional) This is the preferred vendor that you order this item from and is useful if you plan to set up reorder points (ROP). If you have a min & max level set for this item (levels are set up in the Item module), you can click “AutoPO” in the Purchasing module and create a Purchase Order for its default vendor. If you don’t have a default vendor, keep the header on the spreadsheet but leave the column blank.

UPC: (Optional) This is the field a barcode is scanned into. If you are using barcodes that are already associated with items, they may be scanned here. You do not have to use this system to barcode. If an item does not already have a barcode, then Boxstorm can print a barcode for the item immediately following the import. If you do not have a UPC, keep the header on the spreadsheet but leave the column blank.

Sell As: (Mandatory) This is the name of the item as it appears on a Sales Order. Depending on your company process, this may just be the same as the item’s “name”. If you want to sell an item with a different name than that which is used internally, then enter the Sell As name here. If you wish to keep the item’s name the same on the Sales Order as it is internally, then simple copy and paste the “name” column to this column.

Tag: (Optional) This is a way to categorize items. For example, if I have a red adult road bike, I could set tags such as “road bike, asset, red, adult”. Tags can be filtered on some reports (such as Inventory on Hand), and can be used to view stock or email a PDF stock report to clients. There is no limit on tags, and they need to be separated by a comma.

UOM: (Mandatory) This is the Unit of Measure and details how you measure or sell your item. Each is the default UOM in every Boxstorm database, but others may be added. If you plan to have Units of Measure that are different than each (ea), they need to be manually added (or imported via CSV file) BEFORE importing the items.

Description: (Mandatory) This is the description of your item. Descriptions can be searched, so it is recommended to have detailed identifiers. For example, “Youth green helmet” could be searched by youth, green, or helmet.

Item Type: (Mandatory) This is the item type and has 3 options. You may choose from Inventory, Shipping, or Service. Inventory items are the most common.

URL: (Optional) This is to link a file on a computer page or a website for internal reference. If you do not have a URL, keep the header on the spreadsheet but leave the column blank.

SKU: (Optional) This is a field that may be useful if you have a second name for an item. Items can also be searched by SKU. If you do not have a SKU, keep the header on the spreadsheet but leave the column blank.

Deleted: (Optional) This field is not used during an initial import, and is beneficial when your desire is to delete items in bulk. Items can only be deleted after they have been already entered into the system. To delete mark the field as “true”. If this is an initial import, simply leave the column here blank.

Price: (Mandatory) This is the price you will be selling the item for. If you do not know the price at this time, you can enter 0.00 for this column and re-import the price at a later date.

Cost: (Optional) This is the cost from your vendor to you. This will not enter a cost for an item that does NOT have any inventory, rather it creates a cost based off the history usage for this item. Inventory is not added during this import, but may be added on a separate import if desired.

Notes: (Optional) This is an internal only note that can be added to an item. You can search this in the Notes field.

Name: (Mandatory) This is the item’s number or name

ID: Do not fill this in. Boxstorm assigns an ID upon importing your items to the database. This will always be left blank when importing new items.


5. After the spreadsheet has been populated correctly, go back to the Items Module and once again choose the 3 vertical circles in the upper right hand corner. Select Item: Import.

6. This time select the Choose File option and browse to where your CSV file is located.

7. Once uploaded, your screen will show a summary report like the image below. If the file has been filled accurately and has all of the necessary information in the correct places you will see green check marks next to the columns. If there is data that needs a little more specification there will be a red X and a notice asking you to choose the correct column for the info. For example, if the system can not tell which column on your spreadsheet is supposed to be the description, it will ask you to select the column manually using the dropdown. If you continue to have problems with the upload after this point, please contact (support@boxstorm.com) and attach your spreadsheet as well as a screenshot image and detailed description of the problem.

8. Once each item is approved with green checkmarks, choose the Next button. You will now see a Summary page like the one listed below. All of your items to be imported will be shown in a list. Here you can click on any field to finalize the import and make any last minute changes. Once you are satisfied with your import, choose the Import Data option in the lower right hand corner.

Congratulations! You have now imported your items into your database. If you have any difficulty after reading this documentation, please email support@boxstorm.com. It will be helpful if you include the spreadsheet or details on what you need help with when you contact us.

Getting Started Checklist

Getting Started Checklist

This article provides the recommended order of imports to successfully get your database running smoothly. Clicking on each module link below will take you to the individual page where you can find additional detailed information for that area. Data for several modules may be imported in batch via a CSV spreadsheet file.*

We recommend entering your company data in the following order:

 

*To see a sample of a CSV import file, choose a Module and select the menu option in the upper right hand corner.
Choose the “Import” option and then select “Download a Sample CSV File”.

This will provide a very helpful visual example of how your spreadsheet should be formatted before it can be properly imported into your database!

Note: At this time there is not a way to create additional blank databases. For help in this area, please contact Support.

InvoiceNinja Install CentOS with Apache

This application is quite useful for tracking payments. This quick tip is going to only go over the app installation for self-hosted versions (not setting up a server from scratch).

What you need to have:

  1. A CentOS server and Apache with PHP updated to version 7 or greater. (By default you usually get PHP 5.6. You may need to manually update this to 7. There are tutorials online for this)
  2. Knowledge or Google-Fu on Virtual Hosts with Apache
  3. Basic knowledge on moving files/ editing files within a Linux system.

What you need to do:

  1. Download the files. You can do this through commands like wget on the box or download it from www.invoiceninja.com on a Windows box and upload it to your web server.
  2. Extract the files either on your linux box or before uploading them through a utility like Filezilla
  3. Move (mv) the files to your web directory (IE: /var/www/html)
  4. I tend to put the application under a folder called ninja and modify permissions/ owner appropriately. Modify/ create a Virtual host for 80 and 443 pointed to the directory /var/www/html/ninja/public.
  5. cd /var/www/html/ninja
  6. composer install
  7. composer update
  8. Now when you navigate to your URL (IE: website.com or web.site.com), you’ll get the setup prompts.

Remember & Note

  • The .env is your settings file. It’s required to connect to any existing database if you are doing an update. If you update, please move this file to the new folder you upload.
  • Composer is a utility that will download necessary dependencies that Ninja will need to run. I tend to run these two commands every time I update the software to get the latest and greatest versions of all the dependencies.