Comments by gcogco10 (Top 184 by date)

Zurdo what i meant is to how if you have an interface or controller consume 3 endpoints namely Add a coin, Get the total amount of coins, Reset coin. But it must first accept the latest coinage and volume 0f 42 fluids ounces. counter to keep track of total amount of money collected, reset bac to $0.00

No had a work around i was missing this below solution, Datepicker.

datepicker is not working.

Mine should download, this is my front end button in bootstrap.



Download Excel

Thanks Richard, now how will i access this method from my button on View? will i use redirect? the button must be able to download from the method itself excel format.

@F-ES Sitecore i did change it to var SearchValue = $("#SearchLv").val(); but i still get the same issue, the issue each time i insert using int, no search filter is finding the ID from the record, but when i used string value, it throws an exception inside GetSearchData method on the controller. "incorrect string format value".

@F-ES SiteCore i have included full Html for more clarity and understanding, maybe i omitted something along the way.

SearchBy=ID, SearchValue="undefined"

@bbirajdar show me an example so can do it

Ok Richard, what i want is when i click the check-box it must show me datepicker i have created on the second function, when i unchecked then it must clear the datepicker from the modal form, hope make clarity now sorry for not being clear.

Hi Sandeep, yes table grid with multiple rows of data for defined columns.

@Richard thanks mate

Gerry can you give me an example of this as to how to use it in jquery and bootstrap?

What i want, when a user click the checkbox-must bring datepicker in order to select date and time. when its unchecked it must dissapear not seeing.

e.g...? dataType: ModelName...?

Ok thanks.

Sandeep, ok let me be clear. How do this in asp.net mvc 5? Meaning to pull the records to the database both on the controller and ViewSide. That is my issue not on bootstrap only.

Gerry yes thanks for mentioning that to me, had a work around and its working now.

I have tried this logic, ok what i want to achieve when the folder is clicked it routes there hope make sense, please share your thoughts.

F-ES Site i was thinking if i put onclick="Url.Action("Files", "Home")". is this a bad approach? Need some examples at least then can work accordingly.

@Richard the null is thrown cb.eNtsaCourse.Add(eNtsaCourses.Courses);

Derek the issue is it does not hit Httpost to my controller as it goes within jquery side. What i want exactly when a user clicks it must fire and save those details to my table. currently it does not.

Hi All sorry for late, responce. what i want here. is when a user click on the checkbox it must call datepicker that has latest date and time, below the checkbox. hope make sense.

F-ES Site had a work around, as a way to follow the skeleton. Some reason when i debug it only hits the HttpGet not HttPost method. Im still trying to understand the reason behind it. Actually currently the code looks exact the same, but the problem is on Httpost method is not getting in there at all.

Well i have used the example shared, it still does not hit the post on controller, only gets to [HttpGet].

