I will do excel data entry, data collection and data mining for $20

I will do excel data entry, data collection and data mining

Well come to My Service…
I’m enthusiastic and professional data entry operator,with 2 years of quality data entry experience. ..My Provide Services…

  1. Data Entry job
  2. Data Scraping
  3. Copy Paste task
  4. Admin Support
  5. Web Research
  6. Manual Typing
  7. File Conversions
  8. Email List into Excel Sheet
  9. Product listing
  10. Data copy paste one website to another website.
  11. Download your images into a zip folder.
  12. Data copy paste from different link source.
  13. Copy and Paste of a file of your choice (Word Document, Spreadsheet, Notepad)
  14. Convert PDF into EXCEL.
  15. Virtual assistant
  16. & much more….

My Service Quality….

  • 100% accuracy
  • 100% guaranteed quality work
  • Fair/low price
  • 24-hour quick turnaround

I’m crazily passionate about data entry!If your required service is not listed above, just inbox me with all details, I’ll try to reach as soon as possible.Thank you……!!!

.(tagsToTranslate)DataEntry(t)Datacollection

2013 – How to Get the Total File size from all document libraries in a site collection based document creation date

For an approximate total content size for a Site Collection using PowerShell:

Get-SPSite http://yourServer/sites/yourSite | select StorageUsed

The same from REST API:

http://yourServer/sites/yourSite/_api/site/usage

Count and size for a single library (excluding versions):

Get-SPSite http://yourServer/sites/yourSite | 
  select -ExpandProperty lists | 
  where Title -eq "Documents" | 
  select -ExpandProperty Items | 
  select -ExpandProperty File | 
  measure -Property Length -Sum

Count and size of files for an entire Site Collection (excluding versions, list content, and “other”):

Get-SPSite http://yourServer/sites/yourSite | 
  Get-SPWeb -Limit all | 
  select -ExpandProperty lists | 
  select -ExpandProperty Items | 
  select -ExpandProperty File | 
  measure -Property Length -Sum

magento2, order collection, how get billing address

i have this code

$collection = $this->orderCollectionFactory->create()
                //('increment_id', 'global_currency_code', 'status', 'updated_at')
                ->addFieldToSelect('*')
                ->addAttributeToFilter('status', ('in' => (
                    Order::STATE_CLOSED,
                    Order::STATE_COMPLETE,
                    Order::STATE_CANCELED
                )))
                ->addAttributeToFilter('created_at', ('from' => $result('from'), 'to' => $result('to')));

            $data = $collection->getData();

how can i get billing address in my collection?

c# – Using Method Chaining To Alter Last Item Added To Collection

There is a Name class with properties that represent different components that make up a person’s name. A Name object requires a FirstName and Surname. All other fields are optional.

class Name
{

    public string FirstName { get; set; } = String.Empty;
    public string Surname { get; set; } = String.Empty;
    public string Rank { get; set; } = String.Empty;
    public string Suffix { get; set; } = String.Empty;
    public string NickName { get; set; } = String.Empty;
    public string MiddleName { get; set; } = String.Empty;
            

    public Name(string firstName, string surname) 
    {
        this.FirstName = firstName;
        this.Surname = surname;
        
    }

}

Also, there is a NamesBuilder class that has a List<Name> collection. It has a GetListAsString method which iterates over the collection and builds a single string with the list of names:

class NamesBuilder
{
    List<Name> Names;

    public NamesBuilder()
    {
        Names = new List<Name>();
    }

    public NamesBuilder AddName(string firstName, string surname)
    {
        Names.Add(new Name(firstName, surname));

        return this;
    }


    public string GetListAsString()
    {
        StringBuilder sb = new StringBuilder();

        foreach (Name name in Names)
        {

            //add Title if exists
            if (name.Rank.Length > 0)
            {
                sb.Append(name.Rank);
                sb.Append(" ");
            }

            //add Firstname
            sb.Append(name.FirstName);
            sb.Append(" ");


            //add MiddleName if exists
            if (name.MiddleName.Length > 0)
            {
                sb.Append(name.MiddleName);
                sb.Append(" ");
            }

            //add NickName if exists
            if (name.NickName.Length > 0)
            {
                sb.Append((char)34);
                sb.Append(name.NickName);
                sb.Append((char)34);
                sb.Append(" ");
            }

            //add Surname
            sb.Append(name.Surname);


            //add Suffix if exists
            if (name.Suffix.Length > 0)
            {
                sb.Append(" ");
                sb.Append(name.Suffix);                    
            }


            //add new line
            sb.AppendLine();
        }

        return sb.ToString();

    }

}

