Search found 56 matches
- by ehersh
- Fri Jul 28, 2017 3:50 pm
- Forum: Community Forum
- Topic: checking flat bfile
- Replies: 1
- Views: 5993
We currently have a process of manually checking flat files for errors. We scroll all the way to the right. slowly moving down checking to see if any CRLF's are out of alignment. then if they are we fix that record. It may be a blank line, it may have a special character inserted etc. I know GOANYWH...
- by ehersh
- Mon Apr 24, 2017 11:58 am
- Forum: Community Forum
- Topic: copying files based on rowset
- Replies: 8
- Views: 15445
I was able to get back to this and I think I figured it out so thought I would share. If anyone has any suggestions of a better way to accomplish this I would be excited to hear about it. I used a nested for each loop. the outer loop will go through the file list. So for each file in the file list t...
- by ehersh
- Mon Apr 24, 2017 7:51 am
- Forum: Community Forum
- Topic: Reading excel spreadsheet past last row
- Replies: 0
- Views: 17828
I am reading an excel spreadsheet then I need to use the data. The spreadsheet has 113 rows. However I have a count rowset in it and the counts gives me 167 rows. When I set up a loop with a print it shows me the value of the column I am trying to use is ' '. None of the columns are blank. Any idea ...
- by ehersh
- Thu Apr 20, 2017 8:34 am
- Forum: Community Forum
- Topic: count rowset error
- Replies: 2
- Views: 21205
I figured it out thank you. I have a read excel that I had a file list on. The count rows was trying to count the rows in the file list instead of the row set. I removed the file list from the read excel and created a separate one then it worked, thank you.
- by ehersh
- Wed Apr 19, 2017 7:14 am
- Forum: Community Forum
- Topic: count rowset error
- Replies: 2
- Views: 21205
Any idea what could cause this error in a count rowset? : 8099 - Count RowSet] An unexpected error occurred. Your InputStream was neither an OLE2 stream, nor an OOXML stream . The column count works its just the row count that does not. the count rowset code is <countRowSet rowsetVariable="${newrow}...
- by ehersh
- Mon Apr 10, 2017 6:45 am
- Forum: Community Forum
- Topic: SFTP error
- Replies: 4
- Views: 16600
I believe we fixed it. We added the key exchange to the algorithm tab, thank you for your help.
- by ehersh
- Fri Apr 07, 2017 1:28 pm
- Forum: Community Forum
- Topic: copying files based on rowset
- Replies: 8
- Views: 15445
I am looping through the file list and I am getting an error. Below is my code. <project name="test file transfer" mainModule="Main" version="2.0" logLevel="debug"> <description>This job will read the test_file.xlsx spreadsheet customer column and load to file list</description> <module name="Main" ...
- by ehersh
- Thu Apr 06, 2017 4:49 pm
- Forum: Community Forum
- Topic: SFTP error
- Replies: 4
- Views: 16600
The SSH keys tab is blank. Which properties tab did you need to see?
- by ehersh
- Tue Apr 04, 2017 2:46 pm
- Forum: Community Forum
- Topic: copying files based on rowset
- Replies: 8
- Views: 15445
I am trying to just create a file list using the row parameter <readExcel inputFile="<path to>/Test_Files/transfer.xlsx" outputRowSetVariable="newrow" dataStartRowNumber="2" headingsRowNumber="1" version="2.0"> <data> <column index="3" name="column filename" /> </data> </readExcel> <createFileList f...
- by ehersh
- Tue Apr 04, 2017 10:33 am
- Forum: Community Forum
- Topic: SFTP error
- Replies: 4
- Views: 16600
Any idea what could cause the following error? We get it when we test the resource yet the file can be sent using FILEZILLA [8098 - SFTP] Session.connect: java.security.InvalidAlgorithmParameterException: Prime size must be multiple of 64, and can only range from 512 to 1024 (inclusive). Full stack ...