Error occured while creating a mount smb:///
I am encountering a error with my file writer snap while trying to write to a file share on a different server. The error is as follows: Error occured while creating a mount smb:///. I dont think this is a permissions issue as I have granted access to the account I am using on the server I am trying to write to. That got me past an access denied error that I had encountered earlier in testing. I am also open to any suggestions you may have to help me better troubleshoot. Thank you for any help in advance, it is greatly appreciated!8.6KViews0likes9CommentsRemote file renaming/moving
Hi, I have a requirement to push a file to SFTP server. But since the file is quite large and to avoid race condition (we writing and remote function reading at the same time) we like to write the file with different extension or to a temp folder in remote server and them rename or move the file at the server. None for the File snaps support these feature. Could you please help me identify a way around to address above problem.7.4KViews1like13CommentsWriting Zip Files to S3
I am encountering some severe sluggishness in writing zip files to S3. When writing a 76 MB file, it takes 12 minutes to complete, versus 16 second when writing to a local destination. I think the problem is in transferring from ground to cloud. This process is part of a generic file transport solution, so the read file snap is being executed on a groundplex, and the write file snap is being executed on the cloudplex. This switch is done by a pipeline execute snap specifying execution on the cloudplex. I’m thinking it is possible the issues are cause by the conversion from binary to document and then back to binary once the document stream is passed into the child pipeline. Has anyone else run into similar issues? I am happy to provide an outline of the pipeline if that helps. Thanks.6.4KViews1like5CommentsNeed to create a text file
Hi We need to create a text file to send to a third party, but snaplogic does not appear to have the ability to create a text file I’ve had look at online, and only found 1 post that said to export it into a txt file you need to use a csv formatter Tried this, and the file in snaplogic manager says ABC.txt, but when I download it, its ABC.csv Is there a way to create a text document with Snaplogic? I’ve created a view that creates the lines for the file, already in CSV format, and all I want to do is save that to a txt file ThanksSolved6.2KViews0likes5CommentsAppend data to csv file with out repeating the header row
hi there, i am trying to append all the records for the day to that days CSV file which has date in the file name. all works fine, if it doesnt fnds the file for the day it creates the file. if it finds the files then it appends the data to the file. But one thing is keeps adding the column names as well to the file. How can i have the only data be appended and not the column headers? Thanks Manohar5.7KViews0likes4CommentsFixed Width Formatter always adds one blank line
I’m using the Fixed Width Formatter snap to create a .txt file with one line in it, but it always writes the file with one extra blank line at the end. I tried adding the Head snap using 0 offset, 1 number of documents and tried 1 offset, 1 number of documents. Still didn’t work. Does anyone know how to prevent the one extra blank line?5KViews0likes4CommentsAccessing Jks(Java Keystore) file in Script
Hi All, I want to retrieve the private key stored in Jks file using the java KeyStore class in script snap. I have uploaded the Jks file in the files section of my project. Now, using the FileInputStream I try to load the jks file in Script snap, but I always get the error that “No such file or directory found”. I have tried various permutations for the file path but in vain. Could someone help me and suggest what should be the file path. Or is there any other way to read the Jks file. Below is my python script code : keystore=java.security.KeyStore.getInstance("JKS") keyPassword="123456" charArray=list(keyPassword) stream =java.io.FileInputStream("sldb:\\\MyFile.jks"); keystore.load(stream,charArray)4.5KViews0likes2CommentsWriting files to on-premise servers
I am trying to write a file that gets created in a pipeline to one of our on-premise servers (i.e. sftp://ourschool:22/directory/filename.txt) and am getting the following error message: Unable to create filesystem object for sftp://ourschool:22/directory/filename.txt, Reason: Failed to get SFTP session connected Has anyone had any luck with this. I am trying to login with Basic Auth (username and password).4.1KViews0likes5CommentsHow to add a custom Header in a file?
Hi, I am reading some table data from a SQL Server (‘SQL Server - Execute’ snap) and writing the output to a text file (‘File Writer’ snap) (using a ‘CSV formatter’ between he above snaps) ‘SQL Server - Execute’ → ‘CSV formatter’ → ‘File Writer’ Requirement I don’t need the SQL column name name as the header ==> I am able to achieve this by unchecking “Write CSV header” in ‘CSV Formatter’ But I need a new heading (instead of the column name) which is would be the “number of records returned by the SQL query”. i.e. If the SQL query returns 99 records, the file should look like 99 Row 1 Row 2 Row 3 … … Row 99 Any help on how can I achieve this is appreciated. Thanks!Solved3.6KViews0likes2Comments