1 of 1 people found this helpful
I just ran Andy's version (version 1.0) and it worked. Make sure you
- perform the workbook import
- Point your Tableau workbook at the Access database
- Refresh all extracts!
Great work Andy! I think this is a good tool to integrate with Tableau, if this ever comes up on ideas list, I'll definitely vote up, till then will give it a try.
I love this tool. One request I would love to see implemented is breaking out the dashboard from the rest of the sheets.
It would be helpful to narrow down what columns are used in what dashboards.
Just for the record since the post was created long ago. If you face Error 13 (Type mismatch) you can try to change one thing in (I refer to TWB v1.0 that I downloaded) function CheckTWBVersion. It helped in my case - original version of code was converting sting with dot ('.') into integer.
Function CheckTWBVersion(xmlTWB As MSXML2.DOMDocument60) As Boolean
' TODO - get the version. The Tableau Desktop build # is in
' an XML comment. There is also a "version" attribute in the
' <workbook> entity, but that doesn't correlate to build number
' Need to explore the older versions a bit...
Dim iMajor As Integer
Dim iMinor As Integer
Dim iFullVersion As Integer
Dim sVersion As String
Dim strError As String
On Error GoTo CheckTWBVersion_Error
sVersion = xmlTWB.selectSingleNode("workbook").Attributes.getNamedItem("version").Text
iMajor = CInt(Left(sVersion, InStr(1, sVersion, "."))) * 100
iMajor = CInt(Left(sVersion, InStr(1, sVersion, ".") - 1)) * 100
iMinor = CInt(Right(sVersion, (Len(sVersion) - InStr(1, sVersion, "."))))
iFullVersion = iMajor + iMinor
CheckTWBVersion = (iFullVersion >= MINIMUM_SUPPORTED_VERSION)
On Error GoTo 0
strError = "There was an error in function: CheckTWBVersion" & vbCrLf & "Workbook:" & g_WorkbookNameAndPath & vbCrLf & "Error " & Err.Number & " (" & Err.Description & ")"
If g_BreakOnErrors Then Call MsgBox(strError, vbExclamation, Application.Name)
LogSomething fnError, strError
CheckTWBVersion = False
1 of 1 people found this helpful
This thing is very cool. Thanks Andy Cotgreave for the original and Toby Erkson for the upgrade. We are using Tableau Server so What's in your workbooks? The TWB Auditor v2.1 works just fine on the workbooks we have stored in folders although I had to make a minor change to the DoTheAudit Function so it loaded twbx files rather than just twb files as follows.
lFileCount = ListFilesToTable(txtFolder, "*.twb", bSubFolders, True, False) 'Toby's Note: Should this "*.twb" be changed to "*.tw*"?
lFileCount = ListFilesToTable(txtFolder, "*.twb*", bSubFolders, True, False) 'Toby's Note: Should this "*.twb" be changed to "*.tw*"?
Using this tool is obviously so much better than manually trying to unpick where data is being sourced from and where the same fields are being used.
I'm new on the Tableau scene so if people are using other tools to trace data connections and field usage I'd love to hear about them.
The zip file does not have the access database - TWB Auditor - data.accdb.
Can you please provide a link to one which has the access database?
A simple Google search revealed this: MS/Access "recordset is not updateable" in Office 2010 but works in Office 2007
There are multiple answers there so you need to read them and try the simple ones first. This looks like the easiest to try (about mid-page):
I CAN'T BELIEVE IT! I've also had this problem since I changed to Office 2010, and it's frustrated me as much as anyone.
I just found my solution, and I can't believe how simple it was. Any location where you are updating data must be included in your TRUSTED LOCATIONS.
To add a trusted location from within MS Access 2010:
1) Click on File
2) Click on then Options
3) In the resulting window, Select 'Trust Center" on the left
4) Click the "Trust Center Settings" button.
5) Select "Trusted Locations" on the left side.
6) Use the "Add new location" button to navigate to the folder where your file exists. If you select a parent folder for many files, MAKE SURE you also check the "Subfolders of this location are also trusted".
One important final clue, if you are working with files on the network, make sure you select "Allow Trusted Locations on my network" in the trust center.
hi how to pull workbooks from server please tell me.???.its showing always errors..
Thanks Andy-- I have a feeling this is going to help me clean up a lot of files that I've been hanging on to... a little worried that they might be connected to other stuff.
Special kudos for your Access programming skills-- I've found Access and Tableau can be good friends!
I'm guessing .HYPER files (10.5) is not an issue because this is analyzing the TWB, not TDE?
hi michael please do think about my problem?
3 of 3 people found this helpful
Just to set expectations here & without speaking for Andy directly: With Andy's increased responsibilities we rarely see him here, I mean, his last login to the forums here was a year and a half ago! Also, this tool is close to three years old and software ages faster than dog-years. I don't use the tool so I no longer support it and I reasonably don't expect Andy to as well.
Something people with programming skills may want to check out is GitHub - tableau/document-api-python: Create and modify Tableau workbook and datasource files . The ability to GET information is why I think it may be helpful.