i have to open it to read its contents and parse it. On Appian cloud . readcsvlog is not reading contents.
Discussion posts and replies are publicly visible
The ".gz" implies that it's been compressed (similar to a "zip" file). I believe you will have to download the file from System Log Files and open it in a compressed file viewer that can handle gZip format - my suggestion would be the free utility 7zip.
Thanks Mike . You mean Advaced Unzip utility ? how to take a log from UI to download and unzip as file is on appian cloud and i can see it on /suite/logs.
Mike is talking about just downloading the file and unzipping it manually. Are you hoping to parse these logs using the log reader plugin? In the plugin page on the App Market, it says: "Does not load files outside the logs directory or files that do not end in .log.* or .csv.*." so I don't think you can parse those logs using the plugin.
Can you talk a bit more about your use case here? If you just need to retrieve the information from an old log file, it seems easiest to just download it once and unzip it. If you need to continuously return historical information on login data, you'd probably be better off creating a process that runs each day that parses the log and inserts all the login information into a database table that's easier to query.
Requirment is that i need to parse a week data on every Sunday. But appian cloud i dont have log acces , whatever i see in /suite/logs/ is login audit in zip format , only today logs i see in log format which i can read in readcsv log but not the zip logs of yesterday and day before. I have to read all one week log and insert in database to ise it further. I accomplished it in onprimise but cloud not working for me
As far as I've seen, log files in Appian are not gzipped until they're about a month old.
Talking about attached .
you are correct cross checked and yes one month after zips it, along with weekly data , first i need to push a year data . i am worried on that
I would recommend you run an automated process every night to handle the last day. You could probably even do this just once per week if you really need to. It won't work to wait for a year and then try to do it all at once.
Yes , that is the plan . Weekly sunday it will execute and insert the data but requirement is to insert 1 year data as well in beginning to start then every week PM will execute . We need historical data as well to start
You will probably want to develop an Appian process that parses CSV data you input manually (either via file upload or even copy-and-pasted raw data). First, download the GZ files, mass unzip them (i think 7zip can do this), then upload to Appian.
That can be one solution yes, i was thinking of something like it will check for file if it is in zip format unzip it then read contents and insert in logs. Can achieve the same in on premise as i know the location but for cloud i am not sure how to do it.
I don't believe there is a way, other than developing your own new custom plug-in to access arbitrarily-named files within the system log directory. This would admittedly be useful to many of us, so if you do I hope you'll publish it in the App Market.
Thank you , it was helpful . Will post if i come up with something .