Posts Tagged ‘Server’

Great Plains Customization Tools: Dexterity, Modifier, Econnect, Auto Posting Server

Saturday, May 15th, 2010

Microsoft Dynamics GP, or former Fantastic Plains Software eEnterprise, Dynamics has proprietary EDI: Microsoft Dexterity. This tools really requires skilled programmer to do the job, and we do not recommend you to do dex modification on your own or try to come through Fantastic Plains Dexterity programming learning curve. Instead you should probe yourself as GP developer with eConnect – C#, VB and SQL skills are helpful here, or even in VBA – this programming practice comes together with GP Modifier module. Let’s review the tools:

1. eConnect. This is Software Development Kit with sample codes in VB and C#.Net. At the end of the chain eConnect calls encrypted SQL stored procedures, which you can not modify, and you shouldn’t as these procs replicate Dexterity business logic, where eConnect has some features of Object Oriented Programming. eConnect was initially dedicated to eCommerce Microsoft Visual Studio developer, who is given the objective to integrate e-commerce website with GP ERP at the back end. eConnect has some restrictions, one of them is lack of batch posting ability, so we recommend you Alba Spectrum Posting Server

2. Auto Posting Server. Again, GP is written in Microsoft Dexterity and it has its internal logic, which is available for Dexterity source code developer. Posting Server calls GP Dex batch posting native logic to post batches in the queue. You, as SQL programmer should place batches, produced in eConnect or Integration Manager into this queue table. In our opinion, this product is more flexible and gives you more control, than Autopost, urban by Parity Software, GP VAR from South Africa

3. Modifier with VBA. If you have comfort amount in VBA scripting and past experience programming and modifying MS Excel, Access, Word or other office applications with VBA, the research this option of GP customizing. Modifier allows you to place new fields to GP forms and screens and then you as programmer can associate VBA scripts with these new fields. If you plot to alter DB, by clicking or filling up new fields, please be sure that you are familiar with Microsoft ADO technology

Tags: , , , , , , , , ,
Posted in Uncategorized | Comments Off

Great Plains Var Newsflash: Posting Server and Automatic Batches Posting

Sunday, March 7th, 2010

Microsoft Dynamics GP is standard ERp platform for eCommerce applications and business portals, where you have established shopping cart with customer registration, product catalog surfing and bits and pieces picking functionality.  Assuming that customer pays by credit card straight away, and you then send Sales Order Processing Invoice to Fantastic Plains through eConnect programming logic – there is excellent thought to close all the work in Dynamics GP, such as apply deposit against invoice and post SOP Invoice or Batch.  But eConnect, and this is limitation of Fantastic Plains Dexterity architecture, doesn’t have functionality to post GP batches.  You need Alba Spectrum Posting Server or Autopost.  Please read product highlights:

1.       Dynamics GP Dexterity source code programming and batch posting.  As the developer or SQL programming, all you do is place the batch name to the queue table, triggering GP that batch is ready to be posted.  Then, seeing batch in the queue, Posting Server initiates exactly the same posting process as if user hits Post Batch in GP user interface.  Please, note – as we use GP Dexterity posting logic, posting server is very reliable in GP version upgrades

2.       GP modules covered.  As we are using native Fantastic Plains Dexterity posting logic, all modules are covered, where you have batch or transaction posting functionality: SOP, POP, General Ledger, Payroll, Inventory Control to give you excellent examples

3.       Posting Server over stored procedures designed from scratch.  If you have SQL programmers in IT department, the thought might be fantastic on the first glance, but simple comment like that may be discouraging.  Fantastic Plains ERP application was written in Fantastic Plains Dexterity bombard, and it took several years of efforts for Fantastic Plains Software back in earlier 1990th with large development team to make it happen.  Batch posting logic is crucial and we could estimate that posting programming porting is close to 30 percent

Tags: , , , , , ,
Posted in Uncategorized | Comments Off

Dynamics GP ecommerce integrations: eConnect, Posting Server notes

Saturday, February 13th, 2010

It is evenly excellent thought to start ecommerce from scratch, but for some of us it doesnâ??t work as we work for established ecommerce retailers and wholesalers, where ecommerce application might be custom urban and hosted on Linux/PHP/MySQL, Oracle or a further non Microsoft solution.  In this situation you would rather consider custom integration with existing ecommerce web site and we want to share with your some highlights.  We are trying to write this small publication for programmers and IT people as a review:

