Never done this, anyone got an idea how this works?

Not absolutely necessary, but looks nicer

We have some basic logo and identity in place right now. But it could be better. New kind of logo or something identifiable would be nice.

Also, at least we need some images for the meta tags in #24.

Especially retrieving an image. Maybe do it like Facebook and propose a few options to the user, let them choose the best option. Now it comes up empty a lot of times.

It appears the route cfp/getMetadata returns a 404. Probably has something to do with the Route attributes I added earlier.

This is probably the reason one can't submit a new CFP (which returns a 400) due to some missing fields.

Since the Twitter account is now in place, it might be nice to have it broadcast more than just "a new CFP was added". For instance, have it tweet each week what CFPs are about to expire or something. Or just random sometimes to advertise itself.

Maybe through an Azure Function?

There is some very small validation in place which basically stops the form from posting. There is not always feedback to the user, also it isn't really unified.

When the event date is known on cfp.exchange it would be nice to be able to add it to your calendar.

I don't have any hands-on experience with building something like this, is there a universal format which works for most calendars? I think most systems that do this provide multiple formats?

The process of error handling could be better.

Right now, a JS popup is shown which doesn't even give any relevant information. Would be even better if there would be a difference between actually saving the CFP and all other stuff (downloading the image, sending the tweet). Now the process just halts regardless of what went wrong.

I feel design can be better. It feels a bit cluttered here and there.
Things I'm not happy about atm:

• Font in the date picker
• Date picker opening on tab out of event URL
• Showing the event date info in CFPs red header
• Details page with all the things that are being added
• Input for tags on submit form

There is a big CFP of the day on the homepage. This is however not really a CFP of the day. Come up with a way to select a CFP each day.

Or, if we can't easily do this, just skip it (for now).

Come up with a smart way to be able to detect (possible) duplicates

Something seems to go wrong in the Azure Function downloading the image.
It downloads correctly but updates the CFP record with the static text @EventImage instead of the actual image URL from the blog storage.

Seem to go wrong here: https://github.com/jfversluis/CfpExchange/blob/master/CfpExchange.Functions/DownloadEventImage.cs#L78

Probably the SQL parameter isn't replaced for some reason.

I would love to have the ability to log in via some of the social providers.

No need to have local accounts (accounts not created via a social provider) in my opinion, because that's just a lot of hassle. Only thing which needs to be stored in the CFP Exchange repository is the Name an identifier and maybe the E-mail address if you want to send out mailings later on (take into consideration the GDPR before sending out those mails).

The userbase (at the moment) are all developers/IT-pro's, so the GitHub & Twitter social providers should suffice.
Of course adding Google & Microsoft accounts is doable also.

Some documentation or .NET Core 2.1 integration:
https://docs.microsoft.com/en-us/aspnet/core/security/authentication/social/?view=aspnetcore-2.1
Covers all major providers

For the love of.. I always run into trouble with EF migrations.
I somehow managed to create a migration without the Cfp.ProvidedExpenses property. Fixed it manually now, but I guess whenever a new migration is generated the property will be dropped, or when installed clean, this will cause trouble.

Need to figure out how to fix this, if fixing is needed at all.

Has probably something to do with #75.

I did add the settings back manually right now, but still, the tweet doesn't go out. Don't have a proper error message yet.

It would be beneficial to spec a standard for data interchange between (external) sources of CFP papers in order to seamlessly integrate or import sessions.

This can be as simple as a JSON spec hosted on http://schemastore.org/json/

I have access to the public projects preview on VSTS. With moving to ARM templates etc. it would be great to host and build everything there.

All PRs need to be merged etc. first then. Maybe I will just move the building process there, have to look into what is possible.

I just deleted my database and created a new one. Afterward, I did an Update-Database and saw a lot of errors occurring. Because of this, the site isn't able to load anymore.