@using(Html.BeginForm("CoursesRegistration", "Home", FormMethod.Post, new { id="saveData", @class="form-horizontal"})) { 
                            
                                
                                    
                                        
                                            <h5 class="modal-title" id="exampleModalLabel">Start New Course</h5>
                                            
                                                <span>×</span>
                                            
                                        
                                        
                                            CourseName
                                            
                                                @Html.EditorFor(model => model.CourseName, new { htmlAttributes = new { @class = "form-control", autofocus = "autofocus", placeholder = "CourseName" } })

                                            
                                        
                                        
                                            Content Licence
                                            
                                            
                                            
                                        
                                       
                                        
                                            Cancel
                                            <a href="@Url.Action(" class="btn btn-large btn-success">Create Courses</a>
                                            
                                                $("#exampleModal.btn-success").click(function () {
                                                    saveData();
                                                });

                                                function saveData() {
                                                    $.ajax({
                                                        url: "/Home/CoursesRegistration",
                                                        data: $('#coursesRegistration').serialize(),
                                                        type: 'post',
                                                        success: function (data) {
                                                            if (data.Success) {
                                                                $("#exampleModal").modal('hide');
                                                            } else {

                                                            }

                                                        },
                                                        error: function (xhr, status) {

                                                        }
                                                       
                                                    });
                                                    return false;
                                                }

F-ES mind sharing that, im keen mate

i have a return false, now the form does not do nothing. not what i want there, help me there a second

I get your point, reason why i am doing click be true, that link opens up popup modal that i need to pass the data back to my database column, I dont know if sounds or make sense.

On the client side if you look at it, i am calling post there. Can you give me an example of this to the ActionResult side. The issue is there way i see it hence its not passing to [HttpPost]

I have them both, when i debug it only stops on [HttpGet] only not pass to [HttpPost]. What could be the reason for this behavior?

[HttGet] ActionResult? [HttpPost] ActionResult also? is it allowed by mvc? to have this in one method or post will be on jquery side?

[HttpPost] does not seem to work, i do need a link for other form to open href="@Url.Action("CoursesRegistration", "Home"). But with [HttpGet] no Server/Error Application. What am i missing that is my question?

@F-ES Site i do, https://www.codeproject.com/Questions/5277146/Asp-net-MVC-bootstrap-modal-is-not-saving-to-the-d

I have tried its work, the issue i get now is not saving to my table from the database

In another words [HttpGet] public ActionResult(....) {}?

@F-ES Sitecore, my application is using AspNetIdentity, so below is my configuration from routing; // Route to CoursesRegistered
routes.MapRoute(
name: "CoursesRegistration",
url: "courses-enrolled-for/",
defaults: new { controller = "Home", action = "CoursesRegistration", url = UrlParameter.Optional }

);

// Route to home-page.
routes.MapRoute(
name: "Default",
url: "{controller}/{action}/{id}",
defaults: new { controller = "Account", action = "Index", id = UrlParameter.Optional }
); // This is used when used are registered/login on the site hope you get an idea

must i create ActionResult Add(eNtsaCourse courses) {.... //logic like var data = db.eNtsaCourses.Add();?}

Yes Mewara

Thanks Richard

Richard, what i am trying to explain. i have a dashboard header but i want my header to have popup menu button at the end of it. Just cant seem to get relevant examples on it that is why need some help around based on my given logic

Hi Garth is the same with this sign # 'shift' '3'?

I have been answered by Garth here below on that, i figure it out before i was not sure how to get pass that.

no but i want to use it inside the file ...@app.route, i can only type app.route. any ideas?

I have tried this and i am still getting that more. It only shows build success, but no folder under that name under project folder. Any ideas?

Thanks so much Richard.

on the sql server itself or console from visual studio?

Sandeep, i accidentically deleted from the database itself. Although the DbContext points to it. On SQLServer, the table is deleted, tried to do "update-database" fails as well. What can i do?

Richard i have defined it under my model as [Key]
public Guid? Id { get; set; }. This Id holds value within a table from the database.

Richard i am not getting Invalid Index, what could i be missing. Yes on the table ID has some values its not empty.

It is working MadMyche, its just the error label

// Route for Dashboard.
routes.MapRoute(
name: "Dashboard",
url: "dashboard/",
defaults: new { controller = "Home", action = "Index", id = UrlParameter.Optional }
); Nothing is as a error on developer tool I have checked

Richard I do have this configured as well, still nothing is working. Im trying to redo it from using one specific texbox to see if this could work.

@OriginalGriff i did and still not winning

Hi Richard, i have made the changes as per this solution and i removed my id, amended as per this logic. Still no validation, anything i could be missing? Please advice

Every time when I try to load the pages. I get thrown

@for(int i = 0; i

Thanks Richard for being kind and care, it does give me space im using  

Zurdo it does not give me coordinates of this location,it only loads the location up until user needs to either choose use map or satelite.

ZurdoDev yes and its fixed. I was missing <appsetting>

You always my hero Richard, saw what was the issue by using that -verbose. I omit this <appsetting>

System.TypeInitializationException: The type initializer for 'System.Data.Entity.Migrations.DbMigrationsConfiguration`1' threw an exception. ---> System.TypeInitializationException: The type initializer for 'System.Data.Entity.Internal.AppConfig' threw an exception. ---> System.Configuration.ConfigurationErrorsException: Configuration system failed to initialize ---> System.Configuration.ConfigurationErrorsException: Unrecognized configuration section add. (C:\Users\gcobanim\source\repos\eNtsaRegistrationTraining\Web.config line 14)
at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)
at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)
at System.Configuration.ClientConfigurationSystem.EnsureInit(String configKey)
--- End of inner exception stack trace ---
at System.Configuration.ClientConfigurationSystem.EnsureInit(String configKey)
at System.Configuration.ClientConfigurationSystem.PrepareClientConfigSystem(String sectionName)
at System.Configuration.ClientConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String sectionName)
at System.Configuration.ConfigurationManager.GetSection(String sectionName)
at System.Configuration.ConfigurationManager.get_ConnectionStrings()
at System.Data.Entity.Internal.AppConfig..ctor()
at System.Data.Entity.Internal.AppConfig..cctor()
--- End of inner exception stack trace ---
at System.Data.Entity.Infrastructure.DependencyResolution.DbConfigurationManager.EnsureLoadedForAssembly(Assembly assemblyHint, Type contextTypeHint)
at System.Data.Entity.Migrations.DbMigrationsConfiguration`1..cctor()
--- End of inner exception stack trace ---
at System.Data.Entity.Migrations.DbMigrationsConfiguration`1..ctor()
at eNtsaRegistrationTraining.Migrations.Configuration..ctor() in C:\Users\gcobanim\source\repos\eNtsaRegistrationTraining\Migrations\Configuration.cs:line 13
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Data.Entity.Migrations.Utilities.MigrationsConfigurationFinder.FindMigrationsConfiguration(Type contextType, String configurationTypeName, Func`2 noType, Func`3 multipleTypes, Func`3 noTypeWithName, Func`3 multipleTypesWithName)
at System.Data.Entity.Infrastructure.Design.Executor.GetMigrationsConfiguration(String migrationsConfigurationName)
at System.Data.Entity.Infrastructure.Design.Executor.ScaffoldInternal(String name, DbConnectionInfo connectionInfo, String migrationsConfigurationName, Boolean ignoreChanges)
at System.Data.Entity.Infrastructure.Design.Executor.Scaffold.<>c__DisplayClass0_0.<.ctor>b__0()
at System.Data.Entity.Infrastructure.Design.Executor.OperationBase.<>c__DisplayClass4_0`1.<execute>b__0()
at System.Data.Entity.Infrastructure.Design.Executor.OperationBase.Execute(Action action)
The type initializer for 'System.Data.Entity.Migrations.DbMigrationsConfiguration`1' threw an exception.