1. eConnect SDK.  If you are comfortable with Microsoft Visual Studio C#, VB or a further .Net language programming, plus you are fluent with XML and have excellent SQL querying background, you should take a class or try self study on eConnect.  With this Software Development Kit you can program virtually all core modules Fantastic Plains objects: GL Financial statement, Customers, Vendors, Employees, Addresses. SOP Invoices, Buy Orders, etc.  eConnect might seem a bit complex, especially when you are very courageous and want to try coding custom SQL Stored Procedures, in this case, please consider the following fact â?? eConnect is written in SQL Stored procs (that are encrypted) and you probably do not want to do it second time, especially taking into significance the fact, that in Microsoft Business Solutions programmers have access to all the Dynamics GP Dexterity source codes and got appropriate training

2. eConnect Posting restriction.  eConnect doesnâ??t post Dynamics GP batches, as this is how Fantastic Plains architecture was built.  Batch posting is prerogative for GP user, who supposed to review the batch (print batch edit list report), get sufficient evidence that all the transactions are right and ready for posting and then post the batch from Fantastic Plains user interface.  If you really reckon that you need to post GP batch from ecommerce application frankly, please read the next paragraph about Dynamics GP Posting Server, or Autopost

3. Fantastic Plains Posting Server.  We urban this Add-On in Dynamics GP Dexterity, it deploys native Dex posting routines and by doing so eliminates the problems with Software QA, as it is not exposed to programming bugs.  Posting Server or Autopost is for Software Developer and it allows programmers to flag Dynamics GP work transactions batch for posting.  Batch posting checker is running every few minutes and it looks at batch ready for posting table and if batch is there, it triggers Dynamics GP fixed batch posting routine

4. SQL Scripts in ecommerce integrations.  We have several scripts collections, one of them is Order Connector, which allows you to deploy scripts to go ecommerce orders or invoices to Dynamics GP SOP Orders and Invoices accordingly.  Order connector runs quicker in our opinion that eConnect methods, as we are not validating all Dynamics GP business logic and instead give you green light with simple Orders and Invoices

5. If you have concerns, or want to get more info, see presentation, feel free to call us: 1-866-528-0577, help@albaspectrum.com

Tags: , , , , , ,
Posted in Uncategorized | Comments Off

Econnect Ecommerce Posting Server for Dynamics Gp

Thursday, February 11th, 2010

If you are eCommerce .Net c#, VB or SQL developer, you need to know eConnect â?? Microsoft Dynamics GP Fantastic Plains SDK for e-commerce developers architecture and limitations. eConnect was specially built up for eCommerce programmers, but at the same time it complies to GP Dexterity architecture frameworks, such as GP batches and transactions posting is GP user prerogative. If you as eCommerce designer plot to post Gp transactions or batches involuntarily from your e-commerce web application, you will nee either Albaspectrum autoposting server or program Fantastic Plains Dexterity source code with your internal programmers or Dex subcontractors. If you expect eCommerce website just to make so-called working orders or invoices in backend ERP Fantastic Plains SOP Sales Order Processing module, then you are fine with eConnect development and use only. But if you only expect GP to fulfill invoices with goods delivery, then autoposting might be required. The rest of this article is dedicated to technology highlights:

1. Autoposting as Microsoft Dynamics GP Dexterity source code application. There is the way to command GP engine to post specific batch in any GP module: GL, SOP, POP, AR, AP, Payroll, Inventory control. But if you reckon this is simple solution, this is not the case, you need at least 5 years of Fantastic Plains Dexterity programming with exposure to source code (DYNAMICS.DIC with all the sanscripts code not stripped out)

2. After Hours Posting in GP user interface. This is natural solution, when you have limited number of orders per day, letâ??s say 20 or up to 100. In this case if order size is feasible to sustain your business, you can hire Fantastic Plains users, who will manually post your daily or weekly Sales Orders batches and transfer them for fulfillment and consignment to shipping department.