This is called using method chaining:

    static void Main(string() args)
    {

        NamesBuilder nb = new NamesBuilder()
            .AddName("James", "Kirk")
            .AddName("Montgomery", "Scott")
            .AddName("Nyota", "Uhura")
            .AddName("Leonard", "McCoy")
            .AddName("Christine", "Chapel");

        Console.WriteLine(nb.GetListAsString());

    }
}

And this outputs:

James Kirk 
Montgomery Scott 
Nyota Uhura 
Leonard McCoy 
Christine Chapel

So the missing functionality is the ability to add optional Rank, Suffix, NickName and MiddleName details to each name. My initial thought was to change the AddName method to multiple optional parameters:

public NamesBuilder AddName(string firstName, string surname, string rank = "", string nickName = "", string middleName = "", string suffix = "")

However, this seems very verbose and inelegant especially if only the suffix needs to be added and all previous optional parameters are not applicable to that particular name.

My approach is to create new methods in the NamesBuilder class that would append those details to the last item added to the collection.

Here is the amended code of the caller illustrating this

    static void Main(string() args)
    {

        NamesBuilder nb = new NamesBuilder()
            .AddName("James", "Kirk").SetRank("Capt").SetMiddleName("Tiberius")
            .AddName("Montgomery", "Scott").SetNickName("Scotty").SetRank("Lt Cdr")
            .AddName("Nyota", "Uhura").SetRank("Lt")
            .AddName("Leonard", "McCoy").SetSuffix("MD").SetNickName("Bones").SetRank("Lt Cdr")
            .AddName("Christine", "Chapel");
            
        Console.WriteLine(nb.GetListAsString());

    }

And here is the updated NamesBuilder class:

class NamesBuilder
{
    List<Name> Names;

    public NamesBuilder()
    {
        Names = new List<Name>();
    }

    public NamesBuilder AddName(string firstName, string surname)
    {

        Names.Add(new Name(firstName, surname));

        return this;
    }

    public NamesBuilder SetRank(string rank)
    {

        Names(Names.Count - 1).Rank = rank;

        return this;
    }

    public NamesBuilder SetSuffix(string suffix)
    {

        Names(Names.Count - 1).Suffix = suffix;

        return this;
    }

    public NamesBuilder SetMiddleName(string middleName)
    {

        Names(Names.Count - 1).MiddleName = middleName;

        return this;
    }

    public NamesBuilder SetNickName(string nickName)
    {

        Names(Names.Count - 1).NickName = nickName;

        return this;
    }

    public string GetListAsString()
    {
        StringBuilder sb = new StringBuilder();

        foreach (Name name in Names)
        {

            //add Title if exists
            if (name.Rank.Length > 0)
            {
                sb.Append(name.Rank);
                sb.Append(" ");
            }

            //add Firstname
            sb.Append(name.FirstName);
            sb.Append(" ");


            //add MiddleName if exists
            if (name.MiddleName.Length > 0)
            {
                sb.Append(name.MiddleName);
                sb.Append(" ");
            }

            //add NickName if exists
            if (name.NickName.Length > 0)
            {
                sb.Append((char)34);
                sb.Append(name.NickName);
                sb.Append((char)34);
                sb.Append(" ");
            }

            //add Surname
            sb.Append(name.Surname);


            //add Suffix if exists
            if (name.Suffix.Length > 0)
            {
                sb.Append(" ");
                sb.Append(name.Suffix);                    
            }


            //add new line
            sb.AppendLine();
        }

        return sb.ToString();

    }

}

The output is now:

Capt James Tiberius Kirk
Lt Cdr Montgomery "Scotty" Scott
Lt Nyota Uhura
Lt Cdr Leonard "Bones" McCoy MD
Christine Chapel

I have never before used methods like this to alter the data of the most recent item added to a collection. It works and I think it looks much better than multiple optional parameters but I’d appreciate feedback.

csom – Can a user who is not a SharePoint Online administrator create a site collection with a template other than communication site or team site?

I have a user who I do not want to promote to a SharePoint Administrator, but I do want to allow them (because they are a developer) to create site collections with the template DEV#0 without having to go through me or my account I know I can set up an application that allows them to do this by using the permissions of the application, but before I do this, I just wanted to confirm that there is no way for a user to do this in SharePoint Online.

  • I can’t use SPO Powershell because they do not have access to the admin center.
  • I can’t use New-PnPTenantSite because they do not have access to the admin center.
  • I tried using the SharePoint Rest API, and here was the code I tried under their account from the JavaScript console at https://tenant.sharepoint.com/_layouts/15/sharepoint.aspx (I used JavaScript fetch for this test):