OK noted, but i have amended using this logic above. I am getting this error center: new google.maps.LatLng(markers[0].lat, markers[0].lng),
zoom: 8,Uncaught TypeError: Cannot read property '0' of null

Thanks Richard, the challenge i am getting now. This app is not showing my current location within the map. What could i be missing, the location its pointing outside continent(Africa). It should be point to SA(port elizabeth)

Thanks Jon

Its a single schema database

Thanks mate, i removed the dbo.Locations to be actually Table name 'Locations' only. Now my maps dont load well and dont know why. please assist

Thanks Jon, now i am getting this Uncaught TypeError: Cannot read property 'lat' of undefined
at window.onload (GoogleMaps:19) center: new google.maps.LatLng(markers[0].lat, markers[0].lng), The name i defined there within the controller. Please advice

I omit to put the logic for my Controller, I invoke using Marker from the controller, that variable is accessing those fields as being declared by the controller.

var markers = @Html.Raw(ViewBag.Markers);

Thanks

ApplicationSignInManager its on IdentityConfig.cs, ManagerController and AccountController

userManager is empty

public ApplicationSignInManager SignInManager{... return _signInManager ?? HttpContext.GetOwinContext().Get...}

Mate I end up figure it out as you mentioned, googling it and find the answer and errors are gone. https://stackoverflow.com/questions/60433327/applicationsigninmanager-could-not-be-found/60434510#60434510 Richard you can close this thread mate.

Yes they are, what I did just now, first removed all dll under bin folder, clean and build solution. Still error, its still there so now im stuck. Usually issue its about using incorrect assembly, checked its correct.

I did use that assembly I am still facing the issue even now.

OriginalGriff, the only thing wanted to achieve is to see the table field names. If i install SQL Server Express, can i be able to see the field names from the table?

But phil this got nothing to do with path, im checking other things like my connectionString. Because at first had an issue with attached not being wanted to load. Here is my connectionString. <connectionstrings>
<add name="eNtsaOnlineRegistrationDB" connectionstring="Data Source=GcobaniM-L\SQLEXPRESS; DataBase=eNtsaOnlineRegistrationDB; Integrated Security=True" providername="System.Data.SqlClient">

