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
2
votes
1 answer

PHP option value suggests from flat file

How could I make this form suggest the words in the first column of $data? This is what I'm trying but doesn't work. As you can see, I cannot make it run with
2
votes
2 answers

SSIS - Can I get the column schema for a flat file source from a database?

We receive a nightly data export from a vendor in the form of about 10 tab-delimited flat file without column headers. In addition, the vendor provides us with the SQL scripts for the database tables so that we can import the files into our system.…
Steve Clement
  • 41
  • 4
2
votes
1 answer

SSIS - ANSI flatfile always saved as UTF-8 (w/o BOM)

I am facing an issue with SSIS where a customer wants a (previously delivered file in UTF-8) to be delivered in ANSI-1252. No big deal i thought. change the file connection manager and done... unfortunately it wasn't that simple. Been stuck on this…
Tsteenbakkers
  • 264
  • 3
  • 18
2
votes
1 answer

SSIS Error Code DTS_E_OLEDBERRORr while running package

I created a package with SSIS to upload a csv file to 3 different tables It works in a way that it reads a csv file and then separates its columns to 3 different tables whereas some columns get uploaded to all tables (ids and such) When I run the…
Taavi
  • 165
  • 1
  • 1
  • 8
2
votes
1 answer

Javascript: most efficient way to store/retrieve data on flat file

I'm creating light weight web-applications based on HTML and Javascript (for example a contact book with around 500 to 1000 entries). I have a simple HTML form to search in the contact list based on a few letters. I want to store the entries on a…
Nicolas Hefti
  • 303
  • 2
  • 9
2
votes
4 answers

Text column not storing more than 8000 characters

I researched this and found that a text column in SQL Server can store a lot more than 8000 characters. But when I run the following insert in the text column, it only inserts 8000 characters: UPDATE a SET [File] = b.Header + CHAR(13) + CHAR(10) +…
user2913493
2
votes
2 answers

How does a Java application using no database , stores previous information and displays it

I have this java application project(client) based on peer to peer file sharing system. It doesn't use any kind of database. There's a Download tab which shows the names of previously downloaded files as well as currently downloading file too.…
acacia
  • 75
  • 8
2
votes
2 answers

Append newline to flat-file schema in BizTalk 2006 R2

I have a flat-file schema that has a header and detail records. It looks something like this: HDR**2401*XX0062484*22750***20081006000000*000******* LIN**001*788-0538-001*4891-788538010*20000*EA**0000*** I need to append two blank lines at the end…
user7607
2
votes
1 answer

Fetching Random Line From Flat Text File Database

I am interested whether the following php script can be written in Javascript (or HTML5)? Basically that is just a simple file reading a .txt and displaying a random line from it:
user3271739
  • 23
  • 1
  • 3
2
votes
3 answers

How to best store a large JSON document (2+ MB) in database?

What's the best way to store large JSON files in a database? I know about CouchDB, but I'm pretty sure that won't support files of the size I'll be using. I'm reluctant to just read them off of disk, because of the time required to read and then…
Paul
  • 485
  • 6
  • 15
2
votes
3 answers

Relational Data to Flat File

I hope you can help find an answer to a problem that will become a recurring theme at work. This involves denormalising data from RDBMS tables to flat file formats with repeating groups (sharing domain and meaning) across columns. Unfortunately this…
Anthony
  • 363
  • 3
  • 9
2
votes
1 answer

Mainframe Flat file to C# classes

I have to communicate with a IBM main frame using IBM WebSphere. The service on the main frame side can only use flat files. On my side I want to use CQRS (Command / Query) In other words I want to serialize command / queries and deserialize query…
Anders
  • 17,306
  • 10
  • 76
  • 144
2
votes
2 answers

JSON-based database system

I am building a web based chat application using Node.js. I am kinda building it gradually while the app is already running in a Node.js PaaS and being tested by my bunch of friends. The thing is, I can't spend much money on database services to…
Mithun
  • 196
  • 1
  • 17
2
votes
3 answers

How can I add a GUID column in SSIS from a Flat File source before importing to a SQL Table?

I'm importing flat files through SSIS which then exports them into a SQL table. I need to add an additional column containing a GUID somewhere in the middle so that it can also be exported to the table. I've made sure there's an additional column…
TJH
  • 189
  • 1
  • 5
  • 18
2
votes
1 answer

Need custom order in flat file from XML using XSLT

I want to create a flat file from an xml using xslt with this output in the order as shown: NM1*CC*1*Smith*John****34*999999999~ N3*100 Main Street~ From this XML:
user2382922
  • 35
  • 3
1 2 3
…
55 56