What is ZIPPYDOC?SupportZIPPYDOC is a platform which connects user groups and automises business processes. All our software solutions embed in the current working environment of the user. The platform is accessible within Excel, as Web App and as Mobile App. Users of the platform can access various data for business and research and a best-in-class suite of analytics tools which can be scheduled and run automatically. ZIPPYDOC also enables you to securely collaborate with your team members on complex analytics projects. You get to decide exactly what part of your data and analysis is shared, and you can even encrypt, control and, track it. With ZIPPYDOC, you don’t have to worry about data security or multiple file versions!
What is ZIPPYDOC used for?SupportZIPPYDOC is used to generate insightful analysis from your data. ZIPPYDOC’s powerful data wrangling and analysis features make data analysis simple and intuitive. Used as Web-Application you can work device independent and even work on mobile or tablet. The ZIPPYDOC Add-In for Excel adds significant productivity, plenty of tools and big data management capacities to Excel. By sharing your workflows with others, the ZIPPYDOC plattform is a marketplace for sharing data and data-analytic solutions. Furthermore, easy and robust scheduling of tasks allows to automize your business.
Whom is ZIPPYDOC meant for?SupportZIPPYDOC is meant for everyone who wants to work or collaborate with data. ZIPPYDOC’s tools are robust enough for deep numerical and contextual analysis for developers and data analysts, yet simple and intuitive enough for people with no previous background in data management and analysis. If you have ever struggled with Excel, or thought that it isn’t robust enough, ZIPPYDOC is for you!
What do I need to use ZIPPYDOC?SupportA Cellphone / Tablet / Laptop or Computer! With all of these devices you can access the ZIPPYDOC platform: https://zippydoc.de/en/ If you want to use the ZIPPYDOC Add-in for Excel you need one of the following versions of Excel: - Excel 2013 or higher on Windows - Excel 2016 or higher on Windows - Excel 2016 or higher on Mac - Excel 2019 or higher on Windows - Excel 2019 or higher on Mac - Excel on Mac (Microsoft 365) - Excel on Windows (Microsoft 365) - Excel on Web
How do I install ZIPPYDOC?SupportA. You can use ZIPPYDOC online as Web application (https://prod.zippydoc.net/#/login) or on your cellphone (https://prod.zippydoc.net/#/app). Here's how to add it to your Home Screen: B. If you want to use ZIPPYDOC within Excel (ZIPPYDOC Add-in for Excel) you have multiple installation options: 1) Download and install ZIPPYDOC from the Microsoft Office Add-ins Store (https://appsource.microsoft.com/de-de/product/office/WA200003023) (Microsoft ID required.) 2) Download and Install ZIPPYDOC from our website (https://zippydoc.de/en/download/) 3) Manually install ZIPPYDOC Excel Manifest (Windows or MacOS)
How do I launch ZIPPYDOC in Excel?SupportAfter you have downloaded an installed ZIPPYDOC, you will have to add it to your Excel. This is a one-time activity. The fastest way to launch the Excel Add-in is to go to the tab "Insert" and "my Ads-ins".Here you will see a list of Excel Add-ins on your system. Click on ZIPPYDOC to add it to your Excel.
How do I start using ZIPPYDOC?SupportAccess ZIPPYDOC online here: https://zippydoc.de/en/web/ Access ZIPPYDOC on your Cellphone here: https://zippydoc.de/en/mobile/ Access ZIPPYDOC within Excel after installation in the Microsoft Store: Once installed, the ZIPPYDOC add-in button will be available in the Home menu of Excel (if not search in "Insert" "my Add-ins"). Click this ZIPPYDOC button to launch the analysis suite.
Is ZIPPYDOC GDPR compliant?SupportFor ZIPPYDOC, privacy and protection of our user’s data is the highest. ZIPPYDOC is compliant with all data security and privacy requirements of The General Data Protection Regulation 2016/679. However, without limiting the foregoing statement, GDPR regulations must also be observed by the users. For instance, the user must evaluate if he remains GDRP compliant, when storing or sharing data with other users. Also, if you use tasks that connect to other services or are published by third party users you need to check GDPR compliance of the tasks you intent to use.
Where does my data go when I use ZIPPYDOC?SupportThe ZIPPYDOC plattform has been designed to provide highest data security for the users of the plattform. If you upload data to the ZIPPYDOC plattform, your data is stored encrypted and only decrypted for the short period of time of a task run limited to the data feed of the respective task. Data is securely transferred via SSL protocol from and to the user's device. ZIPPYDOC neither uses the uploaded user data, not does any ZIPPYDOC team member have access to it. Operations of ZIPPYDOC are fully outsourced to q.beyond (www.qbeyond.de), a trusted and leading operation provider.
How much does ZIPPYDOC cost?SupportThe Standard version of ZIPPYDOC is FREE to download, install, and use – no log-in required! Guest users enjoy a runtime capacity of 100 points for absolutely free. However, guest users do not have access to the full range of functionality of the Professional version, and can neither store data nor create scheduled workflows. The Professional version of ZIPPYDOC is available for users who complete the registration process and create a ZIPPYDOC account. With the Professional version, users get access to the full range of ZIPPYDOC’s feature. Furthermore, new registered users also get initial runtime capacity of 100 points for free. Additional points can be in accordance with our multiple prepaid and pay-as-us go plans (https://zippydoc.de/en/pricing/) Enterprise users who want to license a private cloud solution under their own operations control, please contact our sales team here (https://zippydoc.de/en/contact-us/).
Can I try ZIPPYDOC before purchasing it?SupportYes, absolutely! You can try the Standard version as a guest user. Guest users get runtime capacity of 100 Points for absolutely free! Please note that all Guest user data is deleted after 24 hours. However, the Standard version has limited functionality. To get access to the full functionality of the Professional version of ZIPPYDOC, complete the registration process, and receive an initial runtime capacity of 100 points for absolutely free! Get accomodated to your individual point-usage and purchase an appropriate point-budget.
Can I return the product?SupportOur pay as you go plans are charged only based on usage of the products. You will be billed at the end of the billing cycle. Our prepaid plans allow you to purchase a package of usage points, that can be redeemed for data processing and storage. Unused points expire at the end of the monthly billing cycle and cannot be returned.
What is the ZIPPYDOC Community?SupportThe ZIPPYDOC Community is a network of developers and data analysts, that create and share new ZIPPYDOC workflows. You can contribute to the community or request the community’s help for customized solutions for your data analysis requirements.
Where can I see my point balance?Kate YarmiiYou can view your available points in the user info section.
Can I add my own tasks to the platform?Kate YarmiiYes, you can create and add custom tasks to ZIPPYDOC. For our public cloud solution, the ZIPPYDOC team will review task proposals before deployment. However, for enterprise licenses, quality assurance and deployment of additional tasks remain with the client. More information is available here.
Is ZIPPYDOC making use of my uploaded data?Kate YarmiiNo, ZIPPYDOC neither uses user data nor does any ZIPPYDOC team member have access to it. Operations of ZIPPYDOC are fully outsourced to q.beyond, a trusted and leading operation provider. The user data is encrypted via SSL protocol and transmitted securely to the ZIPPYDOC backend, where it remains encrypted, and is only decrypted to run the task selected by the user. Depending on task run time, the time window in which the data exists in decrypted format can range from a few milliseconds to 6 minutes. Furthermore, the data in decrypted format only exists in the dedicated runtime environment, and is deleted immediately after task completion. This architecture ensures the highest level of data security and protection against data theft. This process is compliant with all data security and privacy features of Microsoft and runs on a Microsoft Azure cloud environment. Please view our data protection policy here.
Power Automate – How to get credentialsSupportIn an initial step, the user needs to create a connection between Power Automate and ZIPPYDOC.
Step1: Select the ZIPPYDOC connector
Step2: Specify the connection name. Enter the name of your choice e.g. "ZIPPYDOC Connector".
Step3: Retreive the API key within the ZIPPYDOC App (select "Get Power Automate Key" in user-menue):
Power Automate – Get started with your connectorSupportAfter having established a connection between Power Automate and ZIPPYDOC (see FAQ Power Automate - How to get credentials), you can start creating your integrated data flow. Find below examples of getting started.
A) Post a message on change of a ZIPPYDOC Table
Step 1: Add a tag to the ZIPPDOC table called "power-automate"
Step 2-4: Setup a Power-Automate Flow
- Step 2: Select ZIPPYDOC Trigger ON_TABLE_CHANGE trigger in Power Automate
- Step 3: Select ZIPPYDOC Action GET TABLE BY NAME or GET TABLE BY ID in Power Automate
- Step 4: Select the BODY of above selected Table to post it e.g. to a TEAMS channel.
Power Automate View of Step 2-4
B) Run a ZIPPYDOC Transformer on a Table
- Step 1: Select a Table within you Power Automate Flow
- Step 2: Upload the selected table into a ZIPPYDOC Flow by Selecting UPLOAD TABLE
- Step 3: Run the ZIPPYDOC Transformer by Selecting EXECUTE and specifying your ZIPPYDOC flow name
- Step 4: Get the resulting table by Selecting GET TABLE BY NAME
- Step 5: Use the transformed table in your Power Automate flow, e.g. to post it into an E-MAIL.
Compressed view of above Flow
Detail view of the single steps
Power Automate – Known issues and limitationsSupport
- The ZIPPYDOC service is not designed for high trigger frequencies. Please configure your connections with a trigger frequency of not less than 1 per second.
Power Automate – Common errors and remediesSupport
- In case not enough rescource usage points are available, the ZIPPYDOC service will return a PAYMENT_REQUIRED error. To overcome this issue, the user is required to either buy additional points https://zippydoc.de/en/pricing/ or to opt for a pay as you go payment model.
- The on table changed trigger is only executed, if the ZIPPYDOC notification table is tagged with the tag: power-automate
Power Automate – What actions and triggers are available?Support
Execute: Execute a flow specified by the ZIPPYDOC flow name. All tasks of this flow are executed in accordance to their top-to-down order.
Upload Table: Upload a table to a specified ZIPPYDOC flow.
Get Table By ID: Retrieve content of specified ZIPPYDOC table (using table id). The table is returned in JSON format.
Get Table By Name: Retrieve content of specified ZIPPYDOC table (using table name). The table is returned in JSON format.
On table changed: Get notification when a table content has been changed. The trigger is only executed, if the notification table is tagged with the tag: power-automate