Activities of "daws"

I'm in the same case.

When a new release is out (for nuget + aspnetzero Template) :

1. update of ABP nugets (and dependencies)
2. fix breaking change (see the github release to see if there is any breaking change)
3. if it run, ... it run :D
4. download the latest template
5. update current project with the template (I set the same name and structure for my project than the Template) with a copy/paste in my solution.
6. resolve naming dependencies if there is some wrong copy/paste.

and voila ... in conclusion, there is no magic solution.

1. update your nuget
2. fix breaking change
3. check the github for changes (or copy/paste all files that are the same as the Template without modification from your side; if it's the same naming)

note : wait for the 0.9.2 version, there is some bug on 0.9.1.1 :)

making a new branch for every new version will be a nightmare in TFS, but it's up to you :) Good branch : (following the correct order of publishing dev->test->acc->prod)

• DEV (for all your tests, nuget update, dev)
• TEST (testing, if your dev seems ok)
• ACC (acceptance, validation by client)
• PROD (production, release in prod)

Download hangfire project example from official hangfire website.

It has multiple example : console, Windows service, ...

for example, abp implementation in hangfire console :

(which is just hangfire official example encapsulated in abpboostrapper :) ) (nb I use nlog, change it to your log provider)

class Program
    {
        static void Main()
        {
            //Bootstrapping ABP system
            using (var bootstrapper = new AbpBootstrapper())
            {
                IocManager.Instance.IocContainer.AddFacility<LoggingFacility>(f => f.UseNLog().WithConfig("NLog.config"));

                bootstrapper.Initialize();

                LogProvider.SetCurrentLogProvider(new ColouredConsoleLogProvider());

                const string endpoint = "http://localhost:12345";

                using (WebApp.Start<Startup>(endpoint))
                {
                    Console.WriteLine();
                    Console.WriteLine("{0} Hangfire Server started.", DateTime.Now);
                    Console.WriteLine("{0} Dashboard is available at {1}/hangfire", DateTime.Now, endpoint);
                    Console.WriteLine();
                    Console.WriteLine("{0} Type JOB to add a background job.", DateTime.Now);
                    Console.WriteLine("{0} Press ENTER to exit...", DateTime.Now);

                    string command;
                    while ((command = Console.ReadLine()) != String.Empty)
                    {
                        if ("job".Equals(command, StringComparison.OrdinalIgnoreCase))
                        {
                            BackgroundJob.Enqueue(() => Console.WriteLine("{0} Background job completed successfully!", DateTime.Now.ToString()));
                        }
                    }
                }


            }

        }
    }

Re hello there ;)

After some tests, ALWAYS with [AbpApiAuthorize]n here some results

With postman : <a class="postlink" href="http://localhost:6235/odata">http://localhost:6235/odata</a> : $metadata retrieved for abpodataentitycontroller <a class="postlink" href="http://localhost:6235/odata/Persons">http://localhost:6235/odata/Persons</a> : access denied

from excel, giving this url as oData flux: <a class="postlink" href="http://localhost:6235/odata">http://localhost:6235/odata</a> : access granted to Persons table data (& all other data) <a class="postlink" href="http://localhost:6235/odata/Persons">http://localhost:6235/odata/Persons</a> : access denied (but if i can access it via the url just on previous line, it does not help us :mrgreen: )

and the following method to authentificate

• anonymous
• windows
• basic
• api Web (asking for a key), -> could be the one
• marketplace key
• profesionnal account

Is it planned on your side ton investigate further on this ?

it will be necessary for me in few weeks. :cry:

I could provide an excel 2016 proplus account (365, in english) to test it, if necessary and a fee if not planned on your side :)

Thks for your help ;)

Is it a possibility to integrate secure access atribute for odata soon ?

Thanks ;)

It was resolved with 0.8.1 (<a class="postlink" href="https://github.com/aspnetboilerplate/aspnetboilerplate/issues/864">https://github.com/aspnetboilerplate/as ... issues/864</a> ) did you get the latest nuget version ? ;)

Adding the [AbpApiAuthorize] give me the http call with "Authorization has been denied for this request."

But when I use this flux on excel (2016), I can access all data without login request :( ;)

Works like a charm !

thanks for the help ;)

Had the same stuff for weeks ... I was going to throw my computer out of the window :lol:

Thanks for the investigation ;)

For executing SP with user defined tables, i use this package on sql server. <a class="postlink" href="https://github.com/Fodsuk/EntityFrameworkExtras">https://github.com/Fodsuk/EntityFrameworkExtras</a> #446@d867302f-819f-44ef-9a53-cebedb5ada2e

I've investigated the ODATA sample (on github); using Power BI Tools from Microsoft Office.

Using ODATA v4 with powerview/powerpivot allow us to make great reports with excel.

I'll look more into this on next month.

Sampath, maybe you could see if it fits your needs.