Can we develop a specific data provider type ?
Hi
Yes, you can write your own data provider. Here’s some boilerplate code to help you get started; Acumatica will automatically detect your provider. This is from an existing provider that I wrote, I just removed everything that is specific and provided just a base template for you.
InternalImport/InternalExport are the functions you need to implement and where the actual work happens.
using PX.Api;
using PX.Data;
using PX.DataSync;
using PX.Objects.AP;
using PX.SM;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml;
using System.Xml.Linq;
using System.Xml.Schema;
namespace Velixo.Sample
{
public class SampleProvider : PXSYBaseEncodedFileProvider, IPXSYProvider
{
protected const string MsgId = "MsgId";
public string DefaultFileExtension => ".xml";
public override string ProviderName => "My Provider";
public override string Extensiton => DefaultFileExtension;
public override PXFieldState[] GetSchemaFields(string objectName)
{
List<PXFieldState> ret = new List<PXFieldState>(base.GetSchemaFields(objectName));
//TODO: Add the fields your provider will be exposing
ret.Add(CreateFieldState(new SchemaFieldInfo(-1, MsgId)));
return ret.ToArray();
}
protected override List<PXStringState> FillParameters()
{
List<PXStringState> ret = base.FillParameters();
//TODO: Add the parameters your provider will be exposing
return ret;
}
protected override byte[] InternalExport(string objectName, PXSYTable table)
{
throw new NotImplementedException();
}
protected override void InternalImport(PXSYTable table)
{
throw new NotImplementedException();
}
}
}
What are you trying to create the provider for? Some multi-table type import operations might not be ideal to use integration scenarios.
So this could work with any file extension or only the ones supported by acumatica (xml, excel; csv..) ?
public string DefaultFileExtension => ".xml";
What are you trying to create the provider for? Some multi-table type import operations might not be ideal to use integration scenarios.
For a specific file with .TRA extension that doesn’t exist already in acumatica
Hi
Yes, you can write your own data provider. Here’s some boilerplate code to help you get started; Acumatica will automatically detect your provider. This is from an existing provider that I wrote, I just removed everything that is specific and provided just a base template for you.
InternalImport/InternalExport are the functions you need to implement and where the actual work happens.
using PX.Api;
using PX.Data;
using PX.DataSync;
using PX.Objects.AP;
using PX.SM;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml;
using System.Xml.Linq;
using System.Xml.Schema;
namespace Velixo.Sample
{
public class SampleProvider : PXSYBaseEncodedFileProvider, IPXSYProvider
{
protected const string MsgId = "MsgId";
public string DefaultFileExtension => ".xml";
public override string ProviderName => "My Provider";
public override string Extensiton => DefaultFileExtension;
public override PXFieldState[] GetSchemaFields(string objectName)
{
List<PXFieldState> ret = new List<PXFieldState>(base.GetSchemaFields(objectName));
//TODO: Add the fields your provider will be exposing
ret.Add(CreateFieldState(new SchemaFieldInfo(-1, MsgId)));
return ret.ToArray();
}
protected override List<PXStringState> FillParameters()
{
List<PXStringState> ret = base.FillParameters();
//TODO: Add the parameters your provider will be exposing
return ret;
}
protected override byte[] InternalExport(string objectName, PXSYTable table)
{
throw new NotImplementedException();
}
protected override void InternalImport(PXSYTable table)
{
throw new NotImplementedException();
}
}
}
Thnk u :)
where can i find this code to modify it ? thnx
Thanks :)
Have you managed to create the data provider?
It depends on what type of data provider you want to create. Is it a B2B data provider designed specifically for sales?
You will need to understand the main features of B2B data providers and see how other data providers work. Here are some examples of good B2B data providers on the market:
- OneMoreLead
- PureB2
- Globaldatabase
- Salesify
- Leadspace
All of them offer the following services: data accuracy, CRM management, pipeline prediction, and more sales.
In conclusion, you better do some research and choose the best data provider as a prototype.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.