Stack Overflow
Stack Overflow

Questions tagged [flat-file]

A flat-file database model is any system using a single file for storage with one record per line, usually plain-text or text mixed with binary data.

A "flat file" is a plain text or mixed text and binary file which usually contains one record per line or 'physical' record (example on disc or tape). Within such a record, the single fields can be separated by delimiters, e.g. commas, or have a fixed length. In the latter case, padding may be needed to achieve this length. Extra formatting may be needed to avoid delimiter collision. There are no structural relationships between the records.

Typical examples of flat files are /etc/passwd and /etc/group on Unix-like operating systems. Another example of a flat file is a name-and-address list with the fields Name, Address, and Phone Number.

Source: Wikipedia (Flat file database)

830 questions
-1
votes
1 answer

When importing a flat file in SQL Server, is there a way to change all data types at once?

Is there a way to change every column data type to the same data type at once (e.g. varchar(MAX)) when importing a flat file into SQL Server? My data set has 500+ columns. I could ALTER the data types by a script, however, the auto assigned data…
d789w
  • 357
  • 5
  • 19
-1
votes
1 answer

How to read file from txt file with delimiters, and write it back to new txt file

i've been given a data from txt file for example Trans ID;Transaction Date;Cashier Name 00001;1 January;Ricky 00001;1 January;Ricky 00002;2 January;Rico the problem is im new to this kind of file and dont know how to read and export it to a new txt…
user11548035
-1
votes
1 answer

Tree structure flat file to dynamic XSLT

I have a tree-structured flat file for which I need to write into a dynamic XSLT. The flat file data keep changing. For example, I have tag A, B, C, D as given below. Then the next file can have E, F, G, H.The tree itself will have 4-6 levels of…
Syeda Samreen
  • 99
  • 1
  • 13
-1
votes
1 answer

How to import a one lined flat file .txt with much information in R

my test.txt file looks like this "Nr" | | "X1" | | "ID_T20" | | "Herstellernummer" | | "Werksnummer" | | "Fehlerhaft" "1" | | 1 | | "20-211-2111-14" | | "211" | | "2111" | | 0 I tried a lot of commands to import it as a data frame like this: "Nr"…
Allerdings
  • 1
-1
votes
2 answers

Good practice for choosing a web configuration file saved in a php file?

Hello I want to save the configuration of my web page in a php file.The idea is the configuration is available regardless of whether there is a connection or not to database. I want to be in php files to more secured even if there is not a file…
bedamusa
  • 1
  • 2
-1
votes
1 answer

Creating a Database service

I am running Nginx and PHP on a Virtual Linux machine with Digital Ocean. I use a very simple folder and file system as a database that looks like this: --Users --User1 --file1.json --file2.json --User2 --file1.json …
Shawn Cooke
  • 907
  • 1
  • 11
  • 28
-1
votes
5 answers

Flat file to XML in JAVA

I have a flat file of fixed length fields like this: ITEM1234LED Light Set ITEM1235Ratchet Tie I'd like to convert it into xml file: 1234 LED Light Set …
Fred Smith
  • 73
  • 1
  • 8
-1
votes
1 answer

C# Binaryformatter deserialize to string?

I am serializing only one data to MyFile.bin file, now i have to deserialize it to a string or Int and add +1 with current value and save it again, In order to do this how to deserialize the value to Int or String variable? Code public void…
user466061
  • 91
  • 11
-1
votes
1 answer

i want to compare the data in a PDF file with the flat file by using unix terminal

I want to compare the data in the PDF file with the flat file by using unix terminal. Is it possible to do so by writing any script.
vijetha
  • 1
  • 1
-1
votes
1 answer

How to import data from multiple files with different columns to multiple destination in SSIS?

Objective: Load data from flat files which has different headers to it's each corresponding table.The files can be differentiated by it's filename as it contains the name of the table. What I've tried: Used a foreach loop container to loop multiple…
kurozakura
  • 2,339
  • 8
  • 28
  • 41
-1
votes
1 answer

Flat file Schema (Delimited) creation wizard in Biztalk server 2015

i want to add nested child record with elements in Positional File (Flat File schema Creation wizard) using Biztalk, for Eg. Generated instance to be like this: ELEMENT
Prem S
  • 11
  • 3
-1
votes
2 answers

VBA: Replace text from txt for each line and save as

Could somebody help me with the following? I tried making it on my own, but all I could do is open a txt and replace a static word with static word. VBA script: Open and Read first line of ThisVbaPath.WordsToUse.txt Open and Find USER_INPUT in…
Dkoonice
  • 1
  • 2
-1
votes
1 answer

XSD for testdata generation

I'm trying to generate flat file for test data using JAVA. Flat file has own mapping document which describes all fields of each line. I was suggested to use XSD for mapping and I did some research on XSD. As I understood that XSD is for only…
Alden
  • 11
  • 1
-1
votes
1 answer

How do RDBM’s make working with data more effective than flat files and spreadsheets

Could anyone help me answer this question: How do RDBM’s make working with data more effective than flat files and spreadsheets.
Abi Houghton
  • 111
  • 1
  • 1
  • 6
-1
votes
1 answer

Importing Flat Files in SSIS using @FileName as the destination table

I'm trying to import a large number of flatfiles using SSIS, but the thing is I wanted to use foreach, so that it could get the name of the file and use it as the table destination name. For example: Flat File name: ExampleOfFile.txt foreach…
ArchTrivium
  • 1
1 2 3
…
55 56