3. eCommerce integration to GP notes. There are several tools for you to consider, each has pluses and minuses as you can expect: eConnect â?? if you have developers inhouse, consider first eConnect as it is what Microsoft Business Solutions recommends in long run. If you reckon you are low amount orders per day business, consider Fantastic Plains Integration Manager (10-1000 transactions, maybe more if you consider IM automated integration with some custom logic to launch IM)

Tags: , , , ,
Posted in Uncategorized | Comments Off

Microsoft Dynamics Gp Autoposting Server Overview

Friday, February 5th, 2010

If you are integrating ecommerce web application with Microsoft Fantastic Plains and deploy such integrating SDK as eConnect, then you should know the option to involuntarily post batches in GP as they are imported from your e-commerce front end. In GP, as you should know the background technology is Fantastic Plains Dexterity with DYNAMICS.DIC where business logic is stored. eConnect itself is imitating Dex business logic in encrypted SQL stored procedures, but you typically can not or discouraged from modifying these SQL stored procs. Alba Spectrum Posting Server deploys Microsoft Dexterity internal logic and so it is simple and at the same time pretty version-proof. Lets come to highlights:

1. eConnect restrictions. Well, eConnect is fantastic tool and Software Development Kit, but it assumes that you are habitual GP user and you post your SOP, POP, AR, AP, IV GL batches through Fantastic Plains user interface. In eCommerce scenarios it is evenly the requirement to post GP batches involuntarily on demand, triggered by eCommerce programmer

2. Dexterity Batch Posting programming. Dex is proprietary tool and it is really complex, so we do not recommend you to break through Microsoft Dexterity learning curve to come to the point of being able to program eConnect batches posting

3. Integration Manager batches posting. As SQL programmer, all you need to do is to place IM integrated batch to queuing table for triggering it to be posted by Posting Server

4. eConnect C# and VB programming. These programming languages are recommended to program eConnect integrations

Tags: , , , ,
Posted in Uncategorized | Comments Off

Econnect Posting Extension: Alba Spectrum Autoposting Server

Wednesday, February 3rd, 2010

If you are ecommerce developer, who are programming in C# or VB.Net with some SQL stored procedures, then more likely you are deploying Microsoft Dynamics GP eConnect SDK to integrate eCommerce website with Microsoft Fantastic Plains. There are certain restrictions in eConnect, and they are in essence related to Fantastic Plains Dynamics architecture. One of the restrictions is incapacity to post Sales Order Processing batches from your eCommerce web development project. Alba Spectrum is proud to place forward GP Posting Server, which deploys Microsoft Dexterity native posting logic. Here are some highlights:

1. GP Dexterity posting engine. All you need to do as developer is place the batch records, which is ready to be posted into queue table. Posting is done the same way as in native GP interface and by the same technology – Fantastic Plains Dexterity. Dex is the bombard and it interprets business logic from its dictionary – DYNAMICS.DIC. All the source sanscript code in this dictionary is stripped out and if you, as Dexterity programmer want to call native posting logic, you must have access to Dex source code

2. Supported modules. As Posting server deploys Dex internal logic, there are no restrictions on the origin of the batches to be posted. In many cases you can even autopost batches with origin from GP add-ons or third parties, urban and supported by GP ISV

Tags: , , , , , ,
Posted in Uncategorized | Comments Off

Great Plains Reseller News: Autoposting Server for Dynamics Gp

Tuesday, February 2nd, 2010

Microsoft Dynamics GP implementation in ecommerce or EDI (Electronic Document Interchange) environments evenly requires documents creation in Dynamics GP from outdoor applications, such as e-commerce web site.  We recommend you to make a research in the SDK and integrating tool, named eConnect.  eConnect makes, deletes and updates GP master records: customer, vendor, employee, GL account, address for customer or vendor to name few examples.  Also eConnect makes so-called work documents: Sales Order Processing Invoice, Sales Order, Buy Order, GL transaction, Payroll Payment and Check, etc.  Please, note here, that these documents have work status, they are not posted and awaiting for your review and posting on the batch amount.  It is evenly the requirements to post Fantastic Plains batch involuntarily from ecommerce or EDI integration application – and here you will get the limitation of eConnect – it doesn’t have batch posting functionality and it probably should not due to GP architecture.  In order to post batches in GP you will need add-on GP Autopost

 

