After testing my app with Instruments I realized that the current CSV parser I use has a huge memory footprint. Does anybody have a recommendation for one with a low memory footprint?
How can I plot (a 3D plot) a matrix in Gnuplot having such data structure. I cannot find a way to use the first row and column as a x and y ticks (or to ignore them)
,5,6,7,8
1,-6.20,-6.35,-6.59,-6.02
2,-6.39,-6.52,-6.31,-6.00
3,-6.36,-6.48,-6.15,-5.90
4,-5.79,-5.91,-5.87,-5.46
Is the splot 'data.csv' matrix the correct parameter to use ?
Anyone know of a command-line CSV viewer for Linux/OS X? I'm thinking of something like less but that spaces out the columns in a more readable way. (I'd be fine with opening it with OpenOffice Calc or Excel, but that's way too overpowered for just looking at the data like I need to.) Having horizontal and vertical scrolling would be great.
I am currently using fgetcsv in php to get rows in CSV file. For each row, I need it's 3 previous rows and 3 next rows for some requirement.
while(($data = fgetcsv($handle, 5000, ",")) !== FALSE) {
//$data is current row data
//I need previous rows and next rows data
}
I don't know how to try this, as each while iterate will be having the current row's information.
Is there anything we can achieve this within the fgetcsv loop? I am also open for other alternatives for this problem.
Currently I am using ctype_alnum to check for alphanumeric type in csv file. But one of my data has white spaces between them and so ctype_alnum gives me false.
Example: ctype_alnum("Here is 23");
So my question is how can I check for white spaces in string in php ?
I have a MySQL database from a Joomla MultiSite installation where it has a set of tables with different prefixes for each Joomla site. When I export the db via phpMyAdmin it creates a SQL file where the tables are created and populated in alphabetical order. The problem is that the tables for the slave sites have dependencies on the tables for the master site, but alphabetically their prefixes are ahead of the master site. So the export works fine but when I try importing I get error after error and have to manually move sections around in the SQL file to make sure that the dependent tables are created/populated first.
So, is it possible toexport a db via phpMyAdmin with the tables in a specific order?
I have a very strange effect when using subclipse with eclipse. Whenever I use Team-Export toexport a file from the editor the export works fine, but the label of the tab of the file is removed.
Effect can be seen here: http://www.daspferd.de/img/tabs.png
Strangely enough it happens with php-files, css-files, html-files but NOT with javascript-files. So I'm assuming it's some kind of setting that I haven't found yet and not a bug in subclipse.
Anyone know where I can shut down this behaviour?
How would I go around creating a MYSQL table schema inspecting an Excel(or CSV) file.
Are there any ready Python libraries for the task?
Column headers would be sanitized to column names. Datatype would be estimated based on the contents of the spreadsheet column. When done, data would be loaded to the table.
I have an Excel file of ~200 columns that I want to start normalizing.
Outlook 2003 and Outlook 2007 allow you toexport your contacts toCSV format. Is there a difference between the two or is this in fact the same format; in other words, are they backward compatible or did Outlook 2007 create some new fields that Outlook 2003 would have trouble importing?
Hi Experts,
I am having an issue with importing a large(60MB) CSV file in MYSQL DB.
The problem arises when an address field has multiple comma seperated values e.g. home no, street no, town etc.
I tried to use BigDump for it but, the problem did not solved because of a single field containing multiple comma separated values.
Any idea, suggestion or solution from experts how to handle it?
Please reply, because I am sick of it.
Thanks
I would like toexport some records from an EndNote (reference management software) library and import into a MySQL database. Does anyone have any experience with this? I've tried creating custom EndNote "output styles" containing either comma-delimited values or even SQL code, but have had mixed results, either because EndNote filters out some characters (like `) or because EndNote doesn't (or I can't work out how to make it) escape text, which might include characters like ' and ". I realize this might be a bit off-topic but any help would be appreciated.
We use a SharePoint wiki* at the office to serve as a knowledgebase for our IT operations. Recently we went through a disaster recovery exercise where we realized we had a key hole in our plans: how do you restore the services if your instruction manual is down because some services are offline?
Anyhow, we did realize that the wiki angle was definitely something we wanted to keep, but rather that we should explore a way to create offline backups of the wiki which could be easily read using common software we should be able to setup without any knowledge from the wiki.
So, does anyone know of a good utility that can take a SharePoint wiki and dump it to PDF/Word/RTF/[INSERT HUMAN FRIENDLY FORMAT] easily from the command line?
*-Yes, there are better solutions out there. But this was easy and used existing infrastructure and generally does what we need it to do.
What I need:
I have an existing SSL certificate installed on IIS 6. On the same machine, I have GlassFish installed and would like to share the same certificate since they both share the same hostname, and they use different ports: IIS uses 443 and GlassFish uses 8181.
Why I need it:
Reuse existing SSL certs from IIS to GlassFish. I imagine that this is possible. I am able to install an SSL cert into GlassFish's keystore, and then import the same exact cert into IIS. I just want to go the other way - imagine having an SSL cert on IIS being used for months, and now I want to enable SSL on GlassFish.
What I have done:
Created a keystore with an alias:
server.hostname.com
Imported
intermediate CA certs associated with
the existing SSL Cert
Imported the
existing SSL cert with the same
alias: server.hostname.com, but the
keytool won’t allow this, as it is
not associated: keytool error:
java.lang.Exception: Public keys in
reply and keystore don't match Why?
Using a different alias causes the
cert to not be trusted in the CA
chain.
What I need:
I have an existing SSL certificate installed on IIS 6. On the same machine, I have GlassFish installed and would like to share the same certificate since they both share the same hostname, and they use different ports: IIS uses 443 and GlassFish uses 8181.
Why I need it:
Reuse existing SSL certs from IIS to GlassFish. I imagine that this is possible. I am able to install an SSL cert into GlassFish's keystore, and then import the same exact cert into IIS. I just want to go the other way - imagine having an SSL cert on IIS being used for months, and now I want to enable SSL on GlassFish.
What I have done:
Created a keystore with an alias:
server.hostname.com
Imported
intermediate CA certs associated with
the existing SSL Cert
Imported the
existing SSL cert with the same
alias: server.hostname.com, but the
keytool won’t allow this, as it is
not associated: keytool error:
java.lang.Exception: Public keys in
reply and keystore don't match Why?
Using a different alias causes the
cert to not be trusted in the CA
chain.
Anybody know how I can convert my Firefox Bookmarks to a Mediawiki Wiki page?
I've tried exporting the Firefox Bookmarks to HTML and then entering that HTML into the wiki page that markup isn't recognized by Mediawiki.
Hi All,
All I need is to have an Excel list of file paths and use Powershell to append (not replace) the same extension on to each file.
It should be very simple, right? The problem I'm seeing is that if I go input-csv -path myfile.csv | write-host I get the following output:
@{FullName=C:\Users\jpalumbo\test\appendto.me}
@{FullName=C:\Users\jpalumbo\test\append_list.csv}
@{FullName=C:\Users\jpalumbo\test\leavemealone.txt}
In other words it looks like it's outputting the CSV "formatting" as well.
However if I just issue import-csv -path myfile.csv, the output is what I expect:
FullName
--------
C:\Users\jpalumbo\test\appendto.me
C:\Users\jpalumbo\test\append_list.csv
C:\Users\jpalumbo\test\leavemealone.txt
Clearly there's no file called "@{FullName=C:\Users\jpalumbo\test\leavemealone.txt}" and a rename on that won't work, so I'm not sure how to best get this data out of the import-csv command, or whether to store it in an object, or what.
Thanks!!
local_machine:$> ssh myself@external_machine_ip_address -p specific_port -X
external_machine:$> echo $DISPLAY
localhost:10.0
external_machine:$> emacs
Warning: Cannot convert string "-*-courier-medium-r-*-*-*-120-*-*-*-*-iso8859-*" to type FontStruct
Warning: Cannot convert string "-*-helvetica-medium-r-*--*-120-*-*-*-*-iso8859-1" to type FontStruct
I do see the emacs window, but I can't see any of the characters. What could be the error ?
Hi guys!
I'm faced with needing access for reporting to some data that lives in Oracle and other data that lives in a SQL Server 2000 database. For various reasons these live on different sides of a firewall. Now we're looking at doing an export/import from sql server to oracle and I'd like some advice on the best way to go about it... The procedure will need to be fully automated and run nightly, so that excludes using the SQL developer tools. I also can't make a live link between databases from our (oracle) side as the firewall is in the way. The data needs to be transformed in the process from a star schema to a de-normalised table ready for reporting.
What I'm thinking about is writing a monster query for SQL Server (which I mostly have already) that will denormalise and read out the data from SQL Server into a flat file using the sql server equivalent of sqlplus as a scheduled task, dump into a Well Known Location, then on the oracle side have a cron job that copies down the file and loads it with sql loader and rebuilds indexes etc.
This is all doable, but very manual. Is there one or a combination of FOSS or standard oracle/SQL Server tools that could automate this for me? the Irreducible complexity is the query on one side and building indexes on the other, but I would love to not have to write the CSV dumping detail or the SQL loader script, just say dump this view out toCSV on one side, and on the other truncate and insert into this table from CSV and not worry about mapping column names and all other arcane sqlldr voodoo...
best practices? thoughts? comments?
edit: I have about 50+ columns all of varying types and lengths in my dataset, which is why I'd prefer to not have to write out how to generate and map each single column...
In my C# windows application, I am exporting sql server data to excel on remote drive. But it is too slow.
However, if I export data to excel in the local drive, it is fast.
How can I increase the time if I want toexport data to remote drive?
Thanks in advance...
I have an sql query with sql datareader. i put a for loop for the data reader. now when the data starts coming in from the query i want it toexportto excel in the for loop.
here's my code
Try
Dim SqlStr As String = "", dr As SqlDataReader = Nothing
ConnectDB(Cnn)
Str = "query"
SqlCmd = New SqlCommand(Str, Cnn)
dr = SqlCmd.ExecuteReader
while dr.read
..EXPORTTO EXCEL
do
end while
does anyone know how to do this?
With cvs one can export the files that have a specific tag and get no cvs meta data included such as with this command:
cvs -z3 -d:ext:[email protected]:/cvsroot/emle export -R -r BL0123 -d emle030205_BL0123 emle
What is the corresponding bzr command where the launchpad.net branch is lp:emle and the tag is BL0123?
I am trying toexport files from Zend Studio's "SVN Repositories" perspective that belong to a revision number, but the studio exports all the files form other revision number as well.
Maybe this is because the target directory is empty. Can anyone help me on how toexport files from one revision number only, not all?
Is there any data export framework in .net or something.I have need to device a tool kit toexport legacy and data from older/legacy application to the new application under development,there are around three similar systems.To give you an idea the three have employee table.Is there any framework or dsl tool for this? Or I have to come up with all the code? How do you guys do it when you have customers whom you want to migrate to the new product ?
Is there any data export framework in .net or something.I have need to device a tool kit toexport legacy and data from older/legacy application to the new application under development,there are around three similar systems.To give you an idea the three have employee table.Is there any framework or dsl tool for this? Or I have to come up with all the code? How do you guys do it when you have customers whom you want to migrate to the new product ?