Request:

fetch("https://tenant.sharepoint.com/_api/SPSiteManager/Create", {
"headers": {
"accept": "application/json;odata=verbose",
"accept-language": "en-US,en;q=0.9",
"content-type": "application/json;odata=verbose",
"sec-fetch-dest": "empty",
"sec-fetch-mode": "cors",
"sec-fetch-site": "same-origin",
"x-requestdigest": "Request_Digest_Here"
},
"body": "{"request":{"__metadata":{"type":"Microsoft.SharePoint.Portal.SPSiteCreationRequest"},"WebTemplate":"DEV#0","Title":"Test dev site","Url":"https://tenant.sharepoint.com/sites/devsite1","Description":"","Classification":"","Lcid":1033,"ShareByEmailEnabled":false,"WebTemplateExtensionId":"00000000-0000-0000-0000-000000000000","HubSiteId":"00000000-0000-0000-0000-000000000000"}}",
"method": "POST",
"mode": "cors",
"credentials": "include"
});

Response:

{"error":{"code":"-2147024809, System.ArgumentException","message":{"lang":"en-US","value":"siteTemplaternParameter name: Performing this operation on a site with this template is not allowed."}}}
  • I can’t use CSOM because I can’t create a Tenant object to use the Tenant.CreateSite method without the account being a SharePoint administrator.
  • Correct me if I’m wrong, but I don’t think there is a way to create a site collection in JSOM.
  • Is it possible to use WSDL/SharePoint SOAP API?

Am I missing any methods? Is it possible to use the SOAP API or JSOM? Can I resolve the error in the REST API? Or is this just not possible?

SharePoint Online Powershell script–To Query(TO and CC) parameters from all the Approval 2010 Workflow Template OOTB workflows in a site collection

Stack Exchange Network


Stack Exchange network consists of 177 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Mongodb index keeps growing in size eventhough the collection has a TTL index

I work on a mongodb sharded cluster (3.0.2 i know it’s very outdated, not my call), on which i have a sharded db and a sharded collection on which i have multiple indexes.

One of the indexes is a TTL index (24h only, 86400) on a date field named d, used to expire old data, this leads to almost fixing the number of entries in the collection within our use case. Given the fixed structure and model of the data, this means an almost fixed size of the collection and it’s indexes, it has always been the case for index and collection sizes throughout the whole cluster.

Our issue is, we have another index on this collection, on a field named k which is a large string.

ex : GigabitEthernet_XXXX-XXXXX-01_ABC_DEFG-HIJKLMNOP-5-QRS_TUV_7_0&#47;0&#47;1

This index keeps growing indefinitely in size, and causes memory outages and we don’t know why. Any help ?

Knowing that the TTL index always expires/removes data from the collection, isn’t the second index, on the k field supposed to also remove the references to that data, hence be fixed or at least not be evergrowing in size ?

We use this same technique (TTL index + other indexes) on all our collections and it always works in terms of fixing the sizes, not on this collection though. It is also important to note that other collections have a much smaller k field than this one, is that the issue ? Any explanations ? Any mongodb docs about this ?

Happy to provide any needed details to explain the issue.

Thanks in advance

Collection of online tools and utilities for text, numbers, dates, and various other data types.

Why are you selling this site?

I’ve build this as a challenge for myself, and accomplished as much. Unfortunately, I’m tight on cash and would like to pass it on to someone else who may want or need it — either for SEO or otherwise. It has great potential in the right hands.

How is it monetized?

It’s not. App is brand new and I haven’t had the time to do anything yet. No visitors or any revenue yet.

Does this site come with any social media accounts?

Yes, Twitter. Will also include domain email via zoho.

How much time does this site take to run?
SEMrush

As little as few hours a month? Once the content is up, it should be trivial to optimize for SEO. Would be a good idea to add new content (tools) periodically.

What challenges are there with running this site?

Site is built with node.js, so buyer will need to know how to run such an app and have access to a vps server, or something that can run node.js. Some html/js/css knowledge will be useful for adding new content.

Web app was build from scratch with a certain node.js framework & mysql over the course of ~3 months in my spare time and accumulated over 270 commits. It has user accounts (easily enabled/disabled, but not on right now) and an admin panel to perform various tasks and add/edit new content. It’s build with SEO in mind, is very lightweight, and runs very smoothly on my free, low spec VPS.

To get this going you need to keep adding new content, which I will explain how and where to source it to the buyer. Ideally, it should have 30-50 total apps. The admin panel has a very extensive content editor(s) with live preview and various other helper tools to make adding new content very easy.

https://www.coditools.com/

Cheers