Forum Posts

olivier kamoun
Mar 23, 2022
In Data Samples
Simple Guest list FIX transaction to NeyYork stock exchange
0
0
1
olivier kamoun
Feb 23, 2022
In Questions & Answers
Welcome to the world of Coding by Example of Bailam. the steps below will help you to start using the system. They are many ways to use the system but we advice o start with simple example on the web UI and to get into more complex cases. Below are some link that can help you : - Registration to the application : https://app.bailam.com/smartmap/register/ - Link to tutorial (need different registration ) : https://www.bailam.com/tutorials - link to FAQ Forum : https://www.bailam.com/forum if you need help : - contact us at support@bailam.com - you can raise a request to the help desk from the application under the help menu. if you want to use the Api for Jupiter: - small introduction : https://www.bailam.com/post/618bc7db10e553001732d348/edit - gitlab public project : https://gitlab.com/kamouno/bailam_api Please don't hesitate to contact us at support@bailam.com or to add comments below.
0
0
6
olivier kamoun
Feb 22, 2022
In Data Samples
This is a small example to transform a simple xml with list of book into a table The source data is like : <?xml version="1.0"?> <catalog> <book id="bk101"> <author>Gambardella, Matthew</author> <title>XML Developer's Guide</title> <genre>Computer</genre> <price>44.95</price> <publish_date>2000-10-01</publish_date> <description>An in-depth look at creating applications with XML.</description> </book> <book id="bk102"> <author>Ralls, Kim</author> <title>Midnight Rain</title> <genre>Fantasy</genre> <price>5.95</price> <publish_date>2000-12-16</publish_date> <description>A former architect battles corporate zombies, an evil sorceress, and her own childhood to become queen of the world.</description> </book> <book id="bk103"> <author>Corets, Eva</author> <title>Maeve Ascendant</title> <genre>Fantasy</genre> <price>5.95</price> <publish_date>2000-11-17</publish_date> <description>After the collapse of a nanotechnology society in England, the young survivors lay the foundation for a new society.</description> </book> <book id="bk104"> <author>Corets, Eva</author> <title>Oberon's Legacy</title> <genre>Fantasy</genre> <price>5.95</price> <publish_date>2001-03-10</publish_date> <description>In post-apocalypse England, the mysterious agent known only as Oberon helps to create a new life for the inhabitants of London. Sequel to Maeve Ascendant.</description> </book> <book id="bk105"> <author>Corets, Eva</author> <title>The Sundered Grail</title> <genre>Fantasy</genre> <price>5.95</price> <publish_date>2001-09-10</publish_date> <description>The two daughters of Maeve, half-sisters, battle one another for control of England. Sequel to Oberon's Legacy.</description> </book> <book id="bk109"> <author>Kress, Peter</author> <title>Paradox Lost</title> <genre>Science Fiction</genre> <price>6.95</price> <publish_date>2000-11-02</publish_date> <description>After an inadvertant trip through a Heisenberg Uncertainty Device, James Salway discovers the problems of being quantum.</description> </book> <book id="bk110"> <author>O'Brien, Tim</author> <title>Microsoft .NET: The Programming Bible</title> <genre>Computer</genre> <price>36.95</price> <publish_date>2000-12-09</publish_date> <description>Microsoft's .NET initiative is explored in detail in this deep programmer's reference.</description> </book> <book id="bk111"> <author>O'Brien, Tim</author> <title>MSXML3: A Comprehensive Guide</title> <genre>Computer</genre> <price>36.95</price> <publish_date>2000-12-01</publish_date> <description>The Microsoft MSXML3 parser is covered in detail, with attention to XML DOM interfaces, XSLT processing, SAX and more.</description> </book> <book id="bk112"> <author>Galos, Mike</author> <title>Visual Studio 7: A Comprehensive Guide</title> <genre>Computer</genre> <price>49.95</price> <publish_date>2001-04-16</publish_date> <description>Microsoft Visual Studio 7 is explored in depth, looking at how Visual Basic, Visual C++, C#, and ASP+ are integrated into a comprehensive development environment.</description> </catalog> The target is : The first generated logic doesn't have enough data to get the mapping fro all category of book, using the Review Result for the field "group" and adding expected value for the line without mapping we get to the following logic : You can access the resulting System link at : https://app.bailam.com/smartmap/2416/smart-link/ The system can transform the file on the serve and can also product the XSLT for the transformation : <?xml version="1.0"?> <xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:csv="csv:csv" xmlns:bailam="http://whatever" xmlns:fn="http://www.w3.org/2005/xpath-functions"> <xsl:function name="bailam:multiply"> <xsl:param name="x" as="xs:anyAtomicType"/> <xsl:param name="y" as="xs:anyAtomicType"/> <xsl:sequence select="fn:number($x) * fn:number($y)" /> </xsl:function> <xsl:function name="bailam:round"> <xsl:param name="x" as="xs:anyAtomicType?"/> <xsl:param name="n" as="xs:anyAtomicType?"/> <xsl:sequence select="fn:round($x)" /> </xsl:function> <xsl:function name="bailam:addition"> <xsl:param name="x" as="xs:anyAtomicType"/> <xsl:param name="y" as="xs:anyAtomicType"/> <xsl:sequence select="fn:number($x) + fn:number($y) " /> </xsl:function> <xsl:function name="bailam:toLower"> <xsl:param name="s" as="xs:anyAtomicType"/> <xsl:sequence select="fn:lower-case(fn:string($s)) " /> </xsl:function> <xsl:function name="bailam:toUpper"> <xsl:param name="s" as="xs:anyAtomicType"/> <xsl:sequence select="fn:upper-case(fn:string($s)) " /> </xsl:function> <xsl:function name="bailam:splitWord1"> <xsl:param name="s" as="xs:anyAtomicType"/> <xsl:sequence select="fn:tokenize( fn:string($s),'\s')[1] " /> </xsl:function> <xsl:output method="text" encoding="utf-8"/> <xsl:variable name="delimiter" select="','"/> <csv:columns> <column>group</column> <column>prix</column> <column>titre</column> </csv:columns> <!-- template per tables --> <xsl:template match="catalog"> <!-- Output the CSV header --> <xsl:text>group</xsl:text> <xsl:value-of select="$delimiter"/> <xsl:text>prix</xsl:text> <xsl:value-of select="$delimiter"/> <xsl:text>titre</xsl:text> <xsl:text>&#xa;</xsl:text> <xsl:apply-templates select="book"> </xsl:apply-templates> <xsl:text>&#xa;</xsl:text> </xsl:template> <xsl:template match="book"> <!-- Output the CSV header --> <xsl:variable name="catalog.book.genre" select="genre"/> <xsl:variable name="catalog.book.price" select="price"/> <xsl:variable name="catalog.book.title" select="title"/> <xsl:value-of select="concat('&quot;', ( 'IT', 'HO', 'SF', 'FY', 'RM' )[index-of(( 'Computer' , 'Horror' , 'Science Fiction' , 'Fantasy' , 'Romance' ), $catalog.book.genre)], '&quot;')"/> <xsl:value-of select="$delimiter"/> <xsl:value-of select="concat('&quot;',$catalog.book.price, '&quot;')"/> <xsl:value-of select="$delimiter"/> <xsl:value-of select="concat('&quot;',$catalog.book.title, '&quot;')"/> <xsl:text>&#xa;</xsl:text> </xsl:template> </xsl:stylesheet>
XML for list of books content media
0
0
1
olivier kamoun
Feb 15, 2022
In Questions & Answers
Bailam can process the following file formats: - xlsx (if there is mutiple sheets the additional sheets are assumed to contain possible dictionaries) - csv - json - XML - pdf with tables - zip for PDF with form (One file to become one row ) they should be send in zip containing multiple PDFs The format of target are limited to : - xlsx - csv - json (Support to json is currently limited to simple hierarchy)
0
0
3
olivier kamoun
Dec 07, 2021
In Questions & Answers
In order to learn by example Bailam need to connect records from the source to records from the target so there is necessary to have dat that allow this link to be done by the system, this is done by defining what we call the scenario_id for the source and target. The simplest approach is to have identifier in the source and in the target that contain the same data. it can be a transaction id , a phone number, and email. The user can select the field to be use in the source and target but if the user doesn't define the fields the system will try to select the fields automatically. Few comments : - There is no need to have matching identifier for all lines, if the system has enough line to learn it is enough - If some id are not unique there will be excluded for the learning but it will still be mapped to the target - The link can use more than one field - If exact match are not found Bailam can find "fuzzy" match to find corresponding line (this is not available in the basic suscription) In the resulting page the scenario id and the number of found matching records is displayed. If the field don't seems correct you can select the correct one manually in the system creation page. You can select the scenario_id for the source or for the target or for both. if you define only one side the system will look for the best filed in the target to match you selection.
0
0
3
olivier kamoun
Dec 07, 2021
In Questions & Answers
In order to discover the world of programing by example of Bailam you can go through the first tutorial : Please register on the site to access the tutorial and register on the application to test it.
0
0
1
olivier kamoun
Dec 07, 2021
In Questions & Answers
Bailam offer a free access to online mapping service for flat file. In order to register to the site you can go to . The basic access provide : - Access to bailam web application for file to file mapping (up to 50 fields in source and target file) - Generation of python code for the mapping - Advance mapping review system for incremental learning - Up to 50 mapping learning per month https://app.bailam.com/smartmap/register/ The commercial subscription model offer : - Mapping from Json Files - Mapping from PDF including advance OCR - Generation of Sql code - Definition of private dictionary - Access to full ReST API - Comparison of source - Release impact analysis and more to come Please contact us for more information
0
0
3
olivier kamoun
Dec 06, 2021
In General Discussion
Share your thoughts. Feel free to add GIFs, videos, #hashtags and more to your posts and comments. Get started by commenting below.
0
0
0
olivier kamoun
Dec 06, 2021
In General Discussion
We'd love to get to know you better. Take a moment to say hi to the community in the comments.
0
0
0
olivier kamoun
Dec 06, 2021
In General Discussion
We want everyone to get the most out of this community, so we ask that you please read and follow these guidelines: Respect each other Keep posts relevant to the forum topic No spamming
0
0
0

olivier kamoun

Admin
More actions