My keyboard does not use that hyphen i tried using several times, its only - not ~ on VS 2019

Ok i fix that Richard, but i am still stuck not getting this select option to work. My logic is there and even if i troubleshoot no errors at all.

Richard kindly assist, the column to get render you doing this inside the existing column or override new one below? Mine doesnt work well and getting this error. 92 TypeError: n[m] is undefined

XHR request does come with status 200 with data response only data with records not one i just implemented.

downloadable font: OS/2: Bad sTypoLineGap, setting it to 0: -32 (font-family: "Dropdown" style:normal weight:400 stretch:100 src index:0) source: data:application/x-font-ttf;charset=utf-8;base64,AAEAAAALAIAAAwAwT1MvMggjB5AAAAC8AAAAYGNtYXAPfuIIAAABHAAAAExnYXNwAAAAEAAAAWgAAAA … AG0AbwBvAG4ARgBvAG4AdAAgAGcAZQBuAGUAcgBhAHQAZQBkACAAYgB5ACAASQBjAG8ATQBvAG8AbgAuAAAAAAMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=

You see i did put the columns, but they do not show within the DataTable and no error shown when i inspect. Could this perhaps i have few records from the DataTable?

last question Richard, must all columns be before or after ajax call function, mine its after ajax call and yet its not loading, i see some errors when inspect on the browser. please assist here.

shot thanks let me do it.

This can be done on Ajax side on my View mate?

The values do show, its a response back i am getting and data format when i debugg on the client side its not formatted well and its not readable. Any idea?

Richard, what could be the reason if my DataTable does not filter data back on the record list? i am experience this issue now. Thanks for specifying the space in between sortColumnName and sortDirection.

I dont know, i thought by now by mapping this fields from Json format on Ajax should be reference. Now i am getting no field "TrainingTypeasc' not exist. How can i fix this issue? Please help mates

Richard, i am now getting this error 'No property or field 'asc' exists in type 'TblEventsManagements''

Richard McCutchan thanks so much mate, you are star. I had to follow the documentation step by step. Now can able to see my all my DbContext under the Model Folder. Thanks mate dammm what an excercise.

Here is my connectionString and yet i am using Initial Catalog correctly, <connectionstrings>
<add name="eNtsaOnlineRegistrationDB" connectionstring="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\eNtsaOnlineRegistrationDB.mdf;Initial Catalog=master; Integrated Security=True" providername="System.Data.SqlClient">

How do i modified my connectionString mate? an example will be enough for me to try and test this now.

I ran it and now iam getting Keyword not supported 'catalog'

Ok i did that mate, and had missing package called Microsoft.EntityFramework.Tools v 3.1.1. The error was gone, but now i cant seem to find new DbContext class under Model folder. that was initial goal to get access to my DBContext. Help me to this issue.

Ok so now must i put the directory of the project where mdf file is located, right after -OutputDir?

Ok mate i re ran the command and getting new error. Its this one scaffold-DBContext : Exception calling "Start" with "1" argument(s): "The system cannot find the file specified" yes i put space after sqlServer -Verbose and got the above error.

@Liktor, i would say each time im trying to run the command its not added to the solution. Here is my connectionString below, <connectionstrings>
<add name="eNtsaOnlineRegistrationDB" connectionstring="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\eNtsaOnlineRegistrationDB.mdf;Initial Catalog=eNtsaOnlineRegistration; Integrated Security=True" providername="System.Data.SqlClient">

Unable to find provider assembly with name Microsoft.EntityFrameworkCore.SqlServer-Verbose. Ensure the specified name is correct and is referenced by the project.

I am trying to amend the command to scaffold-DBContext "Data Source=(LocalDb)\MSSQLLocalDB; Catalog=eNtsaOnlineRegistrationDB;Integrated Security=True" Microsoft.EntityFrameworkCore.SqlServer-Verbose, still no luck as to what could be an issue.

https://serversmtp.com/pop-and-smtp/

SO far i am trying to use this provider Outlook. I am getting Microsoft error;
Client was not authenticated to send anonymous mail during MAIL FROM [CT2P275CA0035.ZAFP275.PROD.OUTLOOK.COM]

Richard MacCuthan, please give me default example surely can work around.

