SS&C Blue Prism Community

JongjongOclari1 · 15-02-21

Hi Everyone -Does anyone encountered this issue whenever a process is opening a csv file using the ms excel vbo open workbook action the format of the date changes, but when i open the file manually it does not change the date format. Any idea's or a...

JongjongOclari1 · 22-12-20

Hi All, Is there a way to do a bulk insert into MySQL table. Thanks------------------------------Jongjong Oclarit------------------------------

JongjongOclari1 · 16-02-21

Hi Everyone -I think my logic here is wrong when I use excel action on getting data since I am getting data from a csv file I should use the action from Utility File Management and Utility string vbo and not the excel.Cheers.------------------------...

JongjongOclari1 · 23-12-20

Hi Guys, Thanks for the reply I will try your suggestion once i will get the data from a file. For now i will use this line of code below as data needs to be validated first. INSERT INTO projects(name, start_date, end_date) VALUES ('AI for Marketing...

SS&C Blue Prism Community

User Statistics

User Activity

Date Format in CSV file changes when opened in excel

Bulk Insert into MySQL Table

RE: Date Format in CSV file changes when opened in excel

RE: Bulk Insert into MySQL Table