Excel Tools

• Import CSV to Database
  
  In this smart service if the last columns has no data in csv and so not delimited it seems to populate data with previous record data. Can this be corrected to populate null/empty value in the database.
  
  This would be helpful to not have random data populated for the parsed records into database.

Did you find any way to execute this requirement?

Has anyone used the queryAppianLogs function to select a count from the files with a group by and a where condition ?

No matter what I try I'm getting a null value return ... using the query without the group by returns data, using the count without the where also returns data but when combining the two together to get a simple count from the removed processes log where the timestamp is today returns nothing.

Is this is a feature of the plug in ? We're using 2.5.0 

Any hints / tips would be appreciated. 

Thanks 

Paul

Hi,

We have a Appian 24.1, is this plugin compatible for this version?

We are facing issues while performing export of records. It is not downloading the file even after clicking the Export option. Also, do you any recommendations on how many records we need to download at a time

Team,

I am using the smart service - Import Excel to Database - in one of my development projects to read an excel files and write the values as-is to the database tables. The excel file is huge and is having 2 sheets that contains data to be written to 2 different table. As per the implementation, I have created 2 different tables for storing this information and the excel column names and table column names were specifically mentioned along with the mandatory information required for the smart service to work.

Data is getting written into the database table, but not fully. The first sheet has 83621 rows (out of 83625), and the second sheet has 137738 rows (out of 137742) of data that needs to be written to the database table. The batch size of the smart service is configured as 1000. After successful execution of the process model, I could see that the 82994 rows were written from the first sheet and 136994 rows were written from the second sheet of the excel file.

I believe it is something related to the batch size, as I modified the batch size from 1000 to 500 and the number of rows processes got changed to 83494 and 137494 respectively, which is 500 rows more than what was the previous outcome. Further, I reduced the batch size to 100 and the number of rows processes got changed to 83594 and 137694 respectively, which is again 100 more than was the previous outcome.

Because of this issue, we are not able to extract the data completely from the excel files. Kindly help me in resolving this issue.

Is there a way in this plugin by which we are able to get the sheet name (tabs name) in the excel spreadsheet from this smart service ?

• Added support for PostreSQL.

Hi Team,

I am using plugin html to csv. In converted csv file one of the column which has date value shows as "####".

Could you please advise if we can avoid this and values can be visible to user. ?

Hi there, is there any known problem about concurrency? We have checked that when we execute 2 processes concurrently that call the CSV to DB smart service, it fails due to an SQL exception, but if we relaunch every single failed process model, it can process with no problem. It seems that the plugin cannot manage more than one connection on the same time.

• Upgraded Commons Compress Version