I need to create MAX file for using it in Xerox FreeFlow Process Manager. Most of the data is static, and is just poped out of the mssql database. (And it has nothing to do with Excel.) What is better in this situation to use? some tools like CSVReader/CSVWriter? Or is it more useful to handle it with the Apache Velocity?
1351
Can anyone recommend a simple API that will allow me to use read a CSV input file, do some simple transformations, and then write it.  A quick google has found  which looks promising.  I just wanted to check what others are using before I couple myself to this API.
82413
I mean 100+ MB big; such text files can push the envelope of editors.  I need to look through a large XML file, but cannot if the editor is buggy.  Any suggestions?
13614
I want to generate a CSV file for user to use Excel to open it.  If I want to escape the comma in values, I can write it as "640,480".  If I want to keep the leading zeros, I can use ="001234".  But if I want to keep both comma and leading zeros in the value, writing as ="001,002" will be splitted as two columns.  It seems no solution to express the correct data.  Is there any way to express 001, 002 in CSV for Excel?
112477
My web application generates a lot of reports in formats like excel sheet, Csv(comma-separated values), fixed width columns, pdf format, html reports etc based on the parameters I select. There is a lot of data in the reports.  Are there any essential criteria for testing report generation that I may not have considered.  I know to test these things:   Data is correct Filters are used Output format is correct   What else is there?
7105
Is there a database program for the Mac that makes it easy to import a CSV file into a table and then query and manipulate the data using ad-hoc SQL queries?  (A Windows example of a similar product would be Microsoft Access ... it also has forms and reports, which are not as important, but I would not mind a Mac solution that has those too.)
16360
I'm a huge fan of the  in the SFDC Developer Console:    Is there a way to export the table of results as JSON/csv/excel or in some format that can be consumed by Excel?  (I know that I can replicate the functionality in DemandTools or other tools, but sometimes when I've thrown up a query for debugging, it would be really handy to be able to export and manipulate the results.)
40643
I need a dynamic solution to produce questionnaires from a database of questions which gets updated from time to time. I thought of LaTeX for set out the layout but the question is whether LaTeX can import specified fields of an Acces or Excel or whatsoever external "database".  I also thought about WORD Macros and .NET programming, but I preferred LaTeX.
59924
Someone was reviewing my DDL code for creating tables and suggested, when they saw I saw using VARCHAR(256) fields for text I expect to be pretty small, like a first name or whatever, that I should always just use VARCHAR(MAX) and linked . I read it but it seemed dated, as it was focusing on 2005, and didn't seem to offer any real justification to allocate potentially up to 2 GB per row on all text fields.   From a performance, storage, etc. standpoint, how should one go about deciding whether to use VARCHAR(MAX) or a smaller more specific type for modern versions of SQL Server? (e.g., 2008, 2012, 2014)
17130
I have the need to synchronize the data in certain Salesforce tables (user, account, opportunity, lead, task, contact, etc.) to a local database. For reasons that I won't go into here, I can't use the streaming API. I want to kick off a local process every X minutes that will:   Go through each of the tables on my list Insert any new records Update any existing records that were updated Delete any records locally that were deleted on the server (either deleted directly or indirectly (e.g. through a foreign key relationship, like when an account is deleted its associated tasks are deleted as well).   Can you please offer advice on what API's might be good to use here, and whether one stands out more than the others? Are there any specific design recommendations that might be useful for achieving this goal? Or is there really no practical difference between what REST vs SOAP can do?  It comes down to what is the easiest to maintain/implement? Is there some other route that might be beneficial to use (example: bulk data load to start out followed by outbound messaging tied to all of the objects in question to get updates/inserts/deletes)?   I am using C#/.net.
119820
I have a memory optimised table in SQL Server 2016, with file durability enabled. The table is only 100MB. SQL Server is constantly creating new files on disk, which start off at a few hundred MB, but then grow constantly until the drive runs out of space then they clear down and the process starts again. The files are growing at about 900MB an hour. Running the SQL below shows that all the space is in Precreated Data - so it's not even actually storing large amounts of data, just allocating space to use later.  SELECT state_desc, file_type_desc, COUNT(*) AS [count],    SUM(file_size_in_bytes) / 1024 / 1024 AS [on-disk size MB]    FROM sys.dm_db_xtp_checkpoint_files   GROUP BY state, state_desc, file_type, file_type_desc   ORDER BY state, file_type     File growth on the file group is set to unlimited, so I'm assuming I can set a value on this and stop it growing, but I can't find anything to say why it's allocating so much space in the first place. The data in the table does change very rapidly (a lot of inserts and deletes as the data is constantly processed, but it the data that isn't Precreated never gets over 4GB.  Is there a setting in SQL Server that controls this file precreation? Is it safe to set a limit on the autogrowth for the file group?
68361
I'm always looking for the best way to represent a file structure on my posts.  I generally use this one:  Project  |  +-- file 1  |      +-- dir 2  |  |    |  +-- file 2.1  |      +-- dir 3  |  |    |  +-- file 3.1  |  +-- file 3.2  |      +-- dir 4  |  |    +  |-- dir 4.1   Is there a real convention for those representations? Is there any script (Windows, Linux or web app service) that provide formatting?  Any advice / tool / recommendation / ISO ( ? ;) ) would be appreciated.  Some examples:
109855
(ArcGIS10, SP2, ArcInfo)  This is my model, and it works perfectly, but...    I do have a large amount of data to process. The interim output files (from raster calculator, collect value) would reach the capacity of my hard drive. Therefore, I cut my input shape file into tiles and want to run it on all tiles and just overwrite the interim output files which are create for each feature.   However, as we all know, the model builder does not allow using two iterators in one model.  I used to do this with the batch processing function ().   However, the cell statistics tool does not allow me edit the output location within the batch dialogue box (after right clicking on the model, batch).     The fields are greyed in the table and I cannot add further output locations. Thus, I cannot run the model on several input files.   I guess it is a buck of the combination of cell statistics and collect values. Only the combination of those two tools resulted in this problem.  Potential solution for my problem are:  • Fixing the problem with the output location within the batch dialogue box.  • Substituting the combination of cell statistics and collect values by anything else resulting in the same outcome.  • Using any other possible way to run a feature iterator on several feature classes (something like a nested iterator)  Any suggestions?
44536
Is there a way to export a table with selected records to an Excel spreadsheet?  I was trying to export just to .txt file but ArcGIS gives me an error message.     An error occurred exporting the table   The other problem I have is with coordinates. I want them only with one locus after the comma, I mean like the format: xx xx xx,x not like I have now xx xx xx,xxx.     The version of my software is 9.3.
6941
I often have to write up reports based on the analysis of some data. I use R to analyse the data and export tables, figures, and text. This is then included into a LaTeX document either using input or Sweave ().  However, when I collaborate with others, I sometimes need to provide a document in Open Office / MS Word format.  Question:  Thus, assume the simplest scenario   I have a LaTeX document with text, tables, and figures I need to export this reliably into Open Office or MS Word format: this includes mathematical formulas, table formatting, and quality figures) I don't need to go back from MS Word to LaTeX   What is a reliable, efficient, and preferably free process?  Initial Thoughts:   Export to HTML,  LaTeX - LyX - ODF Use odfWeave  that deals with some specific issues associated with LaTeX to Open Office conversion    I was hoping that there is an expert out there who has worked out a good system already.
118096
My company has recently exceeded our data storage cap (at 102% right now.. :/ ).  A large portion of the data that pushed us over our limit was due to an import of records.  The weird thing about this is that the records only had a couple of fields populated each out of the 200 total fields on the object.  What this tells me is that SalesForce holds the space for each field (since it knows the max-length of each field) rather than populating space only when the field is not null.  Does anyone know if this is the case?  To reiterate, and perhaps present this question more clearly:  If a field has a max character count of 1,000 and only 250 of those characters are actually being used, does SalesForce count the total data storage consumed by that field as 250 or 1,000?
17627
I am trying to import an Excel CSV into InDesign Data Merge. Everytime I try to export the csv, it appears in Data Merge as only one field, with fields separated by semicolons, although in Excel I have multiple, comma separated fields.  I've done this plenty of times and have never experienced this problem. I have checked the language and regional settings on my laptop and these are set as comma separated. I've tried to use a txt file version, but Indesign won't accept it. I am now very much stuck! any suggestions?
97807
I have been tasked to create a batch apex loader which parses a CSV file from an email attachment.  I will use an email handler to get the email with the CSV file attached, and then I will try to load the attachment, and go through it, and create a new object for each line in it.  The CSV file will be sent from an outside source, and it can contain a lot of long text in some of the columns. Even line-breaks, and quotes can appear in some of the columns.  Is there a good, readily available CSV parser class/library in APEX, that I could use? One that handles all the cases, where there could be separators, quotes, end of lines INSIDE a value? Also, I would like to be able to handle all kinds of international &amp; special characters.  I don't want to re-invent the wheel, and spend a lot of time on writing &amp; testing the parser, if there's something already out there.  Thanks