Hi F-ES Site, you raising something new now. What i have experience and tested based on this blog you sent me. If i am using outlook, i am still getting similar but error now is "Client was not authenticated to send anonymous mail during MAIL FROM [CT2P275CA0042.ZAFP275.PROD.OUTLOOK.COM]

@Richard, i have just recheck under Google Account Setting, its has been set for securelessapp including password. My Question is must i used same credentials when registering for new users on my web app?

@F-ES Site i would have gone this forum if wasnt google this issue and yet i raised this as well to stackoverflow. I have tried the steps, still even set up my gmail security to allow apps to secure be on. What could be other issue?

All my settings are correct, just checked.

System.Net.Mail.SmtpClient("smtp.gmail.com"); Now that this is changed, i cant get a confirmation to this domain, its failing due to connected third party. What could be an issue?

@F-ES Sitecore i hear you mate, let me double check the settings.

Im connected to the University network, could this be the reason why fire wall blocks the request?

Its handled by the framework and now i am getting an error.

Is there any default example, i do have an idea but just need to be sure.

@jimmson I ended up fixing the issue, I was not installing the correct assembly to my project. Therefore I have ran this Package manager console Install-Package Microsoft.AspNet.Identity.Owin. It was gone the error.

On My web.config i have this version, <assemblyidentity name="Microsoft.Extensions.Configuration.Abstractions" publickeytoken="adb9793829ddae60" culture="neutral">
<bindingredirect oldversion="0.0.0.0-3.1.1.0" newversion="3.1.1.0">

IAuthentication Manager does not contain this method, no accessible method for it. the on my nuget ran this command Install-Package Microsoft.AspNet.Identity.Owin -Version 2.2.3. But i dont think it fixed it. Now im running some load exception assembly.

UserID is empty, i have an insert statement on that table with data. Still i am unable to get value only null as a string on my stacktrace.

<






@using (Html.BeginForm())
{
@Html.AntiForgeryToken()


@Html.ValidationSummary()




Username:
@Html.TextBoxFor(model=>model.username, new {@class ="form-control text-center", automplete="off" })
@Html.ValidationMessageFor(model=>model.username)




Password:
@Html.PasswordFor(model=>model.password, new {@class = "form-control text-center", autocomplete="off" })
@Html.ValidationMessageFor(model=>model.password)











}

@jimmson, i did call it on my controller=>model=>view [HttpPost]
[AllowAnonymous]
public ActionResult Create(CreateModel submit)
{
ViewBag.Msg = "Details submitted successfully";

return View(submit);
}

I have created a unique name and value for that handler, still not getting it right. What could be an issue? I think my controller does not work well. Each time click create, the validation it gets are from login actionResult method.

No Mate there is, i checked both createUser.cshtml and login.cshtml.

Ok now i getting this error, Cannot find the object 'UserReg', because it does not exist or you do not have permission. I created new login it and mapped it with my Domain(window authentication mode). What could i be missing?

I followed this and i am getting this weird error on my sql editor. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. Even if i try revoke all on object::dbo.Users to public

GRANT SELECT ON OBJECT::TestUser.UserName TO Users;
GO

@phil.o this is strange, i follow this through and grant permission and even restart the sql server. I still facing the same error and still persist.

I have grant permission by following the link and youtube. Now will check if still getting the same issue.

I want my username and password text field be center and button, they are scewed left

sql server management studio

