Tech World: July 2015

Tuesday, July 7, 2015

Access is denied in Plugin registration tool login

If you have any doubt in the post please post comments. I will try to solve your problem.

When you try login plugin registration tool the below mentioned error occur.

Solutions:

Check your username and PWD has valid in the CRM login. If the username is not in the CRM user list then this error occur.

Create a username and PWD in the CRM users(Settings->Security->Users). Then try login with that username and PWD in the plugin registration tool. You can successfully login.

Saturday, July 4, 2015

Length cannot be less than zero parameter name length error occur in webservice using scribe

If you have any doubt in the post please post comments. I will try to solve your problem.

This error occur due to given url is not valid WSDL format.

Solutions:

Click edit button in the web service connection manager window.Web service window will open.

In that check "Location Name required" the given URL must ends with WSDL. Otherwise you service may validate successful but you cannot connect web service.

Connect SQL using Scribe Insight

If you have any doubt in the post please post comments. I will try to solve your problem.

Using ODBC adapter we can create SQL server connection and load tables in the configure steps/source.

You can simply select single table.
You can even write complex custom query to execute.
You can also execute store procedure.

1. Open the scribe click configure steps

2. Add connection. Expand ODBC and double click "Add/Modify Datasource"

3. ODBC data source window will pop up. Click "Add" button in the user DSN tab.

4. Select "SQL Server" and click "Finish" button.

5. Give sql server name in the server input field and give name of your datasource.

6. If logged in windows login user name and PWD are same to connect the SQL server click "Windows NT authentication"

Other click SQL server authentication using login id and pwd and give username and pwd.

7. Check change default datasource and choose you database in the SQL server and click next button.

8. Click finish button.

9. Click testdatasource button,Your database added in the ODBC datasource and click OK button.

10. Choose your datasource in the configure steps connection lookup.

11. Now your tables are loaded. You can click tables and click. If you want write custom query you can do it. You can also execute store procedure.

Connect Webservice in Scribe Insight

If you have any doubt in the post please post comments. I will try to solve your problem.

In scribe, there are lot of adapters. In which we are going to see webservice adapter.

For some reason we are using webservice to insert/update/ delete data to destination system.

1. Open the scribe, click configure steps in the rights side. Connection manager window open.

2. Click "Add" button,"Add connection" window will open in that double click "webservice".

3. Webservice connection manager window pop-up and click Add webservice.

4. Define WSDL url in the location of wsdl input field.Give display name and click validate button.

Make sure the url end with WSDL otherwise validate will successful but you could not connect the webservice. it throws as "length cannot be less than zero"

5. Then click connect button.

6. Select login type as none or give username and PWD to connect webservice and click ok button.Now webservice connections are ready.

7. In configure steps choose webservice adapter. Now webservices are loaded, expand all data object. There you can see all webservice method.Select any method and click Add "Execute" button.

In the next post we will see how will you connect SQL in scribe.

Integrate(Import) Excel Workbook(CSV,XLS) to CRM using Scribe Insight

Integrate(Import) Excel Workbook(CSV,XLS) to CRM using Scribe Insight

If you have any doubt in the post please post comments. I will try to solve your problem.

using scribe with excel sheet we are going to integrate CRM contact
Open the scribe

Left side implies source system and right side would be destination. In our case source would be excel and right side would be CRM.

To create source click configure source. Configure source window open then we are going to create connection.There are lot of connections are available in CRM

Adapter
Database
ODBC
Text file

Here we are going to Text file and CRM adapter. In my later post we will see ODBC,webservice and SQL adapter.

Source system:
1. To create a new connection in the configure source click "Add" button.

2. To create a file source connection. Expand "TextFiles" and click Add/Modify text data source

Text wizard window open.

3. Fill DataSource name,Location and file extension if you are file is CSV,TXT,xslx. Check if you file has column name and click next button.

4. select the file in the wizard and click next button

5. In Text wizard step 3 is little bit tricky.In Excel all the column is by default take as string.

Table Name:Give name of the table name
Type:Make sure column must have same column type with destination system, if it is not then change "Type" drop down.Otherwise at the time of integration it throw error as column type is not valid.
Precision: The column max value number is filled by default(. It is equivalent to column length in database. Make sure always source column and destination mapped column must have same length.

click ok button.

Column type:

6. Now file will be added in the connection pane.

7. Select the new created source connection and click ok button.Connection setting window open

8. Click ok,automatically add this connection setting with connection manager window.

9. In the configure source window choose your connection settings.

Excel object is loaded in the table.You can also write sql query.

10. Click ok button.

Now our source system is ready. Then we are going to configure destination system.

Destination system:

Here we are going to configure steps. There are multiple steps possible.For example we can create a contact in one step and create customer in another step.

1. Click configure steps. Similar to source system click connection configure manager window open. Click Add connections.

Here we are going to select adapter. Expand the adapter and select Mircosoft CRM.

2. Double click the CRM adapter. Adapter login window will open.

3. click button and add in the connection manager.

4. Click close button and choose the CRM adapter. CRM adapter object will be loaded.

5. select the entity we are going to map. Here i am going to insert contact so i select contact. Choose the operation drop down to which step do you want to execute. Here i am going to select insert. If you choose update/insert then step will execute as check contact is there in CRM if already is there then update the contact if not then insert a contact.Click "Insert steps" button.

6. Now step is added in the system. If you have multiple steps then how and when the step will execute can control by configure in flow control tab. In later post you can see how will you configure multiple steps.

7. You can also configure before step execute what have to check by click formula editor in "pre-operation" section. For example Last name is mandatory so i will check is there last name is available or not if not then go to next line in the source.

Now source and destination system is ready.Then we are going to map the column from source to destination.

8. We mapped first name and last name in the system.

There are two icons in green colour.

Tick - To validate the output not real transaction(not affect in CRM)
Play - Real time.

9. To validate the output click "tick" icon, you can see the output window. In show first data in the excel object by clicking next button you can get consecutive data in the excel. In the right side pane you can see the corresponding output of the row and also you can check whether data is inserted or skipped in "Step result" tab.