Hello, every 15 days I use the importer app to upload a XLS file to my pipe in order to work on pending orders collection of customers. I have a database on Pipefy that has all the customer types/categories (let’s say “Customer A”, “Customer B”, etc.)
Whenever I try to upload that file into Pipefy, I get an error message that the importer cannont overwrite the Database. The input from my excel file customer type column is exactly the same than the one in the database (i.e. “Customer A” in excel file = “Customer A” in DB registry)
I’ve already read those pieces you kindly sent me but my questions still remains. What Im trying to import is a category included in each row of a xls file into Pipefy. That category is the one I have in my category database (previoulsy built in Pipefy).
I’m getting this message. I dont quite understand why as the value Im trying to import is exactly the same than one existing in my category database:
Error on field "CATEGORIES": Value You don't have permission to connect these cards/table records.
@christian-delvalle-sekufin What is the type of this "Categories" field?
@Lais Laudari thansk for the help.
Categories is a Database with text only.
When I try to import a xls file, the category (for example) is “GMM Grupo” in the xls file AND in the database record/registry. I keep getting the same error:
Error on field "CATEGORIES": Value You don't have permission to connect these cards/table records.
Thank you @christian-delvalle-sekufin !
I believe that this error is related to your permission in this database conected! Could you check it, please?
Hello @Lais Laudari ! Im being a royal pain now. Im sorry but Im learning!
Yes, Database is connected to the pipe. “Ramos” is the name of the database. Im attaching 2 images so you can see how they are configured.
Thanks.
Hello @christian-delvalle-sekufin , how are you?
I believe it's related to permissions, but in order to analyze and give you more detailed information about the error, I need to have access to the information from Pipe, the database, etc.
So, if you can contact us via the support chat, we'll sort it out for you, OK?
We look forward to hearing from you.
See you soon
How do you display 2 results from 2 different columns on the database on a card