In previous versions of zed E-Commerce and WebCRM, as well as WebTools, a document (NP2SBO-DataMap.xls) was shipped in the SDK\Code Examples\SynchPlugin\ folder that contained a mapping of how the data synchs from one system to the other. However, not everyone knew this document was there and the information contained in it was considerably out of date. As part of the 7.1.2 release of zed E-Commerce and WebCRM we wanted to include the updated information as well as present it in a user friendly format that will allow the users to search for the information they require without having to scroll through pages of information to try and find it. This data will also be updated with each release to reflect the current version of the application.

Anyone who has installed 7.1.2 can view this information in the Admin under Help -> Synch Data Map. This will open a new tab displaying the basic information. For a more detailed view of the data click on the Advanced View link at the bottom of the page. The table will be updated to include information such as the field sizes and API properties.

If you haven't yet downloaded 7.1.2 you can view this information at http://www.b1webcrm.com/admin/synchmap.aspx . However, this link will reflect the mapping as of the version installed on the b1webcrm site (currently 7.1.2).

I've included a couple of examples as part of this document of how a beginner or a more advanced user might use the data mapping to solve issues that they may encounter. If there are any specific situations which you have used this information for, or plan to use this information for please add a comment here so that others can learn from your experience. Also, as this information is every changing please feel free to comment on how we could improve the presentation to make it more beneficial.

Basic View:

 The Basic View contains the follow Columns:

Name:

          A friendly name used to identify the Synch Object.

zed Table:

          The table name in the zed E-Commerce and WebCRM database.

zed Field:

          The name of the field in the zed E-Commerce and WebCRM table.

B1 Table:

          The table name in the SAP Business One database.

B1 Field:

          The name of the field in the SAP Business One table.

To B1:

          Does this field Synch to Business One.

To zed:

          Does this field Synch to zed E-Commerce and WebCRM.

Comments:

          Any additional information about the line.

Finding Information:

Page Control:

The page control is located at the bottom of the table. The user can click the First, Next, Previous, and Last buttons to scroll through the data. A picture of this control can be seen below.

 

Group By Area:

The Group By area allows users to group the data by dragging columns from the table and dropping them in this area. This will change the display to group by the specified columns. For example, if we drag the Name column to the Group By Area it will be updated to look like this:

Sections can then be expanded by clicking on the '+' at the beginning of the row. To ungroup the data the column can be dragged back to its place in the table.

 

Search Box:

The Search Box is displayed in the far right corner of the Group By Area. The user can type characters into this field and it will search all columns and rows for cells containing this information. The table is refreshed as each character is typed so it is not necessary to press the enter key after entering the word that you wish to search for. For example, if a user wanted to know where all of the fields in the PartsMaster table synch they could type PartsMaster into the search box and the following will be displayed:

 

Additional Features:

Sorting:

          The data in the table can be sorted by clicking on the column header.

Organizing:

The columns can be dragged and dropped in the table allowing the user to change the order of the columns.

Resizing:

The width of columns can be increased by dragging the column separator to the desired width.

Examples:

Q: I want to know if the remarks on an Item in E-Commerce synchs to the Item Master in Business One?

A: Using the Search Box type in the information that you know. In this example, you know the field is called Remarks so type in Remarks. A few lines will be returned. Looking at the lines you will notice that one is for Items.

Reading the rest of the line you can see that it synchs to the UserText field in the OITM table of Business One. Also, that it synchs in both directions.

Q: I want to Synch quotes but I'm not sure if all of the information that I require will be synched. What exactly synchs for quotes and where does it Synch?

A: Since you know that you want information about Quotes type Quote in the Search Box. The table will be filled with the data associated with quotes. From this list you can identify which fields synch and where they synch to.

Advanced View:

For more advanced users another view of the data mapping is available that displays additional information. A user can see this view by click the Advanced View link at the bottom of the page. All features described above also apply to the Advanced View. This view can be seen below:

Additional Columns:

zed Field Size:

          The size of the field in the zed E-Commerce and WebCRM table.

API Class:

          The class in the Netpoint.API library that references the zed table.

API Property:

          The property in the API class that references the zed field.

 

DI API Class:

          The class in the SAP Business One DI API that references the B1 Table.

 

DI API Property:

          The property in the DI API class that references the B1 Field.

 

B1 Field Size:

          The size of the field in the SAP Business One table.

 

Examples:

Q: After the Item Synch completes, I want to create a Synch Plugin that will update the dimensions with data from a custom table to handle a conversion we need in Business One. How do I know what to use in the Netpoint.API to update these fields.

A: Using the Search Box type in the information that you know. In this example, you know that it is part of the Item synch so type Item. This will return rows related to the synching of items. From this list locate the dimensions. Using the API Class and API Property columns you will see that it uses NPPart and the Properties are Depth, Width and Height.

 

Q: I've created a synch plugin to update the name of the Contract Template once it has been added to the WebTools database. I'm using the DI API to retrieve the Contract Templates in Business One. My plugin fails stating that the Template Name is too long. I don't have access to the database server. How can I find out the maximum size of this field?

A: Using the Search Box type in the DI API property (TemplateName) that you are using to access the field in Business One. This will return the row that you are looking for. From here you can see that the maximum field size is 100 characters.