Printer Friendly

Bulk generate applications does not work

masino.sinaga, Sun Jul 10 2022, 01:26PM

Please try Bulk generate applications from Run application wizard.

After selecting all tables in current database, then click on Generate bulk button, there is a popup message appear in IDE:

"Oeps... Cannot find main in the applist. Please close PHsPeed and restart."

After clicking on "OK" button, then there is another new message appears:

"sorry, your projectfile seems to be corrupted: main"

After clicking on "OK" button on that message box, then there is another message appears:

"Missing default layout, using layout_1"

After clicking on "OK" button on the message box, then there the message popup back to:

"sorry, your projectfile seems to be corrupted: main"

and so forth repeated as many as the number of selected tables ...

Re: Bulk generate applications does not work
masino.sinaga, Sun Jul 10 2022, 01:27PM

Apologized, this topic should be put under "Bug reports" section.

Re: Bulk generate applications does not work
administrator, Sun Jul 10 2022, 02:29PM

No problem, we appreciate your good feedback. Reported to the bugtracker: https://www.phspeed.com/bt/index.php?do=details&task_id=404

Re: Bulk generate applications does not work
administrator, Sun Jul 10 2022, 05:22PM

Could you report the steps you did to lead to the problem? I created a fresh project, applied connection, went to the wizard and used bulk generator to generate all my crud applications. Tried a few times, no issues. Same with using the function in an existing project.

Re: Bulk generate applications does not work
masino.sinaga, Mon Jul 11 2022, 12:07AM

Sure. Here are the steps to reproduce the issue

1. Create a new project, of course, with database connection,
2. Click on Run application wizard menu,
3. Leave Grid with popup form option selected,
4. Leave Module id blank,
5. Click on Bulk generate applications button,
6. Select all tables, then click on Generate bulk button,
7. Then the issue appears as I described some message boxes appeared and it is repeated as many as the selected tables.

Re: Bulk generate applications does not work
administrator, Mon Jul 11 2022, 09:44AM

That is exactly what I did, w.o. problems. Could you send a database structure dump so we can see if there is something in the database structure?

Please send it to support at phspeed.com

Re: Bulk generate applications does not work
masino.sinaga, Mon Jul 11 2022, 09:53AM

Sure, I've just sent it to support at phspeed.com

However, for your reference and others, too, let me post it here as nothing special, I think.