It's a bit much to copy the complete error over here, but this is an excerpt of the first part.

Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (31ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
      VALUES (N'20180609180239_AddedExpensesToCfpAndUserStuff', N'2.0.2-rtm-10011');
failApplication startup exception: Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Invalid column name 'CfpDecisionDate'.
Invalid column name 'DuplicateOfId'.
Invalid column name 'EventTags'.
Invalid column name 'EventTimezone'.
Invalid column name 'EventTwitterHandle'.
Invalid column name 'ProvidesAccommodation'.
Invalid column name 'ProvidesTravelAssistance'.
Invalid column name 'Remarks'.
Invalid column name 'Slug'.
Invalid column name 'CfpDecisionDate'.
Invalid column name 'DuplicateOfId'.
Invalid column name 'EventTags'.
Invalid column name 'EventTimezone'.
Invalid column name 'EventTwitterHandle'.
Invalid column name 'ProvidesAccommodation'.
Invalid column name 'ProvidesTravelAssistance'.
Invalid column name 'Remarks'.
Invalid column name 'Slug'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues)
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(Tuple`2 parameters)
   at Microsoft.EntityFrameworkCore.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState,TResult](IExecutionStrategy strategy, TState state, Func`2 operation)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IReadOnlyList`1 entries)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges()
   at CfpExchange.Data.CfpContextExtensions.EnsureSeeded(CfpContext context) in D:\Projecten\CfpExchange\CfpExchange\Data\CfpContext.cs:line 149
   at CfpExchange.Startup.Configure(IApplicationBuilder app, IHostingEnvironment env) in D:\Projecten\CfpExchange\CfpExchange\Startup.cs:line 117
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.AspNetCore.Hosting.ConventionBasedStartup.Configure(IApplicationBuilder app)
   at Microsoft.AspNetCore.Hosting.Internal.AutoRequestServicesStartupFilter.<>c__DisplayClass0_0.<Configure>b__0(IApplicationBuilder builder)
   at Microsoft.AspNetCore.Hosting.Internal.WebHost.BuildApplication()
: CfpExchange.Startup[0]
      Failed to migrate or seed database
System.Data.SqlClient.SqlException (0x80131904): ALTER TABLE DROP COLUMN failed because column 'ProvidedExpenses' does not exist in table 'Cfps'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite, String methodName)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues)
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
   at Microsoft.EntityFrameworkCore.Migrations.MigrationCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable`1 migrationCommands, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
   at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.Migrate(DatabaseFacade databaseFacade)
   at CfpExchange.Startup.Configure(IApplicationBuilder app, IHostingEnvironment env) in D:\Projecten\CfpExchange\CfpExchange\Startup.cs:line 88
ClientConnectionId:3f7aba2d-dfb7-423f-ad89-795b800cdad7
Error Number:4924,State:1,Class:16
Microsoft.EntityFrameworkCore.Migrations[20402]
      Applying migration '20180612071509_TravelAndAccommodation'.
fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
      Failed executing DbCommand (707ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      DECLARE @var0 sysname;
      SELECT @var0 = [d].[name]
      FROM [sys].[default_constraints] [d]
      INNER JOIN [sys].[columns] [c] ON [d].[parent_column_id] = [c].[column_id] AND [d].[parent_object_id] = [c].[object_id]
      WHERE ([d].[parent_object_id] = OBJECT_ID(N'Cfps') AND [c].[name] = N'ProvidedExpenses');
      IF @var0 IS NOT NULL EXEC(N'ALTER TABLE [Cfps] DROP CONSTRAINT [' + @var0 + '];');
      ALTER TABLE [Cfps] DROP COLUMN [ProvidedExpenses];
System.Data.SqlClient.SqlException (0x80131904): ALTER TABLE DROP COLUMN failed because column 'ProvidedExpenses' does not exist in table 'Cfps'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite, String methodName)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues)
ClientConnectionId:3f7aba2d-dfb7-423f-ad89-795b800cdad7
Error Number:4924,State:1,Class:16

I'm not sure why this occurs as I haven't seen this before in this project.

By the way, this also happens when doing the auto-migrations whenever the site hits the database. Can only reproduce this on an actual SQL Server. When using the services.AddDbContext<CfpContext>(opt => opt.UseInMemoryDatabase("Cfps")); I don't see this error occurring.

Right now the event website is scraped for details.
If this fails or is not sufficient, there is no way to supply the details yourself now. There is a button in place, but it's not working yet.

As the list of CFPs grows, it might be useful to have some kind of basic search functionality in place

Because images of CFP's are loaded on this site, it's possible to have mixed content on the page.

Browsers will notify the user the site isn't safe (see image below of my Firefox).

Only thing I can come up with is to download the images/external content and host it ourselves. Of course, this will cost a bit more bandwidth and storage.

I don't think "expenses" are a good term to put here. It might stand for reimbursing train tickets, taxi rides etc, but the whole box is missing "accommodation only" option which is more common than covering expenses IMO.

The manually added application settings are erased right now when a deploy happens.

This causes the Twitter connection and e-mail functionality to get interrupted. We need to add the settings from the secrets.json into the ARM template.

Just tried to add a new CFP, but it appears the binding of dates is broken.

The JSON which is being sent to the Submit looks like this.

{"eventUrl":"https://www.dddeastanglia.com/","eventImageUrl":"/images/noimage.svg","eventTitle":"DDD East Anglia Home Page","eventDescription":"DDD East Anglia developer conference website","locationName":"Cambridge, UK","locationLat":52.205337,"locationLng":0.12181699999996454,"cfpEndDate":"0001-01-01T00:00:00","eventStartDate":"0001-01-01T00:00:00","eventEndDate":"0001-01-01T00:00:00","cfpUrl":null,"providesAccommodation":0,"providesTravelAssistance":0,"submittedByName":"Jan"}

