Questions tagged [data-validation]

The tag has no usage guidance, but it has a tag wiki.

Filter by
Sorted by
Tagged with
1
vote
0answers
18 views

How to use validation rule within database with drop down menus.

Building a scheduling database using access 2013 for my company. I currently have it set up so that only employees that have a rating of 3 or more for the particular job show up when you use the drop ...
2
votes
2answers
112 views

Insert/update data into relational database tables only after administrator approval - how to approach it?

I'm building a relational database that holds 21 tables, which is connected to my website application through PHP. The website has search functionality which allows users to search this database. ...
1
vote
2answers
2k views

Validating the GST Identification Number (GSTIN)

The following image describes the format of the GST Identification Number: The first 2 digits denote the unique State Code in accordance with the Indian Census 2011. For instance, the State Code of ...
0
votes
0answers
74 views

Configuring GeoServer SQL Views and Validation

For a little background i want to mention that I am using GeoEXT with Geoserver. I am using the Geoext comboboxes to search point data by name. The application works properly for name having single ...
11
votes
1answer
11k views

How do I store phone numbers in PostgreSQL?

Let's assume I want to store phone numbers in a database. I may accept phone numbers from outside of the United States. How would I go about storing these phone numbers?
0
votes
1answer
371 views

db.collection.validate() missing output and verify() returned EBUSY on first run

logs of the successful run # grep conn103640 mongodb.log | head -10 2017-01-12T11:29:51.492+0000 I ACCESS [conn103640] Successfully authenticated as principal tz6z on admin 2017-01-12T11:31:20.954+...
3
votes
2answers
3k views

Loop through list of fields, check against lookup table

I have a list of fields: FIELD_DOMAIN_ENG_VW +-------------+------------+-------------+ | TABLE_NAME | FIELD_NAME | DOMAIN_NAME | +-------------+------------+-------------+ | ENG.TABLE_1 | FIELD_1 ...
0
votes
1answer
1k views

vba Excel data Validation error 'Application-defined or object-defined error'

I've read loads of similar questions and answers, but keep getting error. What I do is I export query via DoCmd.TransferSpreadsheet acExport, 8, "blabla", outputFile, True Then I'm attempting to ...
0
votes
0answers
28 views

Constraint with respect to existing data

Talking about SQL Server. Table contains column A and B. For simplicity - no key. Both columns may contain any values. But with a limitation: if column A receives a value which was already used in ...
3
votes
1answer
465 views

use cases for db.collection.validate() - checks the structures within a namespace for correctness by scanning the collection’s data and indexes

I found on MongoDB mailing list one use case for db.collection.validate(): The count() command is generally an estimate of the current document count, based upon statistics provided by the ...
9
votes
2answers
6k views

How do I determine why a MongoDB document is failing validation?

How do I determine why a MongoDB document insert is failing validation? All I get back is a writeError that says "Document failed validation", which isn't very helpful. (This happens often, and I'd ...
1
vote
1answer
41 views

Easy way to have non-tech users modify database?

We're in the process of engineering a BI solution. One problem we have is that sadly a lot of HR information (start date, department, department change date, work hours, etc etc) -- seems to me ...
3
votes
4answers
2k views

Validate three digits before decimal and after decimal point six digits

I have columns called longitude and latitude with nvarchar data type. The user can enter something like (23.23424432),(432423.343), which should not be allowed. Can anyone help me to validate this in ...
5
votes
1answer
11k views

Best Practice for SQL Server data validation

I have CSV files that I would like to import into SQL Server 2014. Each record in the files has around 20 columns, each of them should be validated for data type compliance as well as some other ...
2
votes
1answer
1k views

How to validate data before loading it to DB

I have a situation where in I have million records in CSV file, what I need to do is to apply some business validation on certain columns of CSV and load data to DB only if particular record is valid. ...
1
vote
1answer
707 views

MySQL-load data infile- invalid data validation

Is it possible to validate the data and load it in a table using load data infile? This is the query load data local infile 'C:/Users/970685/Desktop/SFcheck.csv' into table wow_macro....
3
votes
1answer
1k views

Table structure for validating data using category and subcategory fields

I am creating a simple budget application, and the primary table will be a transaction table that contains things like the amount of the transaction, date, account, the category and subcategory (the ...
1
vote
1answer
44 views

Can I enforce one field being dependent on another?

I would like to know if it's possible to have two fields (in this case bits) in the same table where one is dependent on another. For example Check2 may only be true if Check1 is true. Note: I'm ...
1
vote
1answer
372 views

Compare table content from different PostgreSQL 9.3 DBs

The problem How do I efficiently and idiomatically compare the content of two tables, each in a different DB? I have 3 DBs (the classic dev, stg and prod). Each DB has a few tables which should be ...
2
votes
1answer
8k views

How to check the consistency of tables in mysql

I have few questions regarding consistency in Mysql in two scenarios 1st scenario: How can I verify a restored backup matches the original DB data on all the tables? We have two hosts with the same ...