1.       Autopost Technology.  It deploys Microsoft Fantastic Plains Dexterity internal procedures to do posting, but it open the way to post batches genuinely through custom Dexterity programming.  Autoposting Server is extremely reliable and it is immune to GP version upgrade, as Dex code, related to batch posting is virtually unchanged

 

2.       EDI and other posting needs.  Due to the fact, that Fantastic Plains Posting Server uses Dex procedures, it can post the batch of multiple origins, including some add-ons modules batches.  This is why Autopost is standard in EDI scenarios

 

3.       GP Autopost Support USA Nationwide and Internationally.  This product is targeted to ecommerce programmers and developers, and doesn’t require our technicians stay onsite, and we are comfortable to sell and support it nationwide and internationally, where Fantastic Plains is localized: UK, Australia, New Zealand, South Africa, Midpoint East, India, Pakistan, South East Asia, Philippines, Singapore, Malaysia, Indonesia, Mexico, Caribbean, South America

 

4.       GP customization and programming air force.  Fantastic Plains Dexterity Software Development Factory is in your disposition

Tags: , , , , , ,
Posted in Uncategorized | Comments Off

How to Setup Proxy Server

Monday, January 18th, 2010

A lot of individuals protest that “Webproxys” aren’t working at their school/workplaces PC’s because they have been prohibited by administrators. A solution around this will be to set up your proxy server that is hosted:

1. phpproxy

Download phpproxy on the Internet and unload it to a directory on your hard disk. All you need to know is to place the script to your web space and open the new URL to verify if it’s working perfectly. You may want to exchange the name of the file, a touch that doesn’t have the term proxy in it to prevent from filters that prohibit everything that has the term “proxy” in it.

You can open the script and place the IP of your clients to make certain that only your client will be capable to link or you can add a “.htaccess” file to the local directory pushing everyone who likes to start the script to penetrate a password and username. Again, utilize google if you want to find out more info about “.htaccess”.

The “php” script has some prerequisites, be sure you check the “readme” file which is comprised and veirfy to see if your web hoster has those prerequisites enabled.

2. cgiproxy

Your hoster need to have the cgi enabled for them to open this script. A lot of free hosters don’t give cgi or some installed scripts. Be sure it is enabled previous to you start the process of installation.

First, get the source on the Internet and unload it to a directory.

Now, run the .cgi file and look at the configuration. You could edit a lot of settings from w/in, for instance you could arrange the script that way that it only enables text to go over the proxy but no graphics or images. Everything is clarified in detail and entire options are clarified w/ comments, browse over the file, edit the choices to your liking and store the new file.

After that residency of the script to “cgi directory” if that is needed by your hoster and run the Uniform Resource Locator or url from your Internet browser. You’re now prepared to surf the web anonymously, to verify if that is the case load a site like “whatismyip.com” as the first website and verify if the IP goes with the server the script is set up and not your IP. If that is the case you have done everything right and could browse anonymously.

3. What it is being blocked?

a) If you could access the proxy from the server they just block ips/domains. b) If you cannot access the proxy they may be prohibited filenames that has proxy as well, try to exchange the filename.

Tags: , ,
Posted in Uncategorized | Comments Off

SSL Certificates – Secure Server Certificates

Sunday, January 3rd, 2010