-- ----------------------------
-- Table structure for events
-- ----------------------------
DROP TABLE IF EXISTS `events`;
CREATE TABLE `events`  (
  `my_id` int(11) NOT NULL AUTO_INCREMENT,
  `my_title` varchar(160) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `my_description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `begin_date` datetime NOT NULL,
  `finish_date` datetime NOT NULL,
  `my_allDay` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `my_color` varchar(7) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `my_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `my_category` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `my_repeat_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `my_user_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `my_repeat_id` int(11) NOT NULL,
  `my_timezone` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `my_date_add` datetime NULL DEFAULT NULL,
  `my_user_add` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `my_date_edit` datetime NULL DEFAULT NULL,
  `my_user_edit` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`my_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of events
-- ----------------------------
INSERT INTO `events` VALUES (1, 'Pancasila\'s Day', 'This day is a Pancasila Day.\r\nThat means, it\'s the day when Pancasila was born.\r\nPancasila is a foundation of Indonesia country.\r\nThanks for reading this. \r\nThis was made to test Calendar Scheduler extension.', '2022-06-01 00:00:00', '2022-06-01 23:59:59', 'true', '#ff0000', 'false', 'General', 'no', 'andrew', 1, 'Asia/Jakarta', '2022-06-27 14:31:17', 'Administrator', '2022-06-27 14:31:17', 'Administrator');
INSERT INTO `events` VALUES (2, 'Nancy\'s Event', 'This event is assigned to Nancy user.\r\nYou may see this event if you have logged in as Nancy.\r\nIn addition, Administrator also will be able to see this event.', '2022-06-02 00:00:00', '2022-06-02 23:59:59', 'true', '#6aa84f', 'false', 'Personal', 'no', 'nancy', 2, 'Asia/Jakarta', '2022-06-27 14:32:42', 'Administrator', '2022-06-27 14:32:42', 'Administrator');
INSERT INTO `events` VALUES (3, 'Janet\'s Repeated Event', 'This is Janet\'s event.\r\nRepeated every week for 3 times.', '2022-06-03 00:00:00', '2022-06-03 23:59:59', 'true', '#0000ff', 'false', 'Work', 'every_week', 'janet', 3, 'Asia/Jakarta', '2022-06-27 14:33:49', 'Administrator', '2022-06-28 10:53:31', 'Administrator');
INSERT INTO `events` VALUES (4, 'Janet\'s Repeated Event', 'This is Janet\'s event.\r\nRepeated every week for 3 times.', '2022-06-10 00:00:00', '2022-06-10 23:59:59', 'true', '#0000ff', 'false', 'Work', 'every_week', 'janet', 3, 'Asia/Jakarta', '2022-06-27 14:33:49', 'Administrator', '2022-06-28 10:53:31', 'Administrator');
INSERT INTO `events` VALUES (5, 'Janet\'s Repeated Event', 'This is Janet\'s event.\r\nRepeated every week for 3 times.', '2022-06-17 00:00:00', '2022-06-17 23:59:59', 'true', '#0000ff', 'false', 'Work', 'every_week', 'janet', 3, 'Asia/Jakarta', '2022-06-27 14:33:49', 'Administrator', '2022-06-28 10:53:31', 'Administrator');
INSERT INTO `events` VALUES (6, 'Janet\'s Repeated Event', 'This is Janet\'s event.\r\nRepeated every week for 3 times.', '2022-06-24 00:00:00', '2022-06-24 23:59:59', 'true', '#0000ff', 'false', 'Work', 'every_week', 'janet', 3, 'Asia/Jakarta', '2022-06-27 14:33:49', 'Administrator', '2022-06-28 10:53:31', 'Administrator');
INSERT INTO `events` VALUES (7, 'Admin\'s Event', 'This event is assigned to admin.\r\nRepeated every day for 5 times.\r\nOnly Admin can see this event.', '2022-06-04 00:00:00', '2022-06-04 23:59:59', 'true', '#bf9000', 'false', 'Personal', 'every_day', 'Administrator', 7, 'Asia/Jakarta', '2022-06-27 14:34:48', 'Administrator', '2022-06-27 14:34:48', 'Administrator');
INSERT INTO `events` VALUES (8, 'Admin\'s Event', 'This event is assigned to admin.\r\nRepeated every day for 5 times.\r\nOnly Admin can see this event.', '2022-06-05 00:00:00', '2022-06-05 23:59:59', 'true', '#bf9000', 'false', 'Personal', 'every_day', 'Administrator', 7, 'Asia/Jakarta', '2022-06-27 14:34:48', 'Administrator', '2022-06-27 14:34:48', 'Administrator');
INSERT INTO `events` VALUES (9, 'Admin\'s Event', 'This event is assigned to admin.\r\nRepeated every day for 5 times.\r\nOnly Admin can see this event.', '2022-06-06 00:00:00', '2022-06-06 23:59:59', 'true', '#bf9000', 'false', 'Personal', 'every_day', 'Administrator', 7, 'Asia/Jakarta', '2022-06-27 14:34:48', 'Administrator', '2022-06-27 14:34:48', 'Administrator');
INSERT INTO `events` VALUES (10, 'Admin\'s Event', 'This event is assigned to admin.\r\nRepeated every day for 5 times.\r\nOnly Admin can see this event.', '2022-06-07 00:00:00', '2022-06-07 23:59:59', 'true', '#bf9000', 'false', 'Personal', 'every_day', 'Administrator', 7, 'Asia/Jakarta', '2022-06-27 14:34:48', 'Administrator', '2022-06-27 14:34:48', 'Administrator');
INSERT INTO `events` VALUES (11, 'Admin\'s Event', 'This event is assigned to admin.\r\nRepeated every day for 5 times.\r\nOnly Admin can see this event.', '2022-06-08 00:00:00', '2022-06-08 23:59:59', 'true', '#bf9000', 'false', 'Personal', 'every_day', 'Administrator', 7, 'Asia/Jakarta', '2022-06-27 14:34:48', 'Administrator', '2022-06-27 14:34:48', 'Administrator');
INSERT INTO `events` VALUES (12, 'Admin\'s Event', 'This event is assigned to admin.\r\nRepeated every day for 5 times.\r\nOnly Admin can see this event.', '2022-06-09 00:00:00', '2022-06-09 23:59:59', 'true', '#bf9000', 'false', 'Personal', 'every_day', 'Administrator', 7, 'Asia/Jakarta', '2022-06-27 14:34:48', 'Administrator', '2022-06-27 14:34:48', 'Administrator');
INSERT INTO `events` VALUES (13, 'Another Nancy\'s event', 'This is another event for Nancy.', '2022-06-11 00:00:00', '2022-06-15 23:59:59', 'true', '#6aa84f', 'false', 'General', 'no', 'nancy', 13, 'Asia/Jakarta', '2022-06-27 14:35:19', 'Administrator', '2022-06-27 17:23:29', 'nancy');
INSERT INTO `events` VALUES (14, 'Another Event for Janet', 'This is another event for Janet.', '2022-06-15 00:00:00', '2022-06-15 23:59:59', 'true', '#674ea7', 'false', 'General', 'no', 'janet', 14, 'Asia/Jakarta', '2022-06-27 14:35:40', 'Administrator', '2022-06-27 14:35:40', 'Administrator');
INSERT INTO `events` VALUES (15, 'Another Event for Andrew', 'Hi there!\r\nThis is another event that assigned to Andrew.\r\nHope this helps.\r\nThanks!', '2022-06-06 00:00:00', '2022-06-06 23:59:59', 'true', '#0000ff', 'false', 'General', 'no', 'andrew', 15, 'Asia/Jakarta', '2022-06-27 14:36:57', 'andrew', '2022-06-27 14:36:57', 'andrew');
INSERT INTO `events` VALUES (16, 'This Event Can Be Seen by All Users', 'This events can be seen by all users.\r\nWhy? Because there are no user assigned to this event.\r\nThat means all users will be able to see this event.\r\nHope this helps!', '2022-05-31 00:00:00', '2022-06-01 00:00:00', 'true', '#6aa84f', 'false', 'General', 'no', '', 16, 'Asia/Jakarta', '2022-06-27 14:38:05', 'Administrator', '2022-06-27 14:40:30', 'janet');
INSERT INTO `events` VALUES (17, 'Event by Nancy', 'This event is entered by Nancy.\r\nYou may check from the User Add and/or User Edit.', '2022-06-08 00:00:00', '2022-06-08 23:59:59', 'true', '#0000ff', 'false', 'General', 'no', 'nancy', 17, 'Asia/Jakarta', '2022-06-27 14:39:06', 'nancy', '2022-06-27 14:39:06', 'nancy');
INSERT INTO `events` VALUES (18, 'Event Entered by Andrew', 'This event is entered by Andrew.', '2022-06-10 00:00:00', '2022-06-10 23:59:59', 'true', '#ff9900', 'false', 'General', 'no', 'andrew', 18, 'Asia/Jakarta', '2022-06-27 14:39:47', 'andrew', '2022-06-27 14:39:47', 'andrew');
INSERT INTO `events` VALUES (19, 'Event by Janet', 'This event is entered by Janet herself.\r\nThank you.', '2022-06-08 00:00:00', '2022-06-08 23:59:59', 'true', '#ff0000', 'false', 'General', 'no', 'janet', 19, 'Asia/Jakarta', '2022-06-27 14:40:21', 'janet', '2022-06-27 14:40:21', 'janet');
INSERT INTO `events` VALUES (20, 'Three Days Event for All', 'This is a three days event for all users.\r\nYou can see this event will use 3 dates continuosly.\r\nThe record will be inserted once for those 3 days.\r\nIsn\'t cool, right? Let\'s see the result.\r\nThanks anyway!', '2022-06-01 00:00:00', '2022-06-04 00:00:00', 'false', '#674ea7', 'false', 'Personal', 'no', '', 20, 'Asia/Jakarta', '2022-06-27 16:45:28', 'Administrator', '2022-06-27 16:45:28', 'Administrator');

-- ----------------------------
-- Table structure for userlevelpermissions
-- ----------------------------
DROP TABLE IF EXISTS `userlevelpermissions`;
CREATE TABLE `userlevelpermissions`  (
  `userlevelid` int(11) NOT NULL,
  `tablename` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `permission` int(11) NOT NULL,
  PRIMARY KEY (`userlevelid`, `tablename`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of userlevelpermissions
-- ----------------------------
INSERT INTO `userlevelpermissions` VALUES (-2, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}calendar', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}userlevelpermissions', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}userlevels', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}users', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}calendar.php', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}calendar', 0);
INSERT INTO `userlevelpermissions` VALUES (1, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}calendar', 367);
INSERT INTO `userlevelpermissions` VALUES (2, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}calendar', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}userlevelpermissions', 0);
INSERT INTO `userlevelpermissions` VALUES (1, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}userlevelpermissions', 256);
INSERT INTO `userlevelpermissions` VALUES (2, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}userlevelpermissions', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}userlevels', 0);
INSERT INTO `userlevelpermissions` VALUES (1, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}userlevels', 256);
INSERT INTO `userlevelpermissions` VALUES (2, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}userlevels', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}users', 0);
INSERT INTO `userlevelpermissions` VALUES (1, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}users', 256);
INSERT INTO `userlevelpermissions` VALUES (2, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}users', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}calendar.php', 0);
INSERT INTO `userlevelpermissions` VALUES (1, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}calendar.php', 367);
INSERT INTO `userlevelpermissions` VALUES (2, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}calendar.php', 0);
INSERT INTO `userlevelpermissions` VALUES (1, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}events', 104);
INSERT INTO `userlevelpermissions` VALUES (1, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}userlevelpermissions', 0);
INSERT INTO `userlevelpermissions` VALUES (1, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}userlevels', 0);
INSERT INTO `userlevelpermissions` VALUES (1, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}users', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}calendar', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}events', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}userlevelpermissions', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}userlevels', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}users', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}calendar', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}events', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}userlevelpermissions', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}userlevels', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}users', 0);
INSERT INTO `userlevelpermissions` VALUES (1, '{841354F0-FBDB-4CEF-B2E0-2D4B1E837B56}calendarscheduler', 367);
INSERT INTO `userlevelpermissions` VALUES (1, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}calendarscheduler', 239);
INSERT INTO `userlevelpermissions` VALUES (2, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}events', 104);
INSERT INTO `userlevelpermissions` VALUES (2, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}userlevelpermissions', 0);
INSERT INTO `userlevelpermissions` VALUES (2, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}userlevels', 0);
INSERT INTO `userlevelpermissions` VALUES (2, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}users', 0);
INSERT INTO `userlevelpermissions` VALUES (2, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}calendarscheduler', 239);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C865BD0A-E9F1-487A-B0B5-1819166EA574}calendarscheduler', 40);

-- ----------------------------
-- Table structure for userlevels
-- ----------------------------
DROP TABLE IF EXISTS `userlevels`;
CREATE TABLE `userlevels`  (
  `userlevelid` int(11) NOT NULL,
  `userlevelname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`userlevelid`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of userlevels
-- ----------------------------
INSERT INTO `userlevels` VALUES (-2, 'Anonymous');
INSERT INTO `userlevels` VALUES (-1, 'Administrator');
INSERT INTO `userlevels` VALUES (0, 'Default');
INSERT INTO `userlevels` VALUES (1, 'Sales');
INSERT INTO `userlevels` VALUES (2, 'Manager');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `EmployeeID` int(11) NOT NULL AUTO_INCREMENT,
  `LastName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `FirstName` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `Title` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `TitleOfCourtesy` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `BirthDate` datetime NULL DEFAULT NULL,
  `HireDate` datetime NULL DEFAULT NULL,
  `Address` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `City` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Region` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `PostalCode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Country` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `HomePhone` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Extension` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Photo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Notes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `ReportsTo` int(11) NULL DEFAULT NULL,
  `Username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Activated` enum('Y','N') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Profile` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `UserLevel` int(11) NULL DEFAULT 0,
  `Signature` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`EmployeeID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 'Nancy', 'Davolio', 'Sales Representative', 'Ms.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 'nancy', '1234', 'nancy@example.com', 'Y', 'a:29:{s:15:\"LoginRetryCount\";i:0;s:9:\"SessionID\";s:0:\"\";s:20:\"LastAccessedDateTime\";s:0:\"\";s:10:\"EmployeeID\";s:1:\"1\";s:8:\"LastName\";s:5:\"Nancy\";s:9:\"FirstName\";s:7:\"Davolio\";s:5:\"Title\";s:20:\"Sales Representative\";s:15:\"TitleOfCourtesy\";s:3:\"Ms.\";s:9:\"BirthDate\";N;s:8:\"HireDate\";N;s:7:\"Address\";N;s:4:\"City\";N;s:6:\"Region\";N;s:10:\"PostalCode\";N;s:7:\"Country\";N;s:9:\"HomePhone\";N;s:9:\"Extension\";N;s:5:\"Photo\";N;s:5:\"Notes\";N;s:9:\"ReportsTo\";s:1:\"2\";s:8:\"Username\";s:5:\"nancy\";s:5:\"Email\";s:17:\"nancy@example.com\";s:9:\"Activated\";s:1:\"Y\";s:7:\"Profile\";N;s:9:\"UserLevel\";s:1:\"1\";s:9:\"Signature\";N;s:9:\"UserImage\";s:0:\"\";s:23:\"LastPasswordChangedDate\";s:10:\"2022/06/17\";s:20:\"LastBadLoginDateTime\";s:19:\"2022/06/25 10:35:23\";}', 1, NULL);
INSERT INTO `users` VALUES (2, 'Fuller', 'Andrew', 'Vice President, Sales', 'Mr.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'andrew', '1234', 'andrew@example.com', 'Y', 'a:27:{s:15:\"LoginRetryCount\";i:0;s:9:\"SessionID\";s:0:\"\";s:20:\"LastAccessedDateTime\";s:0:\"\";s:10:\"EmployeeID\";s:1:\"2\";s:8:\"LastName\";s:6:\"Fuller\";s:9:\"FirstName\";s:6:\"Andrew\";s:5:\"Title\";s:21:\"Vice President, Sales\";s:15:\"TitleOfCourtesy\";s:3:\"Mr.\";s:9:\"BirthDate\";N;s:8:\"HireDate\";N;s:7:\"Address\";N;s:4:\"City\";N;s:6:\"Region\";N;s:10:\"PostalCode\";N;s:7:\"Country\";N;s:9:\"HomePhone\";N;s:9:\"Extension\";N;s:5:\"Photo\";N;s:5:\"Notes\";N;s:9:\"ReportsTo\";N;s:8:\"Username\";s:6:\"andrew\";s:5:\"Email\";s:18:\"andrew@example.com\";s:9:\"Activated\";s:1:\"Y\";s:7:\"Profile\";N;s:9:\"UserLevel\";s:1:\"2\";s:9:\"Signature\";N;s:23:\"LastPasswordChangedDate\";s:10:\"2022/06/25\";}', 2, NULL);
INSERT INTO `users` VALUES (3, 'Leverling', 'Janet', 'Sales Representative', 'Ms.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 'janet', '1234', 'janet@example.com', 'Y', 'a:27:{s:15:\"LoginRetryCount\";i:0;s:9:\"SessionID\";s:0:\"\";s:20:\"LastAccessedDateTime\";s:0:\"\";s:10:\"EmployeeID\";s:1:\"3\";s:8:\"LastName\";s:9:\"Leverling\";s:9:\"FirstName\";s:5:\"Janet\";s:5:\"Title\";s:20:\"Sales Representative\";s:15:\"TitleOfCourtesy\";s:3:\"Ms.\";s:9:\"BirthDate\";N;s:8:\"HireDate\";N;s:7:\"Address\";N;s:4:\"City\";N;s:6:\"Region\";N;s:10:\"PostalCode\";N;s:7:\"Country\";N;s:9:\"HomePhone\";N;s:9:\"Extension\";N;s:5:\"Photo\";N;s:5:\"Notes\";N;s:9:\"ReportsTo\";s:1:\"2\";s:8:\"Username\";s:5:\"janet\";s:5:\"Email\";s:17:\"janet@example.com\";s:9:\"Activated\";s:1:\"Y\";s:7:\"Profile\";N;s:9:\"UserLevel\";s:1:\"1\";s:9:\"Signature\";N;s:23:\"LastPasswordChangedDate\";s:10:\"2022/06/26\";}', 1, NULL);
INSERT INTO `users` VALUES (4, 'Super', 'Admin', 'Super Admin', 'Mr.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Administrator', 'master', 'admin@example.com', 'Y', NULL, -1, NULL);

Re: Bulk generate applications does not work
administrator, Mon Jul 11 2022, 10:23AM

Thank you, I'll let you know.

Re: Bulk generate applications does not work
administrator, Mon Jul 11 2022, 10:58AM

This is going to be a challenge as we cannot reproduce the load issue. We did reproduce the next/prev record as seen in the video:

Re: Bulk generate applications does not work
masino.sinaga, Mon Jul 11 2022, 11:14AM

Thanks for the video.

After watching the video, I tried as demonstrated in video, and it works now. Not sure, why it works now, while yesterday I got the error message.

It's weird, but it works now. Thank you!

Re: Bulk generate applications does not work
masino.sinaga, Mon Jul 11 2022, 11:16AM

However, the next/prev still does not work. When you click on next button, it goes to the last record.

Re: Bulk generate applications does not work
administrator, Mon Jul 11 2022, 12:45PM

Yes, that is visualized on the video as well. We're working on it.

Re: Bulk generate applications does not work
administrator, Mon Jul 11 2022, 01:47PM

Quick fix: locate spdatasource, function readpage and remove line
setSessionVar($this->name.'_currec', $offset+$reccnt);

The use is limited btw. If you select a record in the grid this record is then set into the form. But not the other way around, which means that you can scroll out of the grids view. To avoid that, you can consider removing the next/prev/first/last buttons from the toolbar.

Re: Bulk generate applications does not work
masino.sinaga, Mon Jul 11 2022, 02:10PM

Thank you. Removing the code you mentioned resolved the issue on navigating records on form.

However, after navigating records on form, then I go to another page in Grid and select another record, then when I navigate back on form, it seems the session still remember the previous one, not the last session that should hold the record id from the selected row in Grid.