Sage 100

Anyone know how to export to csv without having a trailing comma at the end of each row using VI? They do not have access and excel will not handle their number of records. Clients wants to push nightly dumps to SalesForce.com

I use a Crystal Report scheduled on Task Scheduler to run with the free version of Logicity. I get no commas.

I don't have an answer but could you instead use Ascii or ODBC?

I thought about ascii but I think they want csv and odbc is out of the question. I guess crystal may be the option - I was just concerned with the number of columns.

Number of columns?

+1 for Logicity. Also, much faster than VI.

@MarkKotyla, did you mean that Crystal is much faster than VI? Also, Logicity is similar to Visual CUT, correct? Any major differences?

@BrettZimmerman Yes. I originally created a VI export of the days shipments, based upon Invoice History Detail (took approx. 30 minutes to generate the export file). Recreated the same export with Crystal/Logicity, and it takes about 5 minutes. I've never used Visual Cut, but the initial difference is $300. Logicity has a free version which works well, and a pro version. A comparison can be found at http://www.logicitysuite.com/products/logicity/16-pages/products/88-feature-comparison.html .

Note that using Crystal/Logicity as a Scheduled Task does require a silent DSN to bypass the login prompt, but only on the server. Although ""Command Line Variable Replacements"" is a nice feature in the Pro version, I've found that the same effect can be achieved by a small change to the report. Crystal's variable facility is stronger and since the report has to have the DSN changed anyway it's a no brainer.

@JohnnyPabian - Just to offer an alternative for future cases where Crystal / Logicity may not be an option (and in case this is one of those situations where you would need to squeeze in 85 fields for export in the report), one can create Perform Logic on the Export job that runs VB script that would strip the trailing commas off each line. You would set it up for Job Completion and use the * in the command line as way of letting you run bat files, scripts, and executables. Attached is a sample where the V/I export file is set to APVendorsFromVI.txt and when script gets kicked off it creates APVendorsNoTrailingCommas.txt (which you can upload to Salesforce.com)

@AlnoorCassim Very interesting - I was looking for a script last night thinking the samething. Trying the @DanBurleson logicity method it seems to work - 2 tables down - 2more to go.

Logicity is a good option in this case also because it sounds like you need to schedule an unattended upload of the file at night. Visual CUT is great too (very cool when you need to burst emails)