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

SSIS: How to read flatfile and add a new row to the file

I have a text file and needs to read it and change some text and add some new text in a new row. How do I add e new row with some text in it? I now use a script component to read existing rows and change in them but I can't add a new row :-( Thanks…
Brno
0
votes
1 answer

flat file blog engine powered by asp.net

Regarding blog engines, are there any blog engines that meet all of the following criteria? exists in the asp.net ecosystem flat file option to edit files as raw html (not markdown) actively maintained project I have come across AtomSite…
mg1075
  • 17,985
  • 8
  • 59
  • 100
0
votes
1 answer

Batching line-item data using Flat-File

I have to parse a CSV flat-file containing only line item data, with no recognisable header record, kinda like this: 930001,14-02-2013,100.00,1,Line 1,2,10.00,20.00 930001,14-02-2013,100.00,2,Line 2,2,20.00,40.00 930001,14-02-2013,100.00,3,Line…
Brett
  • 1,127
  • 6
  • 11
0
votes
1 answer

How can I save a rolling flat file trace listener on another machine in LAN?

Hi I'm using Enterprise Library 5, I defined rolling flat file trace listener, to save my logs to a file, how can I address this file to be saved on another machine on LAN?
Masoud
  • 8,020
  • 12
  • 62
  • 123
0
votes
2 answers

Where to store flat files in CakePHP?

I am building an application that allows a user to browse html templates. The html template will be displayed in a preview area (source code will be obfuscated), and although the template will contain inline CSS/JS, there will also be the odd linked…
Chris J Allen
  • 18,970
  • 20
  • 76
  • 114
0
votes
1 answer

BizTalk flat file output schema - Test Map gives Output validation error: The element 'Root' has invalid child element 'Record'

I have a fairly simple flat file schema that just generates CSV, or at least it is supposed to. It has a Root node which is delimited by CRLF, and then a Record node which is delimited by comma, and then the actual fields under that.
RationalGeek
  • 9,425
  • 11
  • 62
  • 90
0
votes
1 answer

How to output a String with JRecord

I am trying to convert a XML/Bean (either one) to a fixed length flatfile with JRecord. I am not able to output it correctly to a String in file. I can only get an output as binary. So I will just convert a XML/Beant to String. Not to a Binary Fixed…
ZiggyStardust
  • 415
  • 1
  • 7
  • 18
0
votes
5 answers

SQL and Flat Files... In harmony?

I was just thinking, how quick it would be to store the actual data of an application in a flat file. Now, you can't just go storing everything in a flat file... sometimes sorts and searches are required, and to go through directories and files…
Kladskull
  • 10,332
  • 20
  • 69
  • 111
0
votes
2 answers

Create value with specific parts of a text file

Ok, I am working on a flatfile shoutbox, and I am trying to achieve a way to get the username from the flatfile and making it a variable so I can use it to make a call to the database to check if the user is admin so they can delete/ban users…
kira423
  • 325
  • 1
  • 5
  • 26
0
votes
0 answers

FlatFile Processing

I have a flat file which contain data with Fixed length,Is there any good approach to parse the data and splitting the lines using a regular occurrence,ie for every occurrence starting with "02" should be a new line and it should be stored some…
Prabhath kesav
  • 428
  • 3
  • 6
  • 21
0
votes
2 answers

What is the best way to store downloaded files?

Sorry for the bad title. I'm saving web pages. I currently use 1 XML file as an index. One element contains file created date (UTC), full URL (w. query string and what not). And the headers in a separate file with similar name but appended special…
CS.
  • 1,845
  • 1
  • 19
  • 38
0
votes
1 answer

Magento - automated order extract - EAV vs flat files

I want to build an automated routine that exports orders from Magento to another ERP. I started down the road of the magento SOAP/XML API's. However we are finding this solution slow for large numbers of orders. Now I realize that the flat order…
Mustapha George
  • 2,497
  • 9
  • 47
  • 79
0
votes
1 answer

Parse flat file with multiple formats

Its been a while since Ive had to write what amounts to a custom format edi processor. The last time I wrote one, I was an AS/400 programmer (not iSeries to give you a timeframe). It was pretty easy, I built a structure and inspected the record…
jason
  • 767
  • 2
  • 9
  • 24
0
votes
1 answer

Importing big (and corrupt?) plaintext files into mysql broken my lamp install

I was importing data from txt files into mysql (via php script). This dump is huge, it's splitted into 10 files. I imported first and second one and everything was ok - I could see all entries in phpmyadmin, etc. There were about 700 000(?) of…
Tz
0
votes
2 answers

How to import to SQL Server 2005 from flat file with data transformations

I have a flat data file that I need to import into my SQL Server 2005 DB. Many of the fields need to be split off into different, related tables. For example, the flat file has names, addresses and telephone numbers, all in one record. In my DB,…
Shaul Behr
  • 36,951
  • 69
  • 249
  • 387
1 2 3
…
55 56