Sotirios Zormpas

szormpas

Greece

Joined: Sun Nov 07 22:33:30 UTC 2021

My Posts

Latest Posts

Re: Resetting a Page Field...
@Graham Brown Hi, One way to go is by setting the "Binding" property of this field to "Per record in memory (browser)."
- szormpas
- 2 days ago
- Get help
- Reported - view
Re: CSV Import Wizard
I see the problem now. The main script depends on the shareFile() function to create a link of the CSV file, and I guess that's not possible locally. So, the solution above only works for the web.
- szormpas
- 3 wk ago
- Learn and share
- Reported - view
Re: CSV Import Wizard
@我是我的我 OK, remove the "do as server.......end" from the main code inside the button.
- szormpas
- 3 wk ago
- Learn and share
- Reported - view
Re: CSV Import Wizard
@我是我的我 Thanks. Can you check this in your app?
- szormpas
- 3 wk ago
- Learn and share
- Reported - view
Re: CSV Import Wizard
@Rafael Hi, Since the main code is running on the server side, I'm not sure why it's not working on your Android app. Unfortunately, I don't have an Android device for checking.
- szormpas
- 3 wk ago
- Learn and share
- Reported - view
CSV Import Wizard

Hello everyone, Since a lot of our community members are interested in ways to automate the import of a CSV file, I decided to put together a complete working example database to show how to do it.…
- szormpas
- 3 wk ago
- 9replies
- 74
- 6
- Learn and share
Re: Modularity Coming to Public Cloud!
@Fred that's good to hear!
- szormpas
- 3 wk ago
- Learn and share
- Reported - view
Re: can I launch import wizard (for .csv) via script?
@Dave Airel Hi, You can't launch the Ninox import wizard via scripting, but you can make your own custom import wizard to automate the whole process. I just had a feeling that you wanted to get there…
- szormpas
- 3 wk ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel Hi, The script expects compatible data types between the 'Attended' fields in the RSVP and StagingImport tables.
- szormpas
- 4 wk ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel please mark the post as answered.
- szormpas
- 4 wk ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel well done!
- szormpas
- 4 wk ago
- 1
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel just go to your online account and click on 'import archive'.
- szormpas
- 4 wk ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel Could you please use the updated version of the database I uploaded above? I think it's easier since there's no real data yet.
- szormpas
- 4 wk ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel copy-paste the following script: do as server let allContacts := (select Contacts); let allEvents := (select Events); let allRSVP := (select RSVP);…
- szormpas
- 4 wk ago
- 1
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel We made it! The issue in your database came up because the 'Event ID' field in the StagingImport table was set to number data type. So, I changed it to a text field type.…
Attachment
- szormpas
- 4 wk ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel We should use the same logic in the Contacts table. If a new contact attends multiple events in the .csv file, only one new record should be created in the Contacts Table.…
Attachment
- szormpas
- 4 wk ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel@Fred@RoSoft_Steven I think we're getting there. The issue came up because the 'select' statement returns 'nid', but the 'create' statement returns 'rid'. Here's a script you can try out.…
- szormpas
- 4 wk ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel Hi, I forgot to put the "w" variable in brackets []. Here's the updated script, let's hope it works! do as server let x := select Contacts; let y := select Events; let z := select RSVP;…
- szormpas
- 4 wk ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel Can you make a last effort to try the following script? do as server let x := select Contacts; let y := select Events; let z := select RSVP; for i in select StagingImport do let c :…
- szormpas
- 4 wk ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel Let's try to solve the problem here...
- szormpas
- 4 wk ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Sotirios Zormpas can you upload a Demo database and a sample .csv file for testing purposes?
- szormpas
- 4 wk ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel the only changes I've made in the previous script were to add two extra lines: y := select Events; delete select StagingImport; Can you use the previous script and gradually add the above…
- szormpas
- 4 wk ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel does the field names of the StagingImport Table corresponds to those in the script?
- szormpas
- 4 wk ago
- 1
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel Great... First point: There's a bug in the script. We need to update the "y" variable with the new Event ID so it's recognized in the next iteration. Second point: You got it.…
- szormpas
- 4 wk ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel Hi, You can try the following code inside a button. If it works, we can optimize it further. do as server let x := select Contacts; let y := select Events; let z := select RSVP;…
- szormpas
- 4 wk ago
- Get help
- Reported - view

1 2 3 4 5 21

Welcome to the Ninox community

Sotirios Zormpas

My Posts

Re: Resetting a Page Field...

Re: CSV Import Wizard

Re: CSV Import Wizard

Re: CSV Import Wizard

Re: CSV Import Wizard

Re: Modularity Coming to Public Cloud!

Re: can I launch import wizard (for .csv) via script?

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Overview