Zoho DataPrep and File Pattern configuration

Zoho DataPrep and File Pattern configuration

I'm using Zoho data prep to ingest data from One Drive into Zoho Analytics...
The pipeline is super simple but I can't any way to get all the files that I need. Basically I need to bring all the files with a certain pattern and for that I'm using a regex expression on the source configuration.
My files are called with this format YYYYMMDD_HHMMSS_CONTACT and YYYYMMDD_HHMMSS_ACCOUNT_CONTACT

For example
20241115_050104_CONTACT
20241106_050120_CONTACT
20241003_050129_ACCOUNT_CONTACT
20240918_112048_ACCOUNT_CONTACT 

The pattern for ACCOUNT_CONTACT is working perfectly with .*ACCOUNT_CONTACT.json

But I can't use the same strategy for CONTACT because it will bring also ACCOUNT_CONTACT, so I tried to validate that the previuos character is numeric but it's not working as expected.



Also I tried a different pattern to match with the format YYYYMMDD_HHMMSS like this 
[0-9]{8}_[0-9]{6}_CONTACT.json

The weird part is but scenarios are able to read some files but it ignore the majority.

I will appreciate ideas about why it can be block because I'm really stuck with this.

thanks in adavence!!

    • Sticky Posts

    • How to Add Users to your Organization in ZohoMail?

      A better clarity so you can create other users to start using Zoho Mail. You can directly Add Users from the Control Panel to your Organization. You can invite users with the existing email address. If the person (user) already uses ZohoCRM, then you can import users from Zoho CRM. You can also import them using a .csv file. (if you are planning to add them in Bulk)  In this topic, We will be discussing on how to Add and Invite users only.  The Import options are self explanatory. ____________________________________________________________________________________________________________

    • Recent Topics

    • Not able to import transactions from Razorpay

      Hi, tried implementing Razorpay integration with books,also added a webhook, but while this added a razorpay clearing account it does not have any data in it. Neither is it getting updated with new transactions happening on Razorpay. This problem is compounded

    • **Building Role-Appropriate Accountability Layers in Zoho Projects - Looking for Real-World Experience**

      We're a small ISP/telecom operator on Zoho One and I'm trying to solve what I think is a common organizational problem. Would love to hear from others who've tackled it. **The Core Problem** Staff will only consistently use a project management system

    • Zoho Social API for generating draft posts from a third-party app ?

      Hello everyone, I hope you are all well. I have a question regarding Zoho Social. I am developing an application that generates social media posts, and I would like to be able to incorporate a feature that allows saving these posts as drafts in Zoho Social.

    • Choosing the Right Automation in Zoho Projects

      In any project, different types of actions are needed at different points. Some projects require control on how tasks move, some require reacting to updates, and some require executing additional actions beyond the task. Automation in Zoho Projects is

    • Ignroe_filtrers and drill through

      I have two charts, where one is connected to the other using drill-through. The issue is with the second chart (the drill-through target). It contains an aggregation formula that uses the ignore_filters function. Under normal conditions, the formula works

    • Dropshipping Address - Does Not Show on Invoice Correctly

      When a dropshipping address is used for a customer, the correct ship-to address does not seem to show on the Invoice. It shows correctly on the Sales Order, Shipment Order, and Package, just not the Invoice. This is a problem, because the company being

    • Cancelled Transfer order problem

      Hello, We've canceled a transfer order, and we can't add the related items to a new Transfer Order. The system tells us that the bin doesn't have the required quantity, but when we check the item, it indicates that there are 2 units in the bin. It also

    • Sales Allowed Beyond Available Stock and Payment Recorded Without Restriction

      Hi, While testing in Zoho Inventory, I noticed that a sales order can be created with a quantity exceeding the available stock in the selected warehouse. In my case: Available stock: 5 units Ordered quantity: 6 units Despite this: I was able to convert

    • Zoho Sign Webhooks Security

      in Zoho Sign, what protection is in place - if any - so that the receiving endpoint can verify the authenticity of the sender (Zoho DC / app). otherwise anyone knowing the https address of my endpoint can forge the request. webhooks signatures would be

    • Issue with attaching files to a task through the API

      Hello! I've implemented a function that creates a task for every new bill that is created but I haven't been able to attach to the task the files which are attached to the bill. I have encountered multiple errors but the most common one is error 33003:

    • E-Invoicing Automation

      Do you have an API endpoint for pushing the invoice through the e-tims for Kenya

    • Can I write a check in Zoho Books with no associated bill?

      This currently does not seem possible, and I have a client that desperately needs this function if I am able to convert them with Quickbooks. Thank you in advance for your reply. 

    • Backorder process review - Automating Removal of Sales Order from "On Hold" When PO is Received

      Hello Zoho Inventory Team, Currently, sales orders in On Hold status are released only when the bill for the purchase order is created. In our workflow, it would be much more efficient if the sales order could automatically move out of On Hold as soon

    • Zoho Inventory - Managing Items With Multiple Suppliers

      Hi community, I'm working on a project at the moment for a car parts wholesale business. Each Item (part) has its own original manufacturer part number (sometimes more than one part number for the same item). When purchasing parts from 3rd party suppliers,

    • Gear up for the Zoho Finance & Operations Workshop 2026! [India]

      Hello everyone! 👋 We're excited to announce that the Zoho Finance & Operations Workshop 2026 is now underway! As our global community continues to grow, we’re expanding our locations to connect with users around the world—giving you more opportunities

    • Introducing the Zoho Books/Invoice Integration

      Recruitment doesn’t end with a successful hire. That’s usually when billing begins, and for most teams, that still means switching systems, re-entering data, and manually aligning numbers. This disconnect between hiring and billing often leads to delays,

    • Problem with local database connection to Zoho Analytics On Premise

      For days now I have been trying to connect my local database to Zoho Analytics On Premise, but it won't let me. No one from Zoho support has been able to help me, in fact I did connection tests with the cloud version and it allowed me to make the connection,

    • Record-Level Cliq Conversations Inside Zoho CRM

      It would be extremely useful to bring the Zoho Projects + Cliq conversation experience into Zoho CRM records. Today, in Zoho Projects, each project or task can have its own related chat conversation through Cliq, allowing team members to discuss that

    • Blueprint transitions on locked records

      We use the ability to automatically lock records (quotes, sales orders, etc.) based on criteria, such as stage. For instance, if a quote has been sent to a client, the quote is then locked for further edits. Our ideal quote stage process is: Draft>Sent>Won.

    • Email from CRM being Blocked or Marked as Spam by Google (and maybe more)

      In the past 24 hours we’ve noticed that emails sent via Zoho CRM are being blocked or flagged as phishing, particularly by Google. The issue seems to occur specifically when emails contain links. URLs like www.domain.com or www.example.com are automatically

    • Manage WhatsApp conversations across Zoho services using one phone number

      If your teams use multiple Zoho services to handle different business functions, such as support, sales, or other Zoho tools, you might have asked this question: Can we manage all WhatsApp conversations using the same business phone number across these

    • Tickets without registration

      Hi, would it be possible to give customers the opportunity to be able to read their tickets without registration?

    • Handling Hard Bounce Contacts with Active Phone-Based Users (WhatsApp Use Case)

      In Zoho Marketing Automation, when a contact is marked as “Hard Bounce”, we noticed that the contact stops receiving updates from CRM fields and may be excluded from automations. Is this expected behavior? In our case, the primary identifier and verified

    • Enhancing user experience with Audio/Video Upload in Zoho Forms

      Hello form builders! Today, interactive forms are an integral part of websites and applications. While text-based inputs serve a variety of purposes, audio and video uploads can open up a world of possibilities for businesses. Imagine you are a talent

    • Gear up for the Zoho Finance & Operations Workshop 2026!

      Hello everyone! 👋 We're excited to announce that the Zoho Finance & Operations Workshop 2026 is officially underway! As our global community continues to grow, we're expanding our locations to connect with users around the world. If you haven't had a

    • Gear up for the Zoho Finance & Operations Workshop 2026!

      Hello everyone! 👋 We're excited to announce that the Zoho Finance & Operations Workshop 2026 is officially underway! As our global community continues to grow, we're expanding our locations to connect with users around the world. If you haven't had a

    • Zoho Analytics - Business Hour reporting doesn't use Business Hours

      Hi, I've been having an issue where metrics that state they are reporting based on business hours, like "First response time (in Business Hours)" and "Total response time (in Business Hours)" but are being calculated based on 24 hour days (instead of the 9-5 business hours we have setup). Any help would be much appreciated.  I've provided an example and more details in this ticket: https://help.zoho.com/portal/en/ticket/39690706

    • Analytics : Highlighting a single bar in a bar chart

      I have a bar chart showing values across a year by week. I have a user filter to change the selected week, however the year graph will remain as showing the full year. Is there anyway to conditionally format or construct the year graph to highlight the

    • New Income Tax Act 2025 and Rules 2026 for India (Effective 1 April 2026)

      Hello everyone, The Income Tax Act 2025 came into effect from 1 April 2026. This new law replaces the old Income Tax Act of 1961. Along with the new Act, the Income Tax Rules 2026 have also been released by the government. These updates bring practical

    • Cancelled appointments still block out timeslot

      I haven't had to test this before, but I've just found a problem. I had an appointment in a certain timeslot, and that appointment was cancelled. However, Bookings won't let another appointment be booked in that slot - it makes that time unavailable until

    • Item Categories in Zoho Books

      I realize this feature is available in Inventory, but we do not keep track of inventory. Basically, we have 2 product offerings, residential and commercial. Right now we can only run sales reports for all items. What is the best way to keep track of sales

    • Profit / margins on Sales orders / Invoices / Estimates

      When we select an SKU or item name in any of these documents, much info such as invoice.line_items.rate is pulled from the item & filled into the document being worked on. If we had another lineItem DB field (hidden) auto filled at the same time: invoice.line_items.purchase_rate

    • tracking inventory in item in zoho books

      Hello, I follow the instructions to be able to enable inventory fot the items, but I dont see the check box (Image zohobooks3) in the item to activate "Track inventory for this item". Imagezohobooks4: Is the menu of the configuration of the item.

    • Quickbooks API with Zoho Analytics (Profit and Loss Report)

      Hi There! We're currently using Quickbooks Advanced Analytics to create reports. I'm wondering if there's a way for us to use Quickbooks' API so we can grab our Profit & Loss report directly instead of creating the report in Zoho Analytics.  We have journal entries that makes it difficult to identify if they are credit or debit with Zoho Analytics. I'm wondering if any user here has experienced the same issue and found a workaround or a way to display the report.  Any suggestion you may have is greatly

    • Restrict Appointment Booking to Approved Clients

      Dear Zoho Bookings Support Team, We'd like to propose a feature enhancement for managing appointments within Zoho Bookings. This feature would ensure only pre-approved clients can schedule meetings. Desired Functionality: We propose the introduction of

    • Product margin is negative

      Hi I'm having a hard time figuring out why are my margins negative. Sales price is larger than purchase price and when I manually calculate the margin I do not get the same numbers that I get once I run the report. FYI - im testing Zoho inventory at this point. Invoices have been created, as well as packages and shipping was completed. I have not created any payments received. Also, when I pull profit/loss in Zoho Books, i'm showing profit. I've attache screenshot of one of the products.  For this

    • Zoho Reports Quarters don't match CRM financial quarters for CRM analytics reports?

      Hi, I have a client who is doing analysis using the new CRM Analytics function. I am having trouble creating the reports I need which need to key off the clients financial year quarters rather than the standard Q1 = Jan-Mar, Q2 = Apr-Jun etc. My customers financial year starts April and ends on the last day of the following March.  I have looked at generating another date to use for calculations based on the closing date - e.g. closing date+90 days, but this isn't accurate enough and will cause issues

    • Gear up for the Zoho Finance & Operations Workshop 2026!

      Hello everyone! 👋 We're excited to announce that the Zoho Finance & Operations Workshop 2026 is officially underway! As our global community continues to grow, we're expanding to select international locations to connect with users around the world.

    • Zoho CRM Community Digest - March 2026 | Part 1

      Hello Everyone! March kicked off with a strong mix of AI-driven enhancements, smarter data handling, and practical workflow improvements across Zoho CRM. From leveraging Zia for automated communication to optimizing cross-platform data retrieval, this

    • Lead import only imported 15 records

      I have an 82k .CSV file with over 500 records. I imported leads and only got 15 records. I tried it again and got the same 15 records. I'm on the free account.

    • Next Page