CODEWITHSUNDEEP
c#
The real napster
The real napster

Reputation: 2324

Inserting data in Microsoft Dynamics C5 from C#

I need to transfer some data from our CRM system into the Microsoft Dynamics C5 accountance system.

Is this possible? Writing directly in a SQL database and such hacks will be fine for me as well.

Upvotes: 2

Views: 1405

Answers (4)

Erling Damsgaard
Erling Damsgaard

Reputation: 31

Inserting data directly to a Dynamics C5 SQL database - will give you problems if you don't remember to use a correct LXBENUMMER/ROWNUMBER. You have to use a unique number for each row. Rownumbers are managed by the table XALSEQ. Remember that empty strings must contain a CHAR(2).

Otherwise you could look at XU4N - that will give you a .NET entry to the Dynamics C5 application (not the data-layer). www.dns-it.dk/xu4n

Regards Erling Damsgaard

Upvotes: 2

cyberzed
cyberzed

Reputation: 2076

There is the option of buying solutions from vendors as well (yes I'm working for one, just for the record...so I might fanzy our product over others).

The concept we have is a "designer" where you create a mapping from c5 to "whatever", at the moment we have a mapping towards C# and other C5 versions, the concept will probably be expanded to Ax and interfacing to other programming languages.

We run a C5 that responds to our "mappings", with a pinch of magic ;) and yes ofcourse there is a cost at doing this but as we tell all our customers...why replicate business logic.

So in the end...you can insert data into C5 without running straight to the database...which can be very bad if people have triggers or other stuff happening when they insert data into C5.

Upvotes: 0

The real napster
The real napster

Reputation: 2324

I am surprised no one had this need.

Anyway after talking to a consultant I found out that there are two ways to solve it.

  1. Install C5 on a SQL server you manage and manipulate the data directly.
  2. Default C5 install with a Native DB and buy the C5 ODBC module that makes it possible to manipulate the data through ODBC.

Upvotes: 1

Kirtan
Kirtan

Reputation: 21685

You can export data from CRM system in an excel file. Then import the same Excel file into your C5 system.

Upvotes: 0

Related Questions