Assign owner to imported records

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
Nicolas
Veteran Member
Posts: 43
Joined: 2015-12-08 08:08
Location: Barcelona
Contact:

Assign owner to imported records

Post by Nicolas » 2017-01-25 12:16

Hi there, good day
Using appgini 5.51 rev 905

I have a clients table which is handled by different sales reps and some time ago I imported via mysql a set of external records to be redistributed to sales guys....

I have tried to do inside the same tableview marking some on the left and then on "more" and I get a message that can't be done with this error message
1.- Record not found ...if it was imported externally, try assigning an owner from the admin area
Captura.JPG
Captura.JPG (99.29 KiB) Viewed 4334 times
Then ... on the admin area I don't know where to find it...it looks that I missed something or doing it externally the process did not add the ownership....
How can I do it inside appgini? or can I do it on mysql assigning membership userrecords???

Thank you

thecomputerchap
Veteran Member
Posts: 47
Joined: 2016-08-28 10:37

Re: Assign owner to imported records

Post by thecomputerchap » 2017-01-27 09:14

Export the records from your MySQL database as CDC first then use the import feature in the admin screen under the utilities menu. That should create the ownership records automatically for you too.

thecomputerchap
Veteran Member
Posts: 47
Joined: 2016-08-28 10:37

Re: Assign owner to imported records

Post by thecomputerchap » 2017-02-01 15:11

Sorry,

A typo there!... Not CDC, CSV!

Nicolas
Veteran Member
Posts: 43
Joined: 2015-12-08 08:08
Location: Barcelona
Contact:

Re: Assign owner to imported records

Post by Nicolas » 2017-03-29 11:44

Thank you, I'll do that next time.... in the mean time I've discovered a way into the mysql but far more complicate....
Understood for next one!!!!
Keep well and regards from Spain

User avatar
baudwalker
Veteran Member
Posts: 188
Joined: 2015-02-03 08:08
Location: Bellingen NSW Australia

Re: Assign owner to imported records

Post by baudwalker » 2017-07-13 10:11

and what did you do? Nicolas

Post Reply