I believe it's this item, as seen here.
Use GUID as the default session cookie name
I believe it's this item, as seen here.
Use GUID as the default session cookie name
I don't have any proof as I have not collected any data but I can say the following:
Many months ago, out disk was getting full with a Purge data setting of 4-5 weeks.
Then the disk was starting to get full again, and I reduced that further to a 10 days.
We have not added any additional data points during this time, and the disk is getting full again.
I just realized that the purge settings probably only affect the NoSQL database, but it's the H2 database that is causing us issues.
Can we reset this database cleanly and start again, which I imagine will hold up well for another number of years without trouble. I have instructions for how to delete and restore the database, but that also removes the configuration settings. Is is possible to remove only the data history while keeping the configuration?
What is the difference between core-database and configuration backups anyway?
Here's how I did it.
<!-- Get point values -->
<ma-point-values point-xid="hallsFanInletAirTemp" point="inletAir"></ma-point-values>
<!-- Create a way to manupulate point values to 12 previous hours and update. In this example, I am getting previous 12 hours at a 1 minute average. You only have to do this once -->
<ma-now update-interval="1 minutes" output="to"></ma-now>
<ma-calc input="to | moment:'subtract':12:'hours'" output="from"></ma-calc>
<!-- Manipulate the actual values of the point. This code can be multiplied for as many points as you want -->
<ma-point-values point="inletAir" values="inletAirValues" from="from" to="to" rollup="AVERAGE" rollup-interval="1 minutes">
</ma-point-values>
<!-- Display Chart -->
<ma-serial-chart
style="height: 500px; width: 100%"
series-1-values="inletAirValues"
series-1-point="inletAir"
series-1-color="green"
series-1-axis="left"
series-1-type="line"
legend="true"
baloon="false"
options="{
valueAxes:[
{
axisColor:'black',
color:'black',
title: 'Temperature °F',
titleColor: 'black',
minimum:-40,
maximum:140,
fontSize:26,
titleFontSize:26,
},
]
}"
>
</ma-serial-chart>
Try this to read a point, like the Voltage from your meter. You can get here from the Data Sources page. See my picture below:
Oh, your modbus settings have to match the meter, of course, like the bit rate, parity, etc.
One more thing, you have to turn off the serial data source to do the test, or else i'll throw an error because it's busy.
Oh sorry we are running core core 3.3.4 - MangoES.
Which backup should I restore, NoSQL or SQL. I am guessing SQL, but I know restoring NoSQL could also work, or am I wrong?
I have not tried to restore yet, so there aren't any other problems.
For some reason, during this particular time period, the data is not syncing.
Data Source:
MangoES
core 3.34
Data Destination:
Mango Enterprise
core 3.34
Data is sent through Mango Persistent TCP Sync.
Source Prior To Sync:
Destination Prior to Sync:
Syncing:
Log from Source:
INFO 2018-04-20T09:12:02,021 (com.serotonin.m2m2.persistent.pub.PersistentSenderRT.raiseSyncCompletionEvent:301) - Points: 159, sent 773 requests, synced 383631 records, target overcounts: 9, response errors: 0, elapsed time: 1m15s
Source Post Sync (I added more points):
Destination Post Sync:
select count(*) from pointValues; = 0
mrosu@22historian:~$ du -sh /opt/mango/databases/*
3.2G /opt/mango/databases/mah2.h2.db
4.0K /opt/mango/databases/mah2.lock.db
12K /opt/mango/databases/mah2.trace.db
47M /opt/mango/databases/mangoTSDB
1.2M /opt/mango/databases/mangoTSDBAux
12K /opt/mango/databases/reports
Synchronize history prior to is set at 1 minute.
I've taken a representative sample of points, and checked again today. It looks like all points are affected.
Here's the data again as of today, but with a lot more points.. Well if we cannot resolve this by May 3, it will be purged from the source. It's not the end of the world, but if you are interested in investigating it, it might help you find issues. I don't know if this is a problem on our end either.
Still at source:
Still missing:
Thanks Phil, we're back to a very reasonable database size.
Yep, that did it, thanks!
I am interested in upgrading the underlying OS from Raspbian 10 Buster to Raspbian 11 Bullseye on a couple of MangoGTs.
Would it be all right if I did this?
If I run into any issues, would it be covered by support?
Thank you.
@jared-wiltshire Ah I figured out what it is.
I expected the historian GUis to be native on HTTPS, but I forgot I let them be on HTTP...
The other issue is with my HAProxy, which I figured out as well.
What confused me is that I attempted to reach the GUI via HTTPs and thought they were down.
I think this probably happened since the last update, a few days ago. I forgot to double check the web GUIs at the time, but I did need to get to them today.
Devices Affected:
Normally I access them through an HA Proxy with LetsEncrypt, but I also tried with their regular DNS name too. I found this one error using the HAProxy, but not by dns name:
Only accessing by IP works.
Any idea how I can rectify this issue?
Is there any other information I can provide?
I'd like to upload .log files, but it says I do not have enough permissions.
Enterprise ma.log
INFO 2021-12-16T09:30:20,535 (com.serotonin.m2m2.Main.main:121) - Starting Mango 3.7.9 with Schema Version: 29
WARN 2021-12-16T09:30:21,236 (com.serotonin.m2m2.Main.loadModules:443) - Module dglux: this module requires a core version of 2.8, which does not match the current core version of 3.7.9. Module not loaded.
WARN 2021-12-16T09:30:21,464 (com.serotonin.m2m2.Main.loadModules:443) - Module jspViews: this module requires a core version of 2.8, which does not match the current core version of 3.7.9. Module not loaded.
INFO 2021-12-16T09:30:21,834 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'dataFile', v3.7.1 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,902 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'measurlogicDTSCell', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,914 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'twilio', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,929 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'http', v3.7.1 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,945 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'mqttClientDataSource', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,955 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'mangoESConfiguration', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,971 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'graphicalViews', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:22,014 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'onewire', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:22,027 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'egauge', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:22,041 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'mangoNoSqlDatabase', v3.7.1 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:22,057 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'excelReports', v3.7.1 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,382 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'BACnet', v3.7.1 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,395 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'controlcore', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,410 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'pop3', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,424 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'dataPointDetailsView', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,438 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'galil', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,448 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'dataImport', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,460 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'lang_en', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,464 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'zwave', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,531 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'TCPIP', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,547 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'pid', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,563 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'sqlds', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,579 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'pointLinks', v3.7.1 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,592 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'sstGraphics', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,651 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'persistent', v3.7.1 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,666 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'snmp', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,680 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'advancedComponents', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,685 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/advancedComponents/web/dox/manifest.xml
INFO 2021-12-16T09:30:21,703 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'scripting', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,715 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'sstTheme', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,720 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'deviceConfig', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,725 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/deviceConfig/web/dox/manifest.xml
INFO 2021-12-16T09:30:21,732 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'opcda', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,738 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'meta', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,749 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'dashboardDesigner', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,754 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/dashboardDesigner/web/dox/manifest.xml
INFO 2021-12-16T09:30:21,759 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'scheduledEvents', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,772 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'openv4j', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,778 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'mbus', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,790 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'log4JReset', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,796 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'ssh', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,809 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'reports', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,824 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'asciiFile', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,835 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'serial', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,847 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'mangoApi', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,863 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'virtualDS', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,878 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'loggingConsole', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,892 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'log4jDS', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,902 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'watchlists', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,927 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'mangoUI', v3.7.8 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,932 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/mangoUI/web/dox/manifest.xml
INFO 2021-12-16T09:30:21,976 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'envcands', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:21,988 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'templateConfig', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:22,002 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'pachube', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:22,011 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'sstGlobalScripts', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:22,024 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'modbus', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:22,036 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'sqlConsole', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:22,049 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'jmxds', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:22,060 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'dnp3', v3.7.6 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:22,074 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'jsonFileImport', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:22,084 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'vmstat', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:22,096 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'pakbus', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:22,107 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'maintenanceEvents', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:22,119 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'Haystack', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:22,132 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'internal', v3.7.0 by Infinite Automation Systems Inc.
INFO 2021-12-16T09:30:26,978 (com.serotonin.m2m2.Lifecycle.loadLic:582) - Checking license...
INFO 2021-12-16T09:30:27,275 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager
INFO 2021-12-16T09:30:29,558 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:38) - Starting instance with core version 3.7.9, schema v29
INFO 2021-12-16T09:30:29,558 (com.infiniteautomation.nosql.MangoNoSqlProxy.initialize:77) - Starting MangoNoSql Database
INFO 2021-12-16T09:30:29,659 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:144) - Database at /opt/mango/databases/mangoTSDB started
INFO 2021-12-16T09:30:31,273 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:173) - Empty dir delete for database at /opt/mango/databases/mangoTSDB took 1536ms
INFO 2021-12-16T09:30:31,295 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:234) - Corruption scan for database at /opt/mango/databases/mangoTSDB skipped because the database is configured not to run scan.
INFO 2021-12-16T09:30:31,302 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:144) - Database at /opt/mango/databases/mangoTSDBAux started
INFO 2021-12-16T09:30:31,332 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:173) - Empty dir delete for database at /opt/mango/databases/mangoTSDBAux took 0ms
INFO 2021-12-16T09:30:31,333 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:234) - Corruption scan for database at /opt/mango/databases/mangoTSDBAux skipped because the database is configured not to run scan.
INFO 2021-12-16T09:30:36,217 (com.infiniteautomation.system.SystemManager.createProcess:107) - Running command: sh -c chmod +x /opt/mango/web/modules/mangoESConfiguration/resources/scripts/linux/*.sh
INFO 2021-12-16T09:30:36,224 (com.infiniteautomation.system.SystemManager.createProcess:107) - Running command: sh -c chmod +x /opt/mango/web/modules/mangoESConfiguration/resources/scripts/linux/patchScripts/*.sh
INFO 2021-12-16T09:30:36,351 (com.serotonin.m2m2.rt.DataSourceGroupInitializer.initialize:77) - Initializing 5 NORMAL priority data sources in 8 threads.
INFO 2021-12-16T09:30:36,400 (com.infiniteautomation.system.MulticastDNSServiceDiscovery.startJmDNS:180) - Multicast DNS Service Discovery started on eth0 (eth0) with IP address 10.4.0.20
INFO 2021-12-16T09:30:36,600 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initializeDataSourceStartup:408) - Data source 22HistorianModbusPublisher took 247ms to start
INFO 2021-12-16T09:30:36,683 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initializeDataSourceStartup:408) - Data source LobbyHistorianModbusPublisher took 327ms to start
INFO 2021-12-16T09:30:36,717 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initializeDataSourceStartup:408) - Data source LBBY-DRYR-PLC-P1540-1 took 360ms to start
INFO 2021-12-16T09:30:37,293 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initializeDataSourceStartup:408) - Data source Alarms took 939ms to start
INFO 2021-12-16T09:30:38,773 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initializeDataSourceStartup:408) - Data source PersistentTCPSync took 2416ms to start
INFO 2021-12-16T09:30:38,789 (com.serotonin.m2m2.rt.DataSourceGroupInitializer.initialize:109) - Initialization of 5 NORMAL priority data sources took 2439ms
INFO 2021-12-16T09:30:38,789 (com.serotonin.m2m2.rt.DataSourceGroupInitializer.initialize:77) - Initializing 1 LAST priority data sources in 8 threads.
INFO 2021-12-16T09:30:40,493 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initializeDataSourceStartup:408) - Data source MetaDataSource took 1702ms to start
INFO 2021-12-16T09:30:40,593 (com.serotonin.m2m2.rt.DataSourceGroupInitializer.initialize:109) - Initialization of 1 LAST priority data sources took 1804ms
INFO 2021-12-16T09:30:40,667 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initialize:176) - Starting 0 Publishers...
INFO 2021-12-16T09:30:40,667 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initialize:188) - 0 Publisher's started in 5ms
INFO 2021-12-16T09:30:48,196 (com.serotonin.m2m2.web.mvc.rest.v1.BacnetDiscoveryRestController.<init>:54) - Creating Discovery Rest Controller
Yep, that did it, thanks!
Hi Jared, thanks for the assistance. I have the following issues / questions:
openjdk version "13.0.1" 2019-10-15
OpenJDK Runtime Environment AdoptOpenJDK (build 13.0.1+9)
OpenJDK Server VM AdoptOpenJDK (build 13.0.1+9, mixed mode)
As far as I can tell, the armv7l CPUs on the MangoGTs are 32-bit.
When I tried to look for a newer Java version on Oracle's sites, I see that there's not even any 32-bit arm versions, so I'm confused. Also, on here it says this version has been superseded. I cannot find even the OpenJDK 11 package for arm 32-bit.
I cannot figure out which newer version of java I should be installing that is compatible with 32-bit arm, except for Java 8. Can you please give me a bit more guidance on this issues?
I've updated the packages via apt just prior to doing the modules upgrade, as it is part of my monthly maintenance routine. I checked again and ca-certificates package is up to date.
I've completed this step.
I never had a store.url parameter existing, but I did add this to /opt/mango/overrides/properties/env.properties
store.url=https://store.mango-os.com
I restarted the mango service and the whole OS and am still having this issue. I guess it may be because I haven't update OpenJDK.
Thanks!
The modules cannot be updated on both our mangoGT devices due to this error:
"Error checking for upgrades — Invalid CertificateVerify signature"
core 3.7.7
This issue happens with the old and new interface.
No worries, much appreciated. =)
@mattfox said in Changing Data Source but Retaining Data Point History?:
&limit=10000
Since the last time we worked on this, this '&limit=10000" does not allow the page to load.
Anyway, the mango install just can't handle downloading an entire data set for even a single XID. The whole mango service comes to a slow crawl, as it pegs all cores to 100%. All screens can't reach the mango service, and in general is not ideal. And in the end, it still can't download it.
Plus how am I supposed to re-upload it. This download format is different than what you get using the watch list page downloads. Tn addition, the timestamp column appears messed up =( There are also not enough rows in excel for some of this data, I suspect, lol.
I will have to continue this conversation with IA.
As far as I can tell, there's no decent way, for the lay-man such as myself, to manipulate large amounts of data and other critical information. I suspect a lot of back-end work would have to be done to allow for such functionality.
My uneducated guess is that the whole structure is a bit rigid.
I'll keep putting this work off until a good solution appears, or I can get help directly from IA.
Okay awesome, I'll play around with stuff, see what works well.