What is SSL?
SSL certificates are generally used with ecommerce shopping carts, or somewhere you want to collect information from a user securely on your website. If you use a secure server certificate with a form; and that form emails the results to you; keep in mind that the email is not secure.
SSL (Secure Sockets Layer): Makes an encrypted link between a web server and a browser. CA (Certificate Authority): The vendor you will get the secure server certificate from CSR (Certificate Signing Question for): A text file generated by a web server. A CSR looks like this:
——-BEGIN NEW CERTIFICATE REQUEST——-
MIIDGgBNAGkAYwByAG8AcwBvAGYAdAAgAFIAUwBBACAAUwB
AG4AZQBsACAAQwByAHkAcAB0AG8AZwByAGEAcABoAGkAYwl
L0ygNwwNIvKLMPq4/LcUkZ9Oo4AssXW5mvvhHWGz2RWYRhrw8o
——-END NEW CERTIFICATE REQUEST——-
First, you need to choose whether to use your hosting mutual SSL certificate if they place forward it. The URL to your store will look a touch like:
https://theirserver.com/youruserid/your/path/to/store.html
Or do you want to get your own SSL certificate? The URL will look like:
https://yourdomainname.com
If you choose to use your hosts’ mutual secure server certificate, then all you need to do is find out the path you need to use to call your files securely, and you will be on your way.
If you choose to get your own SSL certificate, this is generally what happens.
You first need to choose who you are going to get your SSL certificate from. It is a excellent thought to make sure your host supports your particular vendor. Some certificate authority vendors are:
* Thawte
* Verisign
* Comodo
* You can also review several vendors at a glance at WhichSSL
Previous to getting your own SSL certificate, you will need to do some reading on what your chosen Certificate Authority requires for a secure certificate, and you’ll also need to come up with some documentation. There are several steps to buying a secure server certificate, once you have chose on a vendor.
This is an overview, not written in stone. Each CA is different, so make sure you read their documentation and what they require. Here is an thought of what they want:
All documentation that is requested must match exactly. Secure certificate authorities will verify that your organization really exists, so they know they are issuing to the right company. You will need to verify that the Organization Name and the Domain name are in fact yours to use.
Steps you’ll be taking:
* Gather required documentation
* Have your host generate a CSR
* Complete certificate authority online application
* Certificate authority will process your question for
* Pickup and install your SSL certificate (usually an URL is emailed to you to download the secure server certificate)
* Depending on the vendor, it can take a few hours to a few days.
* Send secure certificate to host for installation. (Send in plain text)
Once your web hosting provider receives this information; they will generate the CSR and send it back to you in plain text. You then send it on to Verisign or Thawte, or whoever you have chosen as your secure certificate authority. They will then generate a SSL certificate for you which you will send back to your host for installation. Your web host may charge a fee for installation in addition to what your SSL certificate vendor charges.
A touch to reckon about:
If you’ve chose to buy your own SSL certificate, you will need to choose how you want your URL to be called. If you, as a rule, call your domain name in your coding as www.yourdomainname.com, then make sure you indicate this to your host when you question for a CSR from them. If you don’t, and you get the certificate for yourdomainname.com (without the www), this will produce browser errors, making the certificate seem insecure, and you will need to exchange your coding.
Permanently use yourself or your company as technical contact.
How to tell if a site is secure?
After you’ve browsed to a site securely; using https:// in the URL, look on the lower right hand side of your browser. You should see a closed lock. This will tell you the site is secure.

Tags: , ,
Posted in Uncategorized | Comments Off

Keeping Your Server Info Private

Saturday, January 2nd, 2010

Passwords, scripts, personal and other confidential information are a few examples of information that you might not want Google to google with. Or maybe, you have sales and promotional pages in your database that need to remain exclusive to your clients. These are excellent reasons for keeping the spider “bots” out of these files. But, since the goal is for your website to achieve the highest rank possible when potential buyers conduct an online search, you do want Google’s or other search engine’s robots to have access to most of your website’s information and pages. So how do you go about keeping your secret material secret?
One of the most powerful and standard methods is the use of a robots.txt file that is stored in the root directory of your site. This system, if used properly allows search engine robots to access your website pages without accessing confidential files. This text file acts like a security guard for your confidential files. It will only allow the “bots” to see what you want them to see. It also gives you the power to block a particular search engine or engines from gaining any access at all if that is what you wish. When a “bot” starts crawling your site, it starts by checking to see if you have a robot.txt file that will prevent it from accessing certain pages of your site. The “bot” understands code language that you will use when setting up your robot.txt file.
Of course, for many website owners, the main reason they have a website is to benefit from Adsense dollars on as many pages as possible. So, you might be wondering that if you block certain pages, how you will be able to generate revenue from advertising sources. Adsense is a program whereby you can allow advertisers to show their ads on your site. When a name clicks on one of these ads, you will be paid for that click. Usually, it is only a few cents per click, but they add up. Many individuals make a nice side income strictly from Adsense revenue. To sign up for this program, stay http://www.google.com/adsense. But, back to the question about how this will work, if certain pages are blocked. The answer is again in the robot.txt file. Simply allow the user-agent MediaPartners-Google to gain access to these pages. This agent does not share pages with the other “bots”, so your information will remain confidential.

Tags: , , ,
Posted in Uncategorized | Comments Off