Hi @philo.o i created a user table on my DB, My mapping is Web(Security.InitializedDatabaseConnection("MyString", "Users", "UserId", "UserName", autoCreateTables:true) my Users has this field ID(primary key), EmailID, UserName and FullName. But i am still getting same issue. Please assist

@philo.o the user that was created is not yet on the DB, now how do then fix that if the user is not yet created as an existing?

@phil.o before this error, i was first getting system exception on " You must call the WebSecurity.InitializeDatabaseConnection". The i modified my file AuthoConfig.cs under my AppStart folder. So what i have missed before this?

I have change the Default to be "Mystring, now i am getting Database.Sql.ClientException login failed for user

@ZurdoDev, I did made it public and I am no longer getting that error.

Hi mate, i changed the channel to public and was not getting that error anymore.

Yes that is my solution, basically I wanted to find a way around putting my iframe(last one) below first two.

Ok what i want to achieve, is i want my last iframe to below than those two. inside that iframe my switch button should be within that iframe. I hope i am clear.

Well this is not what i am looking for, all i want is my last iframe to be on its own position(below) having the switch button to be clicked only.

I have made the attempt but i could not successed well. Here is my logic, im using last iframe(keen to achieve this one) as i want my button to be below it or within the iframe













OFF
ON

Switched off.

@ZurdoDev, i want to create two iframe within or side by side(left and right). Any idea how to achieve this?

Thanks mate, i made those ID unique to each. now i can be able to download from last year to today date. I wanted to avoid manually put static value on window.open(end=2020-01-10T23:59:02:00&timezone...); not good practise.

thanks mate, the format did work. it now reads as 15-01-2020 which is readable. I did know there is an option. Also when using the format:dd-mm-yyyy works to this approach unlike if using this format:mm/dd/yyyy

On the form to me it reads as 01/07/2020. Instead it should be on a normal form when using datepicker 07/01/2020. Question is does bootstrap support this logic, the problem its not on datepicker on Jquery but on the form itself.

My logic is as below var selectedDate = $('.input-daterange').val(), var selectedEndDate = $('input-daterange').val(); window.open(https://api.thingspeak.com/channel/..../api_key....&start='+selectedDate+'&end='+selectedEndDate+'&timezone=Africa/Johannesburg); My endDate does not work well, i have used same input-daterange from my form on date-picker its downloading same year. What am i missing? Should my value be unique or not same('input-daterange').val(); please advice thanks.

window.open(......api_key=FDJCD...&start='+selectedDate+'&end=2020-01-10T23:59+02:00&timezone=Africa/Johannesburg);

Last question is end date on my API URL, which means i have to manually change its time. Is there way around this? Please advice, thanks.

Thanks mates, i took the last responce and its working well as i have tested.

Ok how do I then, reference my jquery request for passing data using JqueryUI date-picker?

Hi Mate, unfortunate part im using thingspeak and its uses Rest API, but to this issue i am restricted to communicate to my things network gateway as a result of the CORS security authentication. I am trying to follow currently this link, https://putsreq.com/agT2991XWmifYEvy20Uy/inspect

Mate can you give me at least an example to have an idea. access policy?

Does any mate experience same response when using this code i provided?

There are no errors apparently, so i dont follow and did use inspect element.

It appeared that i was not calling my Model object well, that is why it could not able to access them directly from table within the database itself. I end up restart it and was able to get it write, i am not well experience fully in MVC when using asp.net web application. But i will continue learn and understand it more.

Yes something like that

How do you check if there is a combination of either being selected? e.g if one is selected and other one is not and vice versa.

Thanks mate, its working as per what i wanted to achieve

Im still not getting it right, but if i am using that operator. which means i a pointing to all ID element throughout my document?

Temperature

I am struggling to get correct fields on my CSV file, when the download button is clicked, if the checkbox is either illuminance nor temperature it must be able to give me those fields on my CVS file when its being downloaded.

@ZurdoDev, sorry for the late response I have already been answered for this question. My aim I wanted my button to work like light bulb, if the button is on must trigger a function call on my ajax call request. If the button is off must do some functionality.

Thanks Richard Deeming, i have tested second logic you gave, the logic seem to work fine and sending the correct date format as per requested from ajax call.

any pseudo code examples to this will be appreciated.

From this link, there are not much examples https://community.thingspeak.com/tutorials/javascript/parse-thingspeak-last-entry-feed-with-jquery/

Hi All i am working something along this line, but my URL on Ajax is not working, but my button should be able to download those record set on date range. Here is my code on Jquery i just implemented;

$(document).ready(function() {
$("#download").click(function() {
$.ajax({
url:'https://api.thingspeak.com/update?api_key=D****&field8=1',
type:'POST',
success:function(response){
window.location = response;
}
});

});

});

Hi Harsh.Shah.ifour, thanks i came right there with datepicker. The output looks the same as mine. Now i want to find a way, if there is a control to be able to download that start date and end date in jquery or javascript.

@Dave Kreskowiah yes and be able to have a download-option from those records as cvs file or pdf.

The data should be to download the date itself from a specific day e.g 07-11-2019 to 09-11-2019 on datepicker its. I am using Jquery to interface with my browser.

F-ES Sitecore, what i am trying to do simple. I want my value on URL from ajax call field8=1 not to update twice must update once. While field8=0 must remain its original value not to update that from field8=1, thats is what is happening currently if the button is clicked from the browser. In another words there is mismatched of value between the buttons, if the one clicked first and vice versa.

This seem to work especially clearTimeout, now problem i am getting now. Each time button is clicked more than 3 times, it does not keep previous value. Like an instance of Unsubscribe function() field value is set on url as field8=1. it default to 0 on the browser. Is there a better way to improve from this logic as i am trying to work on that as we speak?. What i want exactly is, if the Suscribe function() keep value as 0, then value must be kept to that original value, not to change whether the browser was refreshed or clicked 3 times. Same applies to Subscribe function(). Please i am battling to get this logic right.

What i mean here is, if my button is on when click, the status message should change to true. If my button is off when clicked, the status message should change to false and must inform the user for both status message. Why i need some logic there, based on what i have tried. Hope this is clear to all. thanks.

Hi Team, the challenge now i am facing is the iteration as it does not stop. Here is adjustment of the code.




function Subscribe() {
$.ajax({
url:'https://api.thingspeak.com/update?api_key=D**&field8=0',
type:'GET',
data:{
type:'text'
},
success:function(response){
alert(response);
$('#singlebutton').append(data);
}

});
setTimeout("Subscribe()", 100);

}
// second button to unsubscribe.
function UnSubscribe() {
$.ajax({
url:'https://api.thingspeak.com/update?api_key=D***&field8=1',
type:'GET',
data:{
type:'text'
},
success:function(response){
alert(response);
$('#singlebtn').append(data);
}

});
//setTimeout("UnSubscribe()", 100);
}

I have fixed it, it can communicate back to my channel. the issue i was not getting it right. was ajax call function for parsing my channels. eg. https://api.thingspeak.com/update?api_key=D****&field8=0

POST method does not allow me, as it show status message on POSTMAN "page you looking for does not exist". the documentation from thingspeak uses GET to access the channel either for reading, https://www.mathworks.com/help/thingspeak/readlastfieldentryage.html. I want to read the last field name i created on my channel. On my channel dashboard no update to see the data.

Json.Document(File.Contents("C:\Users\Gcobanim\Documents\TestJson\Azure JSON files\TestJ\MKR1010-PowerBIVisualizationInput (1).json"))
# "Converted Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"temperature", "illuminance", "EventEnqueuedUtcTime"}, {"Column1.temperature", "Column1.illuminance", "Column1.EventEnqueuedUtcTime"}),
#"Change Type"= Table.TransformColumnTypes(#"Expanded Column1",{{"Column1.EventEnqueuedUtcTime", type time}}),
#"Change Type" = #"Changed Type"{1}[Column1.DateTime]..?

I was looking something along this line#RealJSOP

https://www.yash.com/blog/migrate-sql-data-to-azure-cosmos-db/

But Migration Tool on my side does not seem to convert my JSON format to CSV file as expected. Any reason for this behavior? What is the difference between Azure storage explorer and Migration Tool?

Am i doing this on azure query separately or...? i meant to say i dont want to use any code on Visual Studio, just some implementation on azure itself like a service that can do this work. Hope im clear

JSON format on my activity log it state that message is not defined.

I only created sql statement to do this, did i answered your question?

SELECT PowerBIVisualizationInput.temperature, PowerBIVisualizationInput.EventProcessedUctTime,PowerBIVisualizationOutput.EventEnqueuedUctTime,PowerBIVisualizationInput.humidity,DATEDIFF (minute, PowerBIVisualizationInput.EventProcessedUctTime, PowerBIVisualizationOutput.EventEnqueuedUctTime) AS DurationInMinutes
INTO PowerBITable
FROM PowerBIVisualizationInput TIMESTAMP BY EventProcessedUctTime
JOIN PowerBIVisualizationOutput TIMESTAMP BY EventEnqueuedUctTime
ON (PowerBIVisualizationInput.TollId= PowerBIVisualizationOutput.TollId AND PowerBIVisualizationInput.humidity = PowerBIVisualizationOutput.humidity)
AND DATEDIFF (minute, PowerBIVisualizationInput, PowerBIVisualizationOutput ) BETWEEN 0 AND 15