NEED TO MANIPULATE CSV FILE PRIOR TO IMPORT

Brazil is the next big QuickBase market and I am going to personally come down there and work with you guys to prospect and hold a QuickBase user conference where we feature only topics that can't be done naively or that users don't know how to do natively.

We are going to have to work on our branding. My current thinking is that is a toss up between the original "Mas Que Nada" (No Way inEnglish) theme and the Capacitar (Empower in English) theme. And we may have to substitute Lua (Lua was developedd at Pontifical Catholic University of Rio de Janeiro, in Brazil.) instead of Haskell as the official programming language.

I am going to contact QuickBase marketing and see if they will thrown in some swag like pens, USB cables or t-shirts to support these efforts.

Think big:

I encourage you to stick with QuickBase. It is less expensive than other enterprise solutions, vastly more customizable and more importantly I think you would be greatly underestimating the effort to recreate your accumulated work of the last three years in a new technology. Every product has gaps in its feature set and you will likely just discover new gaps in these other technologies.

Regarding your two issues (1) internationalization and (2) mobile, I had the following comments.

A final solution for internationalization will have to come from QuickBase and when the technology they select is in place, the capability will rapidly expand to many languages as fast as translation sets can be created - this is usually done by contractors who specialize in internationalization. I have no idea where this stands in their planning pipeline. However, in the meantime there are a number of things that can be done now to make the product more useful to non-English users. Feel free to contact me off-world for details. Also, I would encourage you to dialog with the other Brazilian users as I am totally serious about developing Brazil's usage of QuickBase.

Regarding mobile, QuickBase is making improvements in their mobile offering. Again I have no knowledge of their product plans. However, there is a bundle of technology that goes by the name of PWA (Progressive Web Applications) that holds great promise to bring the features of installed native applications to web based applications. One technology that provides these new capabilities is called Service Workers and all browsers manufactures have adopted it (Apple the last holdout to release SW in upcoming Safari 11.1). In the other browsers (Chrome, FireFox, Opera, Edge, UC Browser, Samsung Browser) Service Worker technology is available now and you can do things such as offline usage of QuickBase, notifications, add to home screen.

I work with these technologies in my non-QuickBase work and I can tell you for a fact that as 2018 rolls out there are massive implications for using these and other technologies with QuickBase

Martin j� somos 3 interessados em quickbase en Brazil!!!! Um grande avan�o!!!

We are three known quickbase users in Brazil! Great advance!.

I regularly import bank statements (using the ofx) and do consolidations. I use Quick as mi financial erp( needs to improve but it works).
The code was hacked from dans ideas . I am sure it can be improved a lot but it works.
Once I shared my code with him and said it was a piece of ....... kkkkkk
Every 5 minutes quickbase syncs with my store system ( they provided a web service and I make a call with an automation) also hacked from one of dans ideas.

I am connected to umbounce , twillio. Zendesk and typeform.

I can share with you this dans ideas . He certainly shares though for more complex things he has a life as consultant .

My wife has a production company and is encouraging me to try an become a developer to bring quickbase to Brazil. We even spoke with March Schneider which is a native quickbase developer

We spoke with SEBRAE, cause we have some contacts there and where thrilled but spoke about the language problem.

The idea in Sebrae was to create a tool for cultural production companies, they are small and lack of tools. And share with users individually. Giving access to complex tools to small companies

She can certainly organize a conference cause he organizes events concerts etc.

We can think big but we can do something smaller.

Maybe search for more Brazilian users, and crowd-fund dans trip to Brazil.

If I where quickbase I would certainly collaborate with that crowd-fund.

There we coudl focus in ways to overcome quickbase setbacks for a Brazilian users and learn a couple of things.

CAIPACITAR is a good name cause is the key of success to quickbase adoption from my point of view.

I will call you later today.

I see you live in NATAL I live in SALVADOR.
Northeast to quickbase power!!!

