MSSQL
JIWA is an accounting package ([login to view URL]) we are accessing data directly via the database on mssql 2008 r2
We already have a view in the foamexpolydatabase, we need to make this view in the foamexcentral database
We may need to replicate any custom fields that are needed inside the foamexcentral so they are the same
We currently have a c# ( I should be able to get any source or project file for this if needed) import and export process that runs via a schedule. This export/import is done using CSV
I can assist via teamview and skype
1. Create view in foamexcentral from foamexpoly
2. Create any custom fields that the view may require
3. Edit the export process to export from foamexcentral and add to the csv that is created a field called source and label FC for foamexcentral and FP foamexpoly.
4. Edit the Importer to import the data back to the correct database from the source field
5. Edit the importer logging system to log in more detail but only for errors and activity any scheduled task that has no activity are not to be logged.
Hi, If you really need solution for this project, Please contact me as i m c# and sql server developer... I will discuss more about the project and then can be discuss about the budget. Thanks
I have an 1y + experience of working on mysql and C#. Also I used the database inserting, updating etc through c#. also I worked for importing and exporting data from and in Excel file and pdf file.