We need Data Entry people for the next projects.

Hello,

They need data entry people to fill out forms.

Interested persons please send an email to

Indicate how many hours you can work daily and mention the time from when to until GMT

Regards,
Ganesan

sql server: API to convert Teradata DDL to Azure SQL Data Warehouse

Stack exchange network

The Stack Exchange network consists of 175 question and answer communities including Stack Overflow, the largest and most reliable online community for developers to learn, share their knowledge and develop their careers.

Visit Stack Exchange

java – What programming language is best to create a small application to store data records?

With software development, there is no "better". It is always a matter of compensation. For a small personal project like the one you mention, it does not matter what language you use, especially if you are building it to practice or have fun. If you want to improve in Python, use Python. If you want to improve in Java, use Java. Both are used in leading technology companies, so in this situation, there really is no wrong answer. Whatever you choose, the important thing is that you limit yourself to it and enjoy it.

Error trying to get data from SQL to Excel

I can access and log in to the SQL server fine when I'm in Excel but
I receive this error when on the browser screen in Excel when selecting a certain table:

DataSource.Error: Microsoft SQL: the conversion failed to convert from a character string to a unique identifier.
Details:
DataSourceKind = SQL
DataSourcePath = odin act7; gfpact
Message = The conversion failed to convert from a string to a unique identifier.
Number = 8169
Class = 16

But I can select other tables very well with the same GUID format.

I did CREATE A> New query so that I can the properties of the table

SET ANSI_NULLS ON
TO GO

ESTABLISH QUOTED_IDENTIFIER IN
TO GO

CREATE TABLE [dbo].[TBL_COMPANY](
[COMPANYID] [uniqueidentifier] NOT NULL,
[NAME] nvarchar NOT NULL,
[DESCRIPTION] nvarchar null
[CATEGORY] nvarchar null
[REFERREDBY] nvarchar null
[TICKERSYMBOL] nvarchar null
[NUMEMPLOYEES] [int] NULL,
[INDUSTRY] nvarchar null
[SICCODE] nvarchar null
[REVENUE] [decimal](18, 2) NULL,
[TERRITORY] nvarchar null
[REGION] nvarchar null
[DIVISION] nvarchar null
[WEBADDRESS] nvarchar null
[HIERLEVEL] [int] NULL,
[HIERPATH] null varchar
[HASSUBCOMPANY] [bit] NOT NULL,
[CONTACTQUERYTEXT] nvarchar null
[OPPQUERYTEXT] nvarchar null
[QUERYVERSIONID] [uniqueidentifier] NOT NULL,
[PARENTCOMPANYID] [uniqueidentifier] NULL,
[ISPRIVATE] [bit] NOT NULL,
[MANAGEUSERID] [uniqueidentifier] NOT NULL,
[CREATEUSERID] [uniqueidentifier] NOT NULL,
[CREATEDATE] [datetime] NOT NULL,
[EDITUSERID] [uniqueidentifier] NULL,
[EDITDATE] [datetime] NULL,
[IMPORTDATE] [datetime] NULL,
RESTRICTION [TBL_COMPANY_PK] PRINCIPAL KEY CLUTCHED
(
[COMPANYID] ASC
) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
) IN [PRIMARY] TEXTIMAGE_ON [PRIMARY]
TO GO

Google Apps Script: How to automatically set the date in a cell when a formula changes a different cell value from the data in another sheet?

I currently have a column, eg. ColB, which contains SUMIF functions with its data range of other sheets and a column, p. Eg ColC, with the dates that I want to update automatically to the last date in which the value of ColB was changed. Here is a photo to illustrate what I mean:

After searching, I found the following Google application scripts, but it seems that they only work if the change to the ColB cells is a direct edition instead of a value change of the SUMIF function that recalculates new data:

Example of script 1:

onEdit (e) {function
Yes ([2, 5, 8, 11].indexOf (e.range.columnStart)! = -1) {
e.range.offset (0, 1) .setValue (new Date ());
}
}

Example of script 2:

onEdit () {function
var s = SpreadsheetApp.getActiveSheet ();
if (s.getName () == "Sheet1") {// check that we are on the correct sheet
var r = s.getActiveCell ();
if (r.getColumn () == 13) {// check the column
var nextCell = r.offset (0, 1);
if (nextCell.getValue () === & # 39; & # 39;) // is empty?
var time = new Date ();
time = Utilities.formatDate (time, "GMT", "HH: mm: ss");
nextCell.setValue (time);
};
};
}

Is there a Google Apps script that can execute what I want?

The broken screen of samsung a5 does not turn on. Need data recovery

Stack exchange network

The Stack Exchange network consists of 175 question and answer communities including Stack Overflow, the largest and most reliable online community for developers to learn, share their knowledge and develop their careers.

Visit Stack Exchange

Cloud configurations continue to present security challenges for the data center

Recent studies and surveys indicate that misconfigured instances of the public cloud continue to convert confidential data into hanging fruits.

Despite a great attention to the problem, the configuration of the cloud is still a major problem. When data and applications move from local environments to the cloud, the appropriate access controls do not always follow.

Last month, the Ladders online job site exposed more than 13 million user records that it hosted in the Amazon Web Services cloud. The reason? Access controls misconfigured in your AWS Elasticsearch Service instance.

In May, UpGuard security researchers reported that data on more than 500 million Facebook users were exposed by third parties who stored the information in unsecured Amazon S3 repositories. Chtrbox confirmed the accidental exposure but said the range was not as great as reported.

Source: https://www.datacenterknowledge.com/…ity-challenges

excel – C # LinqToExcel Data reading and creation speed

I have created a function that will read an Excel document.

Within the excel document there are 2 sheets.

What I'm doing is getting some data from sheet 1 and some data from sheet 2 and combining that data into one object and writing it into another Excel document.

The problem here is that it becomes quite slow as more rows are completed, this is because I am using Linq (I suppose) to find some necessary values ​​for the object to be complete, since the rows of the sheet 1 and the Sheet 2 are not online.

                                                                // Get the current row so we know where to start.
int currentRow = excelWorksheet.Dimension.End.Row;

string campaignDate = string.Join ("", sourceExcelPackage.Worksheet (DATABASE_1_WORKSHEET) .Select (x => x["CAMPAIGN_DATE"].Value));

// Start the real work.
foreach (var row in sourceExcelPackage.Worksheet (EVENT_1_WORKSHEET))
{
// Customer identification
string customerId = row["CustomerId"].Value.ToString ();

// Create report object to help keep things readable.
ReportObject reportObject = new ReportObject
{
EventType = row["EventType"].Value.ToString (),
DateCreated = row["DateCreated"].Value.ToString (),
EmailType = row["Context"].Value.ToString (),
LinkClicked = row["Destination"].Value.ToString (),
CampaignDate = campaignDate,
SupporterID = string.Join ("", sourceExcelPackage.Worksheet (DATABASE_1_WORKSHEET) .Where (x => x["DSM_CustomerID"] == customerId)
.Select (x => x["SUPPORTER_ID"].Value)),

PathwayStageHistoryOID = string.Join ("", sourceExcelPackage.Worksheet (DATABASE_1_WORKSHEET) .Where (x => x["DSM_CustomerID"] == customerId)
.Select (x => x["PATHWAY_STAGE_HISTORY_OID"].Value))
};

// Add next row.
currentRow ++;

// Assign data here.
excelWorksheet.Cells[currentRow, 1].Value = reportObject.SupporterID;
excelWorksheet.Cells[currentRow, 2].Value = reportObject.CampaignDate;
excelWorksheet.Cells[currentRow, 3].Value = reportObject.EmailType;
excelWorksheet.Cells[currentRow, 4].Value = reportObject.DateCreated;
excelWorksheet.Cells[currentRow, 5].Value = reportObject.EventType;
excelWorksheet.Cells[currentRow, 6].Value = reportObject.LinkClicked;
excelWorksheet.Cells[currentRow, 7].Value = reportObject.PathwayStageHistoryOID;

// Return the current row as we can
// Use this to build some kind of progress.
Return performance currentRow;
}

As you can see SupporterID Y PathwayStageHistoryOID It's where I'm using LinqToExcel inside the loop.

Cognito Forms: it is necessary to store the data in your own database instead of storing it in the Cognito forms database

Stack exchange network

The Stack Exchange network consists of 175 question and answer communities including Stack Overflow, the largest and most reliable online community for developers to learn, share their knowledge and develop their careers.

Visit Stack Exchange

theme development – Save ContactForm7 data in a cookie

I'm developing a WordPress theme that has a custom message type called & Insights & # 39;. Then in single-insights.php the administrator can upload a PDF file so that the user can download it by clicking on a button & # 39; Download & # 39;.

But before the user downloads the file, a form must appear (ContactForm7) and the file will be downloaded when the user has submitted the form.

All the mentioned, I already did it.

But the client wants the information sent in the form to be stored in a cookie so that the user does not have to complete the form the next time he wants to download a file. That is, the next time the user clicks "Download", the form (ContactForm7) will be sent automatically with the cookie data.

My question is: how can I get the information stored in a cookie when the form is sent and can the data of the cookies be taken next time?

I hope you have understood me. My English is not very good.