Of course, I've used the datepickers to add the correct dates to the appropriate fields.

Error in the browser (Edge) shows: [object Object] in an alert.

As supplying Tags is mandatory now and there isn't suggestion/autocomplete functionality yet, it might be cool to have the tags being prefilled when scraping the site for the event details.

Of course, this is quite hard to do by yourself.

It sounds like a great opportunity to do a deep-dive into AI, ML, etc.
Maybe use the tags of Stack Overflow as a baseline and see if any of those tags are mentioned somewhere on the homepage. If so, suggest them in the Tags box.

Right now when a duplicate event is detected I simply delete it. If a user has linked to it somewhere, the link will be broken. It would be better to mark the event as a duplicate so we can inform the user or simply link them through to the other one.

As suggested by Jim Bennett (https://twitter.com/jimbobbennett/status/1009369974316654592) it would be nice to have a calendar view of when events happen/when CFPs close and/or at least have the possibility to filter on certain dates/months/etc.

Somehow a CFP snuck by without a description, causing an HTTP 500 when trying to view it.

Multiple problems in here:

• the description should be mandatory, so we need to check that
• viewing the CFP shouldn't crash when there is no description. I notice a replacment of \n to
  going on that was the culprit

Loosely coupled to #33, when a user is entering an event manually, you can only do the title and description now. The image should be in there as well. Whenever #10 happens to get implemented we can upload it to our own storage. For now maybe just let them enter a URL?

The Cfp object now has a property to track the clicks on a CFP URL. It would make for some nice statistics to keep track of that. For this we would need an endpoint that first increments the out count and then redirects the user.

The box in the footer. Together with this, find out if Mailgun has a way of sending newsletters.

I've noticed that some dates associated with the event are -1 day after I submit it (event date and cfp closing date).

There is a random CFP shown at the top bar of the homepage. However, this is not random at this time. Implement some kind of randomizer.

I see more and more events that state when they will inform their speakers about their attendance. It might be nice to have a field for this when submitting a CFP and showing it in the details whenever this data is available.

Any people seeing this? Or isn't it that common (yet) to bother right now.

Now, when the direct CFP link is added, you can navigate there by a button directly.
However, there is no link whatsoever to the event's website.

Just found this awesome cognitive services preview for URL previews, much better than my own parsings... https://labs.cognitive.microsoft.com/en-us/project-url-preview

Integrate this future-me!

With the downloading of the own images in place, it tries to download the noimage.svg file but fails. In this case no action should be taken to download the image and just refer to the static hosted one.

A map always looks cool. Might be nice to show all the current open CFPs on a map around the world.

To make the CFPs and links etc more sexy on social media, it would be great to add the right meta tags on the relevant pages.

• When it's a general page, have some general image, title, description for cfp.exchange
• When a CFP page is shared, have the image, title, etc. associated to the event

There is now the possibility to collect the event's Twitter link.
This is used in the tweet that goes out when the CFP is added, but it would be great to have it in the CFP details as well.

At the moment a tweet is sent out when someone has created a new CFP.
While this works, it might make the submission slower as necessary.

Because there's a nice servicebus added for #59 , we can just add a new Queue to it for this process.

That way we can send a message to the queue, which should be vast.
An Azure Function will be triggered and send out the tweet. Implementation will be the same as now, just more awesome 😉

Nice starter issue if you want to get started with ARM templates and Azure Functions.

Not all details that can be entered on the CFP submission form are shown in the details of a CFP. Some of them may even be useful in the overviews/lists

• Add #cfp tag to tweet on new CFP. This tag seems to be used for cfps at this time advertised on Twitter.
• Add location data on tweet, this will (probably?) help people nearby discover the tweet better.
• Add Twitter handle as optional to a CFP to mention the event when the tweet gets posted to make event organizers more aware of CFP Exchange

Adding the Twitter handle to the submission form causes some confusion. Users think that it is their own Twitter handle, while it is actually the event's one.

Could solve this by moving the 'Your name' field to the bottom, or some other solution.

Report simple "report issue" functionality for a CFP.
Whenever someone finds the info for a CFP is wrong or is a duplicate they can report this and the administrator can look into it

Entering a URL that is already in the system triggered a warning, prompting the user to double-check. For some reason that is not working anymore.

Right now in the ARM template, the Function App is specified as Always On. To accommodate this, we need a scaled up hosting plan which impacts costs. We need to examine if we can do without the AlwaysOn option and just pay per invocation of the function. This brings down costs which is always good 🤑

The bug from #28 is back again.

Has to do something with the conversion from the JavaScript ISODate back to the .NET date. Not sure what would be the least dirty solution here.

When submitting a CFP, let the user supply tags to allow other users to filter out certain CFPs suited for them