Importing existing data into Data Table

[dp.nankivell]

Solved my own problem.
I confused the meaning of orient , I read the pandas documentation and figured it out. This should be “records” instead of “doc_number”

[ianbuywise]

I know this is a little old but here was my quick and dirty solution using anvil uplink, with no other pip installation required.
(I already had uplink installed, this uses the python3 build in csv library which does support column headers if you wanted to modify it to spit out a list of dictionarys instead of a list of lists, docs here: https://docs.python.org/3/library/csv.html#csv.DictReader )

On your local machine:

import anvil.server
import csv

@anvil.server.callable
def load_csv_data():

some_data = []
#replace "emails.csv" with the name of your csv in the same directory as your .py file
with open("emails.csv", newline='') as csvfile:
    csvreader = csv.reader(csvfile)
    for row in csvreader:
        some_data.append(row)
return some_data

anvil.server.connect(“YOUR-CONNECTION-STRING”)

try:

anvil.server.wait_forever()

except KeyboardInterrupt:

print("User called to quit.")

input("<< PRESS RETURN >>")

exit()

On your anvil app server module:

@anvil.tables.in_transaction
@anvil.server.callable
def load_csv_to_data_table_from_uplink():

#data comes from anvil uplink on your local machine
csv_row_list = anvil.server.call('load_csv_data')

for csv_row in csv_row_list:
    #where columns 0, 1, and 2 referenced below are in the same order for the correctly corresponding data from the original csv file processed on your local machine
    # 'oper_ref' below is interchangeable for your data table name, and the column names would be --your-- data tables column names, not the placeholders below
    app_tables.oper_ref.add_row(operator_code=csv_row[0], reference_email=csv_row[1], reference_name=csv_row[2])

Then I just added

anvil.server.call(‘load_csv_to_data_table_from_uplink’)

…to an empty form init and set it as the startup form and ran the app once.

This is not something you would do all the time, but it might help you port some one-time reference or test data into your tables to get you started fiddling and testing.
(edited to fix quote formatting X2)

[ananth.krishnamoorth]

Thank you! Snippets and cloning really help learning!!in