I'd think there was a question on this already, but I can't find one. Maybe the solution is too easy... Anyway, I have a flat-file and want to let the user change the values based on a name. I've already sorted out creating new name+value-pairs using the fopen('a') mode, using jQuery to send the AJAX call with newValue and newName. But s...
Hi, I am new to BizTalk server. So if this question is so obvious, plz forgive :( I have a flat file from one application, which i have to send to a biztalk server. In that case which component in my biztalk server converts my flat file to xml. Also I heard that I have to create an input schema(.xsd file), why i need an input message ...
The higher ups in my company were told by good friends that flat files are the way to go, and we should switch from SQL Server to them for everything we do. We have over 300 servers and hundreds of different databases. From just the few I'm involved with we have > 10 billion records in quite a few of them with upwards of 100k new records...
Hi all, when I use SQL server import and export wizard to export a table to a flat file, it keeps giving me error message, stating that data conversion failed because of the column **. Does anyone know the reason to this issue and how to fix it? the problem source column is nvarchar(200) in sql server tables. Thanks for that. Ling ...
I haven't done much programming for Embedded Systems before, and now I have to create some scripts for something relatively tiny (<60MB RAM, almost all of which is already used by other more critical processes, the processor is less ~ 500MHz). I can't run something that is on all the time, so Firebird is out. I suggested sqllite, but peo...
I have a large file that I would like to read via php, and then insert various fields into MySQL. Each file in the feed is in plain text format, separated into columns and rows. Each record has the same set of fields. The following are the delimiters for each field and record: Field Separator (FS): SOH (ASCII character 1) Record Separa...
I want to store a few values in the form of high scores. But since im not going to be storing more than 5 values, using SQLlite doesnt seem appropriate. Another option considering was a flat file, but not sure how to go about.. ...
Hello, I have to import flat files into SQL Server. So far, I've used SSIS packages and Delphi programs to do the job but I'm getting more and more files to load. Many are very wide (more than 90 fields) and they all have their own specifics: some are fixed-width, some are delimited with a wide set of characters used as field and row de...
I have a flat file generated by a C program. Each record in the file consists of a fixed length header followed by data. The header contains a field indicating the size of the following data. My ultimate goal is to write a C#/.NET program to query this flat file, so I'm looking for the most efficient way to read the file using C#. ...
Is there a way to load a flat file into SQL Server as a new table without knowing the data types of the columns in the file? I know one can use BULK INSERT to load flat file data, but a target table must first be created that matches the datatypes in the incoming file. OPENROWSET requires the creation of a format file that specifies th...
Hey guys, stack overflow has already helped me a lot during my programming work so at first: Thanks a lot for all the asked questions and the excellent answers. Nevertheless I have a problem right now, for which I just couldn't find the right answer here. I am programming a Iphone App which is supposed to parse a flat-file from the we...
I've got a gaming-oriented website with 200+ users. The site has a large database tracking user plays, and one of the motivations for continued participation is the extensive statistics and rankings (S&R) with which the site provides the user. As the list of S&Rs tracked has grown, some of the more intricate calculations have been moved...
I have a fixed-width flat file. To make matters worse, each line can either be a new record or a subrecord of the line above, identified by the first character on each line: A0020SOME DESCRIPTION MORE DESCRIPTION 922 2321 # Separate A0021ANOTHER DESCRIPTIONMORE DESCRIPTION 23111442 # records B0021ANOTHER DESCRIPTION THIS T...
trying to keep it stupidly simple. Is it a bad idea to move a txt file into and out of a python list? the txt files will probably get to about 2-5k entries. what is the preferred method to create a simple flat file databse? ...
I have a simple app I'd like to use JDO. But I don't want to use any DB back, just regular file system. Before jdo, I had this class it serializes it object to a file whereas file name is the "primary key". I'd like to be able to do the same thing with JDO. Is that possible? ...