>Maybe search for more Brazilian users, 

Truth be told I am using some analytics that logs a user's location and IP. I just setup an email notification when the country is Brazil.

Yours proposals sound fantastic and I would be the first to finance Dan's travels and efforts, but are not tired of not receiving any formal support from Quickbase? Is it necessary that in order to get basic things we have to hack the code and work in the shadows? How can we think about growing without their support? Is it responsible for our companies to work with solutions that are not reliable for production?
In my case given my technical limitations I already lost the support of my users, at the beginning I used quickbase for everything in the company, today we use pipedrive for crm, trello to track activities and I have a rebellion in the financial sector since they demand a better solution ( importation or automatic linkage with bank statements, issuance of boletos, communication with tax authorities).
I agree 100% with Dan and I really follow in quickbase for all the work developed and because the other platforms that I tried or are very expensive or lack functions (Zoho creator, fieldbook, airtable, ragic, Caspian, Memento db, filemaker, Knack, Mendix , outsystems, wavemaker, etc). Nor are Brazilian ERPs an option because it is too late to get the company used to closed software.
Sincerely today I see quickbase more focused on improvements for large customers (Americans) and cosmetic changes than new basic functions for the rest of the world (translation of the UI and help, special characters, CSV format, etc).
I believe that PWA applications are very promising but realistically, how long can quickbase make it available? I have been waiting for the new Mercury IU for more than 2 years and there is still no release date.
Thanks!

Note: sorry by my English.

FWIW, I added Brazilian Tax ID Number (format: 00.000.000/0000-00 | 00000000000000) to the field validation example in this post:

Field Validation - Sorry No Bubbles
https://community.quickbase.com/quickbase/topics/field-validation-sorry-no-bubbles

I ask you:

What other online database supports the validation of  Brazilian Tax ID Numbers? Only QuickBase!

Dan one thing I have not achieved is a JavaScript code to substitute diacritics and accents before importing in a consistent way. I can do it in a quickbase field ( you suggested that in another post)but would be better before. In that way the database is not polluted and can be filtered.
Any ideas to look at in the internet? It is code related no quickbase related.

I did a project removing diacriticals for French. I think the issue was that search was not picking up the diacritical - I am a little foggy on the requirements as it was a while ago.

Also, when I converted the Pastie Database to point to posts in the new forum I had to run a script to search on the title of the post and finding a match swap in the new URL. As I recall it worked perfectly except on a few messages that had diacriticals in the title. So I am pretty sure I can find a solution.

So I am sure it can be done so feel free to contact me off-world using the information in my profile:

https://getsatisfaction.com/people/dandiebolt/

Eduardo,

I can remove all of the following diacriticals used by Portuguese:

• the cedilla (�)
• acute accent (�, �, �, �, �)
• circumflex accent (�, �, �)
• tilde (�, �)
• grave accent (�)

If this is one of the limitations to using QuickBase in Brazil (or other countries) I don't see a problem.

I am beginning to think we can come up with a working solution sooner than QuickBse will offer an i18n solution and learn a lot in the process.

But I have other work to do so contact me off-world if you want to pursue this.

Good news on the English to Portuguese QuickBase project. We worked out all the technical details and are just testing the Regular Expressions and DOM Selectors to do the string substitutions at scale in the Service Worker. 

Here is an architecture diagram which shows the Service Worker translating the languages strings within the HTML and JavaScript. The whiteboard shows English to Spanish translation (Hello => Hola)  but in fact we are doing English to Portuguese first.



If you are in town this Wednesday our local Portuguese Language Meetup is meeting this Wednesday from 7-10 pm at Grizzly Peak Brewing Co.

Portuguese Language Meetup in ANN ARBOR, Michigan!!!
E a�, galera? Vamos para Ann Arbor?!!
(What's up guys? Let's go to Ann Arbor? !!)
https://www.meetup.com/DetroitPortuguese/events/248027525/