Implementing SmartList Builder: Register

eOne SolutionsThis post is part of the series on Implementing SmartList Builder from eOne Solutions.

If you’re testing SmartList Builder, you can use it in the Famrikam Sample company without entering a registration key. However, yo use it on a normal company, even a test one, you will need to input the key.

To do this, log into Microsoft Dynamics GP as a user with the POWERUSER* role and open the SmartList Builder Register window (Administration area page » Setup » SmartList Builder » Register SmartList Builder) and enter the key in the Registration Key field:

SmartList Builder Register

Click Save to sdave the key and close the window.

IIS Rewrite Rule for Redirect to Directory

Microsoft Dynamics GPThe web hosat I am currently with allows multiple domains, but only 6 websites; this means I have to be a little creative sometimes when creating additional sites.

I actually have a lot more than six websites being hosted on my account, due to a mix of WordPress MU and redirects to folders.

The redirect is done using an IIS rewrite rule. As I may be moving web host soon, I’m posting this so that I have easy access should I need.

This code goes in the rewrite section of the web.config file:

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
<rewrite>
	<rules>
		<rule name="Rewrite subdomain.azurecurve.co.uk subdomain to dir" enabled="true">
			<match url="^(.*)$" />
			<conditions>
				<add input="{HTTP_HOST}" pattern="^subdomain\.azurecurve\.co\.uk$" />
			</conditions>
			<action type="Rewrite" url="_subdomain.azurecurve.co.uk/{R:1}" />
		</rule>
		<rule name="subdomain.azurecurve* wordpress" patternSyntax="Wildcard">
			<match url="*subdomain.azurecurve*" />
			<conditions>
				<add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" />
				<add input="{REQUEST_FILENAME}" matchType="IsDirectory" negate="true" />
			</conditions>
			<action type="Rewrite" url="_subdomain.azurecurve.co.uk/index.php" />
		</rule>
</rewrite>

The second rule is, I believe, required specifically for redirects for WordPress sites, the majority of which my rewrites are for.

Implementing SalesHQ Portal: Configure SalesHQ

SalesHQ PortalThis post is part of a series on Implementing SalesHQ Portal, which is one of the GP Elementz Portals from my new employer, ISC Software Solutions.

After a company has been registered with SalesHQ and you logout and back in, the menu will update with the menu items for the SalesHQ configuration windows:

Administration menu showing CustomerHQ

Continue reading “Implementing SalesHQ Portal: Configure SalesHQ”

Implementing SalesHQ Portal: Portal Deployment on Azure

SalesHQ PortalThis post is part of a series on Implementing SalesHQ Portal, which is one of the GP Elementz Portals from my new employer, ISC Software Solutions.

This is a step which ISC Software will perform, but some information is required for this to be accomplished. In the last post in this series, I showed how to register a company with SalesHQ; this generated a unique GUID for each company.

For ISC Software to deploy the portal, they need the Company ID for each company registered.

Run the script below against your Elementz database, to extract the CompanyID GUIDs:

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int). */
SELECT DynamicsDB,CompanyDB,CompanyId FROM CustomerPortalCompany

Once you have this information reply back to the Azure settings email you received before installing the connector service.

Have an enquiry for ISC Software Solutions?

If you’re interested in speaking to ISC Software about consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else, you can use the form below.





Your Name (required):
Your Email (required):
Subject:
Enquiry message:

Installing FileZilla Client: Stop Upload of GitHub Files

FileZilla - The free FTP solutionThis post is part of the Installing FileZilla Client series. FileZilla is a free software, cross-platform FTP application, consisting of FileZilla Client and FileZilla Server. Client binaries are available for Windows, Linux, and macOS; server binaries are available for Windows only. This series is taking a look only at the Windows FileZilla client.

With my transition from developing plugins for Wordpress to developing them for ClassicPress I have started to use GitHub (on which I will soon be writing a series). One problem I’ve noticed is that when uploading folders which are GitHub repositories, the GitHub files and folders are also uploaded.

However, this does not need to be the case. To prevent GitHub repository files and folders being uploaded, you can change a setting in FileZilla. To do this, click the View menu and select Directory listing filters:

FileZilla View menu

Continue reading “Installing FileZilla Client: Stop Upload of GitHub Files”

How to Remove a Dependency from a Windows Service

Microsoft Dynamics GPIn the last post I showed how to use sc.exe to add a dependency to a Windows service; the first time I added the dependency to the eOne and eConnect services, I got the service name wrong. This was because the server I was working on had a SQL Server Named instance rather than the default name.

I had to do some searching around how to remove the incorrect dependency, as it was preventing the services from starting:

Services - Windows could not start the eConnect for Microsoft Dynamics GP 2018 Integration Service service on the Local Computer

Continue reading “How to Remove a Dependency from a Windows Service”

How to Add a Dependency to a Windows Service

Windows ServerWhile I was blogging about implementing SmartConnect, I mentioned that the service account should be either set as delayed start or have a dependency added.

The former option, making it delayed start, can be done through the Services control panel applet, you can’t add a dependency this way. Instead the dependency can be added via a command.

The service can be changed by using the sc.exe which is a component of Windows. To use the command we need to know the Service name of both the service we want to add the dependency to and also the service name of the service it will be dependent on.

In my example, I am adding a dependency to the eOne SmartConnect Service; to find the Service name, open Services from the Control Panel, rich-click the service and locate the Service name:

eOne SmartConnect Service Properties

Continue reading “How to Add a Dependency to a Windows Service”

Local by Flywheel: Review

Local By FlywheelThis post is part of the series on Local by Flywheel.

Over the course of this series, I’ve installed Local by Flywheel, created and tested the default WordPress site and also accessed the local development site from the Internet.

Overall I have been very impressed with Local by Flywheel. It is a very easy installation, flexible yet simple setup and easy enough to access both internally and externally.

It would be nice, in future, to see ClassicPress available as a default install rather than having to either migrate the default WordPress one or manually replace it with ClassicPress, but that might come with time as ClassicPress grows.

Local by Flywheel: Test Updated Site Works

Local By FlywheelThis post is part of the series on Local by Flywheel.

The change to the wp.config file is the last of the changes needed to complete the migration of the live site into Local by Flywheel.

With the complete, you can access the site and test to make sure that everything has migrated correctly.

Local by Flywheel: Update wp.config

Local By FlywheelThis post is part of the series on Local by Flywheel.

The final step of migrating a live site into Local by Flywheel is to change the wp.config file; this is what tells the WordPres site which database to connect and the credentials to do so.

The settings required for the wp.config file can be found on the Database tab in Local by Flywheel:

Database tab showing connection settings

Continue reading “Local by Flywheel: Update wp.config”