Need a program written in C# that will automatically download the suppression list files from Optizmo. Here is an example Optizmo link:
[login to view URL]
The program will need to connect to a SQL Server database and query a table called SuppressionConfig (see table definition below) for records where logintype='optizmo' where lastlogin is null or not within the past 24 hours. It should get the exact Optizmo URL from the csvurl field. Upon successful download, update the lastlogin field in the table for the particular SCID record.
A config file should specify the path/folder location to save the downloaded file to. The program should use the value in the downloadurl field in the table for the filename to save within that folder.
Should be able to connect to multiple databases to process records in suppressionconfig. The config file should allow us to specify 1..N SQL Server connection strings for the various databases.
The program could either use Optizmo's REST API (see documentation on that page) or automate the web interface. It would probably be more reliable to use the REST API.
CREATE TABLE [dbo].[suppressionconfig](
[scid] [int] IDENTITY(1,1) NOT NULL,
[csvname] [nvarchar](255) NULL,
[downloadurl] [nvarchar](255) NULL,
[csvseparator] [nvarchar](255) NULL,
[emailfieldname] [nvarchar](255) NULL,
[md5hashed] [bit] NOT NULL,
[retrieved_automatically] [bit] NOT NULL,
[whenadded] [datetime] NOT NULL,
[processstatus] [varchar](4) NOT NULL,
[whenupdated] [datetime] NULL,
[whenlastprocessed] [datetime] NULL,
[logintype] [nvarchar](25) NULL,
[csvurl] [nvarchar](255) NULL,
[username] [nvarchar](128) NULL,
[password] [nvarchar](128) NULL,
[lastlogin] [datetime] NULL,
[loginsuccess] [nvarchar](255) NULL,
CONSTRAINT [PK_suppressionconfig] PRIMARY KEY CLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[suppressionconfig] ADD DEFAULT ((0)) FOR [md5hashed]
ALTER TABLE [dbo].[suppressionconfig] ADD DEFAULT ((1)) FOR [retrieved_automatically]
ALTER TABLE [dbo].[suppressionconfig] ADD DEFAULT (getdate()) FOR [whenadded]
ALTER TABLE [dbo].[suppressionconfig] ADD DEFAULT ('N/A') FOR [processstatus]
Dear Hiring Manager, I am an expert of Web Development. I would love to have the opportunity to discuss with you about your project. I have 12+ years experience as a developer. After a full understanding of your pro Plus
42 freelance font une offre moyenne de $187 pour ce travail
Hi This is Cui D from China. I read your description carefully and I'm sure I can build the good work for you. There are many projects I have done before like this project. You can see my profile and check it. I'm a Fu Plus
Hello, I am software developer with enough experiences on C# for 13 years. I can work by full time for your project and trying to satisfy the requirements. I am designing the project from scratch and structure it well. Plus
Greetings sir, I have read your project details and i will develop the software that will connect with Optizmo via api and download the file based on config on sql server. Sir, i can deliver this project sooner t Plus
Hello Sir, I am an expert in C# and API development and did several projects using the same. I am very positive that I can do this project. Thanks Aanvik
Hello, I'm Abu Gosia. I'm interesting in your project very well. I m quite well experienced in these jobs. Let's go ahead with me. Thanks
Hi, Allow Me to Introduce Myself I am a Full Stack Lead Developer with a Decade of Experience with strong Expertise in Nodejs , ReactJs and Angular using Mysql or MongoDB. I have comprehensively developed soci Plus
hi, I have good experience with automating this kind of applications . I am interested in this project , please share more details .
Hi.there. I have fully checked your project ''. I am sure that I can do your project perfectly. I am a Lead/Web/Mobile developer with 11 years of experience. I read fully your requirement and I am sure I can finish yo Plus
I have done many projects like this earlier, if awarded I can deliver it on time with all requirements implemented
Hi there, We've reviewed the details of your project and we can create the app you described in project requirements. We would like to discuss further about it when you're online. Thank you!
Hi, I have gone through your project description and I'm interested to work with you. I'm very passionate about my work and give good quality of work to client. I have more than 5+ years of experience in web developm Plus
Hi, I'm an experienced developer. I'm interested in your task and would like to do it. Contact me anytime to get started............. Thanks.
Hi! Nice to meet you. My name is kuanhui, .Net expert from China. I have read your project detail carefully. I have about 10 years of experience. I can complete your job within a few days. please contact me so that we Plus
Hi, I have good experience in c# language, database integration. please contact me so that we can have a discussion in detail. Regards, Vu
Dear Sir, I am Ali having 5+ years of experience in software development. My developed apps are fast, secure, easy to use and install. I am dedicated freelancer and can be available any time and can deliver your projec Plus
Hello. I'm a C#, .NET expert and have many experiences in MS SQL and several types of APIs. I'm absolutely sure I can do this work perfectly. Please feel free to contact me. Thank you.!
Hi, I have done such types of projects earlier too. Please provide me a chance to do this for you. I have more than 9 years of development experience. You can check my reviews for more details. Thanks & Regards, Vish Plus
Hi, I am an experienced .NET developer with great skills you mentioned in your description. As MCP and MCTS, I know all the area of .NET technology. Thanks.
Unity Game/ VR & AR development Expert here I have 7 years of Unity game development experience and i have deep knowledge about Unity development. Probuild, 3d max, C#, animation, photoshop are all familiar for me and Plus