How we can upload a data set from txt file using workbench 4 as we did on previous versions?
Best Answers
-
The latest version of Workbench is version 4, which includes the same functionality as 3, but has a brand new interface. If the txt file is delimited by a character, you can use the CSV file type to get it pulled in.
For step by step instructions on getting data from a CSV file through Workbench 4, check out the article in the Help Center titled "How do I connect to CSV data in Workbench 4?" You can get to the Help Center from your Domo instance by going to the main menu (down arrow in the top-right corner) and selecting the Help Center option. Then put the title above into the search.
Could you let me know if that information helps you out?
1 -
Is the Workbench service running using a user that has access to that network location? Also, it looks like the file you are looking for is on a mapped drive (O:). Depending on how the user is set up, it may not have that drive mapped for the service user. Can I suggest trying the UNC path instead of a mapped drive. For example, if O: is mapping to the shared folder "Data" on the server called "NetworkStorage", the UNC path would be "\\NetworkStorage\Data\Domo\Orders\OpenRequisitionsDataSet.txt"
1 -
The solution works! I just did little additional changes.
a. I used the IP address instead of the server's name on the transport method.
b. Additionally I missed to set up the impersonation piece (Domain,Username and Password) which allow me to access the server.
Thanks everyone for your help and specially to zcameron!
0
Answers
-
The latest version of Workbench is version 4, which includes the same functionality as 3, but has a brand new interface. If the txt file is delimited by a character, you can use the CSV file type to get it pulled in.
For step by step instructions on getting data from a CSV file through Workbench 4, check out the article in the Help Center titled "How do I connect to CSV data in Workbench 4?" You can get to the Help Center from your Domo instance by going to the main menu (down arrow in the top-right corner) and selecting the Help Center option. Then put the title above into the search.
Could you let me know if that information helps you out?
1 -
Thanks everyone for your help.
I used the CSV dataset type to import but it is not working. It works using previous Workbench version.
This below is the error message and after [ERROR] you can see the log.
Any idea?
Thanks.
[12.14.15 05:56:48] Requesting CSV source file from the Local File Provider
[12.14.15 05:56:48] Loading local file provider properties
[12.14.15 05:56:48] Loading CSV file: O:\Domo\Orders\OpenRequisitionsDataSet.txt
[12.14.15 05:56:48] Source file 'O:\Domo\Orders\OpenRequisitionsDataSet.txt' does not exist[ERROR] [10576:1] 2015-12-14 17:56:48,749 - The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.
System.ServiceModel.CommunicationObjectFaultedException: The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.Server stack trace:
at System.ServiceModel.Channels.CommunicationObject.Close(TimeSpan timeout)Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at System.ServiceModel.ICommunicationObject.Close()
at Workbench.DataCollector.Program.Main(String[] args) in c:\jenkins\workspace\Workbench\WorkbenchBuild\Workbench.DataCollector\Program.cs:line 1281 -
Is the Workbench service running using a user that has access to that network location? Also, it looks like the file you are looking for is on a mapped drive (O:). Depending on how the user is set up, it may not have that drive mapped for the service user. Can I suggest trying the UNC path instead of a mapped drive. For example, if O: is mapping to the shared folder "Data" on the server called "NetworkStorage", the UNC path would be "\\NetworkStorage\Data\Domo\Orders\OpenRequisitionsDataSet.txt"
1 -
The solution works! I just did little additional changes.
a. I used the IP address instead of the server's name on the transport method.
b. Additionally I missed to set up the impersonation piece (Domain,Username and Password) which allow me to access the server.
Thanks everyone for your help and specially to zcameron!
0 -
I'm seeing the same error messange, however, the .csv file I'm trying to upload is saved on my local C drive so I definitely have access. I also tested and it says that the impersonation credentials are valid. Any idea on how to fix this?
Much appreciated!
[ERROR] [5116:1] 2016-03-03 16:37:20,572 - The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.
System.ServiceModel.CommunicationObjectFaultedException: The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.Server stack trace:
at System.ServiceModel.Channels.CommunicationObject.Close(TimeSpan timeout)Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at System.ServiceModel.ICommunicationObject.Close()
at Workbench.DataCollector.Program.Main(String[] args) in c:\jenkins\workspace\Workbench\WorkbenchBuild\Workbench.DataCollector\Program.cs:line 1480 -
Depending on where the file is on the C:, the user may still not have access to it, especially if it is in a user's folder (documents, desktop, etc.). I think it would be a worthwhile test to change the user that is running the workbench service to a user that has access to the specific folder that you're pulling from (maybe try your own to start with). You can do this by going to Administrative Tools -> Services -> Domo Workbench Service and by putting in specific credentials on the login tab.
Let me know how that goes.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive